DBA Data[Home] [Help]

APPS.PA_ASGN_CONFLICT_HIST_PKG dependencies on FND_GLOBAL

Line 44: fnd_global.user_id ,

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:

Line 46: fnd_global.user_id ,

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

Line 47: fnd_global.login_id );

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

Line 112: fnd_global.user_id ,

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:

Line 114: fnd_global.user_id ,

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

Line 115: fnd_global.login_id );

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

Line 141: fnd_global.user_id ,

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:

Line 143: fnd_global.user_id ,

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;

Line 144: fnd_global.login_id );

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:

Line 182: last_updated_by = fnd_global.user_id,

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;

Line 183: last_update_login = fnd_global.login_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:

Line 220: last_updated_by = fnd_global.user_id,

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;

Line 221: last_update_login = fnd_global.login_id

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:

Line 259: last_updated_by = fnd_global.user_id,

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:

Line 260: last_update_login = fnd_global.login_id

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;

Line 299: last_updated_by = fnd_global.user_id,

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:

Line 300: last_update_login = fnd_global.login_id

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;