APPS.HXC_RESTORE dependencies on DBMS_LOCK

Line 320: dbms_lock.sleep(10);

316: WHERE thread_id = 0 ;
317:
318: COMMIT;
319: ELSE
320: dbms_lock.sleep(10);
321: END IF;
322: END LOOP;
323:
324: trans_count := 0;

Line 1429: dbms_lock.sleep(60);

1425: l_trans_count := 0;
1426: l_tau_count := 0;
1427: l_ta_count := 0;
1428: data_mismatch := FALSE;
1429: dbms_lock.sleep(60);
1430: WHEN DEADLOCK_DETECTED THEN
1431: ROLLBACK;
1432: iloop := 1;
1433: fnd_file.put_line(fnd_file.LOG,'This chunk found a resource contention(deadlock), will sleep for a minute ');

Line 1442: dbms_lock.sleep(60);

1438: l_trans_count := 0;
1439: l_tau_count := 0;
1440: l_ta_count := 0;
1441: data_mismatch := FALSE;
1442: dbms_lock.sleep(60);
1443:
1444: END ;
1445: END LOOP TO_CONTINUE_TO_NEXT_CHUNK;
1446: END LOOP;