DBA Data[Home] [Help]

APPS.EAM_ASSIGN_WORK_PVT dependencies on FND_GLOBAL

Line 75: last_updated_by = FND_GLOBAL.user_id

71: Update wip_eam_work_requests
72: set wip_entity_id = p_wip_entity_id,
73: work_request_status_id = decode(l_status_type,4,6,5,6,4) ,
74: last_update_date = sysdate,
75: last_updated_by = FND_GLOBAL.user_id
76: where work_request_id = p_req_id
77: and organization_id = l_organization_id;
78:
79: end if;--for if (temp is not null) then

Line 133: FND_GLOBAL.USER_ID,

129: l_organization_id,
130: p_wip_entity_id,
131: p_req_id,
132: sysdate,
133: FND_GLOBAL.USER_ID,
134: FND_GLOBAL.LOGIN_ID,
135: null,--fnd_global.conc_program_id,
136: null,
137: null,

Line 134: FND_GLOBAL.LOGIN_ID,

130: p_wip_entity_id,
131: p_req_id,
132: sysdate,
133: FND_GLOBAL.USER_ID,
134: FND_GLOBAL.LOGIN_ID,
135: null,--fnd_global.conc_program_id,
136: null,
137: null,
138: null,

Line 135: null,--fnd_global.conc_program_id,

131: p_req_id,
132: sysdate,
133: FND_GLOBAL.USER_ID,
134: FND_GLOBAL.LOGIN_ID,
135: null,--fnd_global.conc_program_id,
136: null,
137: null,
138: null,
139: null,

Line 152: fnd_global.user_id,

148: null,
149: null,
150: null,
151: null,
152: fnd_global.user_id,
153: sysdate,
154: 'Y'); -- Fix for 3773450
155: end if;
156: End if;

Line 270: last_updated_by = FND_GLOBAL.user_id

266: update wip_eam_work_requests
267: set wip_entity_id = null,
268: work_request_status_id = 3,
269: last_update_date = sysdate,
270: last_updated_by = FND_GLOBAL.user_id
271: where work_request_id = p_req_id
272: and organization_id = l_organization_id;
273: end if;
274:

Line 282: last_updated_by = FND_GLOBAL.user_id,

278: if (p_req_id is not null) then
279: update eam_wo_service_association -- Fix for 3773450
280: set enable_flag = 'N',
281: last_update_date = sysdate,
282: last_updated_by = FND_GLOBAL.user_id,
283: last_update_login = FND_GLOBAL.login_id
284: where service_request_id = p_req_id
285: and wip_entity_id = p_wip_entity_id
286: and maintenance_organization_id = l_organization_id

Line 283: last_update_login = FND_GLOBAL.login_id

279: update eam_wo_service_association -- Fix for 3773450
280: set enable_flag = 'N',
281: last_update_date = sysdate,
282: last_updated_by = FND_GLOBAL.user_id,
283: last_update_login = FND_GLOBAL.login_id
284: where service_request_id = p_req_id
285: and wip_entity_id = p_wip_entity_id
286: and maintenance_organization_id = l_organization_id
287: and (enable_flag IS NULL or enable_flag = 'Y');