DBA Data[Home] [Help]

APPS.CN_PAYMENT_WORKSHEET_PVT dependencies on DBMS_LOCK

Line 4273: dbms_lock.sleep(l_sleep_time);

4269: FROM fnd_concurrent_requests fcr
4270: WHERE fcr.parent_request_id = l_conc_request_id
4271: AND fcr.phase_code <> 'C';
4272: EXIT WHEN l_runner_count = 0;
4273: dbms_lock.sleep(l_sleep_time);
4274: END LOOP;
4275:
4276: FOR rs_errors IN (SELECT fcr.request_id,
4277: fcr.actual_completion_date,