481: procedure SLEEP (p_time_in_seconds in number) is
482:
483: begin
484:
485: DBMS_LOCK.SLEEP(p_time_in_seconds);
486:
487: end SLEEP;
488:
489: -- ----------------------------------------------------------
44928: /* Sleep till further worker are available to submit next batch */
44929: loop
44930: exit when l_run_count < l_parallel_proc;
44931:
44932: DBMS_LOCK.SLEEP(l_time_in_seconds);
44933:
44934: UPDATE_BATCH_CONC_STATUS_420;
44935:
44936: select count(*) into l_run_count
44948: /* Wait for all Helpers to complete */
44949: loop
44950: exit when l_run_count = 0;
44951:
44952: DBMS_LOCK.SLEEP(l_time_in_seconds);
44953:
44954: UPDATE_BATCH_CONC_STATUS_420;
44955:
44956: select count(*) into l_run_count