Payroll and OTL - EBS (MOSC)

MOSC Banner

Announcements for Payroll and OTL can now be found in the Announcements - Payroll and OTL - EBS (MOSC) subcategory. Follow to be sure you don't miss a thing!

PAY: pay_element_entry_api.create_element_entry

edited Dec 11, 2013 2:30AM in Payroll and OTL - EBS (MOSC) 1 commentAnswered ✓
Hello Guys, 

Below is the code for the element entry in the custom form the upload the element values.

 Declare
    l_effective_start_date   date     ;
    l_effective_end_date     date     ;
    l_element_entry_id       number(30)   ;
    l_object_version_number  number(30)  ;
    l_create_warning         boolean  ;
    err_num  number;
    err_msg varchar2(2000);
    CURSOR C1 IS 
    select A.EMP_ID,A.LATE_HOURS,A.EARLY_HOURS,papf.EMPLOYEE_NUMBER,papf.person_id,paaf.assignment_ID,Paaf.payroll_ID,
          decode(Paaf.payroll_ID,61,'3121',62,'3123',81,'3122',' ') Element_Link_ID
    from 
    XX_ATTENDANCE_SUMMARY  a, 
    per_all_people_f papf, 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center