169: -- This cursor checks is there any process which is still running.
170:
171: CURSOR csr_chk_dp_child_proc_status (p_request_id number) IS
172: SELECT 1
173: FROM fnd_concurrent_requests
174: WHERE parent_request_id = p_request_id
175: AND phase_code <> 'C';
176:
177: -- get info of all the data pump processes which failed.
176:
177: -- get info of all the data pump processes which failed.
178: CURSOR csr_failed_dp_child_proc (p_request_id number) IS
179: SELECT request_id
180: FROM fnd_concurrent_requests
181: WHERE (parent_request_id = p_request_id OR
182: request_id = p_request_id)
183: AND status_code <> 'C';
184: