eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_DK_ABSR_PKG dependencies on PAY_ACTION_INFORMATION

Line 216: FROM pay_action_information

212:
213: /* Cursor to check if Current Archive exists */
214: CURSOR csr_count is
215: SELECT count(*)
216: FROM pay_action_information
217: WHERE action_information_category = 'EMEA REPORT DETAILS'
218: AND action_information1 = 'PYDKSTATSA'
219: AND action_context_id = pactid;
220:

Line 395: pay_action_information_api.create_action_information

391: CLOSE csr_get_le_da_off_codes;
392:
393: l_le_da_scode := rec_get_le_da_off_codes.da_scode;
394:
395: pay_action_information_api.create_action_information
396: (
397: p_action_information_id => l_action_info_id -- out parameter
398: ,p_object_version_number => l_ovn -- out parameter
399: ,p_action_context_id => pactid -- context id = payroll action id (of Archive)

Line 461: FROM pay_action_information pai

457: ,action_information8 LE_NAME
458: ,action_information18 LE_PUNIT --8840262
459: ,action_information17 LE_DA_OFFICE_CODE
460: ,action_information10 LE_CVR_NUMBER
461: FROM pay_action_information pai
462: WHERE action_context_type = 'PA'
463: AND action_context_id = p_payroll_action_id
464: AND action_information_category = 'EMEA REPORT DETAILS'
465: AND action_information1 = 'PYDKASORA'

Line 730: l_le_cvr_no pay_action_information.action_information1%type;

726: l_bg_id NUMBER;
727:
728: l_loc_punit VARCHAR2(10);
729:
730: l_le_cvr_no pay_action_information.action_information1%type;
731: l_le_da_scode pay_action_information.action_information1%type;
732: l_assg_no pay_action_information.action_information1%type;
733: l_cpr_no pay_action_information.action_information1%type;
734: l_abs_code pay_action_information.action_information1%type;

Line 731: l_le_da_scode pay_action_information.action_information1%type;

727:
728: l_loc_punit VARCHAR2(10);
729:
730: l_le_cvr_no pay_action_information.action_information1%type;
731: l_le_da_scode pay_action_information.action_information1%type;
732: l_assg_no pay_action_information.action_information1%type;
733: l_cpr_no pay_action_information.action_information1%type;
734: l_abs_code pay_action_information.action_information1%type;
735: l_time_units NUMBER;

Line 732: l_assg_no pay_action_information.action_information1%type;

728: l_loc_punit VARCHAR2(10);
729:
730: l_le_cvr_no pay_action_information.action_information1%type;
731: l_le_da_scode pay_action_information.action_information1%type;
732: l_assg_no pay_action_information.action_information1%type;
733: l_cpr_no pay_action_information.action_information1%type;
734: l_abs_code pay_action_information.action_information1%type;
735: l_time_units NUMBER;
736: l_sign_units pay_action_information.action_information1%type;

Line 733: l_cpr_no pay_action_information.action_information1%type;

729:
730: l_le_cvr_no pay_action_information.action_information1%type;
731: l_le_da_scode pay_action_information.action_information1%type;
732: l_assg_no pay_action_information.action_information1%type;
733: l_cpr_no pay_action_information.action_information1%type;
734: l_abs_code pay_action_information.action_information1%type;
735: l_time_units NUMBER;
736: l_sign_units pay_action_information.action_information1%type;
737: l_abs_start_date date;

Line 734: l_abs_code pay_action_information.action_information1%type;

730: l_le_cvr_no pay_action_information.action_information1%type;
731: l_le_da_scode pay_action_information.action_information1%type;
732: l_assg_no pay_action_information.action_information1%type;
733: l_cpr_no pay_action_information.action_information1%type;
734: l_abs_code pay_action_information.action_information1%type;
735: l_time_units NUMBER;
736: l_sign_units pay_action_information.action_information1%type;
737: l_abs_start_date date;
738: l_abs_end_date date;

Line 736: l_sign_units pay_action_information.action_information1%type;

732: l_assg_no pay_action_information.action_information1%type;
733: l_cpr_no pay_action_information.action_information1%type;
734: l_abs_code pay_action_information.action_information1%type;
735: l_time_units NUMBER;
736: l_sign_units pay_action_information.action_information1%type;
737: l_abs_start_date date;
738: l_abs_end_date date;
739: l_punit pay_action_information.action_information1%type;
740: l_punit_code pay_action_information.action_information1%type; --8840262

Line 739: l_punit pay_action_information.action_information1%type;

735: l_time_units NUMBER;
736: l_sign_units pay_action_information.action_information1%type;
737: l_abs_start_date date;
738: l_abs_end_date date;
739: l_punit pay_action_information.action_information1%type;
740: l_punit_code pay_action_information.action_information1%type; --8840262
741: l_org_punit pay_action_information.action_information1%type; --8840262
742:
743: l_abs_start_time pay_action_information.action_information1%type;

Line 740: l_punit_code pay_action_information.action_information1%type; --8840262

736: l_sign_units pay_action_information.action_information1%type;
737: l_abs_start_date date;
738: l_abs_end_date date;
739: l_punit pay_action_information.action_information1%type;
740: l_punit_code pay_action_information.action_information1%type; --8840262
741: l_org_punit pay_action_information.action_information1%type; --8840262
742:
743: l_abs_start_time pay_action_information.action_information1%type;
744: l_abs_end_time pay_action_information.action_information1%type;

Line 741: l_org_punit pay_action_information.action_information1%type; --8840262

737: l_abs_start_date date;
738: l_abs_end_date date;
739: l_punit pay_action_information.action_information1%type;
740: l_punit_code pay_action_information.action_information1%type; --8840262
741: l_org_punit pay_action_information.action_information1%type; --8840262
742:
743: l_abs_start_time pay_action_information.action_information1%type;
744: l_abs_end_time pay_action_information.action_information1%type;
745:

Line 743: l_abs_start_time pay_action_information.action_information1%type;

739: l_punit pay_action_information.action_information1%type;
740: l_punit_code pay_action_information.action_information1%type; --8840262
741: l_org_punit pay_action_information.action_information1%type; --8840262
742:
743: l_abs_start_time pay_action_information.action_information1%type;
744: l_abs_end_time pay_action_information.action_information1%type;
745:
746: l_hours_rate NUMBER;
747: l_freq VARCHAR2(80);

Line 744: l_abs_end_time pay_action_information.action_information1%type;

740: l_punit_code pay_action_information.action_information1%type; --8840262
741: l_org_punit pay_action_information.action_information1%type; --8840262
742:
743: l_abs_start_time pay_action_information.action_information1%type;
744: l_abs_end_time pay_action_information.action_information1%type;
745:
746: l_hours_rate NUMBER;
747: l_freq VARCHAR2(80);
748: l_day_max_hrs NUMBER;

Line 1057: hr_utility.trace(' creating pay_action_information_api.create_action_information ');

1053: hr_utility.trace('l_punit: '||l_punit );
1054:
1055: IF l_time_units <> 0 AND l_abs_code IS NOT NULL THEN --8789760
1056:
1057: hr_utility.trace(' creating pay_action_information_api.create_action_information ');
1058:
1059: pay_action_information_api.create_action_information
1060: ( p_action_information_id => l_action_info_id -- OUT parameter
1061: ,p_object_version_number => l_ovn -- OUT parameter

Line 1059: pay_action_information_api.create_action_information

1055: IF l_time_units <> 0 AND l_abs_code IS NOT NULL THEN --8789760
1056:
1057: hr_utility.trace(' creating pay_action_information_api.create_action_information ');
1058:
1059: pay_action_information_api.create_action_information
1060: ( p_action_information_id => l_action_info_id -- OUT parameter
1061: ,p_object_version_number => l_ovn -- OUT parameter
1062: ,p_action_context_id => l_actid -- Context id = assignment action id (of Archive)
1063: ,p_action_context_type => 'AAP' -- Context type

Line 1088: hr_utility.trace('After pay_action_information_api.create_action_information ' );

1084: ,p_action_information16 => nvl(l_punit_code,l_punit) --LE's P Unit Code --8840262
1085: ,p_action_information17 => l_abs_start_time --Start time of Absence
1086: ,p_action_information18 => l_abs_end_time --End time of Absence
1087: );
1088: hr_utility.trace('After pay_action_information_api.create_action_information ' );
1089:
1090: END IF;
1091:
1092: --8789760

Line 1213: FROM pay_action_information pai

1209: /* Cursor to fetch File Start and End Record Information */
1210: CURSOR csr_get_hdr_info(p_payroll_action_id NUMBER)
1211: IS
1212: SELECT *
1213: FROM pay_action_information pai
1214: WHERE action_context_type = 'PA'
1215: AND action_context_id = p_payroll_action_id
1216: AND action_information_category = 'EMEA REPORT DETAILS'
1217: AND action_information1 = 'PYDKASORA'

Line 1228: pay_action_information pai

1224: SELECT pai.*
1225: FROM
1226: pay_payroll_actions ppa,
1227: Pay_assignment_actions paa,
1228: pay_action_information pai
1229: WHERE
1230: ppa.payroll_action_id = p_payroll_action_id
1231: AND ppa.payroll_action_id = paa.payroll_action_id
1232: AND paa.assignment_action_id = pai.action_context_id