DBA Data[Home] [Help]

APPS.PA_RP_UTIL dependencies on DBMS_LOCK

Line 315: DBMS_LOCK.SLEEP(1);

311: AND status_flag = 'P';
312:
313: IF (l_dev_phase = 'RUNNING') OR ((l_finish = 'N') AND (l_dev_phase = 'INACTIVE') AND (l_dev_status <>'DISABLED')) THEN
314: Pa_Debug.log_message(p_message => 'Waiting for request:'|| l_request_id);
315: DBMS_LOCK.SLEEP(1);
316: END IF;
317: END LOOP;
318:
319: