APPS.BIS_CREATE_REQUESTSET dependencies on DBMS_LOCK
Line 3523: dbms_lock.sleep(10);
3519: is
3520: begin
3521: commit;
3522: LOOP 3523: dbms_lock.sleep(10); 3524: BIS_COLLECTION_UTILITIES.put_line('inside the loop of waitforrequest');
3525: BIS_COLLECTION_UTILITIES.put_line('FND_GLOBAL.conc_request_id '||FND_GLOBAL.conc_request_id);
3526: BIS_COLLECTION_UTILITIES.put_line('p_request_id'||p_request_id);
3527: EXIT WHEN NOT ( is_req_alive(FND_GLOBAL.conc_request_id) and is_req_alive(p_request_id) );