DBA Data[Home] [Help]

APPS.PAY_SE_PAYSLIP_ARCHIVE dependencies on PAY_ACTION_INFORMATION_API

Line 246: pay_action_information_api.create_action_information (

242: OPEN csr_get_message(l_business_group_id);
243: LOOP
244: FETCH csr_get_message INTO rec_get_message;
245: EXIT WHEN csr_get_message%NOTFOUND;
246: pay_action_information_api.create_action_information (
247: p_action_information_id => l_action_info_id
248: ,p_action_context_id => p_payroll_action_id
249: ,p_action_context_type => 'PA'
250: ,p_object_version_number => l_ovn

Line 288: pay_action_information_api.create_action_information (

284: AND action_information2 = l_defined_balance_id
285: AND action_information6 = 'OBAL'
286: AND action_information4 = rec_get_balance.narrative;
287: EXCEPTION WHEN NO_DATA_FOUND THEN
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 336: pay_action_information_api.create_action_information (

332: AND action_information2 = rec_get_element.element_type_id
333: AND action_information3 = rec_get_element.input_value_id
334: AND action_information5 = l_element_context;
335: EXCEPTION WHEN NO_DATA_FOUND THEN
336: pay_action_information_api.create_action_information (
337: p_action_information_id => l_action_info_id
338: ,p_action_context_id => p_payroll_action_id
339: ,p_action_context_type => 'PA'
340: ,p_object_version_number => l_ovn

Line 984: pay_action_information_api.create_action_information (

980: */
981: --fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_EMPLOYEE_DETAILS 6');
982: /* INSERT PERSON DETAILS */
983:
984: pay_action_information_api.create_action_information (
985: p_action_information_id => l_action_info_id
986: ,p_action_context_id => p_archive_assact_id
987: ,p_action_context_type => 'AAP'
988: ,p_object_version_number => l_ovn

Line 1026: pay_action_information_api.create_action_information (

1022: /* INSERT ADDRESS DETAILS */
1023:
1024: IF rec_primary_address.AL1 IS NOT NULL THEN /* CHECK IF EMPLOYEE HAS BEEN GIVEN A PRIMARY ADDRESS */
1025:
1026: pay_action_information_api.create_action_information (
1027: p_action_information_id => l_action_info_id
1028: ,p_action_context_id => p_archive_assact_id
1029: ,p_action_context_type => 'AAP'
1030: ,p_object_version_number => l_ovn

Line 1057: pay_action_information_api.create_action_information (

1053:
1054: ELSE
1055: /* INSERT EMPLOYER ADDRESS AS EMPLOYEE'S PRIMARY ADDRESS */
1056:
1057: pay_action_information_api.create_action_information (
1058: p_action_information_id => l_action_info_id
1059: ,p_action_context_id => p_archive_assact_id
1060: ,p_action_context_type => 'AAP'
1061: ,p_object_version_number => l_ovn

Line 1094: pay_action_information_api.create_action_information (

1090: AND action_information_category = 'ADDRESS DETAILS';
1091: EXCEPTION
1092: WHEN NO_DATA_FOUND THEN
1093: --fnd_file.put_line(fnd_file.log,'PA Employer Address'||p_archive_assact_id);
1094: pay_action_information_api.create_action_information (
1095: p_action_information_id => l_action_info_id
1096: ,p_action_context_id => p_payroll_action_id
1097: ,p_action_context_type => 'PA'
1098: ,p_object_version_number => l_ovn

Line 1268: pay_action_information_api.create_action_information (

1264: AND action_information2 = rec_earnings.element_type_id
1265: AND action_information3 = rec_earnings.input_value_id
1266: AND action_information5 = 'E';
1267: EXCEPTION WHEN NO_DATA_FOUND THEN
1268: pay_action_information_api.create_action_information (
1269: p_action_information_id => l_action_info_id
1270: ,p_action_context_id => p_payroll_action_id
1271: ,p_action_context_type => 'PA'
1272: ,p_object_version_number => l_ovn

Line 1308: pay_action_information_api.create_action_information (

1304: AND action_information2 = rec_deduction.element_type_id
1305: AND action_information3 = rec_deduction.input_value_id
1306: AND action_information5 = 'D';
1307: EXCEPTION WHEN NO_DATA_FOUND THEN
1308: pay_action_information_api.create_action_information (
1309: p_action_information_id => l_action_info_id
1310: ,p_action_context_id => p_payroll_action_id
1311: ,p_action_context_type => 'PA'
1312: ,p_object_version_number => l_ovn

Line 1476: pay_action_information_api.create_action_information (

1472: IF (l_ext_acct IS NOT NULL) THEN
1473:
1474: --fnd_file.put_line(fnd_file.log,'In ARCHIVE_PAYMENT_INFO 2');
1475: l_bank_name := rec_pers_pay.name_id;
1476: pay_action_information_api.create_action_information (
1477: p_action_information_id => l_action_info_id
1478: ,p_action_context_id => p_archive_assact_id
1479: ,p_action_context_type => 'AAP'
1480: ,p_object_version_number => l_ovn

Line 1505: pay_action_information_api.create_action_information (

1501: ,p_assignment_id => p_assignment_id);
1502: ELSE
1503: --fnd_file.put_line(fnd_file.log,'In ARCHIVE_PAYMENT_INFO 3');
1504:
1505: pay_action_information_api.create_action_information (
1506: p_action_information_id => l_action_info_id
1507: ,p_action_context_id => p_archive_assact_id
1508: ,p_action_context_type => 'AAP'
1509: ,p_object_version_number => l_ovn

Line 1541: pay_action_information_api.create_action_information (

1537:
1538: FOR rec_org_pay IN csr_get_org_pay(p_prepay_assact_id,rec_chk.opm_id) LOOP
1539:
1540: l_pay_value := to_char (rec_org_pay.value,g_format_mask);
1541: pay_action_information_api.create_action_information (
1542: p_action_information_id => l_action_info_id
1543: ,p_action_context_id => p_archive_assact_id
1544: ,p_action_context_type => 'AAP'
1545: ,p_object_version_number => l_ovn

Line 1881: pay_action_information_api.create_action_information (

1877: ,p_assignment_action_id
1878: ,rec_group_by.ORG_INFORMATION3)
1879: LOOP
1880: IF csr_result_rec.result_value is not null THEN
1881: pay_action_information_api.create_action_information (
1882: p_action_information_id => l_action_info_id
1883: ,p_action_context_id => p_archive_assact_id
1884: ,p_action_context_type => 'AAP'
1885: ,p_object_version_number => l_ovn

Line 1928: pay_action_information_api.create_action_information (

1924: ,g_element_table(l_index).element_type_id
1925: ,p_assignment_action_id)
1926: LOOP
1927: IF csr_result_rec.result_value is not null THEN
1928: pay_action_information_api.create_action_information (
1929: p_action_information_id => l_action_info_id
1930: ,p_action_context_id => p_archive_assact_id
1931: ,p_action_context_type => 'AAP'
1932: ,p_object_version_number => l_ovn

Line 1962: pay_action_information_api.create_action_information (

1958: ,g_element_table(l_index).element_type_id
1959: ,p_assignment_action_id )
1960: LOOP
1961: IF csr_result_rec.result_value is not null THEN
1962: pay_action_information_api.create_action_information (
1963: p_action_information_id => l_action_info_id
1964: ,p_action_context_id => p_archive_assact_id
1965: ,p_action_context_type => 'AAP'
1966: ,p_object_version_number => l_ovn

Line 2010: pay_action_information_api.create_action_information (

2006: ,g_element_table(l_index).element_type_id
2007: ,p_assignment_action_id )
2008: LOOP
2009: IF csr_result_rec.AMOUNT is not null THEN
2010: pay_action_information_api.create_action_information (
2011: p_action_information_id => l_action_info_id
2012: ,p_action_context_id => p_archive_assact_id
2013: ,p_action_context_type => 'AAP'
2014: ,p_object_version_number => l_ovn

Line 2042: pay_action_information_api.create_action_information (

2038: ,g_element_table(l_index).element_type_id
2039: ,p_assignment_action_id )
2040: LOOP
2041: IF csr_result_rec.AMOUNT is not null THEN
2042: pay_action_information_api.create_action_information (
2043: p_action_information_id => l_action_info_id
2044: ,p_action_context_id => p_archive_assact_id
2045: ,p_action_context_type => 'AAP'
2046: ,p_object_version_number => l_ovn

Line 2111: pay_action_information_api.create_action_information (

2107: END IF; -- End if of segment 7 , unit
2108:
2109: -- Resume again
2110: IF csr_result_rec.result_value is not null THEN
2111: pay_action_information_api.create_action_information (
2112: p_action_information_id => l_action_info_id
2113: ,p_action_context_id => p_archive_assact_id
2114: ,p_action_context_type => 'AAP'
2115: ,p_object_version_number => l_ovn

Line 2162: pay_action_information_api.create_action_information (

2158: FOR csr_result_rec IN csr_result_value(g_element_table(l_index).input_value_id ,g_element_table(l_index).element_type_id
2159: ,p_assignment_action_id)
2160: LOOP
2161: IF csr_result_rec.result_value is not null THEN
2162: pay_action_information_api.create_action_information (
2163: p_action_information_id => l_action_info_id
2164: ,p_action_context_id => p_archive_assact_id
2165: ,p_action_context_type => 'AAP'
2166: ,p_object_version_number => l_ovn

Line 2200: pay_action_information_api.create_action_information (

2196:
2197: l_result_value := rec_sum_of_result_values.result_value;
2198:
2199: IF l_result_value is not null THEN
2200: pay_action_information_api.create_action_information (
2201: p_action_information_id => l_action_info_id
2202: ,p_action_context_id => p_archive_assact_id
2203: ,p_action_context_type => 'AAP'
2204: ,p_object_version_number => l_ovn

Line 2322: pay_action_information_api.create_action_information (

2318: FOR l_index IN g_user_balance_table.first.. g_user_balance_table.last LOOP
2319: l_balance_value := pay_balance_pkg.get_value(g_user_balance_table(l_index).defined_balance_id,p_assignment_action_id);
2320: IF l_balance_value > 0 THEN
2321:
2322: pay_action_information_api.create_action_information (
2323: p_action_information_id => l_action_info_id
2324: ,p_action_context_id => p_archive_assact_id
2325: ,p_action_context_type => 'AAP'
2326: ,p_object_version_number => l_ovn

Line 2538: pay_action_information_api.create_action_information (

2534: */
2535:
2536: l_tax_card_type := hr_general.decode_lookup('SE_TAX_CARD_TYPE',l_tax_card_type ) ;
2537:
2538: pay_action_information_api.create_action_information (
2539: p_action_information_id => l_action_info_id
2540: ,p_action_context_id => p_archive_assact_id
2541: ,p_action_context_type => 'AAP'
2542: ,p_object_version_number => l_ovn

Line 3124: pay_action_information_api.create_action_information (

3120: -- unit and unit price should be absent.
3121: FOR csr_result_rec IN csr_result_value(csr_rec.input_value_id ,csr_rec.element_type_id ,p_assignment_action_id)
3122: LOOP
3123: IF csr_result_rec.result_value is not null THEN
3124: pay_action_information_api.create_action_information (
3125: p_action_information_id => l_action_info_id
3126: ,p_action_context_id => p_archive_assact_id
3127: ,p_action_context_type => 'AAP'
3128: ,p_object_version_number => l_ovn

Line 3158: pay_action_information_api.create_action_information (

3154: ,csr_rec.element_type_id
3155: ,p_assignment_action_id )
3156: LOOP
3157: IF csr_result_rec.result_value is not null THEN
3158: pay_action_information_api.create_action_information (
3159: p_action_information_id => l_action_info_id
3160: ,p_action_context_id => p_archive_assact_id
3161: ,p_action_context_type => 'AAP'
3162: ,p_object_version_number => l_ovn

Line 3207: pay_action_information_api.create_action_information (

3203: ,csr_rec.element_type_id
3204: ,p_assignment_action_id )
3205: LOOP
3206: IF csr_result_rec.AMOUNT is not null THEN
3207: pay_action_information_api.create_action_information (
3208: p_action_information_id => l_action_info_id
3209: ,p_action_context_id => p_archive_assact_id
3210: ,p_action_context_type => 'AAP'
3211: ,p_object_version_number => l_ovn

Line 3239: pay_action_information_api.create_action_information (

3235: ,csr_rec.element_type_id
3236: ,p_assignment_action_id )
3237: LOOP
3238: IF csr_result_rec.AMOUNT is not null THEN
3239: pay_action_information_api.create_action_information (
3240: p_action_information_id => l_action_info_id
3241: ,p_action_context_id => p_archive_assact_id
3242: ,p_action_context_type => 'AAP'
3243: ,p_object_version_number => l_ovn

Line 3308: pay_action_information_api.create_action_information (

3304: END IF; -- End if of segment 7 , unit
3305:
3306: -- Resume again
3307: IF csr_result_rec.result_value is not null THEN
3308: pay_action_information_api.create_action_information (
3309: p_action_information_id => l_action_info_id
3310: ,p_action_context_id => p_archive_assact_id
3311: ,p_action_context_type => 'AAP'
3312: ,p_object_version_number => l_ovn

Line 3344: pay_action_information_api.create_action_information (

3340: ,p_assignment_action_id
3341: ,rec_group_by.ORG_INFORMATION3)
3342: LOOP
3343: IF csr_result_rec.result_value is not null THEN
3344: pay_action_information_api.create_action_information (
3345: p_action_information_id => l_action_info_id
3346: ,p_action_context_id => p_archive_assact_id
3347: ,p_action_context_type => 'AAP'
3348: ,p_object_version_number => l_ovn

Line 3380: pay_action_information_api.create_action_information (

3376: THEN
3377: FOR csr_result_rec IN csr_result_value(csr_rec.input_value_id ,csr_rec.element_type_id ,p_assignment_action_id)
3378: LOOP
3379: IF csr_result_rec.result_value is not null THEN
3380: pay_action_information_api.create_action_information (
3381: p_action_information_id => l_action_info_id
3382: ,p_action_context_id => p_archive_assact_id
3383: ,p_action_context_type => 'AAP'
3384: ,p_object_version_number => l_ovn

Line 3413: pay_action_information_api.create_action_information (

3409: CLOSE csr_sum_of_result_values;
3410:
3411:
3412: IF l_result_value is not null THEN
3413: pay_action_information_api.create_action_information (
3414: p_action_information_id => l_action_info_id
3415: ,p_action_context_id => p_archive_assact_id
3416: ,p_action_context_type => 'AAP'
3417: ,p_object_version_number => l_ovn

Line 3489: pay_action_information_api.create_action_information (

3485: --fnd_file.put_line(fnd_file.log,'Vetri 3: ' || 'In ARCHIVE_MAIN_ELEMENTS'||rec_group_by.ORG_INFORMATION3);
3486: FOR csr_result_rec IN csr_result_value(csr_rec.input_value_id ,csr_rec.element_type_id ,p_assignment_action_id)
3487: LOOP
3488: IF csr_result_rec.result_value is not null THEN
3489: pay_action_information_api.create_action_information (
3490: p_action_information_id => l_action_info_id
3491: ,p_action_context_id => p_archive_assact_id
3492: ,p_action_context_type => 'AAP'
3493: ,p_object_version_number => l_ovn

Line 3523: pay_action_information_api.create_action_information (

3519: ,csr_rec.element_type_id
3520: ,p_assignment_action_id )
3521: LOOP
3522: IF csr_result_rec.result_value is not null THEN
3523: pay_action_information_api.create_action_information (
3524: p_action_information_id => l_action_info_id
3525: ,p_action_context_id => p_archive_assact_id
3526: ,p_action_context_type => 'AAP'
3527: ,p_object_version_number => l_ovn

Line 3570: pay_action_information_api.create_action_information (

3566: ,csr_rec.element_type_id
3567: ,p_assignment_action_id )
3568: LOOP
3569: IF csr_result_rec.AMOUNT is not null THEN
3570: pay_action_information_api.create_action_information (
3571: p_action_information_id => l_action_info_id
3572: ,p_action_context_id => p_archive_assact_id
3573: ,p_action_context_type => 'AAP'
3574: ,p_object_version_number => l_ovn

Line 3602: pay_action_information_api.create_action_information (

3598: ,csr_rec.element_type_id
3599: ,p_assignment_action_id )
3600: LOOP
3601: IF csr_result_rec.AMOUNT is not null THEN
3602: pay_action_information_api.create_action_information (
3603: p_action_information_id => l_action_info_id
3604: ,p_action_context_id => p_archive_assact_id
3605: ,p_action_context_type => 'AAP'
3606: ,p_object_version_number => l_ovn

Line 3670: pay_action_information_api.create_action_information (

3666: END IF; -- End if of segment 7 , unit
3667:
3668: -- Resume again
3669: IF csr_result_rec.result_value is not null THEN
3670: pay_action_information_api.create_action_information (
3671: p_action_information_id => l_action_info_id
3672: ,p_action_context_id => p_archive_assact_id
3673: ,p_action_context_type => 'AAP'
3674: ,p_object_version_number => l_ovn

Line 3708: pay_action_information_api.create_action_information (

3704: ,p_assignment_action_id
3705: )
3706: LOOP
3707: IF csr_result_rec.result_value is not null THEN
3708: pay_action_information_api.create_action_information (
3709: p_action_information_id => l_action_info_id
3710: ,p_action_context_id => p_archive_assact_id
3711: ,p_action_context_type => 'AAP'
3712: ,p_object_version_number => l_ovn

Line 3736: pay_action_information_api.create_action_information (

3732: LOOP
3733:
3734: IF csr_result_rec.result_value is not null THEN
3735:
3736: pay_action_information_api.create_action_information (
3737: p_action_information_id => l_action_info_id
3738: ,p_action_context_id => p_archive_assact_id
3739: ,p_action_context_type => 'AAP'
3740: ,p_object_version_number => l_ovn

Line 3874: pay_action_information_api.create_action_information (

3870: -- Bug#8849455 fix Added space between 3 and 4 digits in postal code
3871: l_emp_postal_code := substr(l_emp_postal_code,1,3)||' '||substr(l_emp_postal_code,4,2);
3872: l_emp_country:=PAY_SE_PAYSLIP_ARCHIVE.get_country_name(rec_employer_address.country);
3873:
3874: pay_action_information_api.create_action_information (
3875: p_action_information_id => l_action_info_id
3876: ,p_action_context_id => p_payroll_action_id
3877: ,p_action_context_type => 'PA'
3878: ,p_object_version_number => l_ovn