DBA Data[Home] [Help]

APPS.WSH_SHIP_CONFIRM_ACTIONS dependencies on FND_CONCURRENT_REQUESTS

Line 2649: FROM fnd_concurrent_requests fcr

2645: wts.last_updated_by = fnd_global.user_id,
2646: wts.last_update_date = sysdate
2647: WHERE wts.pending_interface_flag = 'P'
2648: AND EXISTS (SELECT 'request completed'
2649: FROM fnd_concurrent_requests fcr
2650: WHERE fcr.request_id = wts.request_id
2651: AND fcr.phase_code = 'C');
2652: l_recs := sql%rowcount;
2653:

Line 10365: FROM FND_CONCURRENT_REQUESTS

10361:
10362:
10363: CURSOR c_requests (p_parent_request_id NUMBER) IS
10364: SELECT request_id
10365: FROM FND_CONCURRENT_REQUESTS
10366: WHERE parent_request_id = p_parent_request_id;
10367: e_invalid_number EXCEPTION;
10368:
10369: BEGIN