APPS.CN_SCA_CREDITS_BATCH_PUB dependencies on DBMS_LOCK

Line 119: dbms_lock.sleep(10);

115:
116: debugmsg('SCA : CN_SCATM_TAE_PUB. Request '||l_child_program_id_tbl(l_child_program_id)
117: ||' l_dev_phase '||l_dev_phase||' l_dev_status. Parent Process going to sleep for 10 seconds. ');
118:
119: dbms_lock.sleep(10);
120:
121: END LOOP;
122:
123:

Line 294: DBMS_LOCK.sleep(l_sleep_time);

290: IF l_sleep_time_char IS NOT NULL THEN
291: l_sleep_time := TO_NUMBER(l_sleep_time_char);
292: END IF;
293:
294: DBMS_LOCK.sleep(l_sleep_time);
295:
296: WHILE l_completed_batch_count <= x_batch_total LOOP
297: IF l_primary_request_stack(primary_ptr) IS NOT NULL THEN
298: l_call_status :=

Line 351: DBMS_LOCK.sleep(l_sleep_time);

347: -- batch and some conc requests have not completed.
348: -- Give the conc requests a few minutes to run before
349: -- checking their status
350: IF (primary_ptr > x_batch_total) THEN
351: DBMS_LOCK.sleep(l_sleep_time);
352: primary_ptr := 1;
353: END IF;
354: END IF;
355: END LOOP;