DBA Data[Home] [Help]

APPS.PJI_PROCESS_UTIL dependencies on DBMS_LOCK

Line 485: DBMS_LOCK.SLEEP(p_time_in_seconds);

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: -- ----------------------------------------------------------

Line 44932: DBMS_LOCK.SLEEP(l_time_in_seconds);

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

Line 44952: DBMS_LOCK.SLEEP(l_time_in_seconds);

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