DBA Data[Home] [Help]

APPS.PAY_IE_CESS_REPORT dependencies on HR_NONRUN_ASACT

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

1882: -- CREATE THE ARCHIVE ASSIGNMENT ACTION FOR THE MASTER ASSIGNMENT ACTION
1883: hr_utility.set_location('ASSIGNMENT ID : ' || csr_rec.assignment_id,23);
1884: hr_utility.trace('ASSIGNMENT ID : ' || csr_rec.assignment_id);
1885:
1886: hr_nonrun_asact.insact(l_actid,csr_rec.assignment_id,pactid,chunk,g_paye_ref);
1887: -- CREATE THE ARCHIVE TO PAYROLL MASTER ASSIGNMENT ACTION INTERLOCK AND
1888: -- THE ARCHIVE TO PREPAYMENT ASSIGNMENT ACTION INTERLOCK
1889: -- hr_utility.set_location('creating lock1 ' || l_actid || ' to ' || csr_rec.run_action_id,20);
1890: -- hr_utility.set_location('creating lock2 ' || l_actid || ' to ' || csr_rec.prepaid_action_id,20);

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

1894: hr_utility.set_location('l_actid : ' || l_actid,102);
1895:
1896: IF l_prepay_action_id <> csr_rec.prepaid_action_id THEN
1897: hr_utility.set_location('locked id : ' || csr_rec.prepaid_action_id,23);
1898: hr_nonrun_asact.insint(l_actid,csr_rec.prepaid_action_id);
1899: END IF;
1900:
1901: hr_nonrun_asact.insint(l_actid,csr_rec.run_action_id);
1902:

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

1897: hr_utility.set_location('locked id : ' || csr_rec.prepaid_action_id,23);
1898: hr_nonrun_asact.insint(l_actid,csr_rec.prepaid_action_id);
1899: END IF;
1900:
1901: hr_nonrun_asact.insint(l_actid,csr_rec.run_action_id);
1902:
1903: l_prepay_action_id := csr_rec.prepaid_action_id;
1904: l_person_id := csr_rec.person_id;
1905: l_period_of_service_id := csr_rec.period_of_service_id;

Line 2315: hr_nonrun_asact.insact(

2311: SELECT pay_assignment_actions_s.NEXTVAL
2312: INTO l_actid
2313: FROM dual;
2314:
2315: hr_nonrun_asact.insact(
2316: lockingactid => l_actid
2317: , assignid => l_assignment_id
2318: , pactid => g_archive_pact
2319: , chunk => l_chunk_number

Line 2329: hr_nonrun_asact.insint(

2325: hr_utility.set_location('creating lock4 ' || l_actid || ' to ' || l_child_pay_action,30);
2326: -- bug 5386432, checks l_child_pay_action is not null, since for zero
2327: -- earnigns there will not child actions, so cant lock any
2328: IF l_child_pay_action IS NOT NULL THEN
2329: hr_nonrun_asact.insint(
2330: lockingactid => l_actid
2331: , lockedactid => l_child_pay_action);
2332: END IF;
2333:

Line 2358: hr_nonrun_asact.insint(

2354: hr_utility.set_location('sg Payroll action ='||g_archive_pact,34);
2355: hr_utility.set_location('sg cess action ='||l_last_cess_action,35);
2356:
2357: IF l_last_cess_action IS NOT NULL THEN
2358: hr_nonrun_asact.insint(
2359: lockingactid => l_actid
2360: , lockedactid => l_last_cess_action);
2361: END IF;
2362: