APPS.EAM_MATERIAL_VALIDATE_PUB dependencies on EAM_WORK_ORDER_DETAILS

Line 253: UPDATE eam_work_order_details

249: END IF;
250: IF (p_materials_csr.open_quantity > x_att ) THEN
251: -- The update statement will be replaced by call to Work Order API
252: -- Waiting for necessary changed in Work Order API to be done
253: UPDATE eam_work_order_details
254: SET material_shortage_flag = 1,
255: material_shortage_check_date = sysdate,
256: last_update_date = sysdate,
257: last_updated_by = fnd_global.user_id,

Line 301: UPDATE eam_work_order_details

297: IF (p_direct_items_csr.open_quantity > 0 ) THEN
298:
299: -- The update statement will be replaced by call to Work Order API
300: -- Waiting for necessary changed in Work Order API to be done
301: UPDATE eam_work_order_details
302: SET material_shortage_flag = 1,
303: material_shortage_check_date = sysdate,
304: last_update_date = sysdate,
305: last_updated_by = fnd_global.user_id,

Line 349: UPDATE eam_work_order_details

345: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_asset_number || '');
346: fnd_file.put_line(FND_FILE.OUTPUT, '' || l_yes_no||'' );
347: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
348: END IF;
349: UPDATE eam_work_order_details
350: SET material_shortage_flag = 2,
351: material_shortage_check_date = sysdate,
352: last_update_date = sysdate,
353: last_updated_by = fnd_global.user_id,

Line 377: UPDATE eam_work_order_details

373: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || x_msg_data || '');
374: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
375: END IF;
376: x_shortage_exists := 'E';
377: UPDATE eam_work_order_details
378: SET material_shortage_flag = null,
379: material_shortage_check_date = sysdate,
380: last_update_date = sysdate,
381: last_updated_by = fnd_global.user_id,

Line 401: UPDATE eam_work_order_details

397: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || x_msg_data || '');
398: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
399: END IF;
400: x_shortage_exists := 'E';
401: UPDATE eam_work_order_details
402: SET material_shortage_flag = null,
403: material_shortage_check_date = sysdate,
404: last_update_date = sysdate,
405: last_updated_by = fnd_global.user_id,

Line 430: UPDATE eam_work_order_details

426: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || x_msg_data || '');
427: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
428: END IF;
429: x_shortage_exists := 'E';
430: UPDATE eam_work_order_details
431: SET material_shortage_flag = null,
432: material_shortage_check_date = sysdate,
433: last_update_date = sysdate,
434: last_updated_by = fnd_global.user_id,