DBA Data[Home] [Help]

APPS.PAY_ZA_TYE_ARCHIVE_PKG dependencies on PAY_ACTION_INFORMATION

Line 587: pay_action_information_api.create_action_information

583: 'U0123456789');
584:
585: -- archive data
586: hr_utility.set_location(l_proc,40);
587: pay_action_information_api.create_action_information
588: (
589: p_action_information_id => l_action_info_id,
590: p_action_context_id => pactid,
591: p_action_context_type => 'PA',

Line 2306: , pay_action_information pai

2302: , pai.action_context_id
2303: , pai.action_context_type
2304: from pay_payroll_actions ppa
2305: , pay_assignment_actions paa
2306: , pay_action_information pai
2307: where ppa.payroll_action_id = pactid
2308: and ppa.action_status = 'C'
2309: and paa.payroll_action_id = ppa.payroll_action_id
2310: and paa.action_status = 'C'

Line 2357: update pay_action_information

2353: for emprec in csr_employee_info_rec
2354: loop
2355: l_itreg_cert_num := lpad(l_itreg_cert_num + 1,30,'0');
2356:
2357: update pay_action_information
2358: set action_information1 = l_itreg_cert_num
2359: where action_context_type = emprec.action_context_type
2360: and action_context_id = emprec.action_context_id
2361: and action_information30 = emprec.action_information30 ;

Line 4535: pay_action_information_api.create_action_information(

4531: hr_utility.trace('Defining category '|| p_tab_rec_data(i).action_info_category);
4532: hr_utility.trace('action_context_id = '|| p_assactid);
4533: hr_utility.trace('p_tab_rec_data(i).action_info_category = '|| p_tab_rec_data(i).action_info_category);
4534: if p_tab_rec_data(i).action_info_category is not null then
4535: pay_action_information_api.create_action_information(
4536: p_action_information_id => l_action_id,
4537: p_object_version_number => l_ovn,
4538: p_action_information_category => p_tab_rec_data(i).action_info_category,
4539: p_action_context_id => p_assactid,