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

Line 288: pay_action_information_api.create_action_information (

284: FETCH csr_get_message INTO rec_get_message;
285: EXIT WHEN csr_get_message%NOTFOUND;
286:
287: -- archive the messages
288: pay_action_information_api.create_action_information (
289: p_action_information_id => l_action_info_id
290: ,p_action_context_id => p_payroll_action_id
291: ,p_action_context_type => 'PA'
292: ,p_object_version_number => l_ovn

Line 325: FROM pay_action_information

321:
322: BEGIN
323: -- check if the balance has already been archived
324: SELECT 1 INTO l_flag
325: FROM pay_action_information
326: WHERE action_information_category = 'EMEA BALANCE DEFINITION'
327: AND action_context_id = p_payroll_action_id
328: AND action_information2 = l_defined_balance_id
329: AND action_information6 = 'OBAL'

Line 335: pay_action_information_api.create_action_information (

331:
332: EXCEPTION WHEN NO_DATA_FOUND THEN
333:
334: -- archive the balance definition as it has not been archived before
335: pay_action_information_api.create_action_information (
336: p_action_information_id => l_action_info_id
337: ,p_action_context_id => p_payroll_action_id
338: ,p_action_context_type => 'PA'
339: ,p_object_version_number => l_ovn

Line 382: FROM pay_action_information

378: EXIT WHEN csr_get_element%NOTFOUND;
379: BEGIN
380: -- check if the element definition has already been archived
381: SELECT 1 INTO l_flag
382: FROM pay_action_information
383: WHERE action_context_id = p_payroll_action_id
384: AND action_information_category = 'EMEA ELEMENT DEFINITION'
385: AND action_information2 = rec_get_element.element_type_id
386: AND action_information3 = rec_get_element.input_value_id

Line 392: pay_action_information_api.create_action_information (

388:
389: EXCEPTION WHEN NO_DATA_FOUND THEN
390: -- archive the element definition since it has not been archived
391:
392: pay_action_information_api.create_action_information (
393: p_action_information_id => l_action_info_id
394: ,p_action_context_id => p_payroll_action_id
395: ,p_action_context_type => 'PA'
396: ,p_object_version_number => l_ovn

Line 1278: pay_action_information_api.create_action_information (

1274: /*fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_EMPLOYEE_DETAILS gosi reference');*/
1275:
1276: /* INSERT PERSON DETAILS */
1277:
1278: pay_action_information_api.create_action_information (
1279: p_action_information_id => l_action_info_id
1280: ,p_action_context_id => p_archive_assact_id
1281: ,p_action_context_type => 'AAP'
1282: ,p_object_version_number => l_ovn

Line 1305: pay_action_information_api.create_action_information (

1301:
1302:
1303: /* INSERT ADDRESS DETAILS */
1304: IF rec_primary_address.AL1 IS NOT NULL THEN /* CHECK IF EMPLOYEE HAS BEEN GIVEN A PRIMARY ADDRESS */
1305: pay_action_information_api.create_action_information (
1306: p_action_information_id => l_action_info_id
1307: ,p_action_context_id => p_archive_assact_id
1308: ,p_action_context_type => 'AAP'
1309: ,p_object_version_number => l_ovn

Line 1325: pay_action_information_api.create_action_information (

1321: ,p_action_information14 => 'Employee Address'
1322: ,p_assignment_id => p_assignment_id);
1323: ELSE
1324: /* INSERT EMPLOYER ADDRESS AS EMPLOYEE'S PRIMARY ADDRESS */
1325: pay_action_information_api.create_action_information (
1326: p_action_information_id => l_action_info_id
1327: ,p_action_context_id => p_archive_assact_id
1328: ,p_action_context_type => 'AAP'
1329: ,p_object_version_number => l_ovn

Line 1357: FROM pay_action_information

1353: l_org_exists := 0;
1354:
1355: SELECT 1
1356: INTO l_org_exists
1357: FROM pay_action_information
1358: WHERE action_context_id = p_payroll_action_id
1359: AND action_information1 = l_legal_employer_id -- rec_person_details.org_id
1360: AND effective_date = p_effective_date
1361: AND action_information_category = 'ADDRESS DETAILS';

Line 1366: pay_action_information_api.create_action_information (

1362:
1363: EXCEPTION
1364:
1365: WHEN NO_DATA_FOUND THEN
1366: pay_action_information_api.create_action_information (
1367: p_action_information_id => l_action_info_id
1368: ,p_action_context_id => p_payroll_action_id
1369: ,p_action_context_type => 'PA'
1370: ,p_object_version_number => l_ovn

Line 1500: FROM pay_action_information

1496: BEGIN
1497: hr_utility.trace('p_payroll_action_id***************** '||p_payroll_action_id);
1498: -- check if the Element definition has already been archived
1499: SELECT 1 INTO l_flag
1500: FROM pay_action_information
1501: WHERE action_context_id = p_payroll_action_id
1502: AND action_information_category = 'EMEA ELEMENT DEFINITION'
1503: AND action_information2 = rec_earnings.element_type_id
1504: AND action_information3 = rec_earnings.input_value_id

Line 1513: pay_action_information_api.create_action_information (

1509: EXCEPTION WHEN NO_DATA_FOUND THEN
1510: -- archive the element definition as it has not been archived
1511: hr_utility.trace(' rec_earnings.element_type_id ******** '||rec_earnings.element_type_id);
1512:
1513: pay_action_information_api.create_action_information (
1514: p_action_information_id => l_action_info_id
1515: ,p_action_context_id => p_payroll_action_id
1516: ,p_action_context_type => 'PA'
1517: ,p_object_version_number => l_ovn

Line 1541: FROM pay_action_information

1537: FOR rec_deduction IN csr_ded_element_info LOOP
1538: BEGIN
1539: -- check if the Element definition has already been archived
1540: SELECT 1 INTO l_flag
1541: FROM pay_action_information
1542: WHERE action_context_id = p_payroll_action_id
1543: AND action_information_category = 'EMEA ELEMENT DEFINITION'
1544: AND action_information2 = rec_deduction.element_type_id
1545: AND action_information3 = rec_deduction.input_value_id

Line 1550: pay_action_information_api.create_action_information (

1546: AND action_information5 = 'D';
1547:
1548: EXCEPTION WHEN NO_DATA_FOUND THEN
1549: -- archive the element definition as it has not been archived
1550: pay_action_information_api.create_action_information (
1551: p_action_information_id => l_action_info_id
1552: ,p_action_context_id => p_payroll_action_id
1553: ,p_action_context_type => 'PA'
1554: ,p_object_version_number => l_ovn

Line 1742: pay_action_information_api.create_action_information (

1738: --l_bank_reg_num := rec_pers_pay.bank_reg_num;
1739: l_bank_reg_num := rec_pers_pay.bank_reg_num || ' ' ||
1740: hr_general.decode_lookup('HR_DK_BANK_REGISTRATION',rec_pers_pay.bank_reg_num);
1741:
1742: pay_action_information_api.create_action_information (
1743: p_action_information_id => l_action_info_id
1744: ,p_action_context_id => p_archive_assact_id
1745: ,p_action_context_type => 'AAP'
1746: ,p_object_version_number => l_ovn

Line 1772: pay_action_information_api.create_action_information (

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

Line 1812: pay_action_information_api.create_action_information (

1808: FOR rec_org_pay IN csr_get_org_pay(p_prepay_assact_id,rec_chk.opm_id) LOOP
1809:
1810: l_pay_value := to_char (rec_org_pay.value,g_format_mask);
1811:
1812: pay_action_information_api.create_action_information (
1813: p_action_information_id => l_action_info_id
1814: ,p_action_context_id => p_archive_assact_id
1815: ,p_action_context_type => 'AAP'
1816: ,p_object_version_number => l_ovn

Line 1967: pay_action_information_api.create_action_information (

1963: );
1964: l_ovn :=1;
1965: IF l_accrual_plan_name IS NOT NULL THEN
1966: --
1967: pay_action_information_api.create_action_information (
1968: p_action_information_id => l_action_info_id
1969: ,p_action_context_id => p_archive_assact_id
1970: ,p_action_context_type => 'AAP'
1971: ,p_object_version_number => l_ovn

Line 2267: pay_action_information_api.create_action_information (

2263: EXIT WHEN csr_result_value%NOTFOUND;
2264:
2265:
2266: IF l_result_value is not null THEN
2267: pay_action_information_api.create_action_information (
2268: p_action_information_id => l_action_info_id
2269: ,p_action_context_id => p_archive_assact_id
2270: ,p_action_context_type => 'AAP'
2271: ,p_object_version_number => l_ovn

Line 2362: pay_action_information_api.create_action_information (

2358: ,g_element_table(l_index).element_type_id
2359: ,p_assignment_action_id)
2360: LOOP
2361: IF csr_result_rec.result_value is not null THEN
2362: pay_action_information_api.create_action_information (
2363: p_action_information_id => l_action_info_id
2364: ,p_action_context_id => p_archive_assact_id
2365: ,p_action_context_type => 'AAP'
2366: ,p_object_version_number => l_ovn

Line 2391: pay_action_information_api.create_action_information (

2387: ,g_element_table(l_index).element_type_id
2388: ,p_assignment_action_id )
2389: LOOP
2390: IF csr_result_rec.result_value is not null THEN
2391: pay_action_information_api.create_action_information (
2392: p_action_information_id => l_action_info_id
2393: ,p_action_context_id => p_archive_assact_id
2394: ,p_action_context_type => 'AAP'
2395: ,p_object_version_number => l_ovn

Line 2434: pay_action_information_api.create_action_information (

2430: ,g_element_table(l_index).element_type_id
2431: ,p_assignment_action_id )
2432: LOOP
2433: IF csr_result_rec.AMOUNT is not null THEN
2434: pay_action_information_api.create_action_information (
2435: p_action_information_id => l_action_info_id
2436: ,p_action_context_id => p_archive_assact_id
2437: ,p_action_context_type => 'AAP'
2438: ,p_object_version_number => l_ovn

Line 2459: pay_action_information_api.create_action_information (

2455: ,g_element_table(l_index).element_type_id
2456: ,p_assignment_action_id )
2457: LOOP
2458: IF csr_result_rec.AMOUNT is not null THEN
2459: pay_action_information_api.create_action_information (
2460: p_action_information_id => l_action_info_id
2461: ,p_action_context_id => p_archive_assact_id
2462: ,p_action_context_type => 'AAP'
2463: ,p_object_version_number => l_ovn

Line 2523: pay_action_information_api.create_action_information (

2519: END IF; -- End if of segment 7 , unit
2520:
2521: -- Resume again
2522: IF csr_result_rec.result_value is not null THEN
2523: pay_action_information_api.create_action_information (
2524: p_action_information_id => l_action_info_id
2525: ,p_action_context_id => p_archive_assact_id
2526: ,p_action_context_type => 'AAP'
2527: ,p_object_version_number => l_ovn

Line 2790: pay_action_information_api.create_action_information (

2786: l_balance_value := pay_balance_pkg.get_value(g_user_balance_table(l_index).defined_balance_id,p_assignment_action_id);
2787:
2788: IF l_balance_value > 0 THEN
2789: -- fnd_file.put_line(fnd_file.log,'In ARCHIVE_OTH_BALANCE 2 :' || l_balance_value);
2790: pay_action_information_api.create_action_information (
2791: p_action_information_id => l_action_info_id
2792: ,p_action_context_id => p_archive_assact_id
2793: ,p_action_context_type => 'AAP'
2794: ,p_object_version_number => l_ovn

Line 3186: l_action_info_id pay_action_information.action_information_id%TYPE;

3182: l_previous_income NUMBER (10);
3183: l_ovn NUMBER ;
3184: l_rec get_details%ROWTYPE;
3185: l_tax_rec csr_tax_details%ROWTYPE;
3186: l_action_info_id pay_action_information.action_information_id%TYPE;
3187: l_tax_category hr_soft_coding_keyflex.segment13%TYPE;
3188: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
3189:
3190: -- Bug Fix 5081696

Line 3331: pay_action_information_api.create_action_information (

3327: g_tax_card_tab(2).screen_entry_val := hr_general.decode_lookup('DK_TAX_CARD_TYPE',g_tax_card_tab(2).screen_entry_val);
3328:
3329: -- fnd_file.put_line(fnd_file.log,'archiving ADDL EMPLOYEE DETAILS');
3330:
3331: pay_action_information_api.create_action_information (
3332: p_action_information_id => l_action_info_id
3333: ,p_action_context_id => p_archive_assact_id
3334: ,p_action_context_type => 'AAP'
3335: ,p_object_version_number => l_ovn

Line 3597: pay_action_information_api.create_action_information (

3593: -- fnd_file.put_line(fnd_file.log,'after the select decode');
3594:
3595: -- fnd_file.put_line(fnd_file.log,'starting archiving DK EMPLOYEE DETAILS');
3596:
3597: pay_action_information_api.create_action_information (
3598: p_action_information_id => l_action_info_id
3599: ,p_action_context_id => p_archive_assact_id
3600: ,p_action_context_type => 'AAP'
3601: ,p_object_version_number => l_ovn

Line 3730: FROM pay_action_information pai

3726: ,p_element_type_id NUMBER
3727: ,p_input_value_id NUMBER
3728: ) IS
3729: SELECT pai.action_information_id
3730: FROM pay_action_information pai
3731: WHERE pai.action_context_type = 'PA'
3732: AND pai.effective_date = p_effective_date
3733: AND pai.action_information_category = 'EMEA ELEMENT DEFINITION'
3734: AND pai.action_information2 = to_char(p_element_type_id)

Line 3971: pay_action_information_api.create_action_information (

3967: EXIT WHEN csr_result_value%NOTFOUND;
3968:
3969:
3970: IF l_result_value is not null THEN
3971: pay_action_information_api.create_action_information (
3972: p_action_information_id => l_action_info_id
3973: ,p_action_context_id => p_archive_assact_id
3974: ,p_action_context_type => 'AAP'
3975: ,p_object_version_number => l_ovn

Line 4048: pay_action_information_api.update_action_information(

4044:
4045: /* Commented to avoid updating the element definition
4046: l_new_rep_name := csr_rec.rep_name|| ' ( ' ||rec_get_pp_name.name|| ' ) ' ;
4047:
4048: pay_action_information_api.update_action_information(
4049: p_action_information_id => l_action_info_id_pen
4050: ,p_object_version_number => l_ovn_pen
4051: ,p_action_information4 => l_new_rep_name); */
4052: /*

Line 4069: pay_action_information_api.create_action_information (

4065: /* Added for Pension changes -end */
4066:
4067: /*
4068: IF l_result_value is not null THEN
4069: pay_action_information_api.create_action_information (
4070: p_action_information_id => l_action_info_id
4071: ,p_action_context_id => p_archive_assact_id
4072: ,p_action_context_type => 'AAP'
4073: ,p_object_version_number => l_ovn

Line 4152: pay_action_information_api.create_action_information (

4148:
4149:
4150: IF csr_result_rec.result_value is not null THEN
4151: fnd_file.put_line(fnd_file.log,' 1 csr_result_rec.result_value '||csr_result_rec.result_value);
4152: pay_action_information_api.create_action_information (
4153: p_action_information_id => l_action_info_id
4154: ,p_action_context_id => p_archive_assact_id
4155: ,p_action_context_type => 'AAP'
4156: ,p_object_version_number => l_ovn

Line 4190: pay_action_information_api.create_action_information (

4186:
4187:
4188: IF csr_result_rec.result_value is not null THEN
4189: fnd_file.put_line(fnd_file.log,' 2 csr_result_rec.result_value '||csr_result_rec.result_value);
4190: pay_action_information_api.create_action_information (
4191: p_action_information_id => l_action_info_id
4192: ,p_action_context_id => p_archive_assact_id
4193: ,p_action_context_type => 'AAP'
4194: ,p_object_version_number => l_ovn

Line 4235: pay_action_information_api.create_action_information (

4231: LOOP
4232:
4233: IF csr_result_rec.AMOUNT is not null THEN
4234: fnd_file.put_line(fnd_file.log,' 3 csr_result_rec.AMOUNT '||csr_result_rec.AMOUNT);
4235: pay_action_information_api.create_action_information (
4236: p_action_information_id => l_action_info_id
4237: ,p_action_context_id => p_archive_assact_id
4238: ,p_action_context_type => 'AAP'
4239: ,p_object_version_number => l_ovn

Line 4262: pay_action_information_api.create_action_information (

4258: LOOP
4259:
4260: IF csr_result_rec.AMOUNT is not null THEN
4261: fnd_file.put_line(fnd_file.log,' 4 csr_result_rec.AMOUNT '||csr_result_rec.AMOUNT);
4262: pay_action_information_api.create_action_information (
4263: p_action_information_id => l_action_info_id
4264: ,p_action_context_id => p_archive_assact_id
4265: ,p_action_context_type => 'AAP'
4266: ,p_object_version_number => l_ovn

Line 4332: pay_action_information_api.create_action_information (

4328: -- Resume again
4329:
4330: IF csr_result_rec.result_value is not null THEN
4331: fnd_file.put_line(fnd_file.log,' 5 l_amount '||l_amount);
4332: pay_action_information_api.create_action_information (
4333: p_action_information_id => l_action_info_id
4334: ,p_action_context_id => p_archive_assact_id
4335: ,p_action_context_type => 'AAP'
4336: ,p_object_version_number => l_ovn

Line 4451: pay_action_information_api.update_action_information(

4447:
4448: /* Commented to avoid updating the element definition
4449: l_new_rep_name := csr_rec.rep_name|| ' ( ' ||rec_get_pp_name.name|| ' ) ' ;
4450:
4451: pay_action_information_api.update_action_information(
4452: p_action_information_id => l_action_info_id_pen
4453: ,p_object_version_number => l_ovn_pen
4454: ,p_action_information4 => l_new_rep_name); */
4455:

Line 4474: pay_action_information_api.create_action_information (

4470:
4471: IF l_result_value is not null THEN
4472: -- fnd_file.put_line(fnd_file.log,'D 1 : l_result_value '|| l_result_value );
4473:
4474: pay_action_information_api.create_action_information (
4475: p_action_information_id => l_action_info_id
4476: ,p_action_context_id => p_archive_assact_id
4477: ,p_action_context_type => 'AAP'
4478: ,p_object_version_number => l_ovn

Line 4544: pay_action_information_api.create_action_information (

4540:
4541:
4542: IF l_result_value is not null THEN
4543: -- fnd_file.put_line(fnd_file.log,'D 2 : l_result_value '|| l_result_value );
4544: pay_action_information_api.create_action_information (
4545: p_action_information_id => l_action_info_id
4546: ,p_action_context_id => p_archive_assact_id
4547: ,p_action_context_type => 'AAP'
4548: ,p_object_version_number => l_ovn

Line 4622: pay_action_information_api.create_action_information (

4618:
4619:
4620: IF csr_result_rec.AMOUNT is not null THEN
4621: -- fnd_file.put_line(fnd_file.log,'D 3 : csr_result_rec.AMOUNT '|| csr_result_rec.AMOUNT );
4622: pay_action_information_api.create_action_information (
4623: p_action_information_id => l_action_info_id
4624: ,p_action_context_id => p_archive_assact_id
4625: ,p_action_context_type => 'AAP'
4626: ,p_object_version_number => l_ovn

Line 4683: pay_action_information_api.create_action_information (

4679: /* End */
4680:
4681: IF csr_result_rec.AMOUNT is not null THEN
4682: -- fnd_file.put_line(fnd_file.log,'D 4 : csr_result_rec.AMOUNT '|| csr_result_rec.AMOUNT );
4683: pay_action_information_api.create_action_information (
4684: p_action_information_id => l_action_info_id
4685: ,p_action_context_id => p_archive_assact_id
4686: ,p_action_context_type => 'AAP'
4687: ,p_object_version_number => l_ovn

Line 4788: pay_action_information_api.create_action_information (

4784:
4785:
4786: IF csr_result_rec.result_value is not null THEN
4787: -- fnd_file.put_line(fnd_file.log,'D 5 : csr_result_rec.result_value '|| csr_result_rec.result_value );
4788: pay_action_information_api.create_action_information (
4789: p_action_information_id => l_action_info_id
4790: ,p_action_context_id => p_archive_assact_id
4791: ,p_action_context_type => 'AAP'
4792: ,p_object_version_number => l_ovn