1316: *******************************************************************/
1317:
1318: if ( ln_source_action_id <> prev_source_action_id ) then
1319:
1320: select pay_assignment_actions_s.nextval
1321: into ln_child_xfr_action_id
1322: from dual;
1323:
1324: hr_utility.set_location(gv_package || lv_procedure_name, 30);
1783:
1784: if ( ( ln_source_action_id <> prev_source_action_id ) or
1785: ( ln_tax_unit_id <> prev_tax_unit_id ) ) then
1786:
1787: select pay_assignment_actions_s.nextval
1788: into ln_child_xfr_action_id
1789: from dual;
1790:
1791: hr_utility.set_location(gv_package || lv_procedure_name, 30);
2037:
2038: hr_utility.trace('MG ln_pp_asg_act_id : ' || ln_pp_asg_act_id);
2039: hr_utility.trace('MG ln_tax_unit_id : ' || ln_tax_unit_id);
2040:
2041: select pay_assignment_actions_s.nextval
2042: into ln_child_xfr_action_id
2043: from dual;
2044:
2045: hr_utility.set_location(gv_package || lv_procedure_name, 30);
2344: end if;
2345:
2346: -- create child assignment action
2347: ln_step := 9;
2348: select pay_assignment_actions_s.nextval
2349: into ln_child_xfr_action_id
2350: from dual;
2351:
2352: hr_utility.set_location(gv_package || lv_procedure_name, 90);
3343: hr_utility.set_location(gv_package || lv_procedure_name, 60);
3344: hr_utility.trace('Action_type = '||lv_action_type );
3345:
3346: ln_step := 6;
3347: select pay_assignment_actions_s.nextval
3348: into ln_xfr_action_id
3349: from dual;
3350:
3351: -- insert into pay_assignment_actions.