APPS.INV_MGD_PRD_CONTROL_MEDIATOR dependencies on DBMS_LOCK

Line 2383: DBMS_LOCK.sleep(l_sleep_time);

2379:
2380: /* Bug 3999140. Sleep time is introdued between execution of
2381: * Close Accounting Period concurrent program status checking query.
2382: */
2383: DBMS_LOCK.sleep(l_sleep_time);
2384:
2385: END LOOP;
2386:
2387: IF G_DEBUG = 'Y' THEN

Line 2666: DBMS_LOCK.sleep(l_sleep_time);

2662:
2663: /* Bug 3999140. Sleep time is introdued between execution of
2664: * Close Accounting Period concurrent program status checking query.
2665: */
2666: DBMS_LOCK.sleep(l_sleep_time);
2667:
2668: END LOOP;
2669:
2670: IF G_DEBUG = 'Y' THEN