DBA Data[Home] [Help]

APPS.MSD_DEM_UPLOAD_FORECAST dependencies on DBMS_LOCK

Line 4196: dbms_lock.sleep(dbms_random.value(60,180));

4192: End;
4193:
4194: /* if another workflow is running, sleep for 1 to 3 minutes */
4195: IF ( x_wf_status = 'Running' ) then
4196: dbms_lock.sleep(dbms_random.value(60,180));
4197: ELSE
4198: x_wf_status := 'Not Running' ;
4199: End if;
4200: