APPS.AHL_SIMULATION_PVT dependencies on DBMS_LOCK

Line 100: DBMS_LOCK.SLEEP(10);

96: EXCEPTION
97: WHEN record_locked THEN
98: l_locked_rows := 'Y';
99: -- lock exists. Wait for 20 seconds and try again
100: DBMS_LOCK.SLEEP(10);
101: END;
102: END LOOP;
103:
104: -- Check for locked rows in unit assocs table

Line 118: DBMS_LOCK.SLEEP(10);--sleep for 20 seconds

114: EXIT;
115: EXCEPTION
116: WHEN record_locked THEN
117: l_locked_rows := 'Y';
118: DBMS_LOCK.SLEEP(10);--sleep for 20 seconds
119: END;
120: END LOOP;
121: END IF;
122:

Line 351: DBMS_LOCK.SLEEP(10);--sleep for 20 seconds

347: EXIT;
348: EXCEPTION
349: WHEN record_locked THEN
350: l_locked_rows := 'Y';
351: DBMS_LOCK.SLEEP(10);--sleep for 20 seconds
352: END;
353: END LOOP;
354:
355: -- Check for locks of the ue records

Line 368: DBMS_LOCK.SLEEP(10);--sleep for 20 seconds

364: EXIT;
365: EXCEPTION
366: WHEN record_locked THEN
367: l_locked_rows := 'Y';
368: DBMS_LOCK.SLEEP(10);--sleep for 20 seconds
369: END;
370: END LOOP;
371: END IF;
372:

Line 685: DBMS_LOCK.SLEEP(10);--sleep for 20 seconds

681: EXIT;
682: EXCEPTION
683: WHEN record_locked THEN
684: l_locked_rows := 'Y';
685: DBMS_LOCK.SLEEP(10);--sleep for 20 seconds
686: END;
687: END LOOP;
688:
689: -- Check for locks of the ue records

Line 702: DBMS_LOCK.SLEEP(10);--sleep for 20 seconds

698: EXIT;
699: EXCEPTION
700: WHEN record_locked THEN
701: l_locked_rows := 'Y';
702: DBMS_LOCK.SLEEP(10);--sleep for 20 seconds
703: END;
704: END LOOP;
705: END IF;
706: