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_DP_SV dependencies on V$TIMER

Line 91: SELECT hsecs INTO l_start_time from v$timer;

87: rlm_core_sv.dlog(C_DEBUG,'to date',p_to_date);
88: rlm_core_sv.dlog(C_DEBUG,'Org ID', p_org_id);
89: END IF;
90: --
91: SELECT hsecs INTO l_start_time from v$timer;
92: g_dsp_start_time := NULL; --Bugfix 10053830
93: g_dsp_start_time := SYSDATE; --Bugfix 10053830
94: --
95: IF (l_debug <> -1) THEN

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

341: -- If Profile Workflow Enabled set to No then
342: --
343: IF (nvl(v_WF_Enabled, 'N') = 'N') THEN
344: --{
345: SELECT hsecs INTO l_val_start_time from v$timer;
346: rlm_validatedemand_sv.GroupValidateDemand(v_header_id, v_status);
347: SELECT hsecs INTO l_val_end_time from v$timer;
348: l_val_total:=l_val_total+(l_val_end_time-l_val_start_time)/100;
349: --

Line 347: SELECT hsecs INTO l_val_end_time from v$timer;

343: IF (nvl(v_WF_Enabled, 'N') = 'N') THEN
344: --{
345: SELECT hsecs INTO l_val_start_time from v$timer;
346: rlm_validatedemand_sv.GroupValidateDemand(v_header_id, v_status);
347: SELECT hsecs INTO l_val_end_time from v$timer;
348: l_val_total:=l_val_total+(l_val_end_time-l_val_start_time)/100;
349: --
350: IF (v_status = rlm_core_sv.k_PROC_ERROR) OR
351: (rlm_validatedemand_sv.g_schedule_PS = rlm_core_sv.k_PS_ERROR)

Line 363: SELECT hsecs INTO l_post_start_time from v$timer;

359: IF (l_debug <> -1) THEN
360: rlm_core_sv.dlog(C_DEBUG,'Before PostValidation');
361: END IF;
362: --
363: SELECT hsecs INTO l_post_start_time from v$timer;
364: RLM_TPA_SV.PostValidation;
365: SELECT hsecs INTO l_post_end_time from v$timer;
366: l_post_total:=l_post_total+(l_post_end_time-l_post_start_time)/100;
367: COMMIT;

Line 365: SELECT hsecs INTO l_post_end_time from v$timer;

361: END IF;
362: --
363: SELECT hsecs INTO l_post_start_time from v$timer;
364: RLM_TPA_SV.PostValidation;
365: SELECT hsecs INTO l_post_end_time from v$timer;
366: l_post_total:=l_post_total+(l_post_end_time-l_post_start_time)/100;
367: COMMIT;
368: --
369: END IF;

Line 414: SELECT hsecs INTO l_comp_start_time from v$timer;

410: -- (Enhancement bug# 1062039)
411: --
412: g_warn_replace_schedule := p_warn_replace_schedule;
413:
414: SELECT hsecs INTO l_comp_start_time from v$timer;
415: --
416: RLM_REPLACE_SV.CompareReplaceSched(v_Sched_rec,
417: p_warn_replace_schedule,
418: v_replace_status);

Line 420: SELECT hsecs INTO l_comp_end_time from v$timer;

416: RLM_REPLACE_SV.CompareReplaceSched(v_Sched_rec,
417: p_warn_replace_schedule,
418: v_replace_status);
419: --
420: SELECT hsecs INTO l_comp_end_time from v$timer;
421: --
422: IF v_replace_status = FALSE THEN
423: --
424: RAISE e_ReplaceSchedule;

Line 452: SELECT hsecs INTO l_start_child_time from v$timer;

448: -- Parallelize if more than 1 group found
449: --
450: IF (v_num_child > 1) THEN
451: --
452: SELECT hsecs INTO l_start_child_time from v$timer;
453: --
454: SubmitChildRequests(v_header_id,
455: v_num_child,
456: v_child_req_id);

Line 461: SELECT hsecs INTO l_end_child_time from v$timer;

457: --
458: ProcessChildRequests(v_header_id,
459: v_child_req_id);
460:
461: SELECT hsecs INTO l_end_child_time from v$timer;
462: v_msg_text:='Total Time spent in DSP Child Requests - '|| (l_end_child_time-l_start_child_time)/100 ;
463: fnd_file.put_line(fnd_file.log, v_msg_text);
464:
465: v_child_req_id.delete;

Line 720: SELECT hsecs INTO l_end_time from v$timer;

716: --
717: RunExceptionReport(x_requestId => rlm_message_sv.g_conc_req_id,
718: x_OrgId => p_org_id);
719:
720: SELECT hsecs INTO l_end_time from v$timer;
721: g_dsp_start_time := NULL; --Bugfix 10053830
722: IF (l_debug <> -1) THEN
723: rlm_core_sv.dlog(C_DEBUG,'ValidateDemandTime', l_val_total);
724: rlm_core_sv.dlog(C_DEBUG,'PostValidateTime', l_post_total);

Line 1930: SELECT hsecs INTO l_md_start_time from v$timer;

1926: IF (l_debug <> -1) THEN
1927: rlm_core_sv.dlog(C_DEBUG, '***** Processing new group ****');
1928: END IF;
1929: --
1930: SELECT hsecs INTO l_md_start_time from v$timer;
1931: --
1932: IF NOT rlm_manage_demand_sv.LockLines(v_sched_rec.header_id,
1933: v_group_rec)
1934: THEN

Line 1945: SELECT hsecs INTO l_md_end_time from v$timer;

1941: v_sched_rec,
1942: v_group_rec,
1943: v_status);
1944: --
1945: SELECT hsecs INTO l_md_end_time from v$timer;
1946: l_md_total:=l_md_total+(l_md_end_time-l_md_start_time)/100;
1947: --
1948: IF (l_debug <> -1) THEN
1949: rlm_core_sv.dlog(C_DEBUG,'v_status:',v_status);

Line 1958: SELECT hsecs INTO l_mf_start_time from v$timer;

1954: RAISE e_MDFailed;
1955: --
1956: END IF;
1957: --
1958: SELECT hsecs INTO l_mf_start_time from v$timer;
1959: --
1960: rlm_tpa_sv.ManageForecast(v_sched_rec.header_id,
1961: v_sched_rec,
1962: v_group_rec,

Line 1965: SELECT hsecs INTO l_mf_end_time from v$timer;

1961: v_sched_rec,
1962: v_group_rec,
1963: v_status);
1964: --
1965: SELECT hsecs INTO l_mf_end_time from v$timer;
1966: l_mf_total:=l_mf_total+(l_mf_end_time-l_mf_start_time)/100;
1967: --
1968: IF (l_debug <> -1) THEN
1969: rlm_core_sv.dlog(C_DEBUG,'v_status:',v_status);

Line 1978: SELECT hsecs INTO l_rd_start_time from v$timer;

1974: RAISE e_FDFailed;
1975: --
1976: END IF;
1977: --
1978: SELECT hsecs INTO l_rd_start_time from v$timer;
1979: --
1980: rlm_rd_sv.RecDemand(v_sched_rec.header_id,
1981: v_sched_rec,
1982: v_group_rec,

Line 1985: SELECT hsecs INTO l_rd_end_time from v$timer;

1981: v_sched_rec,
1982: v_group_rec,
1983: v_status);
1984: --
1985: SELECT hsecs INTO l_rd_end_time from v$timer;
1986: l_rd_total:=l_rd_total+(l_rd_end_time-l_rd_start_time)/100;
1987: --
1988: IF v_status = rlm_core_sv.k_PROC_ERROR THEN
1989: --