APPS.PAY_APAC_PAYSLIP_ARCHIVE dependencies on PAY_ACTION_INFORMATION

Line 215: pay_action_information_api.create_action_information

211: END IF;
212:
213: IF p_archive = 'Y' THEN
214:
215: pay_action_information_api.create_action_information
216: ( p_action_information_id => l_action_info_id
217: , p_action_context_id => p_payroll_action_id
218: , p_action_context_type => 'PA'
219: , p_object_version_number => l_ovn

Line 265: pay_action_information_api.create_action_information

261: END IF;
262:
263: IF p_archive = 'Y' THEN
264:
265: pay_action_information_api.create_action_information
266: ( p_action_information_id => l_action_info_id
267: , p_action_context_id => p_payroll_action_id
268: , p_action_context_type => 'PA'
269: , p_object_version_number => l_ovn

Line 389: pay_action_information_api.create_action_information

385: -- Archive balance if non-zero
386:
387: IF l_balance_value <> 0 THEN
388:
389: pay_action_information_api.create_action_information
390: ( p_action_information_id => l_action_info_id
391: , p_action_context_id => p_arch_assignment_action_id
392: , p_action_context_type => 'AAP'
393: , p_object_version_number => l_ovn

Line 458: FROM pay_action_information

454:
455: CURSOR csr_archived_elements(p_arch_assignment_action_id NUMBER)
456: IS
457: SELECT action_information1
458: FROM pay_action_information
459: WHERE action_context_id = p_arch_assignment_action_id
460: AND action_information_category = 'APAC ELEMENTS'
461: AND action_context_type = 'AAP';
462:

Line 600: pay_action_information_api.create_action_information

596: END LOOP;
597: /*Bug 3228928 - Archive the sum for numeric values */
598: IF l_sum_value <> 0 THEN
599:
600: pay_action_information_api.create_action_information
601: ( p_action_information_id => l_action_info_id
602: , p_action_context_id => p_arch_assignment_action_id
603: , p_action_context_type => 'AAP'
604: , p_object_version_number => l_ovn

Line 624: pay_action_information_api.create_action_information

620: ,g_element_table(l_index).element_type_id
621: ,g_element_table(l_index).input_value_id)
622: LOOP
623:
624: pay_action_information_api.create_action_information
625: ( p_action_information_id => l_action_info_id
626: , p_action_context_id => p_arch_assignment_action_id
627: , p_action_context_type => 'AAP'
628: , p_object_version_number => l_ovn

Line 766: FROM pay_action_information pai

762: AND ppa.action_type = 'R'
763: AND ppa.action_status = 'C'
764: AND ppa.payroll_id = pp.payroll_id
765: AND NOT EXISTS (SELECT NULL
766: FROM pay_action_information pai
767: WHERE pai.action_context_id = ppa.payroll_action_id
768: AND pai.action_context_type = 'PA'
769: AND pai.action_information_category = 'EMPLOYEE OTHER INFORMATION')
770: UNION

Line 786: FROM pay_action_information pai

782: AND ppa.action_status = 'C'
783: AND ppa.payroll_id = pp.payroll_id
784: AND paa.payroll_action_id = ppa.payroll_action_id
785: AND NOT EXISTS (SELECT NULL
786: FROM pay_action_information pai
787: WHERE pai.action_context_id = ppa.payroll_action_id
788: AND pai.action_context_type = 'PA'
789: AND pai.action_information_category = 'EMPLOYEE OTHER INFORMATION');
790:

Line 854: pay_action_information_api.create_action_information

850: LOOP
851:
852: IF csr_msg_rec.payroll_message IS NOT NULL THEN
853:
854: pay_action_information_api.create_action_information
855: ( p_action_information_id => l_action_info_id
856: , p_action_context_id => p_payroll_action_id
857: , p_action_context_type => 'PA'
858: , p_object_version_number => l_ovn

Line 1014: FROM pay_action_information

1010: IS
1011: CURSOR check_pa_data_existence
1012: IS
1013: SELECT 1
1014: FROM pay_action_information
1015: WHERE action_context_id = p_payroll_action_id
1016: AND action_context_type = 'PA'
1017: AND action_information_category IN('EMEA BALANCE DEFINITION'
1018: ,'EMEA ELEMENT DEFINITION'