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,
252: last_update_login = fnd_global.login_id
253: WHERE wip_entity_id = p_wip_entity_id;
254: x_shortage_exists := 'Y';
255:
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,
252: last_update_login = fnd_global.login_id
253: WHERE wip_entity_id = p_wip_entity_id;
254: x_shortage_exists := 'Y';
255:
256: IF (p_source_api = 'Concurrent') THEN
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,
300: last_update_login = fnd_global.login_id
301: WHERE wip_entity_id = p_wip_entity_id;
302: x_shortage_exists := 'Y';
303:
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,
300: last_update_login = fnd_global.login_id
301: WHERE wip_entity_id = p_wip_entity_id;
302: x_shortage_exists := 'Y';
303:
304: IF (p_source_api = 'Concurrent') THEN
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,
347: last_update_login = fnd_global.login_id
348: WHERE wip_entity_id = p_wip_entity_id;
349: END IF;
350:
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,
347: last_update_login = fnd_global.login_id
348: WHERE wip_entity_id = p_wip_entity_id;
349: END IF;
350:
351: IF FND_API.To_Boolean( p_commit ) THEN
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,
375: last_update_login = fnd_global.login_id
376: WHERE wip_entity_id = p_wip_entity_id;
377: IF FND_API.To_Boolean( p_commit ) THEN
378: COMMIT;
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,
375: last_update_login = fnd_global.login_id
376: WHERE wip_entity_id = p_wip_entity_id;
377: IF FND_API.To_Boolean( p_commit ) THEN
378: COMMIT;
379: END IF;
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,
399: last_update_login = fnd_global.login_id
400: WHERE wip_entity_id = p_wip_entity_id;
401: IF FND_API.To_Boolean( p_commit ) THEN
402: COMMIT;
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,
399: last_update_login = fnd_global.login_id
400: WHERE wip_entity_id = p_wip_entity_id;
401: IF FND_API.To_Boolean( p_commit ) THEN
402: COMMIT;
403: END IF;
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,
428: last_update_login = fnd_global.login_id
429: WHERE wip_entity_id = p_wip_entity_id;
430: IF FND_API.To_Boolean( p_commit ) THEN
431: COMMIT;
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,
428: last_update_login = fnd_global.login_id
429: WHERE wip_entity_id = p_wip_entity_id;
430: IF FND_API.To_Boolean( p_commit ) THEN
431: COMMIT;
432: END IF;