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
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,
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,
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,
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;
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:
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
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');