494: -- Sets all successfully processed assignment actions to 'C'omplete.
495: --
496: hr_utility.set_location('pay_mag_utils.update_action_status',2);
497: --
498: UPDATE pay_assignment_actions aa
499: SET aa.action_status = 'C'
500: WHERE aa.payroll_action_id = p_payroll_action_id
501: AND aa.action_status = 'U';
502: --
612: -- tax_unit_id updated yet.
613: --
614: CURSOR csr_assignment_action IS
615: SELECT aa.assignment_action_id
616: FROM pay_assignment_actions aa
617: WHERE aa.payroll_action_id = p_payroll_action_id
618: AND aa.assignment_id = p_assignment_id
619: AND aa.tax_unit_id IS NULL;
620: --
619: AND aa.tax_unit_id IS NULL;
620: --
621: -- Local variables.
622: --
623: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
624: --
625: BEGIN
626: --
627: hr_utility.set_location('pay_mag_utils.create_assignment_action',1);
641: OPEN csr_assignment_action;
642: FETCH csr_assignment_action INTO l_assignment_action_id;
643: CLOSE csr_assignment_action;
644: --
645: UPDATE pay_assignment_actions aa
646: SET aa.tax_unit_id = p_tax_unit_id
647: WHERE aa.assignment_action_id = l_assignment_action_id;
648: --
649: hr_utility.set_location('pay_mag_utils.create_assignment_action',3);