DBA Data[Home] [Help]

APPS.MSD_DEM_COMMON_UTILITIES dependencies on DBMS_LOCK

Line 3098: DBMS_LOCK.SLEEP( p_check_interval );

3094: || ' and wfpl.schema_id = wfs.schema_id ' ;
3095: EXECUTE IMMEDIATE l_sql INTO workflow_status,workflow_name ;
3096:
3097: IF (workflow_status = 1) THEN
3098: DBMS_LOCK.SLEEP( p_check_interval );
3099: ELSIF (workflow_status = 0) then
3100: msd_dem_common_utilities.log_message( workflow_name || ' Workflow completed successfully.');
3101: retcode := 0;
3102: EXIT;

Line 3703: DBMS_LOCK.SLEEP( p_check_finish );

3699: || ' and wfpl.schema_id = wfs.schema_id ' ;
3700: EXECUTE immediate l_sql INTO dem_status,dem_schema_name ;
3701:
3702: IF (dem_status = 1) then
3703: DBMS_LOCK.SLEEP( p_check_finish );
3704: ElsIf (dem_status = 0) then
3705: msd_dem_common_utilities.log_message( dem_schema_name || ' Workflow completed successfully.');
3706: retcode := 0;
3707: exit;