APPS.CN_SCA_TRX_PROC_PVT dependencies on DBMS_LOCK

Line 226: dbms_lock.sleep(l_sleep_time);

222: IF l_sleep_time_char IS NOT NULL THEN
223: l_sleep_time := to_number(l_sleep_time_char);
224: END IF;
225:
226: dbms_lock.sleep(l_sleep_time);
227:
228: WHILE l_completed_batch_count <= x_batch_total LOOP
229:
230: IF l_primary_request_stack(primary_ptr) IS NOT NULL THEN

Line 285: dbms_lock.sleep(l_sleep_time);

281: -- batch and some conc requests have not completed.
282: -- Give the conc requests a few minutes to run before
283: -- checking their status
284: IF primary_ptr > x_batch_total THEN
285: dbms_lock.sleep(l_sleep_time);
286: primary_ptr := 1;
287: END IF;
288: END IF;
289: END LOOP;