APPS.PAY_KR_PAYSLIP_ARCHIVE dependencies on PAY_ACTION_INFORMATION

Line 132: -- elements into pay_action_information with action_information_category

128: END assignment_action_code;
129:
130: /********************************************************************************
131: -- This procedure archives all the standard earnings and deductions
132: -- elements into pay_action_information with action_information_category
133: -- as 'APAC ELEMENTS'.
134: ********************************************************************************/
135:
136: PROCEDURE archive_kr_standard_elements

Line 166: pay_action_information_api.create_action_information

162:
163: FOR csr_record IN csr_std_elements(p_pre_assignment_action_id)
164: LOOP
165:
166: pay_action_information_api.create_action_information
167: (p_action_information_id => l_action_info_id
168: ,p_action_context_id => p_arch_assignment_action_id
169: ,p_action_context_type => 'AAP'
170: ,p_object_version_number => l_ovn

Line 198: -- pay_action_information with action_information_category as

194: END archive_kr_standard_elements;
195:
196: /********************************************************************************
197: -- This procedure archives Annual Leave information of an employee into
198: -- pay_action_information with action_information_category as
199: -- 'APAC ABSENCES'.
200: ********************************************************************************/
201:
202: PROCEDURE archive_leave_balances

Line 330: pay_action_information_api.create_action_information (

326: hr_utility.trace('..Leave Balances...........:'|| l_leave_balance);
327: hr_utility.trace('..archiving the ABSENCES Info');
328: end if;
329:
330: pay_action_information_api.create_action_information (
331: p_action_information_id => l_action_info_id
332: ,p_action_context_id => p_arch_assignment_action_id
333: ,p_action_context_type => 'AAP'
334: ,p_object_version_number => l_ovn

Line 420: -- into pay_action_information with action_information_category as

416:
417: /********************************************************************************
418: -- This procedure archives the Employee Other information like
419: -- Second Grade, Grade Point , Job Title, Seniority and Run Type Name
420: -- into pay_action_information with action_information_category as
421: -- 'KR EMPLOYEE DETAILS'.
422: ********************************************************************************/
423:
424: PROCEDURE archive_employee_other_info(

Line 501: pay_action_information_api.create_action_information (

497: if g_debug then
498: hr_utility.trace('l_kr_run_type_name...:'|| l_kr_run_type_name);
499: end if;
500:
501: pay_action_information_api.create_action_information (
502: p_action_information_id => l_action_info_id
503: ,p_action_context_id => p_arch_assignment_action_id
504: ,p_action_context_type => 'AAP'
505: ,p_object_version_number => l_ovn

Line 564: FROM pay_action_information pai

560: IS
561: SELECT pai.action_information_id
562: ,pai.action_information5
563: ,nvl(hr_general_utilities.get_lookup_Meaning('KR_BANK',substr(pai.action_information5,1,2)),' ') bank_name
564: FROM pay_action_information pai
565: WHERE action_information_category = 'EMPLOYEE NET PAY DISTRIBUTION'
566: AND action_context_id = p_assignment_action_id
567: AND action_context_type = 'AAP';
568:

Line 575: FROM pay_action_information pai

571: CURSOR csr_emp_details(p_assignment_action_id IN NUMBER)
572: IS
573: SELECT pai.action_information_id
574: ,pai.action_information18
575: FROM pay_action_information pai
576: WHERE action_information_category = 'EMPLOYEE DETAILS'
577: AND action_context_id = p_assignment_action_id
578: AND action_context_type = 'AAP';
579:

Line 625: pay_action_information_api.update_action_information (

621: if g_debug then
622: hr_utility.trace(' Bank Name....:'||net_pay_rec.bank_name);
623: end if;
624:
625: pay_action_information_api.update_action_information (
626: p_action_information_id => net_pay_rec.action_information_id
627: ,p_object_version_number => l_ovn
628: ,p_action_information9 => net_pay_rec.bank_name );
629: END LOOP;

Line 653: pay_action_information_api.update_action_information (

649: hr_utility.trace(' Updating the Employer Name..:'||emp_rec.action_information18);
650: hr_utility.trace(' with Business Place ..:'||l_kr_business_place);
651: end if;
652:
653: pay_action_information_api.update_action_information (
654: p_action_information_id => emp_rec.action_information_id
655: ,p_object_version_number => l_ovn
656: ,p_action_information18 => l_kr_business_place);
657: