DBA Data[Home] [Help]

APPS.EAM_WO_IMPORT_DS_PVT dependencies on FND_GLOBAL

Line 62: last_updated_by = fnd_global.user_id,

58: -- Validate_Structure failed .Fail entire structure with status 3
59: UPDATE EAM_WORK_ORDER_IMPORT
60: SET process_status = 3,
61: last_update_date = sysdate,
62: last_updated_by = fnd_global.user_id,
63: last_update_login = fnd_global.login_id
64: WHERE group_id = p_group_id
65: AND wip_entity_id IN (SELECT wip_entity_id
66: FROM EAM_WORK_ORDER_IMPORT

Line 63: last_update_login = fnd_global.login_id

59: UPDATE EAM_WORK_ORDER_IMPORT
60: SET process_status = 3,
61: last_update_date = sysdate,
62: last_updated_by = fnd_global.user_id,
63: last_update_login = fnd_global.login_id
64: WHERE group_id = p_group_id
65: AND wip_entity_id IN (SELECT wip_entity_id
66: FROM EAM_WORK_ORDER_IMPORT
67: WHERE top_wip_entity_id= p_top_wip_entity_id);

Line 76: last_updated_by = fnd_global.user_id,

72: -- those work orders which in status 2
73: UPDATE EAM_WORK_ORDER_IMPORT
74: SET process_status = 3,
75: last_update_date = sysdate,
76: last_updated_by = fnd_global.user_id,
77: last_update_login = fnd_global.login_id
78: WHERE group_id = p_group_id
79: AND wip_entity_id in (SELECT wip_entity_id
80: FROM EAM_WORK_ORDER_IMPORT

Line 77: last_update_login = fnd_global.login_id

73: UPDATE EAM_WORK_ORDER_IMPORT
74: SET process_status = 3,
75: last_update_date = sysdate,
76: last_updated_by = fnd_global.user_id,
77: last_update_login = fnd_global.login_id
78: WHERE group_id = p_group_id
79: AND wip_entity_id in (SELECT wip_entity_id
80: FROM EAM_WORK_ORDER_IMPORT
81: WHERE top_wip_entity_id= p_top_wip_entity_id

Line 107: fnd_global.user_id,

103: p_group_id,
104: 1,
105: p_wo_relationship_exc_tbl(work_rel_counter),
106: sysdate,
107: fnd_global.user_id,
108: sysdate,
109: fnd_global.user_id,
110: fnd_global.login_id
111: );

Line 109: fnd_global.user_id,

105: p_wo_relationship_exc_tbl(work_rel_counter),
106: sysdate,
107: fnd_global.user_id,
108: sysdate,
109: fnd_global.user_id,
110: fnd_global.login_id
111: );
112: fnd_file.put_line(FND_FILE.LOG,p_wo_relationship_exc_tbl(work_rel_counter));
113: END LOOP;

Line 110: fnd_global.login_id

106: sysdate,
107: fnd_global.user_id,
108: sysdate,
109: fnd_global.user_id,
110: fnd_global.login_id
111: );
112: fnd_file.put_line(FND_FILE.LOG,p_wo_relationship_exc_tbl(work_rel_counter));
113: END LOOP;
114: END IF;

Line 195: last_updated_by = fnd_global.user_id,

191:
192: UPDATE EAM_WORK_ORDER_IMPORT
193: SET process_status = 4 ,
194: last_update_date = sysdate,
195: last_updated_by = fnd_global.user_id,
196: last_update_login = fnd_global.login_id
197: WHERE group_id = p_group_id
198: AND wip_entity_id = p_wo_rec.wip_entity_id;
199:

Line 196: last_update_login = fnd_global.login_id

192: UPDATE EAM_WORK_ORDER_IMPORT
193: SET process_status = 4 ,
194: last_update_date = sysdate,
195: last_updated_by = fnd_global.user_id,
196: last_update_login = fnd_global.login_id
197: WHERE group_id = p_group_id
198: AND wip_entity_id = p_wo_rec.wip_entity_id;
199:
200: -- get the error messages from the work order api exception stack and insert

Line 229: fnd_global.user_id,

225: p_wo_rec.group_id,
226: p_wo_rec.row_id,
227: temp_err_mesg,
228: sysdate,
229: fnd_global.user_id,
230: sysdate,
231: fnd_global.user_id,
232: fnd_global.login_id
233: );

Line 231: fnd_global.user_id,

227: temp_err_mesg,
228: sysdate,
229: fnd_global.user_id,
230: sysdate,
231: fnd_global.user_id,
232: fnd_global.login_id
233: );
234:
235: END LOOP;

Line 232: fnd_global.login_id

228: sysdate,
229: fnd_global.user_id,
230: sysdate,
231: fnd_global.user_id,
232: fnd_global.login_id
233: );
234:
235: END LOOP;
236: END IF; -- end if for l_msg_count>0

Line 248: last_updated_by = fnd_global.user_id,

244: FOR counter_res_ins IN 1..p_eam_res_inst_tbl.count LOOP
245: UPDATE EAM_RESOURCE_INSTANCE_IMPORT
246: SET return_status = p_eam_res_inst_tbl(counter_res_ins).return_status,
247: last_update_date = sysdate,
248: last_updated_by = fnd_global.user_id,
249: last_update_login = fnd_global.login_id
250: WHERE group_id = p_group_id
251: AND wip_entity_id = p_eam_res_inst_tbl(counter_res_ins).wip_entity_id
252: AND (instance_id = p_eam_res_inst_tbl(counter_res_ins).instance_id OR instance_id IS NULL)

Line 249: last_update_login = fnd_global.login_id

245: UPDATE EAM_RESOURCE_INSTANCE_IMPORT
246: SET return_status = p_eam_res_inst_tbl(counter_res_ins).return_status,
247: last_update_date = sysdate,
248: last_updated_by = fnd_global.user_id,
249: last_update_login = fnd_global.login_id
250: WHERE group_id = p_group_id
251: AND wip_entity_id = p_eam_res_inst_tbl(counter_res_ins).wip_entity_id
252: AND (instance_id = p_eam_res_inst_tbl(counter_res_ins).instance_id OR instance_id IS NULL)
253: AND (serial_number = p_eam_res_inst_tbl(counter_res_ins).serial_number OR serial_number IS NULL);

Line 260: last_updated_by = fnd_global.user_id,

256: FOR counter_res_usg IN 1..p_eam_res_usage_tbl.count LOOP
257: UPDATE EAM_RESOURCE_USAGE_IMPORT
258: SET return_status = p_eam_res_usage_tbl(counter_res_usg).return_status,
259: last_update_date = sysdate,
260: last_updated_by = fnd_global.user_id,
261: last_update_login = fnd_global.login_id
262: WHERE group_id = p_group_id
263: AND wip_entity_id = p_eam_res_usage_tbl(counter_res_usg).wip_entity_id
264: AND resource_seq_num = p_eam_res_usage_tbl(counter_res_usg).resource_seq_num;

Line 261: last_update_login = fnd_global.login_id

257: UPDATE EAM_RESOURCE_USAGE_IMPORT
258: SET return_status = p_eam_res_usage_tbl(counter_res_usg).return_status,
259: last_update_date = sysdate,
260: last_updated_by = fnd_global.user_id,
261: last_update_login = fnd_global.login_id
262: WHERE group_id = p_group_id
263: AND wip_entity_id = p_eam_res_usage_tbl(counter_res_usg).wip_entity_id
264: AND resource_seq_num = p_eam_res_usage_tbl(counter_res_usg).resource_seq_num;
265: END LOOP;

Line 271: last_updated_by = fnd_global.user_id,

267: FOR counter_res IN 1..p_eam_res_tbl.count LOOP
268: UPDATE EAM_RESOURCE_IMPORT
269: SET return_status = p_eam_res_tbl(counter_res).return_status,
270: last_update_date = sysdate,
271: last_updated_by = fnd_global.user_id,
272: last_update_login = fnd_global.login_id
273: WHERE group_id = p_group_id
274: AND wip_entity_id = p_eam_res_tbl(counter_res).wip_entity_id
275: AND resource_seq_num = p_eam_res_tbl(counter_res).resource_seq_num;

Line 272: last_update_login = fnd_global.login_id

268: UPDATE EAM_RESOURCE_IMPORT
269: SET return_status = p_eam_res_tbl(counter_res).return_status,
270: last_update_date = sysdate,
271: last_updated_by = fnd_global.user_id,
272: last_update_login = fnd_global.login_id
273: WHERE group_id = p_group_id
274: AND wip_entity_id = p_eam_res_tbl(counter_res).wip_entity_id
275: AND resource_seq_num = p_eam_res_tbl(counter_res).resource_seq_num;
276: END LOOP;

Line 282: last_updated_by = fnd_global.user_id,

278: FOR counter_mat IN 1..p_eam_mat_req_tbl.count LOOP
279: UPDATE EAM_MATERIAL_IMPORT
280: SET return_status = p_eam_mat_req_tbl(counter_mat).return_status,
281: last_update_date = sysdate,
282: last_updated_by = fnd_global.user_id,
283: last_update_login = fnd_global.login_id
284: WHERE group_id = p_group_id
285: AND wip_entity_id = p_eam_mat_req_tbl(counter_mat).wip_entity_id
286: AND inventory_item_id = p_eam_mat_req_tbl(counter_mat).inventory_item_id;

Line 283: last_update_login = fnd_global.login_id

279: UPDATE EAM_MATERIAL_IMPORT
280: SET return_status = p_eam_mat_req_tbl(counter_mat).return_status,
281: last_update_date = sysdate,
282: last_updated_by = fnd_global.user_id,
283: last_update_login = fnd_global.login_id
284: WHERE group_id = p_group_id
285: AND wip_entity_id = p_eam_mat_req_tbl(counter_mat).wip_entity_id
286: AND inventory_item_id = p_eam_mat_req_tbl(counter_mat).inventory_item_id;
287: END LOOP;

Line 293: last_updated_by = fnd_global.user_id,

289: FOR counter_op IN 1..p_eam_op_tbl.count LOOP
290: UPDATE EAM_OPERATION_IMPORT
291: SET return_status = p_eam_op_tbl(counter_op).return_status,
292: last_update_date = sysdate,
293: last_updated_by = fnd_global.user_id,
294: last_update_login = fnd_global.login_id
295: WHERE group_id = p_group_id
296: AND wip_entity_id = p_eam_op_tbl(counter_op).wip_entity_id
297: AND operation_seq_num = p_eam_op_tbl(counter_op).operation_seq_num;

Line 294: last_update_login = fnd_global.login_id

290: UPDATE EAM_OPERATION_IMPORT
291: SET return_status = p_eam_op_tbl(counter_op).return_status,
292: last_update_date = sysdate,
293: last_updated_by = fnd_global.user_id,
294: last_update_login = fnd_global.login_id
295: WHERE group_id = p_group_id
296: AND wip_entity_id = p_eam_op_tbl(counter_op).wip_entity_id
297: AND operation_seq_num = p_eam_op_tbl(counter_op).operation_seq_num;
298: END LOOP;

Line 303: last_updated_by = fnd_global.user_id,

299:
300: UPDATE EAM_WORK_ORDER_IMPORT
301: SET return_status = p_return_status,
302: last_update_date = sysdate,
303: last_updated_by = fnd_global.user_id,
304: last_update_login = fnd_global.login_id
305: WHERE group_id = p_group_id
306: AND wip_entity_id = p_wo_rec.wip_entity_id;
307: COMMIT;

Line 304: last_update_login = fnd_global.login_id

300: UPDATE EAM_WORK_ORDER_IMPORT
301: SET return_status = p_return_status,
302: last_update_date = sysdate,
303: last_updated_by = fnd_global.user_id,
304: last_update_login = fnd_global.login_id
305: WHERE group_id = p_group_id
306: AND wip_entity_id = p_wo_rec.wip_entity_id;
307: COMMIT;
308: END;