APPS.EDW_OWB_COLLECTION_UTIL dependencies on DBMS_LOCK

Line 7747: DBMS_LOCK.SLEEP(p_sleep_time);

7743: l_job_status(i):='Y';
7744: end loop;
7745: loop
7746: l_found:=false;
7747: DBMS_LOCK.SLEEP(p_sleep_time);
7748: for i in 1..p_number_jobs loop
7749: if l_job_status(i)='Y' then
7750: if p_thread_type='JOB' then
7751: l_status:=check_job_status(p_job_id(i));