APPS.PAY_FI_ARCHIVE_PYSA dependencies on PAY_ACTION_INFORMATION

Line 233: pay_action_information_api.create_action_information (

229: OPEN csr_get_message(l_business_group_id);
230: LOOP
231: FETCH csr_get_message INTO rec_get_message;
232: EXIT WHEN csr_get_message%NOTFOUND;
233: pay_action_information_api.create_action_information (
234: p_action_information_id => l_action_info_id
235: ,p_action_context_id => p_payroll_action_id
236: ,p_action_context_type => 'PA'
237: ,p_object_version_number => l_ovn

Line 262: FROM pay_action_information

258: FETCH csr_def_balance INTO l_defined_balance_id;
259: CLOSE csr_def_balance;
260: BEGIN
261: SELECT 1 INTO l_flag
262: FROM pay_action_information
263: WHERE action_information_category = 'EMEA BALANCE DEFINITION'
264: AND action_context_id = p_payroll_action_id
265: AND action_information2 = l_defined_balance_id
266: AND action_information6 = 'OBAL'

Line 269: pay_action_information_api.create_action_information (

265: AND action_information2 = l_defined_balance_id
266: AND action_information6 = 'OBAL'
267: AND action_information4 = rec_get_balance.narrative;
268: EXCEPTION WHEN NO_DATA_FOUND THEN
269: pay_action_information_api.create_action_information (
270: p_action_information_id => l_action_info_id
271: ,p_action_context_id => p_payroll_action_id
272: ,p_action_context_type => 'PA'
273: ,p_object_version_number => l_ovn

Line 305: FROM pay_action_information

301: FETCH csr_get_element INTO rec_get_element;
302: EXIT WHEN csr_get_element%NOTFOUND;
303: BEGIN
304: SELECT 1 INTO l_flag
305: FROM pay_action_information
306: WHERE action_context_id = p_payroll_action_id
307: AND action_information_category = 'EMEA ELEMENT DEFINITION'
308: AND action_information2 = rec_get_element.element_type_id
309: AND action_information3 = rec_get_element.input_value_id

Line 312: pay_action_information_api.create_action_information (

308: AND action_information2 = rec_get_element.element_type_id
309: AND action_information3 = rec_get_element.input_value_id
310: AND action_information5 = l_element_context;
311: EXCEPTION WHEN NO_DATA_FOUND THEN
312: pay_action_information_api.create_action_information (
313: p_action_information_id => l_action_info_id
314: ,p_action_context_id => p_payroll_action_id
315: ,p_action_context_type => 'PA'
316: ,p_object_version_number => l_ovn

Line 942: pay_action_information_api.create_action_information (

938: l_emp_country:=PAY_FI_ARCHIVE_PYSA.get_country_name(rec_employer_address.country);
939: */
940: /*fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_EMPLOYEE_DETAILS 6');*/
941: /* INSERT PERSON DETAILS */
942: pay_action_information_api.create_action_information (
943: p_action_information_id => l_action_info_id
944: ,p_action_context_id => p_archive_assact_id
945: ,p_action_context_type => 'AAP'
946: ,p_object_version_number => l_ovn

Line 968: pay_action_information_api.create_action_information (

964: /* INSERT ADDRESS DETAILS */
965:
966: IF rec_primary_address.AL1 IS NOT NULL THEN /* CHECK IF EMPLOYEE HAS BEEN GIVEN A PRIMARY ADDRESS */
967:
968: pay_action_information_api.create_action_information (
969: p_action_information_id => l_action_info_id
970: ,p_action_context_id => p_archive_assact_id
971: ,p_action_context_type => 'AAP'
972: ,p_object_version_number => l_ovn

Line 988: pay_action_information_api.create_action_information (

984: ,p_assignment_id => p_assignment_id);
985: ELSE
986: /* INSERT EMPLOYER ADDRESS AS EMPLOYEE'S PRIMARY ADDRESS */
987:
988: pay_action_information_api.create_action_information (
989: p_action_information_id => l_action_info_id
990: ,p_action_context_id => p_archive_assact_id
991: ,p_action_context_type => 'AAP'
992: ,p_object_version_number => l_ovn

Line 1017: FROM pay_action_information

1013: BEGIN
1014: l_org_exists := 0;
1015: SELECT 1
1016: INTO l_org_exists
1017: FROM pay_action_information
1018: WHERE action_context_id = p_payroll_action_id
1019: AND action_information1 = rec_person_details.org_id
1020: AND effective_date = p_effective_date
1021: AND action_information_category = 'ADDRESS DETAILS';

Line 1025: pay_action_information_api.create_action_information (

1021: AND action_information_category = 'ADDRESS DETAILS';
1022: EXCEPTION
1023: WHEN NO_DATA_FOUND THEN
1024: fnd_file.put_line(fnd_file.log,'PA Employer Address'||p_archive_assact_id);
1025: pay_action_information_api.create_action_information (
1026: p_action_information_id => l_action_info_id
1027: ,p_action_context_id => p_payroll_action_id
1028: ,p_action_context_type => 'PA'
1029: ,p_object_version_number => l_ovn

Line 1132: FROM pay_action_information

1128: /* EARNINGS ELEMENT */
1129: FOR rec_earnings IN csr_ear_element_info LOOP
1130: BEGIN
1131: SELECT 1 INTO l_flag
1132: FROM pay_action_information
1133: WHERE action_context_id = p_payroll_action_id
1134: AND action_information_category = 'EMEA ELEMENT DEFINITION'
1135: AND action_information2 = rec_earnings.element_type_id
1136: AND action_information3 = rec_earnings.input_value_id

Line 1139: pay_action_information_api.create_action_information (

1135: AND action_information2 = rec_earnings.element_type_id
1136: AND action_information3 = rec_earnings.input_value_id
1137: AND action_information5 = 'E';
1138: EXCEPTION WHEN NO_DATA_FOUND THEN
1139: pay_action_information_api.create_action_information (
1140: p_action_information_id => l_action_info_id
1141: ,p_action_context_id => p_payroll_action_id
1142: ,p_action_context_type => 'PA'
1143: ,p_object_version_number => l_ovn

Line 1163: FROM pay_action_information

1159: /* DEDUCTION ELEMENT */
1160: FOR rec_deduction IN csr_ded_element_info LOOP
1161: BEGIN
1162: SELECT 1 INTO l_flag
1163: FROM pay_action_information
1164: WHERE action_context_id = p_payroll_action_id
1165: AND action_information_category = 'EMEA ELEMENT DEFINITION'
1166: AND action_information2 = rec_deduction.element_type_id
1167: AND action_information3 = rec_deduction.input_value_id

Line 1170: pay_action_information_api.create_action_information (

1166: AND action_information2 = rec_deduction.element_type_id
1167: AND action_information3 = rec_deduction.input_value_id
1168: AND action_information5 = 'D';
1169: EXCEPTION WHEN NO_DATA_FOUND THEN
1170: pay_action_information_api.create_action_information (
1171: p_action_information_id => l_action_info_id
1172: ,p_action_context_id => p_payroll_action_id
1173: ,p_action_context_type => 'PA'
1174: ,p_object_version_number => l_ovn

Line 1327: pay_action_information_api.create_action_information (

1323: l_pay_value := to_char (rec_pers_pay.value,g_format_mask);
1324: IF (l_ext_acct IS NOT NULL) THEN
1325: /*fnd_file.put_line(fnd_file.log,'In ARCHIVE_PAYMENT_INFO 2');*/
1326: l_bank_name := rec_pers_pay.name_id;
1327: pay_action_information_api.create_action_information (
1328: p_action_information_id => l_action_info_id
1329: ,p_action_context_id => p_archive_assact_id
1330: ,p_action_context_type => 'AAP'
1331: ,p_object_version_number => l_ovn

Line 1355: pay_action_information_api.create_action_information (

1351: ,p_action_information18 => rec_pers_pay.opm_name
1352: ,p_assignment_id => p_assignment_id);
1353: ELSE
1354: /*fnd_file.put_line(fnd_file.log,'In ARCHIVE_PAYMENT_INFO 3');*/
1355: pay_action_information_api.create_action_information (
1356: p_action_information_id => l_action_info_id
1357: ,p_action_context_id => p_archive_assact_id
1358: ,p_action_context_type => 'AAP'
1359: ,p_object_version_number => l_ovn

Line 1391: pay_action_information_api.create_action_information (

1387:
1388: FOR rec_org_pay IN csr_get_org_pay(p_prepay_assact_id,rec_chk.opm_id) LOOP
1389:
1390: l_pay_value := to_char (rec_org_pay.value,g_format_mask);
1391: pay_action_information_api.create_action_information (
1392: p_action_information_id => l_action_info_id
1393: ,p_action_context_id => p_archive_assact_id
1394: ,p_action_context_type => 'AAP'
1395: ,p_object_version_number => l_ovn

Line 1537: pay_action_information_api.create_action_information (

1533: );
1534: l_ovn :=1;
1535: IF l_accrual_plan_name IS NOT NULL THEN
1536: --
1537: pay_action_information_api.create_action_information (
1538: p_action_information_id => l_action_info_id
1539: ,p_action_context_id => p_archive_assact_id
1540: ,p_action_context_type => 'AAP'
1541: ,p_object_version_number => l_ovn

Line 1663: pay_action_information_api.create_action_information (

1659: ,p_assignment_action_id);
1660: FETCH csr_result_value INTO l_result_value;
1661: CLOSE csr_result_value;
1662: IF l_result_value is not null THEN
1663: pay_action_information_api.create_action_information (
1664: p_action_information_id => l_action_info_id
1665: ,p_action_context_id => p_archive_assact_id
1666: ,p_action_context_type => 'AAP'
1667: ,p_object_version_number => l_ovn

Line 1771: pay_action_information_api.create_action_information (

1767: FOR l_index IN g_user_balance_table.first.. g_user_balance_table.last LOOP
1768: l_balance_value := pay_balance_pkg.get_value(g_user_balance_table(l_index).defined_balance_id,p_assignment_action_id);
1769: IF l_balance_value > 0 THEN
1770:
1771: pay_action_information_api.create_action_information (
1772: p_action_information_id => l_action_info_id
1773: ,p_action_context_id => p_archive_assact_id
1774: ,p_action_context_type => 'AAP'
1775: ,p_object_version_number => l_ovn

Line 1901: l_action_info_id pay_action_information.action_information_id%TYPE;

1897: l_previous_income NUMBER (10);
1898: l_ovn NUMBER ;
1899: l_rec get_details%ROWTYPE;
1900: l_tax_rec csr_tax_details%ROWTYPE;
1901: l_action_info_id pay_action_information.action_information_id%TYPE;
1902:
1903: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
1904: l_sal_inc_ptd NUMBER(10,2);
1905: l_sal_inc_ytd NUMBER(10,2);

Line 2007: pay_action_information_api.create_action_information (

2003: END IF;
2004:
2005: l_tax_card_type := hr_general.decode_lookup('FI_TAX_CARD_TYPE',l_tax_card_type ) ;
2006:
2007: pay_action_information_api.create_action_information (
2008: p_action_information_id => l_action_info_id
2009: ,p_action_context_id => p_archive_assact_id
2010: ,p_action_context_type => 'AAP'
2011: ,p_object_version_number => l_ovn

Line 2265: pay_action_information_api.create_action_information (

2261:
2262: END LOOP;
2263: END LOOP;
2264:
2265: pay_action_information_api.create_action_information (
2266: p_action_information_id => l_action_info_id
2267: ,p_action_context_id => p_archive_assact_id
2268: ,p_action_context_type => 'AAP'
2269: ,p_object_version_number => l_ovn

Line 2497: pay_action_information_api.create_action_information (

2493: l_carryover_hd_t_ptd := 0;
2494: END;
2495:
2496:
2497: pay_action_information_api.create_action_information (
2498: p_action_information_id => l_action_info_id
2499: ,p_action_context_id => p_archive_assact_id
2500: ,p_action_context_type => 'AAP'
2501: ,p_object_version_number => l_ovn

Line 2824: pay_action_information_api.create_action_information (

2820: FETCH csr_result_value INTO l_result_value;
2821: CLOSE csr_result_value;
2822:
2823: IF l_result_value is not null THEN
2824: pay_action_information_api.create_action_information (
2825: p_action_information_id => l_action_info_id
2826: ,p_action_context_id => p_archive_assact_id
2827: ,p_action_context_type => 'AAP'
2828: ,p_object_version_number => l_ovn

Line 2866: pay_action_information_api.create_action_information (

2862: CLOSE csr_result_value;
2863:
2864: IF l_result_value is not null THEN
2865:
2866: pay_action_information_api.create_action_information (
2867: p_action_information_id => l_action_info_id
2868: ,p_action_context_id => p_archive_assact_id
2869: ,p_action_context_type => 'AAP'
2870: ,p_object_version_number => l_ovn

Line 2904: CURSOR csr_scl_details (p_payroll_action_id pay_action_information.action_information1%TYPE , p_effective_date DATE ) IS

2900:
2901: PROCEDURE DEINITIALIZATION_CODE
2902: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is
2903:
2904: CURSOR csr_scl_details (p_payroll_action_id pay_action_information.action_information1%TYPE , p_effective_date DATE ) IS
2905: SELECT DISTINCT segment2 local_unit , paaf.business_group_id
2906: FROM per_all_assignments_f paaf
2907: ,HR_SOFT_CODING_KEYFLEX hsck
2908: WHERE p_effective_date BETWEEN paaf.effective_start_date AND paaf.effective_end_date

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

2941: ,hr_organization_units hou
2942: WHERE hou.organization_id = p_organization_id
2943: AND hou.location_id = hla.location_id;
2944:
2945: CURSOR csr_effective_date (p_payroll_action_id pay_action_information.action_information1%TYPE ) IS
2946: SELECT effective_date
2947: FROM pay_payroll_actions
2948: WHERE payroll_action_id= p_payroll_action_id ;
2949:

Line 2981: FROM pay_action_information

2977:
2978: l_org_exists := 0;
2979: SELECT 1
2980: INTO l_org_exists
2981: FROM pay_action_information
2982: WHERE action_context_id = p_payroll_action_id
2983: AND action_information1 = csr_legal_emp_rec.organization_id
2984: AND effective_date = l_effective_date
2985: AND action_information_category = 'ADDRESS DETAILS';

Line 3001: pay_action_information_api.create_action_information (

2997: l_emp_postal_code := rec_employer_address.postal_code;
2998: END IF;
2999: l_emp_country:=PAY_FI_ARCHIVE_PYSA.get_country_name(rec_employer_address.country);
3000:
3001: pay_action_information_api.create_action_information (
3002: p_action_information_id => l_action_info_id
3003: ,p_action_context_id => p_payroll_action_id
3004: ,p_action_context_type => 'PA'
3005: ,p_object_version_number => l_ovn