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: --
93: rlm_message_sv.populate_req_id;
94: --
95: MO_GLOBAL.set_policy_context(p_access_mode => 'S',

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

334: -- If Profile Workflow Enabled set to No then
335: --
336: IF (nvl(v_WF_Enabled, 'N') = 'N') THEN
337: --{
338: SELECT hsecs INTO l_val_start_time from v$timer;
339: rlm_validatedemand_sv.GroupValidateDemand(v_header_id, v_status);
340: SELECT hsecs INTO l_val_end_time from v$timer;
341: l_val_total:=l_val_total+(l_val_end_time-l_val_start_time)/100;
342: --

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

336: IF (nvl(v_WF_Enabled, 'N') = 'N') THEN
337: --{
338: SELECT hsecs INTO l_val_start_time from v$timer;
339: rlm_validatedemand_sv.GroupValidateDemand(v_header_id, v_status);
340: SELECT hsecs INTO l_val_end_time from v$timer;
341: l_val_total:=l_val_total+(l_val_end_time-l_val_start_time)/100;
342: --
343: IF (v_status = rlm_core_sv.k_PROC_ERROR) OR
344: (rlm_validatedemand_sv.g_schedule_PS = rlm_core_sv.k_PS_ERROR)

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

352: IF (l_debug <> -1) THEN
353: rlm_core_sv.dlog(C_DEBUG,'Before PostValidation');
354: END IF;
355: --
356: SELECT hsecs INTO l_post_start_time from v$timer;
357: RLM_TPA_SV.PostValidation;
358: SELECT hsecs INTO l_post_end_time from v$timer;
359: l_post_total:=l_post_total+(l_post_end_time-l_post_start_time)/100;
360: COMMIT;

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

354: END IF;
355: --
356: SELECT hsecs INTO l_post_start_time from v$timer;
357: RLM_TPA_SV.PostValidation;
358: SELECT hsecs INTO l_post_end_time from v$timer;
359: l_post_total:=l_post_total+(l_post_end_time-l_post_start_time)/100;
360: COMMIT;
361: --
362: END IF;

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

403: -- (Enhancement bug# 1062039)
404: --
405: g_warn_replace_schedule := p_warn_replace_schedule;
406:
407: SELECT hsecs INTO l_comp_start_time from v$timer;
408: --
409: RLM_REPLACE_SV.CompareReplaceSched(v_Sched_rec,
410: p_warn_replace_schedule,
411: v_replace_status);

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

409: RLM_REPLACE_SV.CompareReplaceSched(v_Sched_rec,
410: p_warn_replace_schedule,
411: v_replace_status);
412: --
413: SELECT hsecs INTO l_comp_end_time from v$timer;
414: --
415: IF v_replace_status = FALSE THEN
416: --
417: RAISE e_ReplaceSchedule;

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

441: -- Parallelize if more than 1 group found
442: --
443: IF (v_num_child > 1) THEN
444: --
445: SELECT hsecs INTO l_start_child_time from v$timer;
446: --
447: SubmitChildRequests(v_header_id,
448: v_num_child,
449: v_child_req_id);

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

450: --
451: ProcessChildRequests(v_header_id,
452: v_child_req_id);
453:
454: SELECT hsecs INTO l_end_child_time from v$timer;
455: v_msg_text:='Total Time spent in DSP Child Requests - '|| (l_end_child_time-l_start_child_time)/100 ;
456: fnd_file.put_line(fnd_file.log, v_msg_text);
457:
458: v_child_req_id.delete;

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

709: --
710: RunExceptionReport(x_requestId => rlm_message_sv.g_conc_req_id,
711: x_OrgId => p_org_id);
712:
713: SELECT hsecs INTO l_end_time from v$timer;
714:
715: IF (l_debug <> -1) THEN
716: rlm_core_sv.dlog(C_DEBUG,'ValidateDemandTime', l_val_total);
717: rlm_core_sv.dlog(C_DEBUG,'PostValidateTime', l_post_total);

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

1919: IF (l_debug <> -1) THEN
1920: rlm_core_sv.dlog(C_DEBUG, '***** Processing new group ****');
1921: END IF;
1922: --
1923: SELECT hsecs INTO l_md_start_time from v$timer;
1924: --
1925: IF NOT rlm_manage_demand_sv.LockLines(v_sched_rec.header_id,
1926: v_group_rec)
1927: THEN

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

1934: v_sched_rec,
1935: v_group_rec,
1936: v_status);
1937: --
1938: SELECT hsecs INTO l_md_end_time from v$timer;
1939: l_md_total:=l_md_total+(l_md_end_time-l_md_start_time)/100;
1940: --
1941: IF (l_debug <> -1) THEN
1942: rlm_core_sv.dlog(C_DEBUG,'v_status:',v_status);

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

1947: RAISE e_MDFailed;
1948: --
1949: END IF;
1950: --
1951: SELECT hsecs INTO l_mf_start_time from v$timer;
1952: --
1953: rlm_tpa_sv.ManageForecast(v_sched_rec.header_id,
1954: v_sched_rec,
1955: v_group_rec,

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

1954: v_sched_rec,
1955: v_group_rec,
1956: v_status);
1957: --
1958: SELECT hsecs INTO l_mf_end_time from v$timer;
1959: l_mf_total:=l_mf_total+(l_mf_end_time-l_mf_start_time)/100;
1960: --
1961: IF (l_debug <> -1) THEN
1962: rlm_core_sv.dlog(C_DEBUG,'v_status:',v_status);

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

1967: RAISE e_FDFailed;
1968: --
1969: END IF;
1970: --
1971: SELECT hsecs INTO l_rd_start_time from v$timer;
1972: --
1973: rlm_rd_sv.RecDemand(v_sched_rec.header_id,
1974: v_sched_rec,
1975: v_group_rec,

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

1974: v_sched_rec,
1975: v_group_rec,
1976: v_status);
1977: --
1978: SELECT hsecs INTO l_rd_end_time from v$timer;
1979: l_rd_total:=l_rd_total+(l_rd_end_time-l_rd_start_time)/100;
1980: --
1981: IF v_status = rlm_core_sv.k_PROC_ERROR THEN
1982: --