APPS.INV_CONSUMPTION_ADVICE_PROC dependencies on DBMS_LOCK

Line 3836: DBMS_LOCK.sleep(G_SLEEP_TIME);

3832:
3833: END LOOP;
3834:
3835: IF (NOT l_done) THEN
3836: DBMS_LOCK.sleep(G_SLEEP_TIME);
3837: END IF;
3838:
3839: END LOOP;
3840:

Line 3892: DBMS_LOCK.sleep(G_SLEEP_TIME);

3888:
3889: END LOOP;
3890:
3891: IF (NOT l_done) THEN
3892: DBMS_LOCK.sleep(G_SLEEP_TIME);
3893: END IF;
3894:
3895: END LOOP;
3896: