APPS.MSD_DEM_SOP dependencies on DBMS_LOCK

Line 1588: dbms_lock.sleep(p_job_check_interval);

1584: x_sql := 'select 1 from dual where exists ( select 1 from dba_jobs where (upper(what) like ''MSD_DEM_SOP.LOAD_SERIES_DATA_BATCH%'' or upper(what) like ''MSD_DEM_SOP.LOAD_PLAN_DATA_WO_PDS%'' or ';
1585: x_sql := x_sql || 'upper(what) like ''MSD_DEM_SOP.LOAD_PLAN_DATA_WO_ODS%'' ) and upper(broken) = ''N'' ) ';
1586:
1587: loop
1588: dbms_lock.sleep(p_job_check_interval);
1589: execute immediate x_sql into x_jobs_running;
1590: x_jobs_time_elapsed := to_number(to_char(sysdate, 'J')) - to_number(to_char(x_check_start_time, 'J'))
1591: + to_number(to_char(sysdate, 'SSSSS')) - to_number(to_char(x_check_start_time, 'SSSSS'));
1592: exit when x_jobs_time_elapsed >= p_jobs_timeout;

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

2932: execute immediate v_sql into v_status using v_schema_id;
2933:
2934: -- if another workflow is running, sleep for 1 to 3 minutes
2935: IF (v_status = 'Running') THEN
2936: dbms_lock.sleep(dbms_random.value(60,180));
2937: END IF;
2938: END LOOP;
2939:
2940: EXCEPTION