DBA Data[Home] [Help]

APPS.EAM_MATERIAL_VALIDATE_PUB dependencies on FND_GLOBAL

Line 257: last_updated_by = fnd_global.user_id,

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,
258: last_update_login = fnd_global.login_id
259: WHERE wip_entity_id = p_wip_entity_id;
260: x_shortage_exists := 'Y';
261:

Line 258: last_update_login = fnd_global.login_id

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,
258: last_update_login = fnd_global.login_id
259: WHERE wip_entity_id = p_wip_entity_id;
260: x_shortage_exists := 'Y';
261:
262: IF (p_source_api = 'Concurrent') THEN

Line 305: last_updated_by = fnd_global.user_id,

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,
306: last_update_login = fnd_global.login_id
307: WHERE wip_entity_id = p_wip_entity_id;
308: x_shortage_exists := 'Y';
309:

Line 306: last_update_login = fnd_global.login_id

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,
306: last_update_login = fnd_global.login_id
307: WHERE wip_entity_id = p_wip_entity_id;
308: x_shortage_exists := 'Y';
309:
310: IF (p_source_api = 'Concurrent') THEN

Line 353: last_updated_by = fnd_global.user_id,

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,
354: last_update_login = fnd_global.login_id
355: WHERE wip_entity_id = p_wip_entity_id;
356: END IF;
357:

Line 354: last_update_login = fnd_global.login_id

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,
354: last_update_login = fnd_global.login_id
355: WHERE wip_entity_id = p_wip_entity_id;
356: END IF;
357:
358: IF FND_API.To_Boolean( p_commit ) THEN

Line 381: last_updated_by = fnd_global.user_id,

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,
382: last_update_login = fnd_global.login_id
383: WHERE wip_entity_id = p_wip_entity_id;
384: IF FND_API.To_Boolean( p_commit ) THEN
385: COMMIT;

Line 382: last_update_login = fnd_global.login_id

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,
382: last_update_login = fnd_global.login_id
383: WHERE wip_entity_id = p_wip_entity_id;
384: IF FND_API.To_Boolean( p_commit ) THEN
385: COMMIT;
386: END IF;

Line 405: last_updated_by = fnd_global.user_id,

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,
406: last_update_login = fnd_global.login_id
407: WHERE wip_entity_id = p_wip_entity_id;
408: IF FND_API.To_Boolean( p_commit ) THEN
409: COMMIT;

Line 406: last_update_login = fnd_global.login_id

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,
406: last_update_login = fnd_global.login_id
407: WHERE wip_entity_id = p_wip_entity_id;
408: IF FND_API.To_Boolean( p_commit ) THEN
409: COMMIT;
410: END IF;

Line 434: last_updated_by = fnd_global.user_id,

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,
435: last_update_login = fnd_global.login_id
436: WHERE wip_entity_id = p_wip_entity_id;
437: IF FND_API.To_Boolean( p_commit ) THEN
438: COMMIT;

Line 435: last_update_login = fnd_global.login_id

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,
435: last_update_login = fnd_global.login_id
436: WHERE wip_entity_id = p_wip_entity_id;
437: IF FND_API.To_Boolean( p_commit ) THEN
438: COMMIT;
439: END IF;