APPS.CST_PERIODIC_ABSORPTION_PROC dependencies on DBMS_LOCK

Line 4505: DBMS_LOCK.sleep(l_sleep_time);

4501: LOOP
4502: IF GET_OPEN_REQUESTS_COUNT < p_number_of_workers THEN
4503: EXIT;
4504: END IF;
4505: DBMS_LOCK.sleep(l_sleep_time);
4506: END LOOP;
4507:
4508: END LOOP;
4509:

Line 4514: DBMS_LOCK.sleep(l_sleep_time);

4510: LOOP
4511: IF GET_OPEN_REQUESTS_COUNT = 0 THEN
4512: EXIT;
4513: END IF;
4514: DBMS_LOCK.sleep(l_sleep_time);
4515: END LOOP;
4516:
4517: --========================================================================================
4518: -- To arrange different cost groups in incresing order of On Hand quantities for each item