APPS.PAY_IE_P45_ARCHIVE dependencies on HR_NONRUN_ASACT

Line 3130: hr_nonrun_asact.insact(l_actid,csr_rec.assignment_id,pactid,chunk,g_paye_ref);

3126: -- CREATE THE ARCHIVE ASSIGNMENT ACTION FOR THE MASTER ASSIGNMENT ACTION
3127: hr_utility.set_location('ASSIGNMENT ID : ' || csr_rec.assignment_id,23);
3128: hr_utility.trace('ASSIGNMENT ID : ' || csr_rec.assignment_id);
3129:
3130: hr_nonrun_asact.insact(l_actid,csr_rec.assignment_id,pactid,chunk,g_paye_ref);
3131: -- CREATE THE ARCHIVE TO PAYROLL MASTER ASSIGNMENT ACTION INTERLOCK AND
3132: -- THE ARCHIVE TO PREPAYMENT ASSIGNMENT ACTION INTERLOCK
3133: -- hr_utility.set_location('creating lock1 ' || l_actid || ' to ' || csr_rec.run_action_id,20);
3134: -- hr_utility.set_location('creating lock2 ' || l_actid || ' to ' || csr_rec.prepaid_action_id,20);

Line 3142: hr_nonrun_asact.insint(l_actid,csr_rec.prepaid_action_id);

3138: hr_utility.set_location('l_actid : ' || l_actid,102);
3139:
3140: IF l_prepay_action_id <> csr_rec.prepaid_action_id THEN
3141: hr_utility.set_location('locked id : ' || csr_rec.prepaid_action_id,23);
3142: hr_nonrun_asact.insint(l_actid,csr_rec.prepaid_action_id);
3143: END IF;
3144:
3145: hr_nonrun_asact.insint(l_actid,csr_rec.run_action_id);
3146:

Line 3145: hr_nonrun_asact.insint(l_actid,csr_rec.run_action_id);

3141: hr_utility.set_location('locked id : ' || csr_rec.prepaid_action_id,23);
3142: hr_nonrun_asact.insint(l_actid,csr_rec.prepaid_action_id);
3143: END IF;
3144:
3145: hr_nonrun_asact.insint(l_actid,csr_rec.run_action_id);
3146:
3147: l_prepay_action_id := csr_rec.prepaid_action_id;
3148: l_person_id := csr_rec.person_id;
3149: l_period_of_service_id := csr_rec.period_of_service_id;

Line 3405: hr_nonrun_asact.insact(

3401: SELECT pay_assignment_actions_s.NEXTVAL
3402: INTO l_actid
3403: FROM dual;
3404:
3405: hr_nonrun_asact.insact(
3406: lockingactid => l_actid
3407: , assignid => l_assignment_id
3408: , pactid => g_archive_pact
3409: , chunk => l_chunk_number

Line 3419: hr_nonrun_asact.insint(

3415: hr_utility.set_location('creating lock4 ' || l_actid || ' to ' || l_child_pay_action,30);
3416: -- bug 5386432, checks l_child_pay_action is not null, since for zero
3417: -- earnigns there will not child actions, so cant lock any
3418: IF l_child_pay_action IS NOT NULL THEN
3419: hr_nonrun_asact.insint(
3420: lockingactid => l_actid
3421: , lockedactid => l_child_pay_action);
3422: END IF;
3423:

Line 3454: hr_nonrun_asact.insint(

3450: hr_utility.set_location('sg Payroll action ='||g_archive_pact,34);
3451: hr_utility.set_location('sg P45 action ='||l_last_p45_action,35);
3452:
3453: IF l_last_p45_action IS NOT NULL THEN
3454: hr_nonrun_asact.insint(
3455: lockingactid => l_actid
3456: , lockedactid => l_last_p45_action);
3457: END IF;
3458: