APPS.EAM_MATERIAL_VALIDATE_PUB dependencies on EAM_WORK_ORDER_DETAILS

Line 247: UPDATE eam_work_order_details

243: END IF;
244: IF (p_materials_csr.open_quantity > x_att ) THEN
245: -- The update statement will be replaced by call to Work Order API
246: -- Waiting for necessary changed in Work Order API to be done
247: UPDATE eam_work_order_details
248: SET material_shortage_flag = 1,
249: material_shortage_check_date = sysdate,
250: last_update_date = sysdate,
251: last_updated_by = fnd_global.user_id,

Line 295: UPDATE eam_work_order_details

291: IF (p_direct_items_csr.open_quantity > 0 ) THEN
292:
293: -- The update statement will be replaced by call to Work Order API
294: -- Waiting for necessary changed in Work Order API to be done
295: UPDATE eam_work_order_details
296: SET material_shortage_flag = 1,
297: material_shortage_check_date = sysdate,
298: last_update_date = sysdate,
299: last_updated_by = fnd_global.user_id,

Line 342: UPDATE eam_work_order_details

338: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_asset_number || '');
339: fnd_file.put_line(FND_FILE.OUTPUT, '' || l_yes_no||'' );
340: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
341:
342: UPDATE eam_work_order_details
343: SET material_shortage_flag = 2,
344: material_shortage_check_date = sysdate,
345: last_update_date = sysdate,
346: last_updated_by = fnd_global.user_id,

Line 370: UPDATE eam_work_order_details

366: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || x_msg_data || '');
367: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
368: END IF;
369: x_shortage_exists := 'E';
370: UPDATE eam_work_order_details
371: SET material_shortage_flag = null,
372: material_shortage_check_date = sysdate,
373: last_update_date = sysdate,
374: last_updated_by = fnd_global.user_id,

Line 394: UPDATE eam_work_order_details

390: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || x_msg_data || '');
391: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
392: END IF;
393: x_shortage_exists := 'E';
394: UPDATE eam_work_order_details
395: SET material_shortage_flag = null,
396: material_shortage_check_date = sysdate,
397: last_update_date = sysdate,
398: last_updated_by = fnd_global.user_id,

Line 423: UPDATE eam_work_order_details

419: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || x_msg_data || '');
420: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
421: END IF;
422: x_shortage_exists := 'E';
423: UPDATE eam_work_order_details
424: SET material_shortage_flag = null,
425: material_shortage_check_date = sysdate,
426: last_update_date = sysdate,
427: last_updated_by = fnd_global.user_id,