APPS.CN_TRANSACTION_LOAD_PKG dependencies on DBMS_LOCK

Line 444: DBMS_LOCK.sleep(l_sleep_time);

440: IF l_sleep_time_char IS NOT NULL THEN
441: l_sleep_time := TO_NUMBER(l_sleep_time_char);
442: END IF;
443:
444: DBMS_LOCK.sleep(l_sleep_time);
445:
446: WHILE l_completed_batch_count <= x_batch_total LOOP
447: IF l_primary_request_stack(primary_ptr) IS NOT NULL THEN
448: l_call_status :=

Line 503: DBMS_LOCK.sleep(l_sleep_time);

499: -- batch and some conc requests have not completed.
500: -- Give the conc requests a few minutes to run before
501: -- checking their status
502: IF primary_ptr > x_batch_total THEN
503: DBMS_LOCK.sleep(l_sleep_time);
504: primary_ptr := 1;
505: END IF;
506: END IF;
507: END LOOP;