DBA Data[Home] [Help]

APPS.EAM_REQUEST_UTILITY_PVT dependencies on FND_GLOBAL

Line 36: last_updated_by = FND_GLOBAL.user_id,

32: SET
33: wip_entity_id = p_eam_request_rec.wip_entity_id,
34: work_request_status_id = 4,
35: last_update_date = sysdate,
36: last_updated_by = FND_GLOBAL.user_id,
37: last_update_login = fnd_global.login_id
38: WHERE work_request_id = p_eam_request_rec.request_id
39: AND organization_id = p_eam_request_rec.organization_id;
40:

Line 37: last_update_login = fnd_global.login_id

33: wip_entity_id = p_eam_request_rec.wip_entity_id,
34: work_request_status_id = 4,
35: last_update_date = sysdate,
36: last_updated_by = FND_GLOBAL.user_id,
37: last_update_login = fnd_global.login_id
38: WHERE work_request_id = p_eam_request_rec.request_id
39: AND organization_id = p_eam_request_rec.organization_id;
40:
41: END IF;

Line 79: FND_GLOBAL.USER_ID,

75: p_eam_request_rec.organization_id,
76: p_eam_request_rec.wip_entity_id,
77: p_eam_request_rec.request_id,
78: sysdate,
79: FND_GLOBAL.USER_ID,
80: FND_GLOBAL.LOGIN_ID,
81: null,--fnd_global.conc_program_id,
82: null,
83: null,

Line 80: FND_GLOBAL.LOGIN_ID,

76: p_eam_request_rec.wip_entity_id,
77: p_eam_request_rec.request_id,
78: sysdate,
79: FND_GLOBAL.USER_ID,
80: FND_GLOBAL.LOGIN_ID,
81: null,--fnd_global.conc_program_id,
82: null,
83: null,
84: null,

Line 81: null,--fnd_global.conc_program_id,

77: p_eam_request_rec.request_id,
78: sysdate,
79: FND_GLOBAL.USER_ID,
80: FND_GLOBAL.LOGIN_ID,
81: null,--fnd_global.conc_program_id,
82: null,
83: null,
84: null,
85: null,

Line 98: fnd_global.user_id,

94: null,
95: null,
96: null,
97: null,
98: fnd_global.user_id,
99: sysdate,
100: 'Y'); -- Fix for 3773450
101: END IF;
102:

Line 119: last_updated_by = FND_GLOBAL.user_id

115: UPDATE WIP_EAM_WORK_REQUESTS
116: SET wip_entity_id = null,
117: work_request_status_id = 3,
118: last_update_date = sysdate,
119: last_updated_by = FND_GLOBAL.user_id
120: WHERE work_request_id = p_eam_request_rec.request_id
121: AND organization_id = p_eam_request_rec.organization_id;
122: END IF;
123:

Line 129: last_updated_by = FND_GLOBAL.user_id,

125:
126: UPDATE EAM_WO_SERVICE_ASSOCIATION -- Fix for 3773450
127: SET enable_flag = 'N',
128: last_update_date = sysdate,
129: last_updated_by = FND_GLOBAL.user_id,
130: last_update_login = FND_GLOBAL.login_id
131: WHERE service_request_id = p_eam_request_rec.request_id
132: AND wip_entity_id = p_eam_request_rec.wip_entity_id
133: AND maintenance_organization_id = p_eam_request_rec.organization_id

Line 130: last_update_login = FND_GLOBAL.login_id

126: UPDATE EAM_WO_SERVICE_ASSOCIATION -- Fix for 3773450
127: SET enable_flag = 'N',
128: last_update_date = sysdate,
129: last_updated_by = FND_GLOBAL.user_id,
130: last_update_login = FND_GLOBAL.login_id
131: WHERE service_request_id = p_eam_request_rec.request_id
132: AND wip_entity_id = p_eam_request_rec.wip_entity_id
133: AND maintenance_organization_id = p_eam_request_rec.organization_id
134: AND (enable_flag IS NULL or enable_flag = 'Y');