DBA Data[Home] [Help]

APPS.PER_NL_DSR_ARCHIVE dependencies on HR_NONRUN_ASACT

Line 1195: hr_nonrun_asact.insact(

1191: IS
1192: l_asg_act_id NUMBER;
1193: BEGIN
1194: SELECT pay_assignment_actions_s.NEXTVAL INTO l_asg_act_id FROM dual;
1195: hr_nonrun_asact.insact(
1196: lockingactid => l_asg_act_id
1197: ,assignid => p_assignid
1198: ,pactid => p_pactid
1199: ,chunk => p_chunk);

Line 1833: hr_nonrun_asact.insact(

1829: ELSIF l_exists = 'N' THEN
1830:
1831: SELECT pay_assignment_actions_s.NEXTVAL INTO l_child_aa_id FROM dual;
1832:
1833: hr_nonrun_asact.insact(
1834: lockingactid => l_child_aa_id
1835: , assignid => l_assignment_id
1836: , pactid => l_payroll_action_id
1837: , chunk => l_chunk_number

Line 2203: hr_nonrun_asact.insint(lockingactid => p_assignment_action_id

2199: to_char(fnd_date.canonical_to_date(r_get_archived_absence.st_dt),'DDMonYYYY') || ' / ' ||
2200: to_char(fnd_date.canonical_to_date(r_get_archived_absence.end_dt),'DDMonYYYY'));
2201: hr_utility.trace('Org Asg Action ID : ' || r_get_archived_absence.org_asg_act_id);
2202:
2203: hr_nonrun_asact.insint(lockingactid => p_assignment_action_id
2204: , lockedactid => r_get_archived_absence.org_asg_act_id);
2205: IF l_type = 'W' THEN
2206: -- Update previous archive incase of withdrawal.
2207: pay_action_information_api.update_action_information