APPS.HXC_RESTORE dependencies on DBMS_LOCK

Line 328: dbms_lock.sleep(10);

324: WHERE thread_id = 0 ;
325:
326: COMMIT;
327: ELSE
328: dbms_lock.sleep(10);
329: END IF;
330: END LOOP;
331:
332: trans_count := 0;

Line 1950: dbms_lock.sleep(60);

1946: l_trans_count := 0;
1947: l_tau_count := 0;
1948: l_ta_count := 0;
1949: data_mismatch := FALSE;
1950: dbms_lock.sleep(60);
1951: WHEN DEADLOCK_DETECTED THEN
1952: ROLLBACK;
1953: iloop := 1;
1954: fnd_file.put_line(fnd_file.LOG,'This chunk found a resource contention(deadlock), will sleep for a minute ');

Line 1963: dbms_lock.sleep(60);

1959: l_trans_count := 0;
1960: l_tau_count := 0;
1961: l_ta_count := 0;
1962: data_mismatch := FALSE;
1963: dbms_lock.sleep(60);
1964:
1965: END ;
1966: END LOOP TO_CONTINUE_TO_NEXT_CHUNK;
1967: END LOOP;