eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 916: SELECT hsecs INTO v_rd_start_time from v$timer;

912: IF (l_debug <> -1) THEN
913: rlm_core_sv.dlog(C_DEBUG,' Header_id :', v_header_id);
914: END IF;
915: --
916: SELECT hsecs INTO v_rd_start_time from v$timer;
917: --
918: rlm_rd_sv.RecDemand(v_header_id,
919: g_Sch_rec,
920: g_Grp_rec,

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

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

Line 936: SELECT hsecs INTO v_rlm_gps_start_time from v$timer; --Bugfix 12863728

932: RAISE e_DPFailed;
933: --
934: END IF;
935: --
936: SELECT hsecs INTO v_rlm_gps_start_time from v$timer; --Bugfix 12863728
937: rlm_dp_sv.UpdateGroupPS(g_Sch_rec.header_id,
938: g_Sch_rec.schedule_header_id,
939: g_Grp_rec,
940: rlm_core_sv.k_PS_PROCESSED);

Line 944: SELECT hsecs INTO v_rlm_gps_end_time FROM v$timer; --Bugfix 12863728

940: rlm_core_sv.k_PS_PROCESSED);
941: --
942: COMMIT;
943: --
944: SELECT hsecs INTO v_rlm_gps_end_time FROM v$timer; --Bugfix 12863728
945: v_rlm_gps_total :=v_rlm_gps_total+(v_rlm_gps_end_time-v_rlm_gps_start_time )/100; --Bugfix 12863728
946: --
947: IF NOT rlm_dp_sv.LockHeader(v_header_id, g_Sch_rec) THEN
948: --

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

2052: rlm_core_sv.dlog(C_DEBUG,' Header_id :', v_header_id);
2053: END IF;
2054: --
2055: SAVEPOINT s_child_process;
2056: SELECT hsecs INTO v_md_start_time FROM v$timer;
2057: rlm_manage_demand_sv.ManageDemand(v_header_id,
2058: g_Sch_rec,
2059: g_Grp_rec,
2060: v_status);

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

2062: IF (l_debug <> -1) THEN
2063: rlm_core_sv.dlog(C_DEBUG,' After ManageDemand v_status: ', v_status);
2064: END IF;
2065: --
2066: SELECT hsecs INTO v_md_end_time FROM v$timer;
2067: v_md_total:=v_md_total+(v_md_end_time-v_md_start_time)/100;
2068:
2069: IF v_status = rlm_core_sv.k_PROC_ERROR THEN
2070: --

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

2075: IF (l_debug <> -1) THEN
2076: rlm_core_sv.dlog(C_DEBUG,'Before Manage Forecast');
2077: END IF;
2078: --
2079: SELECT hsecs INTO v_mf_start_time FROM v$timer;
2080:
2081: rlm_forecast_sv.ManageForecast(v_header_id,
2082: g_Sch_rec,
2083: g_Grp_rec,

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

2086: IF (l_debug <> -1) THEN
2087: rlm_core_sv.dlog(C_DEBUG,' After ManageForecast v_status: ', v_status);
2088: END IF;
2089: --
2090: SELECT hsecs INTO v_mf_end_time FROM v$timer;
2091: v_mf_total:=v_mf_total+(v_mf_end_time-v_mf_start_time)/100;
2092:
2093: IF v_status = rlm_core_sv.k_PROC_ERROR THEN
2094: --

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

2099: IF (l_debug <> -1) THEN
2100: rlm_core_sv.dlog(C_DEBUG,'Before Reconcile Demand');
2101: END IF;
2102: --
2103: SELECT hsecs INTO v_rd_start_time FROM v$timer;
2104:
2105: rlm_rd_sv.RecDemand(v_header_id,
2106: g_Sch_rec,
2107: g_Grp_rec,

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

2111: IF (l_debug <> -1) THEN
2112: rlm_core_sv.dlog(C_DEBUG, 'After ReconcileDemand v_status', v_status);
2113: END IF;
2114: --
2115: SELECT hsecs INTO v_rd_end_time FROM v$timer;
2116: v_rd_total :=v_rd_total+(v_rd_end_time-v_rd_start_time)/100;
2117: --
2118: IF v_status = rlm_core_sv.k_PROC_ERROR THEN
2119: --

Line 2124: SELECT hsecs INTO v_rlm_pg_gps_start_time from v$timer; --Bugfix 12863728

2120: RAISE e_RDFailed;
2121: --
2122: END IF;
2123: --
2124: SELECT hsecs INTO v_rlm_pg_gps_start_time from v$timer; --Bugfix 12863728
2125: rlm_dp_sv.UpdateGroupPS(g_Sch_rec.header_id,
2126: g_Sch_rec.schedule_header_id,
2127: g_Grp_rec,
2128: rlm_core_sv.k_PS_PROCESSED);

Line 2132: SELECT hsecs INTO v_rlm_pg_gps_end_time FROM v$timer; --Bugfix 12863728

2128: rlm_core_sv.k_PS_PROCESSED);
2129:
2130: COMMIT;
2131: --
2132: SELECT hsecs INTO v_rlm_pg_gps_end_time FROM v$timer; --Bugfix 12863728
2133: v_rlm_pg_gps_total :=v_rlm_pg_gps_total+(v_rlm_pg_gps_end_time-v_rlm_pg_gps_start_time )/100; --Bugfix 12863728
2134: --
2135: resultout := 'COMPLETE:SUCCESS';
2136: --

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

2996: -- Call Sweeper Program here
2997: -- (Enhancement bug# 1062039)
2998: --
2999:
3000: SELECT hsecs INTO l_comp_start_time FROM v$timer;
3001:
3002: RLM_REPLACE_SV.CompareReplaceSched(g_Sch_rec,
3003: RLM_DP_SV.g_warn_replace_schedule,
3004: v_replace_status);

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

3003: RLM_DP_SV.g_warn_replace_schedule,
3004: v_replace_status);
3005:
3006: --
3007: SELECT hsecs INTO l_comp_end_time FROM v$timer;
3008:
3009:
3010: IF v_replace_status = FALSE THEN
3011: --