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

Line 266: pay_action_information_api.create_action_information (

262: LOOP
263: FETCH csr_get_message INTO rec_get_message;
264: EXIT WHEN csr_get_message%NOTFOUND;
265:
266: pay_action_information_api.create_action_information (
267: p_action_information_id => l_action_info_id
268: ,p_action_context_id => p_payroll_action_id
269: ,p_action_context_type => 'PA'
270: ,p_object_version_number => l_ovn

Line 306: FROM pay_action_information

302: BEGIN
303:
304:
305: SELECT 1 INTO l_flag
306: FROM pay_action_information
307: WHERE action_information_category = 'EMEA BALANCE DEFINITION'
308: AND action_context_id = p_payroll_action_id
309: AND action_information2 = l_defined_balance_id
310: AND action_information6 = 'OBAL'

Line 314: pay_action_information_api.create_action_information (

310: AND action_information6 = 'OBAL'
311: AND action_information4 = rec_get_balance.narrative;
312:
313: EXCEPTION WHEN NO_DATA_FOUND THEN
314: pay_action_information_api.create_action_information (
315: p_action_information_id => l_action_info_id
316: ,p_action_context_id => p_payroll_action_id
317: ,p_action_context_type => 'PA'
318: ,p_object_version_number => l_ovn

Line 362: FROM pay_action_information

358:
359: BEGIN
360:
361: SELECT 1 INTO l_flag
362: FROM pay_action_information
363: WHERE action_context_id = p_payroll_action_id
364: AND action_information_category = 'EMEA ELEMENT DEFINITION'
365: AND action_information2 = rec_get_element.element_type_id
366: AND action_information3 = rec_get_element.input_value_id

Line 372: pay_action_information_api.create_action_information (

368:
369:
370: EXCEPTION WHEN NO_DATA_FOUND THEN
371:
372: pay_action_information_api.create_action_information (
373: p_action_information_id => l_action_info_id
374: ,p_action_context_id => p_payroll_action_id
375: ,p_action_context_type => 'PA'
376: ,p_object_version_number => l_ovn

Line 1179: pay_action_information_api.create_action_information (

1175:
1176: /*fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_EMPLOYEE_DETAILS gosi reference');*/
1177:
1178: /* INSERT PERSON DETAILS */
1179: pay_action_information_api.create_action_information (
1180: p_action_information_id => l_action_info_id
1181: ,p_action_context_id => p_archive_assact_id
1182: ,p_action_context_type => 'AAP'
1183: ,p_object_version_number => l_ovn

Line 1203: pay_action_information_api.create_action_information (

1199:
1200:
1201: /*fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_EMPLOYEE_DETAILS 7');*/
1202: /* ADDITIONAL EMPLOYEE DETAILS */
1203: pay_action_information_api.create_action_information (
1204: p_action_information_id => l_action_info_id
1205: ,p_action_context_id => p_archive_assact_id
1206: ,p_action_context_type => 'AAP'
1207: ,p_object_version_number => l_ovn

Line 1228: pay_action_information_api.create_action_information (

1224: /*fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_EMPLOYEE_DETAILS 8');*/
1225:
1226: /* INSERT ADDRESS DETAILS */
1227: IF rec_primary_address.AL1 IS NOT NULL THEN /* CHECK IF EMPLOYEE HAS BEEN GIVEN A PRIMARY ADDRESS */
1228: pay_action_information_api.create_action_information (
1229: p_action_information_id => l_action_info_id
1230: ,p_action_context_id => p_archive_assact_id
1231: ,p_action_context_type => 'AAP'
1232: ,p_object_version_number => l_ovn

Line 1251: pay_action_information_api.create_action_information (

1247: ,p_action_information14 => 'Employee Address'
1248: ,p_assignment_id => p_assignment_id);
1249: ELSE
1250: /* INSERT EMPLOYER ADDRESS AS EMPLOYEE'S PRIMARY ADDRESS */
1251: pay_action_information_api.create_action_information (
1252: p_action_information_id => l_action_info_id
1253: ,p_action_context_id => p_archive_assact_id
1254: ,p_action_context_type => 'AAP'
1255: ,p_object_version_number => l_ovn

Line 1282: FROM pay_action_information

1278: BEGIN
1279: l_org_exists := 0;
1280: SELECT 1
1281: INTO l_org_exists
1282: FROM pay_action_information
1283: WHERE action_context_id = p_payroll_action_id
1284: AND action_information1 = rec_person_details.org_id
1285: AND effective_date = p_effective_date
1286: AND action_information_category = 'ADDRESS DETAILS';

Line 1290: pay_action_information_api.create_action_information (

1286: AND action_information_category = 'ADDRESS DETAILS';
1287:
1288: EXCEPTION
1289: WHEN NO_DATA_FOUND THEN
1290: pay_action_information_api.create_action_information (
1291: p_action_information_id => l_action_info_id
1292: ,p_action_context_id => p_payroll_action_id
1293: ,p_action_context_type => 'PA'
1294: ,p_object_version_number => l_ovn

Line 1413: FROM pay_action_information

1409:
1410: BEGIN
1411:
1412: SELECT 1 INTO l_flag
1413: FROM pay_action_information
1414: WHERE action_context_id = p_payroll_action_id
1415: AND action_information_category = 'EMEA ELEMENT DEFINITION'
1416: AND action_information2 = rec_earnings.element_type_id
1417: AND action_information3 = rec_earnings.input_value_id

Line 1423: pay_action_information_api.create_action_information (

1419:
1420: EXCEPTION WHEN NO_DATA_FOUND THEN
1421:
1422:
1423: pay_action_information_api.create_action_information (
1424: p_action_information_id => l_action_info_id
1425: ,p_action_context_id => p_payroll_action_id
1426: ,p_action_context_type => 'PA'
1427: ,p_object_version_number => l_ovn

Line 1453: FROM pay_action_information

1449:
1450: BEGIN
1451:
1452: SELECT 1 INTO l_flag
1453: FROM pay_action_information
1454: WHERE action_context_id = p_payroll_action_id
1455: AND action_information_category = 'EMEA ELEMENT DEFINITION'
1456: AND action_information2 = rec_deduction.element_type_id
1457: AND action_information3 = rec_deduction.input_value_id

Line 1461: pay_action_information_api.create_action_information (

1457: AND action_information3 = rec_deduction.input_value_id
1458: AND action_information5 = 'D';
1459:
1460: EXCEPTION WHEN NO_DATA_FOUND THEN
1461: pay_action_information_api.create_action_information (
1462: p_action_information_id => l_action_info_id
1463: ,p_action_context_id => p_payroll_action_id
1464: ,p_action_context_type => 'PA'
1465: ,p_object_version_number => l_ovn

Line 1513: ,pay_action_information pai

1509: FROM pay_run_result_values rrv
1510: ,pay_run_results rr
1511: ,pay_assignment_actions paa
1512: ,pay_payroll_actions ppa
1513: ,pay_action_information pai
1514: WHERE rrv.input_value_id = pai.action_information3
1515: AND rr.element_type_id = pai.action_information2
1516: AND rr.run_result_id = rrv.run_result_id
1517: AND rr.assignment_action_id = paa.assignment_action_id

Line 1558: pay_action_information_api.create_action_information (

1554: FETCH csr_result_value INTO rec_result_value;
1555: EXIT WHEN csr_result_value%NOTFOUND;
1556: l_result_value := rec_result_value.result_value;
1557: IF l_result_value is not null THEN
1558: pay_action_information_api.create_action_information (
1559: p_action_information_id => l_action_info_id
1560: ,p_action_context_id => p_archive_assact_id
1561: ,p_action_context_type => 'AAP'
1562: ,p_object_version_number => l_ovn

Line 1744: pay_action_information_api.create_action_information (

1740: /*fnd_file.put_line(fnd_file.log,'In ARCHIVE_PAYMENT_INFO 2');*/
1741:
1742: l_bank_name := hr_general.decode_lookup('SA_BANKS',rec_pers_pay.name_id);
1743:
1744: pay_action_information_api.create_action_information (
1745: p_action_information_id => l_action_info_id
1746: ,p_action_context_id => p_archive_assact_id
1747: ,p_action_context_type => 'AAP'
1748: ,p_object_version_number => l_ovn

Line 1774: pay_action_information_api.create_action_information (

1770:
1771: ELSE
1772:
1773: /*fnd_file.put_line(fnd_file.log,'In ARCHIVE_PAYMENT_INFO 3');*/
1774: pay_action_information_api.create_action_information (
1775: p_action_information_id => l_action_info_id
1776: ,p_action_context_id => p_archive_assact_id
1777: ,p_action_context_type => 'AAP'
1778: ,p_object_version_number => l_ovn

Line 1817: pay_action_information_api.create_action_information (

1813: FOR rec_org_pay IN csr_get_org_pay(p_prepay_assact_id,rec_chk.opm_id) LOOP
1814:
1815: l_pay_value := to_char (rec_org_pay.value,g_format_mask);
1816:
1817: pay_action_information_api.create_action_information (
1818: p_action_information_id => l_action_info_id
1819: ,p_action_context_id => p_archive_assact_id
1820: ,p_action_context_type => 'AAP'
1821: ,p_object_version_number => l_ovn

Line 1978: pay_action_information_api.create_action_information (

1974: l_ovn :=1;
1975:
1976: IF l_accrual_plan_name IS NOT NULL THEN
1977: --
1978: pay_action_information_api.create_action_information (
1979: p_action_information_id => l_action_info_id
1980: ,p_action_context_id => p_archive_assact_id
1981: ,p_action_context_type => 'AAP'
1982: ,p_object_version_number => l_ovn

Line 2128: pay_action_information_api.create_action_information (

2124: FETCH csr_result_value INTO l_result_value;
2125: EXIT WHEN csr_result_value%NOTFOUND;
2126: IF l_result_value is not null THEN
2127:
2128: pay_action_information_api.create_action_information (
2129: p_action_information_id => l_action_info_id
2130: ,p_action_context_id => p_archive_assact_id
2131: ,p_action_context_type => 'AAP'
2132: ,p_object_version_number => l_ovn

Line 2149: pay_action_information_api.create_action_information (

2145: CLOSE csr_result_value;
2146:
2147: /*IF l_result_value is not null THEN
2148:
2149: pay_action_information_api.create_action_information (
2150: p_action_information_id => l_action_info_id
2151: ,p_action_context_id => p_archive_assact_id
2152: ,p_action_context_type => 'AAP'
2153: ,p_object_version_number => l_ovn

Line 2281: pay_action_information_api.create_action_information (

2277:
2278:
2279: IF l_balance_value > 0 THEN
2280:
2281: pay_action_information_api.create_action_information (
2282: p_action_information_id => l_action_info_id
2283: ,p_action_context_id => p_archive_assact_id
2284: ,p_action_context_type => 'AAP'
2285: ,p_object_version_number => l_ovn