APPS.AD_ZD_ADOP dependencies on DBMS_LOCK

Line 270: dbms_lock.sleep(30);

266: end if;
267:
268: if (l_dev_phase = 'PENDING')
269: then
270: dbms_lock.sleep(30);
271: end if;
272: end loop;
273:
274: /*

Line 515: dbms_lock.sleep(p_wait_interval);

511: commit;
512: return;
513: else
514: commit;
515: dbms_lock.sleep(p_wait_interval);
516: end if;
517: exception
518: when resource_busy then
519: dbms_lock.sleep(p_wait_interval);

Line 519: dbms_lock.sleep(p_wait_interval);

515: dbms_lock.sleep(p_wait_interval);
516: end if;
517: exception
518: when resource_busy then
519: dbms_lock.sleep(p_wait_interval);
520: end;
521: end loop;
522: log(l_mod_name, 'ERROR', 'ERROR: Unable to acquire lock on ad_adop_sessions table.');
523: RAISE_APPLICATION_ERROR(-20010,'ERROR: Unable to acquire lock on ad_adop_sessions table.');

Line 549: dbms_lock.sleep(p_wait_interval);

545: return;
546: end if;
547: exception
548: when resource_busy then
549: dbms_lock.sleep(p_wait_interval);
550: end;
551: end loop;
552: log(l_mod_name, 'ERROR', 'ERROR: Unable to acquire lock on ad_adop_sessions table.');
553: RAISE_APPLICATION_ERROR(-20010,'ERROR: Unable to acquire lock on ad_adop_sessions table.');

Line 1289: dbms_lock.sleep(60);

1285: where node_type='master' and adop_session_id=p_session_id;
1286: if(l_status = 'F') then
1287: RAISE_APPLICATION_ERROR(-20010,'ERROR: Master in failure status');
1288: else
1289: dbms_lock.sleep(60);
1290: end if;
1291: end loop;
1292: end WAIT_FOR_DB_CUTOVER;
1293: