DBA Data[Home] [Help]

APPS.WSH_SHIP_CONFIRM_ACTIONS dependencies on FND_CONCURRENT_REQUESTS

Line 2160: FROM fnd_concurrent_requests fcr

2156: wts.last_updated_by = fnd_global.user_id,
2157: wts.last_update_date = sysdate
2158: WHERE wts.pending_interface_flag = 'P'
2159: AND EXISTS (SELECT 'request completed'
2160: FROM fnd_concurrent_requests fcr
2161: WHERE fcr.request_id = wts.request_id
2162: AND fcr.phase_code = 'C');
2163: l_recs := sql%rowcount;
2164:

Line 8980: FROM FND_CONCURRENT_REQUESTS

8976:
8977:
8978: CURSOR c_requests (p_parent_request_id NUMBER) IS
8979: SELECT request_id
8980: FROM FND_CONCURRENT_REQUESTS
8981: WHERE parent_request_id = p_parent_request_id;
8982: e_invalid_number EXCEPTION;
8983:
8984: BEGIN