DBA Data[Home] [Help]

APPS.PAY_IE_LEGISLATIVE_ARCHIVE dependencies on PAY_ACTION_INFORMATION

Line 222: pay_action_information_api.create_action_information (

218: IF p_archive = 'Y'
219:
220: THEN
221:
222: pay_action_information_api.create_action_information (
223: p_action_information_id => l_action_info_id
224: , p_action_context_id => p_pactid
225: , p_action_context_type => 'PA'
226: , p_object_version_number => l_ovn

Line 269: pay_action_information_api.create_action_information (

265: THEN
266:
267: hr_utility.set_location('Arch EMEA ELEMENT DEFINITION',99);
268:
269: pay_action_information_api.create_action_information (
270: p_action_information_id => l_action_info_id
271: , p_action_context_id => p_pactid
272: , p_action_context_type => 'PA'
273: , p_object_version_number => l_ovn

Line 457: pay_action_information_api.create_action_information (

453: hr_utility.set_location('Arch EMEA ELEMENT DEFINITION',99);
454:
455: IF l_payment_type_bik='P'
456: THEN
457: pay_action_information_api.create_action_information (
458: p_action_information_id => l_action_info_id
459: , p_action_context_id => p_pactid
460: , p_action_context_type => 'PA'
461: , p_object_version_number => l_ovn

Line 480: pay_action_information_api.create_action_information (

476: --deduction section,passing a value of 'E' and 'D' to payment type
477:
478: IF l_payment_type_bik='C'
479: THEN
480: pay_action_information_api.create_action_information (
481: p_action_information_id => l_action_info_id
482: , p_action_context_id => p_pactid
483: , p_action_context_type => 'PA'
484: , p_object_version_number => l_ovn

Line 496: pay_action_information_api.create_action_information (

492: , p_action_information4 => csr_element_rec.element_name
493: , p_action_information5 => 'E'
494: , p_action_information6 => csr_element_rec.uom);
495:
496: pay_action_information_api.create_action_information (
497: p_action_information_id => l_action_info_id
498: , p_action_context_id => p_pactid
499: , p_action_context_type => 'PA'
500: , p_object_version_number => l_ovn

Line 1302: pay_action_information_api.create_action_information (

1298: END IF;
1299:
1300: hr_utility.set_location('Archiving IE EMPLOYEE DETAILS',50);
1301:
1302: pay_action_information_api.create_action_information (
1303: p_action_information_id => l_action_info_id
1304: , p_action_context_id => p_assactid
1305: , p_action_context_type => 'AAP'
1306: , p_object_version_number => l_ovn

Line 1455: pay_action_information_api.create_action_information (

1451: THEN
1452:
1453: hr_utility.set_location('Archiving EMEA BALANCES',20);
1454:
1455: pay_action_information_api.create_action_information (
1456: p_action_information_id => l_action_info_id
1457: , p_action_context_id => p_action_context_id
1458: , p_action_context_type => 'AAP'
1459: , p_object_version_number => l_ovn

Line 1594: pay_action_information_api.create_action_information (

1590: INTO l_result_value
1591: FROM dual;
1592:
1593:
1594: pay_action_information_api.create_action_information (
1595: p_action_information_id => l_action_info_id
1596: , p_action_context_id => p_action_context_id
1597: , p_action_context_type => 'AAP'
1598: , p_object_version_number => l_ovn

Line 1785: FROM pay_action_information pai

1781: AND (pact.action_type = 'P' OR
1782: pact.action_type = 'U')
1783: AND pact.action_status = 'C'
1784: AND NOT EXISTS (SELECT NULL
1785: FROM pay_action_information pai
1786: WHERE pai.action_context_id = pact.payroll_action_id
1787: AND pai.action_context_type = 'PA'
1788: AND pai.action_information_category = 'EMEA PAYROLL INFO'
1789: AND pai.action_information5 = g_paye_ref ) -- Bug fix 4001540

Line 1841: FROM pay_action_information pai

1837: AND (pact.action_type = 'R' OR
1838: pact.action_type = 'Q')
1839: AND pact.action_status = 'C'
1840: AND NOT EXISTS (SELECT NULL
1841: FROM pay_action_information pai
1842: WHERE pai.action_context_id = pact.payroll_action_id
1843: AND pai.action_context_type = 'PA'
1844: AND pai.action_information_category = 'EMPLOYEE OTHER INFORMATION'); */
1845: --

Line 1919: pay_action_information_api.create_action_information (

1915:
1916:
1917: /*FOR tax_info_rec IN csr_get_org_tax_address (l_consolidation_set,g_paye_ref) LOOP
1918: --
1919: pay_action_information_api.create_action_information (
1920: p_action_information_id => l_action_info_id
1921: , p_action_context_id => pactid
1922: , p_action_context_type => 'PA'
1923: , p_object_version_number => l_ovn

Line 1993: pay_action_information_api.create_action_information (

1989: hr_utility.set_location('rec_payroll_info.employers_paye_ref_no = ' || rec_payroll_info.employer_paye_ref_no,30);
1990:
1991: hr_utility.set_location('Archiving EMEA PAYROLL INFO',30);
1992:
1993: pay_action_information_api.create_action_information (
1994: p_action_information_id => l_action_info_id
1995: , p_action_context_id => pactid
1996: , p_action_context_type => 'PA'
1997: , p_object_version_number => l_ovn

Line 2024: pay_action_information_api.create_action_information (

2020:
2021: IF rec_payroll_msg.payroll_message IS NOT NULL
2022: THEN
2023: --
2024: pay_action_information_api.create_action_information (
2025: p_action_information_id => l_action_info_id
2026: , p_action_context_id => pactid
2027: , p_action_context_type => 'PA'
2028: , p_object_version_number => l_ovn

Line 2832: FROM pay_action_information pai

2828: CURSOR csr_check_archived(p_pact_id NUMBER) IS
2829: SELECT 1
2830: FROM DUAL
2831: WHERE EXISTS (SELECT NULL
2832: FROM pay_action_information pai
2833: WHERE pai.action_context_id = p_pact_id
2834: AND pai.action_context_type = 'PA'
2835: AND rownum = 1
2836: );

Line 2900: FROM pay_action_information pai

2896: AND pai.locking_action_id = paa_arc.assignment_action_id
2897: AND paa_arc.payroll_action_id = p_pact_id
2898: AND paa.payroll_action_id = pact.payroll_action_id)
2899: AND NOT EXISTS (SELECT NULL
2900: FROM pay_action_information pai
2901: WHERE pai.action_context_id = pact.payroll_action_id
2902: AND pai.action_context_type = 'PA'
2903: AND pai.action_information_category = 'EMEA PAYROLL INFO'
2904: AND pai.action_information5 = g_paye_ref ) -- Bug fix 4001540

Line 2960: FROM pay_action_information pai

2956: AND (pact.action_type = 'R' OR
2957: pact.action_type = 'Q')
2958: AND pact.action_status = 'C'
2959: AND NOT EXISTS (SELECT NULL
2960: FROM pay_action_information pai
2961: WHERE pai.action_context_id = pact.payroll_action_id
2962: AND pai.action_context_type = 'PA'
2963: AND pai.action_information_category = 'EMPLOYEE OTHER INFORMATION');
2964: --

Line 3046: pay_action_information_api.create_action_information (

3042:
3043:
3044: FOR tax_info_rec IN csr_get_org_tax_address (l_consolidation_set,g_paye_ref) LOOP
3045: --
3046: pay_action_information_api.create_action_information (
3047: p_action_information_id => l_action_info_id
3048: , p_action_context_id => p_payroll_action_id
3049: , p_action_context_type => 'PA'
3050: , p_object_version_number => l_ovn

Line 3121: pay_action_information_api.create_action_information (

3117: hr_utility.set_location('rec_payroll_info.employers_paye_ref_no = ' || rec_payroll_info.employer_paye_ref_no,30);
3118:
3119: hr_utility.set_location('Archiving EMEA PAYROLL INFO',30);
3120:
3121: pay_action_information_api.create_action_information (
3122: p_action_information_id => l_action_info_id
3123: , p_action_context_id => p_payroll_action_id
3124: , p_action_context_type => 'PA'
3125: , p_object_version_number => l_ovn

Line 3152: pay_action_information_api.create_action_information (

3148:
3149: IF rec_payroll_msg.payroll_message IS NOT NULL
3150: THEN
3151: --
3152: pay_action_information_api.create_action_information (
3153: p_action_information_id => l_action_info_id
3154: , p_action_context_id => p_payroll_action_id
3155: , p_action_context_type => 'PA'
3156: , p_object_version_number => l_ovn