APPS.MSC_E1APS_UTIL dependencies on DBMS_LOCK

Line 486: DBMS_LOCK.sleep(sleepTime);

482: || ' process_id '
483: || '='
484: || ret_process_id;
485: EXECUTE immediate v_sql INTO dem_status;
486: DBMS_LOCK.sleep(sleepTime);
487: IF dem_status = 0 THEN
488: msd_dem_common_utilities.log_message('DEMANTRA WORKFLOW COMPLETED SUCCESSFULLY');
489: EXIT;
490: elsif dem_cnt = demTimeOut THEN

Line 580: DBMS_LOCK.sleep(60);/*Sleeps the execution for 60 seconds*/

576: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Scenario ' || scenario_name|| ' executed with errors. Session # ' || Session_number );
577: EXIT;
578: END IF;
579:
580: DBMS_LOCK.sleep(60);/*Sleeps the execution for 60 seconds*/
581: v_Sleep:= v_Sleep+60; /*Counter value for Sleep */
582:
583: IF (v_Sleep = Time_Out) Then
584: ResultFlag := 0;