APPS.CN_PERIODS_API dependencies on DBMS_LOCK

Line 251: dbms_lock.sleep(l_sleep_time);

247: cn_message_pkg.debug('Number of batches submitted: ' || g_batch_total);
248: ------------------------------------------------------------------------------------------
249: fnd_file.put_line(fnd_file.Log, 'Step 6 : Total Batches Submitted => ' || g_batch_total);
250: ------------------------------------------------------------------------------------------
251: dbms_lock.sleep(l_sleep_time);
252:
253: WHILE l_completed_batch_count <= g_batch_total LOOP
254: IF l_primary_request_stack(primary_ptr) IS NOT NULL THEN
255: l_call_status := fnd_concurrent.get_request_status

Line 290: dbms_lock.sleep(l_sleep_time);

286:
287: unfinished := FALSE;
288: ELSE
289: IF primary_ptr > g_batch_total THEN
290: dbms_lock.sleep(l_sleep_time);
291: primary_ptr := 1;
292: END IF;
293: END IF;
294: END LOOP;