DBA Data[Home] [Help]

APPS.EAM_TEXT_UTIL dependencies on FND_GLOBAL

Line 664: , fnd_global.user_id

660: values (
661: p_instance_id
662: , l_text_ins
663: , SYSDATE
664: , fnd_global.user_id
665: , SYSDATE
666: , DECODE(p_last_updated_by, FND_API.G_MISS_NUM, fnd_global.user_id, p_last_updated_by)
667: , DECODE(p_last_update_login, FND_API.G_MISS_NUM, fnd_global.login_id, p_last_update_login));
668: END IF;

Line 666: , DECODE(p_last_updated_by, FND_API.G_MISS_NUM, fnd_global.user_id, p_last_updated_by)

662: , l_text_ins
663: , SYSDATE
664: , fnd_global.user_id
665: , SYSDATE
666: , DECODE(p_last_updated_by, FND_API.G_MISS_NUM, fnd_global.user_id, p_last_updated_by)
667: , DECODE(p_last_update_login, FND_API.G_MISS_NUM, fnd_global.login_id, p_last_update_login));
668: END IF;
669: ELSIF ( p_event = 'DELETE' ) THEN
670: DELETE FROM eam_asset_text

Line 667: , DECODE(p_last_update_login, FND_API.G_MISS_NUM, fnd_global.login_id, p_last_update_login));

663: , SYSDATE
664: , fnd_global.user_id
665: , SYSDATE
666: , DECODE(p_last_updated_by, FND_API.G_MISS_NUM, fnd_global.user_id, p_last_updated_by)
667: , DECODE(p_last_update_login, FND_API.G_MISS_NUM, fnd_global.login_id, p_last_update_login));
668: END IF;
669: ELSIF ( p_event = 'DELETE' ) THEN
670: DELETE FROM eam_asset_text
671: WHERE p_instance_id = p_instance_id;

Line 768: , last_updated_by = FND_GLOBAL.user_id

764: IF ( p_event = 'UPDATE' ) THEN
765: UPDATE eam_work_order_text
766: SET text = l_text_upd
767: , last_update_date = SYSDATE
768: , last_updated_by = FND_GLOBAL.user_id
769: , last_update_login = FND_GLOBAL.login_id
770: WHERE wip_entity_id = p_wip_entity_id;
771:
772: ELSIF ( p_event = 'INSERT' ) THEN

Line 769: , last_update_login = FND_GLOBAL.login_id

765: UPDATE eam_work_order_text
766: SET text = l_text_upd
767: , last_update_date = SYSDATE
768: , last_updated_by = FND_GLOBAL.user_id
769: , last_update_login = FND_GLOBAL.login_id
770: WHERE wip_entity_id = p_wip_entity_id;
771:
772: ELSIF ( p_event = 'INSERT' ) THEN
773: INSERT INTO eam_work_order_text

Line 790: FND_GLOBAL.user_id,

786: p_organization_id,
787: p_wip_entity_id,
788: l_text_ins,
789: SYSDATE,
790: FND_GLOBAL.user_id,
791: SYSDATE,
792: FND_GLOBAL.user_id,
793: FND_GLOBAL.login_id
794: );

Line 792: FND_GLOBAL.user_id,

788: l_text_ins,
789: SYSDATE,
790: FND_GLOBAL.user_id,
791: SYSDATE,
792: FND_GLOBAL.user_id,
793: FND_GLOBAL.login_id
794: );
795: END IF; -- p_event
796:

Line 793: FND_GLOBAL.login_id

789: SYSDATE,
790: FND_GLOBAL.user_id,
791: SYSDATE,
792: FND_GLOBAL.user_id,
793: FND_GLOBAL.login_id
794: );
795: END IF; -- p_event
796:
797: