DBA Data[Home] [Help]

APPS.EAM_MATERIAL_VALIDATE_PUB dependencies on FND_GLOBAL

Line 251: last_updated_by = fnd_global.user_id,

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:

Line 252: last_update_login = fnd_global.login_id

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

Line 299: last_updated_by = fnd_global.user_id,

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:

Line 300: last_update_login = fnd_global.login_id

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

Line 346: last_updated_by = fnd_global.user_id,

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:

Line 347: last_update_login = fnd_global.login_id

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

Line 374: last_updated_by = fnd_global.user_id,

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;

Line 375: last_update_login = fnd_global.login_id

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;

Line 398: last_updated_by = fnd_global.user_id,

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;

Line 399: last_update_login = fnd_global.login_id

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;

Line 427: last_updated_by = fnd_global.user_id,

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;

Line 428: last_update_login = fnd_global.login_id

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;