APPS.EAM_WORKORDERS_JSP dependencies on WIP_EAM_WORK_REQUESTS

Line 1369: from wip_eam_work_requests r

1365: elsif (p_work_request_number is not null) then
1366: l_work_request_number := p_work_request_number;
1367: select count(*), avg(r.work_request_id)
1368: into l_count, l_work_request_id
1369: from wip_eam_work_requests r
1370: where r.work_request_number = p_work_request_number;
1371:
1372: -- unique
1373: if(l_count > 1) then

Line 1386: from wip_eam_work_requests r

1382: -- check request status
1383: if( x_return_status = FND_API.G_RET_STS_SUCCESS and l_work_request_id is not null) then
1384: select r.work_request_number, r.wip_entity_id, r.work_request_status_id
1385: into l_work_request_number, l_work_request_wip_entity_id, l_work_request_status
1386: from wip_eam_work_requests r
1387: where r.work_request_id = l_work_request_id for update;
1388:
1389: if(l_work_request_number <> p_work_request_number) then
1390: -- should not happen

Line 2058: update wip_eam_work_requests r

2054: else
2055: if(p_request_type=1) then
2056: -- update work request if exist
2057: if( l_work_request_id is not null) then
2058: update wip_eam_work_requests r
2059: set r.work_request_status_id = 4
2060: , r.wip_entity_id = l_workorder_rec1.wip_entity_id
2061: , r.last_update_date = sysdate
2062: , r.last_updated_by = FND_GLOBAL.user_id

Line 2359: update wip_eam_work_requests r

2355: else
2356: if(p_request_type=1) then
2357: -- update work request if exist
2358: if( l_work_request_id is not null) then
2359: update wip_eam_work_requests r
2360: set r.work_request_status_id = 4
2361: , r.wip_entity_id = l_workorder_rec1.wip_entity_id
2362: , r.last_update_date = sysdate
2363: , r.last_updated_by = FND_GLOBAL.user_id