APPS.MSD_CL_LOADERS dependencies on DBMS_LOCK

Line 530: DBMS_LOCK.SLEEP( 5);

526: select (SYSDATE- START_TIME) into lv_process_time from dual;
527:
528: IF lv_process_time > p_timeout/1440.0 THEN Raise EX_PROCESS_TIME_OUT; END IF;
529:
530: DBMS_LOCK.SLEEP( 5);
531:
532: END IF;
533:
534: ELSE

Line 541: DBMS_LOCK.SLEEP( 5);

537: select (SYSDATE- START_TIME) into lv_process_time from dual;
538:
539: IF lv_process_time > p_timeout/1440.0 THEN Raise EX_PROCESS_TIME_OUT; END IF;
540:
541: DBMS_LOCK.SLEEP( 5);
542:
543: END IF;
544:
545: END LOOP;