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

Line 259: pay_action_information_api.create_action_information (

255: IF p_archive = 'Y'
256:
257: THEN
258:
259: pay_action_information_api.create_action_information (
260: p_action_information_id => l_action_info_id
261: , p_action_context_id => p_pactid
262: , p_action_context_type => 'PA'
263: , p_object_version_number => l_ovn

Line 318: pay_action_information_api.create_action_information (

314: THEN
315:
316: hr_utility.set_location('Arch EMEA ELEMENT DEFINITION',99);
317:
318: pay_action_information_api.create_action_information (
319: p_action_information_id => l_action_info_id
320: , p_action_context_id => p_pactid
321: , p_action_context_type => 'PA'
322: , p_object_version_number => l_ovn

Line 431: pay_action_information_api.create_action_information (

427: END IF;
428:
429: hr_utility.set_location('Arch EMEA ELEMENT DEFINITION',99);
430:
431: pay_action_information_api.create_action_information (
432: p_action_information_id => l_action_info_id
433: , p_action_context_id => p_pactid
434: , p_action_context_type => 'PA'
435: , p_object_version_number => l_ovn

Line 855: pay_action_information_api.create_action_information (

851: END IF;
852:
853: hr_utility.set_location('Archiving GB EMPLOYEE DETAILS',50);
854:
855: pay_action_information_api.create_action_information (
856: p_action_information_id => l_action_info_id
857: , p_action_context_id => p_assactid
858: , p_action_context_type => 'AAP'
859: , p_object_version_number => l_ovn

Line 1084: pay_action_information_api.create_action_information (

1080:
1081:
1082: IF l_balance_value <> 0 and nvl(l_agg_flag,'N')='N' then
1083:
1084: pay_action_information_api.create_action_information (
1085: p_action_information_id => l_action_info_id
1086: ,p_action_context_id => p_action_context_id
1087: ,p_action_context_type => 'AAP'
1088: ,p_object_version_number => l_ovn

Line 1128: pay_action_information_api.create_action_information (

1124: end if;
1125:
1126: IF l_balance_value <> 0 and nvl(l_agg_flag,'N') = 'Y' then
1127:
1128: pay_action_information_api.create_action_information (
1129: p_action_information_id => l_action_info_id
1130: ,p_action_context_id => p_action_context_id
1131: ,p_action_context_type => 'AAP'
1132: ,p_object_version_number => l_ovn

Line 1208: pay_action_information_api.create_action_information (

1204: THEN
1205:
1206: hr_utility.set_location('Archiving EMEA BALANCES',20);
1207:
1208: pay_action_information_api.create_action_information (
1209: p_action_information_id => l_action_info_id
1210: , p_action_context_id => p_action_context_id
1211: , p_action_context_type => 'AAP'
1212: , p_object_version_number => l_ovn

Line 1346: pay_action_information_api.create_action_information (

1342: rec_element_value.result_value)
1343: INTO l_result_value
1344: FROM dual;
1345: --
1346: pay_action_information_api.create_action_information (
1347: p_action_information_id => l_action_info_id
1348: , p_action_context_id => p_action_context_id
1349: , p_action_context_type => 'AAP'
1350: , p_object_version_number => l_ovn

Line 1465: FROM pay_action_information pai

1461: AND (pact.action_type = 'P' OR
1462: pact.action_type = 'U')
1463: AND pact.action_status = 'C'
1464: AND NOT EXISTS (SELECT NULL
1465: FROM pay_action_information pai
1466: WHERE pai.action_context_id = pact.payroll_action_id
1467: AND pai.action_context_type = 'PA'
1468: AND pai.action_information_category = 'EMEA PAYROLL INFO');
1469:

Line 1489: FROM pay_action_information pai

1485: AND (pact.action_type = 'R' OR
1486: pact.action_type = 'Q')
1487: AND pact.action_status = 'C'
1488: AND NOT EXISTS (SELECT NULL
1489: FROM pay_action_information pai
1490: WHERE pai.action_context_id = pact.payroll_action_id
1491: AND pai.action_context_type = 'PA'
1492: AND pai.action_information_category = 'EMPLOYEE OTHER INFORMATION');
1493: */

Line 1626: pay_action_information_api.create_action_information (

1622: , p_payroll_id => rec_payroll_info.payroll_id
1623: , p_effective_date => l_canonical_end_date);
1624: -- End 4071160
1625:
1626: pay_action_information_api.create_action_information (
1627: p_action_information_id => l_action_info_id
1628: , p_action_context_id => pactid
1629: , p_action_context_type => 'PA'
1630: , p_object_version_number => l_ovn

Line 1657: pay_action_information_api.create_action_information (

1653: IF rec_payroll_msg.payroll_message IS NOT NULL
1654:
1655: THEN
1656:
1657: pay_action_information_api.create_action_information (
1658: p_action_information_id => l_action_info_id
1659: , p_action_context_id => pactid
1660: , p_action_context_type => 'PA'
1661: , p_object_version_number => l_ovn

Line 2375: FROM pay_action_information pai

2371: AND (pact.action_type = 'P' OR
2372: pact.action_type = 'U')
2373: AND pact.action_status = 'C'
2374: AND NOT EXISTS (SELECT NULL
2375: FROM pay_action_information pai
2376: WHERE pai.action_context_id = pact.payroll_action_id
2377: AND pai.action_context_type = 'PA'
2378: AND pai.action_information_category = 'EMEA PAYROLL INFO');
2379:

Line 2399: FROM pay_action_information pai

2395: AND (pact.action_type = 'R' OR
2396: pact.action_type = 'Q')
2397: AND pact.action_status = 'C'
2398: AND NOT EXISTS (SELECT NULL
2399: FROM pay_action_information pai
2400: WHERE pai.action_context_id = pact.payroll_action_id
2401: AND pai.action_context_type = 'PA'
2402: AND pai.action_information_category = 'EMPLOYEE OTHER INFORMATION');
2403:

Line 2424: delete from pay_action_information pai

2420: hr_utility.set_location('Entering ' || l_proc,10);
2421:
2422:
2423: -- To avoid re-archiving while Retry
2424: delete from pay_action_information pai
2425: where pai.action_context_id = p_payroll_action_id
2426: and pai.action_context_type = 'PA'
2427: and pai.action_information_category in ('EMPLOYEE OTHER INFORMATION')
2428: and pai.action_information2 = 'MESG';

Line 2430: delete from pay_action_information pai

2426: and pai.action_context_type = 'PA'
2427: and pai.action_information_category in ('EMPLOYEE OTHER INFORMATION')
2428: and pai.action_information2 = 'MESG';
2429:
2430: delete from pay_action_information pai
2431: where pai.action_context_id = p_payroll_action_id
2432: and pai.action_context_type = 'PA'
2433: and pai.action_information_category in ('EMEA PAYROLL INFO');
2434:

Line 2510: pay_action_information_api.create_action_information (

2506: hr_utility.set_location('rec_payroll_info.employers_ref_no = ' || rec_payroll_info.employers_ref_no,30);
2507:
2508: hr_utility.set_location('Archiving EMEA PAYROLL INFO',30);
2509:
2510: pay_action_information_api.create_action_information (
2511: p_action_information_id => l_action_info_id
2512: , p_action_context_id => p_payroll_action_id
2513: , p_action_context_type => 'PA'
2514: , p_object_version_number => l_ovn

Line 2542: pay_action_information_api.create_action_information (

2538: IF rec_payroll_msg.payroll_message IS NOT NULL
2539:
2540: THEN
2541:
2542: pay_action_information_api.create_action_information (
2543: p_action_information_id => l_action_info_id
2544: , p_action_context_id => p_payroll_action_id
2545: , p_action_context_type => 'PA'
2546: , p_object_version_number => l_ovn