APPS.EAM_WORKORDERS_JSP dependencies on WIP_EAM_WORK_REQUESTS

Line 1400: from wip_eam_work_requests r

1396: elsif (p_work_request_number is not null) then
1397: l_work_request_number := p_work_request_number;
1398: select count(*), avg(r.work_request_id)
1399: into l_count, l_work_request_id
1400: from wip_eam_work_requests r
1401: where r.work_request_number = p_work_request_number;
1402:
1403: -- unique
1404: if(l_count > 1) then

Line 1417: from wip_eam_work_requests r

1413: -- check request status
1414: if( x_return_status = FND_API.G_RET_STS_SUCCESS and l_work_request_id is not null) then
1415: select r.work_request_number, r.wip_entity_id, r.work_request_status_id
1416: into l_work_request_number, l_work_request_wip_entity_id, l_work_request_status
1417: from wip_eam_work_requests r
1418: where r.work_request_id = l_work_request_id for update;
1419:
1420: if(l_work_request_number <> p_work_request_number) then
1421: -- should not happen

Line 2089: update wip_eam_work_requests r

2085: else
2086: if(p_request_type=1) then
2087: -- update work request if exist
2088: if( l_work_request_id is not null) then
2089: update wip_eam_work_requests r
2090: set r.work_request_status_id = 4
2091: , r.wip_entity_id = l_workorder_rec1.wip_entity_id
2092: , r.last_update_date = sysdate
2093: , r.last_updated_by = FND_GLOBAL.user_id

Line 2390: update wip_eam_work_requests r

2386: else
2387: if(p_request_type=1) then
2388: -- update work request if exist
2389: if( l_work_request_id is not null) then
2390: update wip_eam_work_requests r
2391: set r.work_request_status_id = 4
2392: , r.wip_entity_id = l_workorder_rec1.wip_entity_id
2393: , r.last_update_date = sysdate
2394: , r.last_updated_by = FND_GLOBAL.user_id