APPS.HXC_ARCHIVE dependencies on DBMS_LOCK

Line 352: dbms_lock.sleep(10);

348: ELSE
349:
350: -- There are no records still in the temp table for transactions.
351: -- Sleep for 10 seconds and try again.
352: dbms_lock.sleep(10);
353:
354: END IF;
355:
356: END LOOP;

Line 1478: dbms_lock.sleep(60);

1474: l_trans_count := 0;
1475: l_tau_count := 0;
1476: l_ta_count := 0;
1477: data_mismatch := FALSE;
1478: dbms_lock.sleep(60);
1479: WHEN DEADLOCK_DETECTED THEN
1480: ROLLBACK;
1481: iloop := 1;
1482: fnd_file.put_line(fnd_file.LOG,'This chunk found a resource contention(deadlock), will sleep for a minute ');

Line 1491: dbms_lock.sleep(60);

1487: l_trans_count := 0;
1488: l_tau_count := 0;
1489: l_ta_count := 0;
1490: data_mismatch := FALSE;
1491: dbms_lock.sleep(60);
1492: END ;
1493: END LOOP TO_CONTINUE_TO_NEXT_CHUNK ;
1494:
1495: END LOOP;