Have any question?
+2 0100 62 62 837
[email protected]
Register Login

Login with your site account

Lost your password?

Not a member yet? Register now

AppsLead | Learn Oracle From The LeadersAppsLead | Learn Oracle From The Leaders
  • Home
  • Courses
    • About Courses

      • Free Training
        • Oracle ebusiness suite Free
        • Oracle Fusion Free
      • Online Live Training
        • Oracle ebusiness suite
        • Oracle Fusion
        • Oracle Database
        • Java & Middleware
      • All Training Courses
      • Training Schedule
      • Register For Live Course
      • Join Our Team
      • Exam Request
  • Blog
    • Oracle ebusiness Suite
      • Oracle Financial
      • Oracle HCM
      • Oracle SCM
    • Oracle Fusion
      • Fusion Financial
      • Fusion HCM
    • Our Authors
    • Be an Author
  • Schedule
  • FAQs
  • About Us
    • About Us
    • Our Services
    • Our Authors
  • Contact Us
  • Home
  • Courses
    • About Courses

      • Free Training
        • Oracle ebusiness suite Free
        • Oracle Fusion Free
      • Online Live Training
        • Oracle ebusiness suite
        • Oracle Fusion
        • Oracle Database
        • Java & Middleware
      • All Training Courses
      • Training Schedule
      • Register For Live Course
      • Join Our Team
      • Exam Request
  • Blog
    • Oracle ebusiness Suite
      • Oracle Financial
      • Oracle HCM
      • Oracle SCM
    • Oracle Fusion
      • Fusion Financial
      • Fusion HCM
    • Our Authors
    • Be an Author
  • Schedule
  • FAQs
  • About Us
    • About Us
    • Our Services
    • Our Authors
  • Contact Us

Blog

  • Home
  • Blog
  • HRMS Attended Establishment API

HRMS Attended Establishment API

  • Posted by Sameh Bakkar
  • Categories Blog
  • Date March 19, 2011
  • Comments 0 comment
Hi guys today we will explain HRMS Attended Establishment API
 

DECLARE
V_ERROR VARCHAR2(400);
P_VALIDATE BOOLEAN;
P_EFFECTIVE_DATE DATE;
P_FULLTIME VARCHAR2(200);
P_ATTENDED_START_DATE DATE;
P_ATTENDED_END_DATE DATE;
P_ESTABLISHMENT VARCHAR2(200);
P_BUSINESS_GROUP_ID NUMBER;
P_PERSON_ID NUMBER;
P_PARTY_ID NUMBER;
P_ADDRESS VARCHAR2(200);

P_ESTABLISHMENT_ID NUMBER;

P_ATTRIBUTE_CATEGORY VARCHAR2(200);

P_ATTRIBUTE1 VARCHAR2(200);

P_ATTRIBUTE2 VARCHAR2(200);
P_ATTRIBUTE3 VARCHAR2(200);
P_ATTRIBUTE4 VARCHAR2(200);

P_ATTRIBUTE5 VARCHAR2(200);

P_ATTRIBUTE6 VARCHAR2(200);

P_ATTRIBUTE7 VARCHAR2(200);

P_ATTRIBUTE8 VARCHAR2(200);
P_ATTRIBUTE9 VARCHAR2(200);
P_ATTRIBUTE10 VARCHAR2(200);
P_ATTRIBUTE11 VARCHAR2(200);
P_ATTRIBUTE12 VARCHAR2(200);
P_ATTRIBUTE13 VARCHAR2(200);
P_ATTRIBUTE14 VARCHAR2(200);
P_ATTRIBUTE15 VARCHAR2(200);
P_ATTRIBUTE16 VARCHAR2(200);
P_ATTRIBUTE17 VARCHAR2(200);
P_ATTRIBUTE18 VARCHAR2(200);
P_ATTRIBUTE19 VARCHAR2(200);
P_ATTRIBUTE20 VARCHAR2(200);
P_ATTENDANCE_ID NUMBER;
P_OBJECT_VERSION_NUMBER NUMBER;

CURSOR C1 IS
SELECT *
FROM XX_Q2
WHERE NVL(VALID_FLAG,'ERROR') 'DONE'
AND PERSON_ID 91
AND PERSON_ID IS NOT NULL;

BEGIN

FOR C1_REC IN C1 LOOP

P_VALIDATE := FALSE;
P_EFFECTIVE_DATE := SYSDATE;
P_FULLTIME := 'N';
P_ATTENDED_START_DATE := NULL;
P_ATTENDED_END_DATE := NULL;
P_ESTABLISHMENT := NULL;
P_BUSINESS_GROUP_ID := 103;
P_PERSON_ID := c1_REC.PERSON_ID;
P_PARTY_ID := NULL;
P_ADDRESS := NULL;

BEGIN
SELECT DISTINCT ESTABLISHMENT_ID
INTO P_ESTABLISHMENT_ID
FROM per_establishments
WHERE UPPER(NAME) = UPPER(C1_REC.ESTABLISHMENT);
EXCEPTION
WHEN OTHERS THEN NULL;
END;

P_ATTRIBUTE_CATEGORY := NULL;
P_ATTRIBUTE1 := NULL;
P_ATTRIBUTE2 := NULL;
P_ATTRIBUTE3 := NULL;
P_ATTRIBUTE4 := NULL;
P_ATTRIBUTE5 := NULL;
P_ATTRIBUTE6 := NULL;
P_ATTRIBUTE7 := NULL;
P_ATTRIBUTE8 := NULL;
P_ATTRIBUTE9 := NULL;
P_ATTRIBUTE10 := NULL;
P_ATTRIBUTE11 := NULL;
P_ATTRIBUTE12 := NULL;
P_ATTRIBUTE13 := NULL;
P_ATTRIBUTE14 := NULL;
P_ATTRIBUTE15 := NULL;
P_ATTRIBUTE16 := NULL;
P_ATTRIBUTE17 := NULL;
P_ATTRIBUTE18 := NULL;
P_ATTRIBUTE19 := NULL;
P_ATTRIBUTE20 := NULL;
P_ATTENDANCE_ID := NULL;
P_OBJECT_VERSION_NUMBER := NULL;

BEGIN
APPS.PER_ESTAB_ATTENDANCES_API.CREATE_ATTENDED_ESTAB (
P_VALIDATE,
P_EFFECTIVE_DATE,
P_FULLTIME,
P_ATTENDED_START_DATE,
P_ATTENDED_END_DATE,
P_ESTABLISHMENT,
P_BUSINESS_GROUP_ID,
P_PERSON_ID,
P_PARTY_ID,
P_ADDRESS,
P_ESTABLISHMENT_ID,
P_ATTRIBUTE_CATEGORY,
P_ATTRIBUTE1,
P_ATTRIBUTE2,
P_ATTRIBUTE3,
P_ATTRIBUTE4,
P_ATTRIBUTE5,
P_ATTRIBUTE6,
P_ATTRIBUTE7,
P_ATTRIBUTE8,
P_ATTRIBUTE9,
P_ATTRIBUTE10,
P_ATTRIBUTE11,
P_ATTRIBUTE12,
P_ATTRIBUTE13,
P_ATTRIBUTE14,
P_ATTRIBUTE15,
P_ATTRIBUTE16,
P_ATTRIBUTE17,
P_ATTRIBUTE18,
P_ATTRIBUTE19,
P_ATTRIBUTE20,
P_ATTENDANCE_ID,
P_OBJECT_VERSION_NUMBER );

UPDATE   XX_Q2
SET VALID_FLAG = 'DONE',
ERROR_MSG = 'NO ERROR'
WHERE PERSON_ID = C1_REC.PERSON_ID;
COMMIT;
EXCEPTION
WHEN OTHERS THEN
V_ERROR := SQLERRM;
UPDATE   XX_Q2
SET VALID_FLAG = 'ERROR',
ERROR_MSG = V_ERROR
WHERE PERSON_ID = C1_REC.PERSON_ID;
COMMIT;
END;


END LOOP;
END;

Tag:API, Attended Establishment API, HRMS, HRMS Attended Establishment API

  • Share:
Admin bar avatar
Sameh Bakkar
Sameh Bakkar has over 15 years Oracle Applications implementation experience (EBS/Fusion) and he is an Oracle authorized trainer. He has in-depth technical and Functional knowledge of Oracle Applications and Oracle HCM Cloud. Sameh has excellent experience in Team management, Man Power and resource planning, and Pre-Sales management Process. Additionally he has also given Best Practices seminars on Oracle e-business suite and Oracle Fusion.

Previous post

HRMS Employee's Address Maigration
March 19, 2011

Next post

HRMS Employee's Qualification API
19 March, 2011

You may also like

  • Entering Request for Quotations (RFQ)
    19 June, 2012
  • HRMS Assignment Migration – API
    9 March, 2011

Leave A Reply Cancel reply

Your email address will not be published. Required fields are marked *

Search

Categories

  • Blog
  • Fusion HCM
  • Oracle ebusiness Suite
  • Oracle Financial
  • Oracle Fusion
  • Oracle HCM
  • Oracle SCM

Latest Courses

R12.x Oracle E-Business Suite Essentials for Implementers

R12.x Oracle E-Business Suite Essentials for Implementers

Free
R12.x Oracle HRMS Work Structures Fundamentals

R12.x Oracle HRMS Work Structures Fundamentals

Free
R12.x Oracle Payroll Fundamentals

R12.x Oracle Payroll Fundamentals

Free
AppsLead | Learn Oracle From The Leaders

+2 0100 62 62 837

[email protected]

Company

  • About Us
  • Blog
  • Contact Us

Links

  • Events

Copyright © 2017 AppsLead, All rights reserved. Developed by ECDSCS Co.

  • Privacy
  • Terms
  • Sitemap