DBA Data[Home] [Help]

APPS.PAY_IE_P45_ARCHIVE dependencies on HR_NONRUN_ASACT

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

3895: -- CREATE THE ARCHIVE ASSIGNMENT ACTION FOR THE MASTER ASSIGNMENT ACTION
3896: hr_utility.set_location('ASSIGNMENT ID : ' || csr_rec.assignment_id,23);
3897: hr_utility.trace('ASSIGNMENT ID : ' || csr_rec.assignment_id);
3898:
3899: hr_nonrun_asact.insact(l_actid,csr_rec.assignment_id,pactid,chunk,g_paye_ref);
3900: -- CREATE THE ARCHIVE TO PAYROLL MASTER ASSIGNMENT ACTION INTERLOCK AND
3901: -- THE ARCHIVE TO PREPAYMENT ASSIGNMENT ACTION INTERLOCK
3902: -- hr_utility.set_location('creating lock1 ' || l_actid || ' to ' || csr_rec.run_action_id,20);
3903: -- hr_utility.set_location('creating lock2 ' || l_actid || ' to ' || csr_rec.prepaid_action_id,20);

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

3907: hr_utility.set_location('l_actid : ' || l_actid,102);
3908:
3909: IF l_prepay_action_id <> csr_rec.prepaid_action_id THEN
3910: hr_utility.set_location('locked id : ' || csr_rec.prepaid_action_id,23);
3911: hr_nonrun_asact.insint(l_actid,csr_rec.prepaid_action_id);
3912: END IF;
3913:
3914: hr_nonrun_asact.insint(l_actid,csr_rec.run_action_id);
3915:

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

3910: hr_utility.set_location('locked id : ' || csr_rec.prepaid_action_id,23);
3911: hr_nonrun_asact.insint(l_actid,csr_rec.prepaid_action_id);
3912: END IF;
3913:
3914: hr_nonrun_asact.insint(l_actid,csr_rec.run_action_id);
3915:
3916: l_prepay_action_id := csr_rec.prepaid_action_id;
3917: l_person_id := csr_rec.person_id;
3918: l_period_of_service_id := csr_rec.period_of_service_id;

Line 4237: hr_nonrun_asact.insact(

4233: SELECT pay_assignment_actions_s.NEXTVAL
4234: INTO l_actid
4235: FROM dual;
4236:
4237: hr_nonrun_asact.insact(
4238: lockingactid => l_actid
4239: , assignid => l_assignment_id
4240: , pactid => g_archive_pact
4241: , chunk => l_chunk_number

Line 4251: hr_nonrun_asact.insint(

4247: hr_utility.set_location('creating lock4 ' || l_actid || ' to ' || l_child_pay_action,30);
4248: -- bug 5386432, checks l_child_pay_action is not null, since for zero
4249: -- earnigns there will not child actions, so cant lock any
4250: IF l_child_pay_action IS NOT NULL THEN
4251: hr_nonrun_asact.insint(
4252: lockingactid => l_actid
4253: , lockedactid => l_child_pay_action);
4254: END IF;
4255:

Line 4288: hr_nonrun_asact.insint(

4284: hr_utility.set_location('sg Payroll action ='||g_archive_pact,34);
4285: hr_utility.set_location('sg P45 action ='||l_last_p45_action,35);
4286:
4287: IF l_last_p45_action IS NOT NULL THEN
4288: hr_nonrun_asact.insint(
4289: lockingactid => l_actid
4290: , lockedactid => l_last_p45_action);
4291: END IF;
4292: