APPS.INV_CONSUMPTION_ADVICE_PROC dependencies on DBMS_LOCK

Line 3976: DBMS_LOCK.sleep(G_SLEEP_TIME);

3972:
3973: END LOOP;
3974:
3975: IF (NOT l_done) THEN
3976: DBMS_LOCK.sleep(G_SLEEP_TIME);
3977: END IF;
3978:
3979: END LOOP;
3980:

Line 4032: DBMS_LOCK.sleep(G_SLEEP_TIME);

4028:
4029: END LOOP;
4030:
4031: IF (NOT l_done) THEN
4032: DBMS_LOCK.sleep(G_SLEEP_TIME);
4033: END IF;
4034:
4035: END LOOP;
4036: