436: -- insert the new assignment action
437: SELECT pay_assignment_actions_s.nextval
438: INTO l_actid
439: FROM dual;
440: hr_nonrun_asact.insact( l_actid
441: , rec_assact.assignment_id
442: , p_payroll_action_id
443: , p_chunk
444: , rec_assact.establishment_id);
442: , p_payroll_action_id
443: , p_chunk
444: , rec_assact.establishment_id);
445: -- insert the lock on the run/arch action.
446: hr_nonrun_asact.insint(l_actid
447: , rec_assact.assignment_action_id);
448: end if; -- l_create_act
449: END LOOP;
450:
570: FOR child IN csr_run_child LOOP
571: --
572: l_child := true;
573: l_grand_child :=false;
574: hr_nonrun_asact.insact(lockingactid => child.new_ass_act_id
575: ,assignid => child.assignment_id
576: ,pactid => g_payroll_action_id
577: ,chunk => child.chunk_number
578: ,greid => child.tax_unit_id
579: ,source_act => p_assignment_action_id);
580: --
581: -- insert the lock on the run action.
582: --
583: hr_nonrun_asact.insint(child.new_ass_act_id,child.assignment_action_id);
584:
585: --Create grand child archive assignment action records
586: FOR grand_child IN csr_grand_child (child.assignment_action_id)
587: LOOP
585: --Create grand child archive assignment action records
586: FOR grand_child IN csr_grand_child (child.assignment_action_id)
587: LOOP
588: l_grand_child :=true;
589: hr_nonrun_asact.insact(lockingactid => grand_child.new_ass_act_id
590: ,assignid => child.assignment_id
591: ,pactid => g_payroll_action_id
592: ,chunk => child.chunk_number
593: ,greid => grand_child.tax_unit_id
595: --
596: -- insert the lock on the run action.
597: --
598:
599: hr_nonrun_asact.insint(grand_child.new_ass_act_id,
600: grand_child.assignment_action_id);
601:
602: open csr_locking_reversal (grand_child.assignment_action_id);
603: fetch csr_locking_reversal into l_num;