185:
186: --cursor to check current archive exists
187: cursor csr_count is
188: select count(*)
189: from pay_action_information
190: where action_information_category = 'EMEA REPORT DETAILS'
191: and action_information1 = 'PYDKPRLEA'
192: and action_context_id = pactid;
193:
562:
563:
564: -- Archive the REPORT DETAILS
565:
566: pay_action_information_api.create_action_information (
567: p_action_information_id => l_action_info_id -- out parameter
568: ,p_object_version_number => l_ovn -- out parameter
569: ,p_action_context_id => pactid -- context id = payroll action id (of Archive)
570: ,p_action_context_type => 'PA' -- context type
597: FETCH csr_pr_ele_ytd INTO l_ele_ytd;
598: CLOSE csr_pr_ele_ytd;
599:
600: -- Creating Archive Entries
601: pay_action_information_api.create_action_information (
602:
603: p_action_information_id => l_action_info_id -- out parameter
604: ,p_object_version_number => l_ovn -- out parameter
605: ,p_action_context_id => pactid -- context id = assignment action id (of Archive)
640: ,csr_rec.date_earned);
641: FETCH csr_pr_ele_ytd INTO l_ele_ytd;
642: CLOSE csr_pr_ele_ytd;
643:
644: pay_action_information_api.create_action_information (
645:
646: p_action_information_id => l_action_info_id -- out parameter
647: ,p_object_version_number => l_ovn -- out parameter
648: ,p_action_context_id => pactid -- context id = assignment action id (of Archive)
772: ,pai2.action_information11 costed_code
773: ,fnd_number.canonical_to_number(pai2.action_information12) pay_value
774: ,fnd_number.canonical_to_number(pai2.action_information13) balance_amount
775: FROM
776: pay_action_information pai1
777: ,pay_action_information pai2
778: WHERE
779: -- Removing to_char for bug fix 5231458
780: --TO_CHAR(pai1.action_context_id)=l_payroll_action_id
773: ,fnd_number.canonical_to_number(pai2.action_information12) pay_value
774: ,fnd_number.canonical_to_number(pai2.action_information13) balance_amount
775: FROM
776: pay_action_information pai1
777: ,pay_action_information pai2
778: WHERE
779: -- Removing to_char for bug fix 5231458
780: --TO_CHAR(pai1.action_context_id)=l_payroll_action_id
781: pai1.action_context_id = l_payroll_action_id