APPS.EAM_ASSIGN_WORK_PVT dependencies on WIP_EAM_WORK_REQUESTS

Line 66: from wip_eam_work_requests

62: --checking if the work request is not assigned to another work order
63: --if it is assigned then error out
64:
65: select wip_entity_id into temp
66: from wip_eam_work_requests
67: where work_request_id = p_req_id
68: and organization_id = l_organization_id;
69:
70: if (temp is null) then

Line 71: Update wip_eam_work_requests

67: where work_request_id = p_req_id
68: and organization_id = l_organization_id;
69:
70: if (temp is null) then
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

Line 266: update wip_eam_work_requests

262:
263: if (p_req_type=1) then --work request
264:
265:
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