[Home] [Help]
184:
185: --cursor to check 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 = 'PYDKPRORGA'
191: and action_context_id = pactid;
192:
541: END;
542:
543: -- Archive the REPORT DETAILS(input Parameters)
544:
545: pay_action_information_api.create_action_information (
546: p_action_information_id => l_action_info_id -- out parameter
547: ,p_object_version_number => l_ovn -- out parameter
548: ,p_action_context_id => pactid -- context id = payroll action id (of Archive)
549: ,p_action_context_type => 'PA' -- context type
576: FETCH csr_pr_ele_ytd INTO l_ele_ytd;
577: CLOSE csr_pr_ele_ytd;
578:
579: -- Creating Archive Entries
580: pay_action_information_api.create_action_information (
581:
582: p_action_information_id => l_action_info_id -- out parameter
583: ,p_object_version_number => l_ovn -- out parameter
584: ,p_action_context_id => pactid -- context id = assignment action id (of Archive)
617: FETCH csr_pr_ele_ytd INTO l_ele_ytd;
618: CLOSE csr_pr_ele_ytd;
619:
620: -- Creating Archive Entries
621: pay_action_information_api.create_action_information (
622:
623: p_action_information_id => l_action_info_id -- out parameter
624: ,p_object_version_number => l_ovn -- out parameter
625: ,p_action_context_id => pactid -- context id = assignment action id (of Archive)
743: ,pai2.action_information10 costed_code
744: ,fnd_number.canonical_to_number(pai2.action_information11) pay_value
745: ,fnd_number.canonical_to_number(pai2.action_information12) balance_amount
746: FROM
747: pay_action_information pai1,pay_action_information pai2
748: WHERE
749: -- Removing to_char for bug fix 5231458
750: --TO_CHAR(pai1.action_context_id)=l_payroll_action_id
751: pai1.action_context_id = l_payroll_action_id