520: select (SYSDATE- START_TIME) into lv_process_time from dual;
521:
522: IF lv_process_time > p_timeout/1440.0 THEN Raise EX_PROCESS_TIME_OUT; END IF;
523:
524: DBMS_LOCK.SLEEP( 5);
525:
526: END IF;
527:
528: ELSE
531: select (SYSDATE- START_TIME) into lv_process_time from dual;
532:
533: IF lv_process_time > p_timeout/1440.0 THEN Raise EX_PROCESS_TIME_OUT; END IF;
534:
535: DBMS_LOCK.SLEEP( 5);
536:
537: END IF;
538:
539: END LOOP;