DBA Data[Home] [Help]

APPS.INV_MGD_PURGE_CP dependencies on DBMS_LOCK

Line 252: DBMS_LOCK.sleep(l_sleep_time);

248: LOOP
249: IF (l_status_ind > p_request_limit) THEN
250: -- sleep for l_sleep_time if all req.
251: -- are running.
252: DBMS_LOCK.sleep(l_sleep_time);
253:
254: -- reset the status number
255: l_status_ind := 1;
256: END IF;

Line 308: DBMS_LOCK.sleep(l_sleep_time);

304: END IF;
305:
306: END LOOP; -- end for loop
307:
308: DBMS_LOCK.sleep(l_sleep_time);
309: END LOOP; -- end while
310:
311: IF G_DEBUG = 'Y' THEN
312: INV_ORGHIERARCHY_PVT.Log