[Home] [Help]
1095: CLOSE csr_exclusion;
1096:
1097: IF l_flag_exclusion <> 'Y' then
1098: IF l_flag_action_type not in ('I','B','V') then
1099: SELECT pay_assignment_actions_s.NEXTVAL
1100: INTO l_actid
1101: FROM DUAL;
1102:
1103: hr_utility.set_location('INSIDE IF',18);
1121: FETCH csr_exclusion into l_flag_exclusion, l_flag_action_type;
1122: CLOSE csr_exclusion;
1123:
1124: IF l_flag_exclusion <> 'Y' then
1125: SELECT pay_assignment_actions_s.NEXTVAL
1126: INTO l_actid
1127: FROM DUAL;
1128: hr_utility.set_location('INSIDE ELSE',18);
1129: hr_utility.set_location('Insert asg actions asg_id '||to_char(csr_select_asg_rec.assignment_id),18);
4120: action. The need for having child assignment action for
4121: retry of pay_payroll action.
4122: */
4123: hr_utility.set_location('Inside Else ..',2002);
4124: SELECT pay_assignment_actions_s.NEXTVAL
4125: INTO l_actid
4126: FROM DUAL;
4127: OPEN get_assignment_id;
4128: FETCH get_assignment_id into v_payroll_action_id,v_assignment_id,v_chunk;
4421: hr_utility.set_location('Before Update',1009);
4422: /* update assignment actions */
4423:
4424: IF v_assignment_id <> l_max_assignment_id THEN
4425: UPDATE pay_assignment_actions SET assignment_id = l_max_assignment_id
4426: WHERE assignment_action_id = p_assactid
4427: AND payroll_action_id= v_payroll_action_id;
4428:
4429: UPDATE pay_assignment_actions SET assignment_id = l_max_assignment_id
4425: UPDATE pay_assignment_actions SET assignment_id = l_max_assignment_id
4426: WHERE assignment_action_id = p_assactid
4427: AND payroll_action_id= v_payroll_action_id;
4428:
4429: UPDATE pay_assignment_actions SET assignment_id = l_max_assignment_id
4430: WHERE source_action_id = p_assactid
4431: AND payroll_action_id = v_payroll_action_id;
4432: END IF;
4433: