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 982: pay_action_information_api.create_action_information (

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

Line 1024: pay_action_information_api.create_action_information (

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

Line 1055: pay_action_information_api.create_action_information (

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

Line 1092: pay_action_information_api.create_action_information (

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

Line 1266: pay_action_information_api.create_action_information (

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

Line 1306: pay_action_information_api.create_action_information (

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

Line 1474: pay_action_information_api.create_action_information (

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

Line 1503: pay_action_information_api.create_action_information (

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

Line 1539: pay_action_information_api.create_action_information (

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

Line 1869: pay_action_information_api.create_action_information (

1865: ,p_assignment_action_id
1866: ,rec_group_by.ORG_INFORMATION3)
1867: LOOP
1868: IF csr_result_rec.result_value is not null THEN
1869: pay_action_information_api.create_action_information (
1870: p_action_information_id => l_action_info_id
1871: ,p_action_context_id => p_archive_assact_id
1872: ,p_action_context_type => 'AAP'
1873: ,p_object_version_number => l_ovn

Line 1916: pay_action_information_api.create_action_information (

1912: ,g_element_table(l_index).element_type_id
1913: ,p_assignment_action_id)
1914: LOOP
1915: IF csr_result_rec.result_value is not null THEN
1916: pay_action_information_api.create_action_information (
1917: p_action_information_id => l_action_info_id
1918: ,p_action_context_id => p_archive_assact_id
1919: ,p_action_context_type => 'AAP'
1920: ,p_object_version_number => l_ovn

Line 1950: pay_action_information_api.create_action_information (

1946: ,g_element_table(l_index).element_type_id
1947: ,p_assignment_action_id )
1948: LOOP
1949: IF csr_result_rec.result_value is not null THEN
1950: pay_action_information_api.create_action_information (
1951: p_action_information_id => l_action_info_id
1952: ,p_action_context_id => p_archive_assact_id
1953: ,p_action_context_type => 'AAP'
1954: ,p_object_version_number => l_ovn

Line 1998: pay_action_information_api.create_action_information (

1994: ,g_element_table(l_index).element_type_id
1995: ,p_assignment_action_id )
1996: LOOP
1997: IF csr_result_rec.AMOUNT is not null THEN
1998: pay_action_information_api.create_action_information (
1999: p_action_information_id => l_action_info_id
2000: ,p_action_context_id => p_archive_assact_id
2001: ,p_action_context_type => 'AAP'
2002: ,p_object_version_number => l_ovn

Line 2030: pay_action_information_api.create_action_information (

2026: ,g_element_table(l_index).element_type_id
2027: ,p_assignment_action_id )
2028: LOOP
2029: IF csr_result_rec.AMOUNT is not null THEN
2030: pay_action_information_api.create_action_information (
2031: p_action_information_id => l_action_info_id
2032: ,p_action_context_id => p_archive_assact_id
2033: ,p_action_context_type => 'AAP'
2034: ,p_object_version_number => l_ovn

Line 2099: pay_action_information_api.create_action_information (

2095: END IF; -- End if of segment 7 , unit
2096:
2097: -- Resume again
2098: IF csr_result_rec.result_value is not null THEN
2099: pay_action_information_api.create_action_information (
2100: p_action_information_id => l_action_info_id
2101: ,p_action_context_id => p_archive_assact_id
2102: ,p_action_context_type => 'AAP'
2103: ,p_object_version_number => l_ovn

Line 2150: pay_action_information_api.create_action_information (

2146: FOR csr_result_rec IN csr_result_value(g_element_table(l_index).input_value_id ,g_element_table(l_index).element_type_id
2147: ,p_assignment_action_id)
2148: LOOP
2149: IF csr_result_rec.result_value is not null THEN
2150: pay_action_information_api.create_action_information (
2151: p_action_information_id => l_action_info_id
2152: ,p_action_context_id => p_archive_assact_id
2153: ,p_action_context_type => 'AAP'
2154: ,p_object_version_number => l_ovn

Line 2188: pay_action_information_api.create_action_information (

2184:
2185: l_result_value := rec_sum_of_result_values.result_value;
2186:
2187: IF l_result_value is not null THEN
2188: pay_action_information_api.create_action_information (
2189: p_action_information_id => l_action_info_id
2190: ,p_action_context_id => p_archive_assact_id
2191: ,p_action_context_type => 'AAP'
2192: ,p_object_version_number => l_ovn

Line 2310: pay_action_information_api.create_action_information (

2306: FOR l_index IN g_user_balance_table.first.. g_user_balance_table.last LOOP
2307: l_balance_value := pay_balance_pkg.get_value(g_user_balance_table(l_index).defined_balance_id,p_assignment_action_id);
2308: IF l_balance_value > 0 THEN
2309:
2310: pay_action_information_api.create_action_information (
2311: p_action_information_id => l_action_info_id
2312: ,p_action_context_id => p_archive_assact_id
2313: ,p_action_context_type => 'AAP'
2314: ,p_object_version_number => l_ovn

Line 2526: pay_action_information_api.create_action_information (

2522: */
2523:
2524: l_tax_card_type := hr_general.decode_lookup('SE_TAX_CARD_TYPE',l_tax_card_type ) ;
2525:
2526: pay_action_information_api.create_action_information (
2527: p_action_information_id => l_action_info_id
2528: ,p_action_context_id => p_archive_assact_id
2529: ,p_action_context_type => 'AAP'
2530: ,p_object_version_number => l_ovn

Line 3104: pay_action_information_api.create_action_information (

3100: -- unit and unit price should be absent.
3101: FOR csr_result_rec IN csr_result_value(csr_rec.input_value_id ,csr_rec.element_type_id ,p_assignment_action_id)
3102: LOOP
3103: IF csr_result_rec.result_value is not null THEN
3104: pay_action_information_api.create_action_information (
3105: p_action_information_id => l_action_info_id
3106: ,p_action_context_id => p_archive_assact_id
3107: ,p_action_context_type => 'AAP'
3108: ,p_object_version_number => l_ovn

Line 3138: pay_action_information_api.create_action_information (

3134: ,csr_rec.element_type_id
3135: ,p_assignment_action_id )
3136: LOOP
3137: IF csr_result_rec.result_value is not null THEN
3138: pay_action_information_api.create_action_information (
3139: p_action_information_id => l_action_info_id
3140: ,p_action_context_id => p_archive_assact_id
3141: ,p_action_context_type => 'AAP'
3142: ,p_object_version_number => l_ovn

Line 3187: pay_action_information_api.create_action_information (

3183: ,csr_rec.element_type_id
3184: ,p_assignment_action_id )
3185: LOOP
3186: IF csr_result_rec.AMOUNT is not null THEN
3187: pay_action_information_api.create_action_information (
3188: p_action_information_id => l_action_info_id
3189: ,p_action_context_id => p_archive_assact_id
3190: ,p_action_context_type => 'AAP'
3191: ,p_object_version_number => l_ovn

Line 3219: pay_action_information_api.create_action_information (

3215: ,csr_rec.element_type_id
3216: ,p_assignment_action_id )
3217: LOOP
3218: IF csr_result_rec.AMOUNT is not null THEN
3219: pay_action_information_api.create_action_information (
3220: p_action_information_id => l_action_info_id
3221: ,p_action_context_id => p_archive_assact_id
3222: ,p_action_context_type => 'AAP'
3223: ,p_object_version_number => l_ovn

Line 3288: pay_action_information_api.create_action_information (

3284: END IF; -- End if of segment 7 , unit
3285:
3286: -- Resume again
3287: IF csr_result_rec.result_value is not null THEN
3288: pay_action_information_api.create_action_information (
3289: p_action_information_id => l_action_info_id
3290: ,p_action_context_id => p_archive_assact_id
3291: ,p_action_context_type => 'AAP'
3292: ,p_object_version_number => l_ovn

Line 3324: pay_action_information_api.create_action_information (

3320: ,p_assignment_action_id
3321: ,rec_group_by.ORG_INFORMATION3)
3322: LOOP
3323: IF csr_result_rec.result_value is not null THEN
3324: pay_action_information_api.create_action_information (
3325: p_action_information_id => l_action_info_id
3326: ,p_action_context_id => p_archive_assact_id
3327: ,p_action_context_type => 'AAP'
3328: ,p_object_version_number => l_ovn

Line 3360: pay_action_information_api.create_action_information (

3356: THEN
3357: FOR csr_result_rec IN csr_result_value(csr_rec.input_value_id ,csr_rec.element_type_id ,p_assignment_action_id)
3358: LOOP
3359: IF csr_result_rec.result_value is not null THEN
3360: pay_action_information_api.create_action_information (
3361: p_action_information_id => l_action_info_id
3362: ,p_action_context_id => p_archive_assact_id
3363: ,p_action_context_type => 'AAP'
3364: ,p_object_version_number => l_ovn

Line 3393: pay_action_information_api.create_action_information (

3389: CLOSE csr_sum_of_result_values;
3390:
3391:
3392: IF l_result_value is not null THEN
3393: pay_action_information_api.create_action_information (
3394: p_action_information_id => l_action_info_id
3395: ,p_action_context_id => p_archive_assact_id
3396: ,p_action_context_type => 'AAP'
3397: ,p_object_version_number => l_ovn

Line 3464: pay_action_information_api.create_action_information (

3460: --fnd_file.put_line(fnd_file.log,'Vetri 3: ' || 'In ARCHIVE_MAIN_ELEMENTS'||rec_group_by.ORG_INFORMATION3);
3461: FOR csr_result_rec IN csr_result_value(csr_rec.input_value_id ,csr_rec.element_type_id ,p_assignment_action_id)
3462: LOOP
3463: IF csr_result_rec.result_value is not null THEN
3464: pay_action_information_api.create_action_information (
3465: p_action_information_id => l_action_info_id
3466: ,p_action_context_id => p_archive_assact_id
3467: ,p_action_context_type => 'AAP'
3468: ,p_object_version_number => l_ovn

Line 3498: pay_action_information_api.create_action_information (

3494: ,csr_rec.element_type_id
3495: ,p_assignment_action_id )
3496: LOOP
3497: IF csr_result_rec.result_value is not null THEN
3498: pay_action_information_api.create_action_information (
3499: p_action_information_id => l_action_info_id
3500: ,p_action_context_id => p_archive_assact_id
3501: ,p_action_context_type => 'AAP'
3502: ,p_object_version_number => l_ovn

Line 3545: pay_action_information_api.create_action_information (

3541: ,csr_rec.element_type_id
3542: ,p_assignment_action_id )
3543: LOOP
3544: IF csr_result_rec.AMOUNT is not null THEN
3545: pay_action_information_api.create_action_information (
3546: p_action_information_id => l_action_info_id
3547: ,p_action_context_id => p_archive_assact_id
3548: ,p_action_context_type => 'AAP'
3549: ,p_object_version_number => l_ovn

Line 3577: pay_action_information_api.create_action_information (

3573: ,csr_rec.element_type_id
3574: ,p_assignment_action_id )
3575: LOOP
3576: IF csr_result_rec.AMOUNT is not null THEN
3577: pay_action_information_api.create_action_information (
3578: p_action_information_id => l_action_info_id
3579: ,p_action_context_id => p_archive_assact_id
3580: ,p_action_context_type => 'AAP'
3581: ,p_object_version_number => l_ovn

Line 3645: pay_action_information_api.create_action_information (

3641: END IF; -- End if of segment 7 , unit
3642:
3643: -- Resume again
3644: IF csr_result_rec.result_value is not null THEN
3645: pay_action_information_api.create_action_information (
3646: p_action_information_id => l_action_info_id
3647: ,p_action_context_id => p_archive_assact_id
3648: ,p_action_context_type => 'AAP'
3649: ,p_object_version_number => l_ovn

Line 3683: pay_action_information_api.create_action_information (

3679: ,p_assignment_action_id
3680: )
3681: LOOP
3682: IF csr_result_rec.result_value is not null THEN
3683: pay_action_information_api.create_action_information (
3684: p_action_information_id => l_action_info_id
3685: ,p_action_context_id => p_archive_assact_id
3686: ,p_action_context_type => 'AAP'
3687: ,p_object_version_number => l_ovn

Line 3711: pay_action_information_api.create_action_information (

3707: LOOP
3708:
3709: IF csr_result_rec.result_value is not null THEN
3710:
3711: pay_action_information_api.create_action_information (
3712: p_action_information_id => l_action_info_id
3713: ,p_action_context_id => p_archive_assact_id
3714: ,p_action_context_type => 'AAP'
3715: ,p_object_version_number => l_ovn

Line 3847: pay_action_information_api.create_action_information (

3843: l_emp_postal_code := rec_employer_address.postal_code;
3844: END IF;
3845: l_emp_country:=PAY_SE_PAYSLIP_ARCHIVE.get_country_name(rec_employer_address.country);
3846:
3847: pay_action_information_api.create_action_information (
3848: p_action_information_id => l_action_info_id
3849: ,p_action_context_id => p_payroll_action_id
3850: ,p_action_context_type => 'PA'
3851: ,p_object_version_number => l_ovn