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_IE_LEGISLATIVE_ARCHIVE dependencies on PAY_ACTION_INFORMATION

Line 112: --Added the below procedure to archieve payments and dedutions data in to pay_action_information table

108:
109: END get_parameters;
110:
111: -- Start fix for Bug#8522324
112: --Added the below procedure to archieve payments and dedutions data in to pay_action_information table
113: PROCEDURE get_pay_deduct_element_info ( p_assignment_action_id IN NUMBER,
114: p_assignment_id IN NUMBER DEFAULT NULL,
115: p_effective_date IN DATE DEFAULT NULL)
116: IS

Line 141: pay_action_information pai, -- archived element/input value definition

137: FROM pay_action_interlocks lck, -- archive action locking prepayment
138: pay_assignment_actions paa1, -- prepayment action
139: pay_assignment_actions paa2, -- archive action
140: pay_payroll_actions ppa, -- prepayment
141: pay_action_information pai, -- archived element/input value definition
142: pay_action_interlocks pac, -- prepayment locking payroll run/quickpay
143: pay_assignment_actions paa, -- payroll run/quickpay action
144: pay_payroll_actions ppa1, -- payroll run/quickpay action
145: pay_element_types_f pet, -- element types processed by the payroll run/quickpay

Line 236: pay_action_information_api.create_action_information (

232: and (rec_element_value.narrative is not null))
233: then
234: hr_utility.set_location('Archiving EMEA ELEMENT INFO',30);
235: /* Creating action information */
236: pay_action_information_api.create_action_information (
237: p_action_information_id => l_action_info_id
238: , p_action_context_id => p_assignment_action_id
239: , p_action_context_type => 'AAP'
240: , p_object_version_number => l_ovn

Line 376: pay_action_information_api.create_action_information (

372: IF p_archive = 'Y'
373:
374: THEN
375:
376: pay_action_information_api.create_action_information (
377: p_action_information_id => l_action_info_id
378: , p_action_context_id => p_pactid
379: , p_action_context_type => 'PA'
380: , p_object_version_number => l_ovn

Line 423: pay_action_information_api.create_action_information (

419: THEN
420:
421: hr_utility.set_location('Arch EMEA ELEMENT DEFINITION',99);
422:
423: pay_action_information_api.create_action_information (
424: p_action_information_id => l_action_info_id
425: , p_action_context_id => p_pactid
426: , p_action_context_type => 'PA'
427: , p_object_version_number => l_ovn

Line 614: pay_action_information_api.create_action_information (

610: hr_utility.set_location('Arch EMEA ELEMENT DEFINITION',99);
611:
612: IF l_payment_type_bik='P'
613: THEN
614: pay_action_information_api.create_action_information (
615: p_action_information_id => l_action_info_id
616: , p_action_context_id => p_pactid
617: , p_action_context_type => 'PA'
618: , p_object_version_number => l_ovn

Line 637: pay_action_information_api.create_action_information (

633: --deduction section,passing a value of 'E' and 'D' to payment type
634:
635: IF l_payment_type_bik='C'
636: THEN
637: pay_action_information_api.create_action_information (
638: p_action_information_id => l_action_info_id
639: , p_action_context_id => p_pactid
640: , p_action_context_type => 'PA'
641: , p_object_version_number => l_ovn

Line 653: pay_action_information_api.create_action_information (

649: , p_action_information4 => csr_element_rec.element_name
650: , p_action_information5 => 'E'
651: , p_action_information6 => csr_element_rec.uom);
652:
653: pay_action_information_api.create_action_information (
654: p_action_information_id => l_action_info_id
655: , p_action_context_id => p_pactid
656: , p_action_context_type => 'PA'
657: , p_object_version_number => l_ovn

Line 1005: FROM pay_action_information pai

1001: CURSOR csr_check_archived(p_pact_id NUMBER) IS
1002: SELECT 1
1003: FROM DUAL
1004: WHERE EXISTS (SELECT NULL
1005: FROM pay_action_information pai
1006: WHERE pai.action_context_id = p_pact_id
1007: AND pai.action_context_type = 'PA'
1008: AND action_information_category = 'EMEA ELEMENT DEFINITION'
1009: AND rownum = 1

Line 1523: pay_action_information_api.create_action_information (

1519: END IF;
1520:
1521: hr_utility.set_location('Archiving IE EMPLOYEE DETAILS',50);
1522:
1523: pay_action_information_api.create_action_information (
1524: p_action_information_id => l_action_info_id
1525: , p_action_context_id => p_assactid
1526: , p_action_context_type => 'AAP'
1527: , p_object_version_number => l_ovn

Line 1676: pay_action_information_api.create_action_information (

1672: THEN
1673:
1674: hr_utility.set_location('Archiving EMEA BALANCES',20);
1675:
1676: pay_action_information_api.create_action_information (
1677: p_action_information_id => l_action_info_id
1678: , p_action_context_id => p_action_context_id
1679: , p_action_context_type => 'AAP'
1680: , p_object_version_number => l_ovn

Line 1881: pay_action_information_api.create_action_information (

1877: INTO l_result_value
1878: FROM dual;
1879:
1880:
1881: pay_action_information_api.create_action_information (
1882: p_action_information_id => l_action_info_id
1883: , p_action_context_id => p_action_context_id
1884: , p_action_context_type => 'AAP'
1885: , p_object_version_number => l_ovn

Line 2072: FROM pay_action_information pai

2068: AND (pact.action_type = 'P' OR
2069: pact.action_type = 'U')
2070: AND pact.action_status = 'C'
2071: AND NOT EXISTS (SELECT NULL
2072: FROM pay_action_information pai
2073: WHERE pai.action_context_id = pact.payroll_action_id
2074: AND pai.action_context_type = 'PA'
2075: AND pai.action_information_category = 'EMEA PAYROLL INFO'
2076: AND pai.action_information5 = g_paye_ref ) -- Bug fix 4001540

Line 2128: FROM pay_action_information pai

2124: AND (pact.action_type = 'R' OR
2125: pact.action_type = 'Q')
2126: AND pact.action_status = 'C'
2127: AND NOT EXISTS (SELECT NULL
2128: FROM pay_action_information pai
2129: WHERE pai.action_context_id = pact.payroll_action_id
2130: AND pai.action_context_type = 'PA'
2131: AND pai.action_information_category = 'EMPLOYEE OTHER INFORMATION'); */
2132: --

Line 2216: pay_action_information_api.create_action_information (

2212: -- End fix for Bug#8522324
2213:
2214: /*FOR tax_info_rec IN csr_get_org_tax_address (l_consolidation_set,g_paye_ref) LOOP
2215: --
2216: pay_action_information_api.create_action_information (
2217: p_action_information_id => l_action_info_id
2218: , p_action_context_id => pactid
2219: , p_action_context_type => 'PA'
2220: , p_object_version_number => l_ovn

Line 2290: pay_action_information_api.create_action_information (

2286: hr_utility.set_location('rec_payroll_info.employers_paye_ref_no = ' || rec_payroll_info.employer_paye_ref_no,30);
2287:
2288: hr_utility.set_location('Archiving EMEA PAYROLL INFO',30);
2289:
2290: pay_action_information_api.create_action_information (
2291: p_action_information_id => l_action_info_id
2292: , p_action_context_id => pactid
2293: , p_action_context_type => 'PA'
2294: , p_object_version_number => l_ovn

Line 2321: pay_action_information_api.create_action_information (

2317:
2318: IF rec_payroll_msg.payroll_message IS NOT NULL
2319: THEN
2320: --
2321: pay_action_information_api.create_action_information (
2322: p_action_information_id => l_action_info_id
2323: , p_action_context_id => pactid
2324: , p_action_context_type => 'PA'
2325: , p_object_version_number => l_ovn

Line 3146: FROM pay_action_information pai

3142: CURSOR csr_check_archived(p_pact_id NUMBER) IS
3143: SELECT 1
3144: FROM DUAL
3145: WHERE EXISTS (SELECT NULL
3146: FROM pay_action_information pai
3147: WHERE pai.action_context_id = p_pact_id
3148: AND pai.action_context_type = 'PA'
3149: AND action_information_category <> 'EMEA ELEMENT DEFINITION' -- Bug#8522324
3150: AND rownum = 1

Line 3215: FROM pay_action_information pai

3211: AND pai.locking_action_id = paa_arc.assignment_action_id
3212: AND paa_arc.payroll_action_id = p_pact_id
3213: AND paa.payroll_action_id = pact.payroll_action_id)
3214: AND NOT EXISTS (SELECT NULL
3215: FROM pay_action_information pai
3216: WHERE pai.action_context_id = pact.payroll_action_id
3217: AND pai.action_context_type = 'PA'
3218: AND pai.action_information_category = 'EMEA PAYROLL INFO'
3219: AND pai.action_information5 = g_paye_ref ) -- Bug fix 4001540

Line 3275: FROM pay_action_information pai

3271: AND (pact.action_type = 'R' OR
3272: pact.action_type = 'Q')
3273: AND pact.action_status = 'C'
3274: AND NOT EXISTS (SELECT NULL
3275: FROM pay_action_information pai
3276: WHERE pai.action_context_id = pact.payroll_action_id
3277: AND pai.action_context_type = 'PA'
3278: AND pai.action_information_category = 'EMPLOYEE OTHER INFORMATION');
3279: --

Line 3362: pay_action_information_api.create_action_information (

3358:
3359:
3360: FOR tax_info_rec IN csr_get_org_tax_address (l_consolidation_set,g_paye_ref) LOOP
3361: --
3362: pay_action_information_api.create_action_information (
3363: p_action_information_id => l_action_info_id
3364: , p_action_context_id => p_payroll_action_id
3365: , p_action_context_type => 'PA'
3366: , p_object_version_number => l_ovn

Line 3439: pay_action_information_api.create_action_information (

3435: hr_utility.set_location('rec_payroll_info.employers_paye_ref_no = ' || rec_payroll_info.employer_paye_ref_no,30);
3436:
3437: hr_utility.set_location('Archiving EMEA PAYROLL INFO',30);
3438:
3439: pay_action_information_api.create_action_information (
3440: p_action_information_id => l_action_info_id
3441: , p_action_context_id => p_payroll_action_id
3442: , p_action_context_type => 'PA'
3443: , p_object_version_number => l_ovn

Line 3470: pay_action_information_api.create_action_information (

3466:
3467: IF rec_payroll_msg.payroll_message IS NOT NULL
3468: THEN
3469: --
3470: pay_action_information_api.create_action_information (
3471: p_action_information_id => l_action_info_id
3472: , p_action_context_id => p_payroll_action_id
3473: , p_action_context_type => 'PA'
3474: , p_object_version_number => l_ovn