APPS.PAY_DK_PR_ASG dependencies on PAY_ACTION_INFORMATION

Line 183: pay_action_information

179: --cursor to check current archive exists
180: cursor csr_count is
181: SELECT count(*)
182: FROM
183: pay_action_information
184: WHERE
185: action_information_category = 'EMEA REPORT DETAILS'
186: AND action_information1 = 'PYDKPRASGA'
187: AND action_context_id = pactid;

Line 263: pay_action_information_api.create_action_information (

259: END;
260:
261: -- Archive the REPORT DETAILS
262:
263: pay_action_information_api.create_action_information (
264: p_action_information_id => l_action_info_id -- out parameter
265: ,p_object_version_number => l_ovn -- out parameter
266: ,p_action_context_id => pactid -- context id = payroll action id (of Archive)
267: ,p_action_context_type => 'PA' -- context type

Line 589: pay_action_information_api.create_action_information (

585: END IF ;
586:
587:
588: -- Creating Initial Archive Entries
589: pay_action_information_api.create_action_information (
590:
591: p_action_information_id => l_action_info_id -- out parameter
592: ,p_object_version_number => l_ovn -- out parameter
593: ,p_action_context_id => l_actid -- context id = assignment action id (of Archive)

Line 644: pay_action_information_api.create_action_information (

640: END IF ;
641:
642:
643: -- Creating Initial Archive Entries
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 => l_actid -- context id = assignment action id (of Archive)

Line 697: pay_action_information

693: CURSOR csr_get_act_info (p_assignment_action_id NUMBER , p_effective_date DATE) is
694: SELECT
695: TO_NUMBER (ACTION_INFORMATION_ID) action_info_id
696: FROM
697: pay_action_information
698: WHERE
699: ACTION_INFORMATION_CATEGORY = 'EMEA REPORT INFORMATION'
700: AND ACTION_INFORMATION1 = 'PYDKPRASGA'
701: AND ACTION_CONTEXT_TYPE = 'AAP'

Line 772: pay_action_information_api.update_action_information (

768:
769: FOR csr_get_act_info_rec IN csr_get_act_info (p_assignment_action_id , p_effective_date ) LOOP
770:
771: -- Updating the Initial Archive Entries
772: pay_action_information_api.update_action_information (
773: p_action_information_id => csr_get_act_info_rec.action_info_id -- in parameter
774: ,p_object_version_number => l_ovn -- in out parameter
775: ,p_action_information12 => rec_emp_details.organization_name --organization name)
776: ,p_action_information13 => rec_emp_details.emp_num -- employee number

Line 836: pay_action_information pai1,pay_action_information pai2

832: ,fnd_number.canonical_to_number(pai2.action_information18) balance_amount
833:
834:
835: FROM
836: pay_action_information pai1,pay_action_information pai2
837: WHERE
838: -- Removing to_char for bug fix 5231458
839: -- Added to_char for bug fix 5236372
840: --TO_CHAR(pai1.action_context_id)=l_payroll_action_id