APPS.CN_TRANSACTION_LOAD_PKG dependencies on DBMS_LOCK

Line 447: DBMS_LOCK.sleep(l_sleep_time);

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

Line 506: DBMS_LOCK.sleep(l_sleep_time);

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