40: p_intra_txn_conflict_flag ,
41: p_processed_flag ,
42: p_self_conflict_flag ,
43: sysdate ,
44: fnd_global.user_id ,
45: sysdate ,
46: fnd_global.user_id ,
47: fnd_global.login_id );
48:
42: p_self_conflict_flag ,
43: sysdate ,
44: fnd_global.user_id ,
45: sysdate ,
46: fnd_global.user_id ,
47: fnd_global.login_id );
48:
49: x_return_status := FND_API.G_RET_STS_SUCCESS;
50: EXCEPTION
43: sysdate ,
44: fnd_global.user_id ,
45: sysdate ,
46: fnd_global.user_id ,
47: fnd_global.login_id );
48:
49: x_return_status := FND_API.G_RET_STS_SUCCESS;
50: EXCEPTION
51: WHEN OTHERS THEN
108: 'N' ,
109: p_processed_flag ,
110: decode((p_assignment_id - p_conflict_assignment_id_tbl(j)), 0, 'Y', 'N'),
111: sysdate ,
112: fnd_global.user_id ,
113: sysdate ,
114: fnd_global.user_id ,
115: fnd_global.login_id );
116:
110: decode((p_assignment_id - p_conflict_assignment_id_tbl(j)), 0, 'Y', 'N'),
111: sysdate ,
112: fnd_global.user_id ,
113: sysdate ,
114: fnd_global.user_id ,
115: fnd_global.login_id );
116:
117: ELSE
118: FORALL j IN p_conflict_assignment_id_tbl.FIRST .. p_conflict_assignment_id_tbl.LAST
111: sysdate ,
112: fnd_global.user_id ,
113: sysdate ,
114: fnd_global.user_id ,
115: fnd_global.login_id );
116:
117: ELSE
118: FORALL j IN p_conflict_assignment_id_tbl.FIRST .. p_conflict_assignment_id_tbl.LAST
119: INSERT INTO pa_assignment_conflict_hist
137: p_intra_txn_conflict_flag_tbl(j) ,
138: p_processed_flag ,
139: decode((p_assignment_id - p_conflict_assignment_id_tbl(j)), 0, 'Y', 'N'),
140: sysdate ,
141: fnd_global.user_id ,
142: sysdate ,
143: fnd_global.user_id ,
144: fnd_global.login_id );
145:
139: decode((p_assignment_id - p_conflict_assignment_id_tbl(j)), 0, 'Y', 'N'),
140: sysdate ,
141: fnd_global.user_id ,
142: sysdate ,
143: fnd_global.user_id ,
144: fnd_global.login_id );
145:
146: END IF;
147: END IF;
140: sysdate ,
141: fnd_global.user_id ,
142: sysdate ,
143: fnd_global.user_id ,
144: fnd_global.login_id );
145:
146: END IF;
147: END IF;
148:
178: UPDATE PA_ASSIGNMENT_CONFLICT_HIST
179: SET
180: resolve_conflicts_action_code = p_resolve_conflict_action_code,
181: last_update_date = sysdate,
182: last_updated_by = fnd_global.user_id,
183: last_update_login = fnd_global.login_id
184: WHERE conflict_group_id = p_conflict_group_id
185: AND assignment_id = p_assignment_id
186: AND conflict_assignment_id = p_conflict_assignment_id;
179: SET
180: resolve_conflicts_action_code = p_resolve_conflict_action_code,
181: last_update_date = sysdate,
182: last_updated_by = fnd_global.user_id,
183: last_update_login = fnd_global.login_id
184: WHERE conflict_group_id = p_conflict_group_id
185: AND assignment_id = p_assignment_id
186: AND conflict_assignment_id = p_conflict_assignment_id;
187:
216: UPDATE PA_ASSIGNMENT_CONFLICT_HIST
217: SET
218: resolve_conflicts_action_code = p_resolve_conflict_action_code,
219: last_update_date = sysdate,
220: last_updated_by = fnd_global.user_id,
221: last_update_login = fnd_global.login_id
222: WHERE conflict_group_id = p_conflict_group_id;
223:
224: x_return_status := FND_API.G_RET_STS_SUCCESS;
217: SET
218: resolve_conflicts_action_code = p_resolve_conflict_action_code,
219: last_update_date = sysdate,
220: last_updated_by = fnd_global.user_id,
221: last_update_login = fnd_global.login_id
222: WHERE conflict_group_id = p_conflict_group_id;
223:
224: x_return_status := FND_API.G_RET_STS_SUCCESS;
225:
255: UPDATE pa_assignment_conflict_hist
256: SET
257: resolve_conflicts_action_code = p_action_code_arr(j),
258: last_update_date = sysdate,
259: last_updated_by = fnd_global.user_id,
260: last_update_login = fnd_global.login_id
261: WHERE conflict_group_id = p_conflict_group_id
262: AND assignment_id = p_assignment_id_arr(j);
263:
256: SET
257: resolve_conflicts_action_code = p_action_code_arr(j),
258: last_update_date = sysdate,
259: last_updated_by = fnd_global.user_id,
260: last_update_login = fnd_global.login_id
261: WHERE conflict_group_id = p_conflict_group_id
262: AND assignment_id = p_assignment_id_arr(j);
263:
264: END IF;
295: UPDATE PA_ASSIGNMENT_CONFLICT_HIST
296: SET
297: processed_flag = p_processed_flag,
298: last_update_date = sysdate,
299: last_updated_by = fnd_global.user_id,
300: last_update_login = fnd_global.login_id
301: WHERE conflict_group_id = p_conflict_group_id
302: AND assignment_id = p_assignment_id;
303:
296: SET
297: processed_flag = p_processed_flag,
298: last_update_date = sysdate,
299: last_updated_by = fnd_global.user_id,
300: last_update_login = fnd_global.login_id
301: WHERE conflict_group_id = p_conflict_group_id
302: AND assignment_id = p_assignment_id;
303:
304: x_return_status := FND_API.G_RET_STS_SUCCESS;