DBA Data[Home] [Help]

APPS.RLM_WF_SV dependencies on V$TIMER

Line 177: SELECT hsecs INTO v_start_time from v$timer;

173: IF (l_debug <> -1) THEN
174: rlm_core_sv.dlog(C_DEBUG,'Before Start Process ');
175: END IF;
176: --
177: SELECT hsecs INTO v_start_time from v$timer;
178:
179: wf_engine.StartProcess(v_ItemType, v_ItemKey);
180: --
181: IF (l_debug <> -1) THEN

Line 322: SELECT hsecs INTO v_end_time FROM v$timer;

318: IF (l_debug <> -1) THEN
319: rlm_core_sv.dpop(C_SDEBUG);
320: END IF;
321:
322: SELECT hsecs INTO v_end_time FROM v$timer;
323: v_wf_msg_text:= 'Time spent in Work Flow call - '||(v_end_time-v_start_time)/100 ;
324: fnd_file.put_line(fnd_file.log,v_wf_msg_text);
325:
326: EXCEPTION

Line 382: SELECT hsecs INTO l_val_start_time from v$timer;

378: --
379: -- Bug 2868593
380: SAVEPOINT s_ValidateDemand;
381: --
382: SELECT hsecs INTO l_val_start_time from v$timer;
383: --
384: rlm_validatedemand_sv.GroupValidateDemand(v_header_id, v_status);
385: --
386: IF (l_debug <> -1) THEN

Line 391: SELECT hsecs INTO l_val_end_time FROM v$timer;

387: rlm_core_sv.dlog(C_DEBUG,' After Validate v_status: ', v_status);
388: rlm_core_sv.dlog(C_DEBUG,'g_schedule_PS', RLM_VALIDATEDEMAND_SV.g_schedule_PS);
389: END IF;
390:
391: SELECT hsecs INTO l_val_end_time FROM v$timer;
392: --
393: IF v_status <> rlm_core_sv.k_PROC_ERROR THEN
394: --
395: IF RLM_VALIDATEDEMAND_SV.g_schedule_PS <> rlm_core_sv.k_PS_ERROR

Line 590: SELECT hsecs INTO v_md_start_time FROM v$timer;

586: END IF;
587: --
588: SAVEPOINT s_child_process;
589:
590: SELECT hsecs INTO v_md_start_time FROM v$timer;
591:
592: rlm_manage_demand_sv.ManageDemand(v_header_id,
593: g_Sch_rec,
594: g_Grp_rec,

Line 601: SELECT hsecs INTO v_md_end_time FROM v$timer;

597: IF (l_debug <> -1) THEN
598: rlm_core_sv.dlog(C_DEBUG,' After ManageDemand v_status: ', v_status);
599: END IF;
600: --
601: SELECT hsecs INTO v_md_end_time FROM v$timer;
602: v_md_total:=v_md_total+(v_md_end_time-v_md_start_time)/100;
603:
604: IF v_status = rlm_core_sv.k_PROC_ERROR THEN
605: --

Line 752: SELECT hsecs INTO v_mf_start_time FROM v$timer;

748: rlm_core_sv.dlog(C_DEBUG,' Header_id :', v_header_id);
749: rlm_core_sv.dlog(C_DEBUG,' ManageForecast');
750: END IF;
751: --
752: SELECT hsecs INTO v_mf_start_time FROM v$timer;
753:
754: rlm_forecast_sv.ManageForecast(v_header_id,
755: g_Sch_rec,
756: g_Grp_rec,

Line 763: SELECT hsecs INTO v_mf_end_time FROM v$timer;

759: IF (l_debug <> -1) THEN
760: rlm_core_sv.dlog(C_DEBUG,' After ManageForecast v_status: ', v_status);
761: END IF;
762: --
763: SELECT hsecs INTO v_mf_end_time FROM v$timer;
764: v_mf_total:=v_mf_total+(v_mf_end_time-v_mf_start_time)/100;
765:
766: IF v_status = rlm_core_sv.k_PROC_ERROR THEN
767: --

Line 911: SELECT hsecs INTO v_rd_start_time from v$timer;

907: IF (l_debug <> -1) THEN
908: rlm_core_sv.dlog(C_DEBUG,' Header_id :', v_header_id);
909: END IF;
910: --
911: SELECT hsecs INTO v_rd_start_time from v$timer;
912: --
913: rlm_rd_sv.RecDemand(v_header_id,
914: g_Sch_rec,
915: g_Grp_rec,

Line 922: SELECT hsecs INTO v_rd_end_time FROM v$timer;

918: IF (l_debug <> -1) THEN
919: rlm_core_sv.dlog(C_DEBUG,' After ReconcileDemand v_status: ', v_status);
920: END IF;
921: --
922: SELECT hsecs INTO v_rd_end_time FROM v$timer;
923: v_rd_total :=v_rd_total+(v_rd_end_time-v_rd_start_time)/100;
924: --
925: IF v_status = rlm_core_sv.k_PROC_ERROR THEN
926: --

Line 2041: SELECT hsecs INTO v_md_start_time FROM v$timer;

2037: rlm_core_sv.dlog(C_DEBUG,' Header_id :', v_header_id);
2038: END IF;
2039: --
2040: SAVEPOINT s_child_process;
2041: SELECT hsecs INTO v_md_start_time FROM v$timer;
2042: rlm_manage_demand_sv.ManageDemand(v_header_id,
2043: g_Sch_rec,
2044: g_Grp_rec,
2045: v_status);

Line 2051: SELECT hsecs INTO v_md_end_time FROM v$timer;

2047: IF (l_debug <> -1) THEN
2048: rlm_core_sv.dlog(C_DEBUG,' After ManageDemand v_status: ', v_status);
2049: END IF;
2050: --
2051: SELECT hsecs INTO v_md_end_time FROM v$timer;
2052: v_md_total:=v_md_total+(v_md_end_time-v_md_start_time)/100;
2053:
2054: IF v_status = rlm_core_sv.k_PROC_ERROR THEN
2055: --

Line 2064: SELECT hsecs INTO v_mf_start_time FROM v$timer;

2060: IF (l_debug <> -1) THEN
2061: rlm_core_sv.dlog(C_DEBUG,'Before Manage Forecast');
2062: END IF;
2063: --
2064: SELECT hsecs INTO v_mf_start_time FROM v$timer;
2065:
2066: rlm_forecast_sv.ManageForecast(v_header_id,
2067: g_Sch_rec,
2068: g_Grp_rec,

Line 2075: SELECT hsecs INTO v_mf_end_time FROM v$timer;

2071: IF (l_debug <> -1) THEN
2072: rlm_core_sv.dlog(C_DEBUG,' After ManageForecast v_status: ', v_status);
2073: END IF;
2074: --
2075: SELECT hsecs INTO v_mf_end_time FROM v$timer;
2076: v_mf_total:=v_mf_total+(v_mf_end_time-v_mf_start_time)/100;
2077:
2078: IF v_status = rlm_core_sv.k_PROC_ERROR THEN
2079: --

Line 2088: SELECT hsecs INTO v_rd_start_time FROM v$timer;

2084: IF (l_debug <> -1) THEN
2085: rlm_core_sv.dlog(C_DEBUG,'Before Reconcile Demand');
2086: END IF;
2087: --
2088: SELECT hsecs INTO v_rd_start_time FROM v$timer;
2089:
2090: rlm_rd_sv.RecDemand(v_header_id,
2091: g_Sch_rec,
2092: g_Grp_rec,

Line 2100: SELECT hsecs INTO v_rd_end_time FROM v$timer;

2096: IF (l_debug <> -1) THEN
2097: rlm_core_sv.dlog(C_DEBUG, 'After ReconcileDemand v_status', v_status);
2098: END IF;
2099: --
2100: SELECT hsecs INTO v_rd_end_time FROM v$timer;
2101: v_rd_total :=v_rd_total+(v_rd_end_time-v_rd_start_time)/100;
2102: --
2103: IF v_status = rlm_core_sv.k_PROC_ERROR THEN
2104: --

Line 2978: SELECT hsecs INTO l_comp_start_time FROM v$timer;

2974: -- Call Sweeper Program here
2975: -- (Enhancement bug# 1062039)
2976: --
2977:
2978: SELECT hsecs INTO l_comp_start_time FROM v$timer;
2979:
2980: RLM_REPLACE_SV.CompareReplaceSched(g_Sch_rec,
2981: RLM_DP_SV.g_warn_replace_schedule,
2982: v_replace_status);

Line 2985: SELECT hsecs INTO l_comp_end_time FROM v$timer;

2981: RLM_DP_SV.g_warn_replace_schedule,
2982: v_replace_status);
2983:
2984: --
2985: SELECT hsecs INTO l_comp_end_time FROM v$timer;
2986:
2987:
2988: IF v_replace_status = FALSE THEN
2989: --