DBA Data[Home] [Help]

APPS.CN_SCA_CREDITS_BATCH_PUB dependencies on DBMS_LOCK

Line 216: DBMS_LOCK.sleep(l_sleep_time);

212: IF l_sleep_time_char IS NOT NULL THEN
213: l_sleep_time := TO_NUMBER(l_sleep_time_char);
214: END IF;
215:
216: DBMS_LOCK.sleep(l_sleep_time);
217:
218: WHILE l_completed_batch_count <= x_batch_total LOOP
219: IF l_primary_request_stack(primary_ptr) IS NOT NULL THEN
220: l_call_status :=

Line 273: DBMS_LOCK.sleep(l_sleep_time);

269: -- batch and some conc requests have not completed.
270: -- Give the conc requests a few minutes to run before
271: -- checking their status
272: IF (primary_ptr > x_batch_total) THEN
273: DBMS_LOCK.sleep(l_sleep_time);
274: primary_ptr := 1;
275: END IF;
276: END IF;
277: END LOOP;