DBA Data[Home] [Help]

APPS.MRP_UPDATE_MRP_INFO_PK dependencies on DBMS_LOCK

Line 333: dbms_lock.sleep(5);

329: EXIT;
330: EXCEPTION
331: WHEN deadlock THEN
332: ROLLBACK TO SAVEPOINT jobs;
333: dbms_lock.sleep(5);
334: END;
335: END LOOP;
336:
337: LOOP

Line 390: dbms_lock.sleep(5);

386: EXIT;
387: EXCEPTION
388: WHEN deadlock THEN
389: ROLLBACK TO SAVEPOINT flow;
390: dbms_lock.sleep(5);
391: END;
392: END LOOP;
393:
394: LOOP

Line 436: dbms_lock.sleep(5);

432: EXIT;
433: EXCEPTION
434: WHEN deadlock THEN
435: ROLLBACK TO SAVEPOINT mtl_sup;
436: dbms_lock.sleep(5);
437: END;
438: END LOOP;
439:
440: LOOP