APPS.PAY_NO_PACCR_PKG dependencies on PAY_ACTION_INFORMATION

Line 188: FROM pay_action_information

184:
185: /* Cursor to check if Current Archive exists */
186: CURSOR csr_count is
187: SELECT count(*)
188: FROM pay_action_information
189: WHERE action_information_category = 'EMEA REPORT DETAILS'
190: AND action_information1 = 'PYNOPACCA'
191: AND action_context_id = pactid;
192:

Line 293: pay_action_information_api.create_action_information

289: IF (l_count < 1) THEN
290:
291: -- Archive the REPORT HEADER
292:
293: pay_action_information_api.create_action_information
294: (p_action_information_id => l_action_info_id -- out parameter
295: ,p_object_version_number => l_ovn -- out parameter
296: ,p_action_context_id => pactid -- context id = payroll action id (of Archive)
297: ,p_action_context_type => 'PA' -- context type

Line 348: FROM pay_action_information pai

344: ,tax_unit_id
345: ,to_number(action_information11) ele_type_id
346: ,action_information14 restr_econtr
347: ,action_information9 cost_seg
348: FROM pay_action_information pai
349: WHERE action_context_type = 'PA'
350: AND action_context_id = p_payroll_action_id
351: AND action_information_category = 'EMEA REPORT DETAILS'
352: AND action_information1 = 'PYNOPACCA'

Line 713: pay_action_information_api.create_action_information

709: Hr_utility.set_location('#- csr_rec.cost_or_bal '|| csr_rec.cost_or_bal,42 );
710: Hr_utility.set_location('#- csr_rec.effective_date '|| csr_rec.effective_date,43 );
711: Hr_utility.set_location('#- csr_rec.emp_name '|| csr_rec.emp_name,44 );
712: --
713: pay_action_information_api.create_action_information
714: (p_action_information_id => l_action_info_id -- OUT parameter
715: ,p_object_version_number => l_ovn -- OUT parameter
716: ,p_action_context_id => l_actid -- Context id = assignment action id (of Archive)
717: ,p_action_context_type => 'AAP' -- Context type

Line 820: FROM pay_action_information pai

816: ,action_information15 balance_or_cost
817: ,tax_unit_id leg_emp_id
818: ,to_number(action_information6) local_unit_id
819: ,effective_date
820: FROM pay_action_information pai
821: WHERE action_context_type = 'AAP'
822: AND action_information3 = to_char(p_payroll_action_id)
823: AND action_information_category = 'EMEA REPORT INFORMATION'
824: AND action_information1 = 'PYNOPACCA'

Line 902: pay_action_information_api.create_action_information

898: CLOSE csr_ele_code;
899: l_ele_code := rec_ele_code.ele_code;
900: l_sum_cost_value := fnd_number.number_to_canonical(rec_costing_summary.costed_value);
901: -- Archive the SUMMARY REPORT DETAILS
902: pay_action_information_api.create_action_information
903: (p_action_information_id => l_action_info_id -- out parameter
904: ,p_object_version_number => l_ovn -- out parameter
905: ,p_action_context_id => p_payroll_action_id -- context id = payroll action id (of Archive)
906: ,p_action_context_type => 'PA' -- context type

Line 967: FROM pay_action_information pai

963: /* Cursor to fetch Header Information */
964: CURSOR csr_get_hdr_info(p_payroll_action_id NUMBER)
965: IS
966: SELECT *
967: FROM pay_action_information pai
968: WHERE action_context_type = 'PA'
969: AND action_context_id = p_payroll_action_id
970: AND action_information_category = 'EMEA REPORT DETAILS'
971: AND action_information1 = 'PYNOPACCA'

Line 978: FROM pay_action_information pai

974: /* Cursor to fetch Costing Summary Information */
975: CURSOR csr_get_summ_info(p_payroll_action_id NUMBER, p_tax_unit_id NUMBER)
976: IS
977: SELECT *
978: FROM pay_action_information pai
979: WHERE action_context_type = 'PA'
980: AND action_context_id = p_payroll_action_id
981: AND action_information_category = 'EMEA REPORT DETAILS'
982: AND action_information1 = 'PYNOPACCA'

Line 1309: FROM pay_action_information pai

1305: /* Cursor to fetch Header Information */
1306: CURSOR csr_get_hdr_info(p_payroll_action_id NUMBER)
1307: IS
1308: SELECT *
1309: FROM pay_action_information pai
1310: WHERE action_context_type = 'PA'
1311: AND action_context_id = p_payroll_action_id
1312: AND action_information_category = 'EMEA REPORT DETAILS'
1313: AND action_information1 = 'PYNOPACCA'

Line 1335: FROM pay_action_information pai

1331: ,action_information15 --COST_OR_BAL
1332: ,action_information13 --ELE_CODE
1333: ,action_information16 --COST_EFFECTIVE_DATE
1334: ,action_information17 --EMP_NAME
1335: FROM pay_action_information pai
1336: WHERE action_context_type = 'AAP'
1337: AND action_information3 = to_char(p_payroll_action_id)
1338: AND action_information_category = 'EMEA REPORT INFORMATION'
1339: AND action_information1 = 'PYNOPACCA'