APPS.HXC_ARCHIVE dependencies on DBMS_LOCK

Line 359: dbms_lock.sleep(10);

355: ELSE
356:
357: -- There are no records still in the temp table for transactions.
358: -- Sleep for 10 seconds and try again.
359: dbms_lock.sleep(10);
360:
361: END IF;
362:
363: END LOOP;

Line 1827: dbms_lock.sleep(60);

1823: l_trans_count := 0;
1824: l_tau_count := 0;
1825: l_ta_count := 0;
1826: data_mismatch := FALSE;
1827: dbms_lock.sleep(60);
1828: WHEN DEADLOCK_DETECTED THEN
1829: ROLLBACK;
1830: iloop := 1;
1831: fnd_file.put_line(fnd_file.LOG,'This chunk found a resource contention(deadlock), will sleep for a minute ');

Line 1840: dbms_lock.sleep(60);

1836: l_trans_count := 0;
1837: l_tau_count := 0;
1838: l_ta_count := 0;
1839: data_mismatch := FALSE;
1840: dbms_lock.sleep(60);
1841: END ;
1842: END LOOP TO_CONTINUE_TO_NEXT_CHUNK ;
1843:
1844: END LOOP;