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

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 281: FROM pay_action_information

277: FETCH csr_def_balance INTO l_defined_balance_id;
278: CLOSE csr_def_balance;
279: BEGIN
280: SELECT 1 INTO l_flag
281: FROM pay_action_information
282: WHERE action_information_category = 'EMEA BALANCE DEFINITION'
283: AND action_context_id = p_payroll_action_id
284: AND action_information2 = l_defined_balance_id
285: AND action_information6 = 'OBAL'

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 329: FROM pay_action_information

325: FETCH csr_get_element INTO rec_get_element;
326: EXIT WHEN csr_get_element%NOTFOUND;
327: BEGIN
328: SELECT 1 INTO l_flag
329: FROM pay_action_information
330: WHERE action_context_id = p_payroll_action_id
331: AND action_information_category = 'EMEA ELEMENT DEFINITION'
332: AND action_information2 = rec_get_element.element_type_id
333: AND action_information3 = rec_get_element.input_value_id

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 1084: FROM pay_action_information

1080: BEGIN
1081: l_org_exists := 0;
1082: SELECT 1
1083: INTO l_org_exists
1084: FROM pay_action_information
1085: WHERE action_context_id = p_payroll_action_id
1086: AND action_information1 = rec_person_details.org_id
1087: AND effective_date = p_effective_date
1088: AND action_information_category = 'ADDRESS DETAILS';

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 1259: FROM pay_action_information

1255: /* EARNINGS ELEMENT */
1256: FOR rec_earnings IN csr_ear_element_info LOOP
1257: BEGIN
1258: SELECT 1 INTO l_flag
1259: FROM pay_action_information
1260: WHERE action_context_id = p_payroll_action_id
1261: AND action_information_category = 'EMEA ELEMENT DEFINITION'
1262: AND action_information2 = rec_earnings.element_type_id
1263: AND action_information3 = rec_earnings.input_value_id

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 1299: FROM pay_action_information

1295: --fnd_file.put_line(fnd_file.log,' DEDUCTION ELEMENT ');
1296: FOR rec_deduction IN csr_ded_element_info LOOP
1297: BEGIN
1298: SELECT 1 INTO l_flag
1299: FROM pay_action_information
1300: WHERE action_context_id = p_payroll_action_id
1301: AND action_information_category = 'EMEA ELEMENT DEFINITION'
1302: AND action_information2 = rec_deduction.element_type_id
1303: AND action_information3 = rec_deduction.input_value_id

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 2451: l_action_info_id pay_action_information.action_information_id%TYPE;

2447:
2448: l_ovn NUMBER ;
2449: l_rec get_details%ROWTYPE;
2450: l_tax_rec csr_tax_details%ROWTYPE;
2451: l_action_info_id pay_action_information.action_information_id%TYPE;
2452:
2453: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
2454:
2455:

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 3750: CURSOR csr_scl_details (p_payroll_action_id pay_action_information.action_information1%TYPE , p_effective_date DATE ) IS

3746:
3747: PROCEDURE DEINITIALIZATION_CODE
3748: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is
3749:
3750: CURSOR csr_scl_details (p_payroll_action_id pay_action_information.action_information1%TYPE , p_effective_date DATE ) IS
3751: SELECT DISTINCT segment2 local_unit , paaf.business_group_id
3752: FROM per_all_assignments_f paaf
3753: ,HR_SOFT_CODING_KEYFLEX hsck
3754: WHERE p_effective_date BETWEEN paaf.effective_start_date AND paaf.effective_end_date

Line 3791: CURSOR csr_effective_date (p_payroll_action_id pay_action_information.action_information1%TYPE ) IS

3787: ,hr_organization_units hou
3788: WHERE hou.organization_id = p_organization_id
3789: AND hou.location_id = hla.location_id;
3790:
3791: CURSOR csr_effective_date (p_payroll_action_id pay_action_information.action_information1%TYPE ) IS
3792: SELECT effective_date
3793: FROM pay_payroll_actions
3794: WHERE payroll_action_id= p_payroll_action_id ;
3795:

Line 3827: FROM pay_action_information

3823:
3824: l_org_exists := 0;
3825: SELECT 1
3826: INTO l_org_exists
3827: FROM pay_action_information
3828: WHERE action_context_id = p_payroll_action_id
3829: AND action_information1 = csr_legal_emp_rec.organization_id
3830: AND effective_date = l_effective_date
3831: AND action_information_category = 'ADDRESS DETAILS';

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