APPS.INV_MGD_PRD_CONTROL_MEDIATOR dependencies on DBMS_LOCK

Line 2180: DBMS_LOCK.sleep(l_sleep_time);

2176:
2177: /* Bug 3999140. Sleep time is introdued between execution of
2178: * Close Accounting Period concurrent program status checking query.
2179: */
2180: DBMS_LOCK.sleep(l_sleep_time);
2181:
2182: END LOOP;
2183:
2184: IF G_DEBUG = 'Y' THEN

Line 2463: DBMS_LOCK.sleep(l_sleep_time);

2459:
2460: /* Bug 3999140. Sleep time is introdued between execution of
2461: * Close Accounting Period concurrent program status checking query.
2462: */
2463: DBMS_LOCK.sleep(l_sleep_time);
2464:
2465: END LOOP;
2466:
2467: IF G_DEBUG = 'Y' THEN