DBA Data[Home] [Help]

APPS.PA_ONESTEP_STREAMLINE_PKG dependencies on DBMS_LOCK

Line 282: dbms_lock.sleep(v_sleep_interval); -- sleep

278:
279:
280: LOOP -- check if all primary and reporting processes have completed
281: v_completed_r := true;
282: dbms_lock.sleep(v_sleep_interval); -- sleep
283: update_request_state(strm_request_table);
284: FOR i IN 1..strm_request_table.count LOOP
285: IF (strm_request_table(i).phase <> 'COMPLETE') THEN
286: v_completed_r := false;