DBA Data[Home] [Help]

APPS.CN_PAYMENT_WORKSHEET_PVT dependencies on DBMS_LOCK

Line 4227: dbms_lock.sleep(l_sleep_time);

4223: FROM fnd_concurrent_requests fcr
4224: WHERE fcr.parent_request_id = l_conc_request_id
4225: AND fcr.phase_code <> 'C';
4226: EXIT WHEN l_runner_count = 0;
4227: dbms_lock.sleep(l_sleep_time);
4228: END LOOP;
4229:
4230: FOR rs_errors IN (SELECT fcr.request_id,
4231: fcr.actual_completion_date,