APPS.INV_TXN_PURGE_MAIN dependencies on FND_CONCURRENT_REQUESTS

Line 238: FROM fnd_concurrent_requests

234: l_req_id := l_reqstatus_tbl_type(idx);
235:
236: SELECT COUNT(*)
237: INTO l_count
238: FROM fnd_concurrent_requests
239: WHERE request_id = l_req_id
240: AND phase_code = 'C';
241:
242: IF l_count = 1 THEN

Line 261: FROM fnd_concurrent_requests

257: --Bug 3687369, need to print the errored status of the child requests in the log.
258:
259: FOR idx IN 1 .. l_reqstatus_tbl_type.COUNT LOOP
260: SELECT STATUS_CODE INTO l_status_code_tbl_type(idx)
261: FROM fnd_concurrent_requests
262: WHERE request_id = l_reqstatus_tbl_type(idx) AND phase_code = 'C';
263:
264: IF (l_status_code_tbl_type(idx) = 'E') then
265: l_status_code_tbl_type(idx) := 'error';