APPS.CST_PERIODIC_ABSORPTION_PROC dependencies on DBMS_LOCK

Line 4874: DBMS_LOCK.sleep(l_sleep_time);

4870: LOOP
4871: IF GET_OPEN_REQUESTS_COUNT < p_number_of_workers THEN
4872: EXIT;
4873: END IF;
4874: DBMS_LOCK.sleep(l_sleep_time);
4875: END LOOP;
4876:
4877: END LOOP;
4878:

Line 4883: DBMS_LOCK.sleep(l_sleep_time);

4879: LOOP
4880: IF GET_OPEN_REQUESTS_COUNT = 0 THEN
4881: EXIT;
4882: END IF;
4883: DBMS_LOCK.sleep(l_sleep_time);
4884: END LOOP;
4885:
4886: --========================================================================================
4887: -- To arrange different cost groups in incresing order of On Hand quantities for each item