APPS.MSC_CL_PROFILE_LOADERS dependencies on DBMS_LOCK

Line 100: dbms_lock.sleep(30);

96:
97: l_request_id := p_request_id;
98:
99: LOOP
100: dbms_lock.sleep(30);
101: l_call_status:= FND_CONCURRENT.GET_REQUEST_STATUS
102: ( l_request_id,
103: NULL,
104: NULL,

Line 366: DBMS_LOCK.SLEEP( 5);

362: select (SYSDATE- START_TIME) into lv_process_time from dual;
363:
364: IF lv_process_time > p_timeout/1440.0 THEN Raise EX_PROCESS_TIME_OUT; END IF;
365:
366: DBMS_LOCK.SLEEP( 5);
367:
368: END IF;
369:
370: ELSE

Line 377: DBMS_LOCK.SLEEP( 5);

373: select (SYSDATE- START_TIME) into lv_process_time from dual;
374:
375: IF lv_process_time > p_timeout/1440.0 THEN Raise EX_PROCESS_TIME_OUT; END IF;
376:
377: DBMS_LOCK.SLEEP( 5);
378:
379: END IF;
380:
381: END LOOP;