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.BIV_RT_SR_AGE_REPORT_PKG dependencies on FND_PROFILE

Line 32: g_debug_flag VARCHAR2(1) := nvl(fnd_profile.value('BIV:DEBUG'),'N');

28: g_where VARCHAR2(1000);
29: g_v_sp VARCHAR2(5) := biv_core_pkg.g_value_sep;
30: g_p_sp VARCHAR2(5) := biv_core_pkg.g_param_sep;
31: g_session_id NUMBER ;
32: g_debug_flag VARCHAR2(1) := nvl(fnd_profile.value('BIV:DEBUG'),'N');
33:
34: PROCEDURE load_sr_backlog_age_report(p_param_str IN VARCHAR2 /*DEFAULT NULL*/) IS
35: l_cur_id PLS_INTEGER;
36: l_return_num PLS_INTEGER := 0;

Line 47: g_sev_1 := fnd_profile.value('BIV:INC_SEVERITY_1');

43: if g_debug_flag = 'Y' then
44: biv_core_pkg.biv_debug('Param Str:'||p_param_str,
45: g_report_code);
46: end if;
47: g_sev_1 := fnd_profile.value('BIV:INC_SEVERITY_1');
48: g_sev_2 := fnd_profile.value('BIV:INC_SEVERITY_2');
49: g_sev_3 := fnd_profile.value('BIV:INC_SEVERITY_3');
50: g_sev_4 := fnd_profile.value('BIV:INC_SEVERITY_4');
51: g_sev_5 := fnd_profile.value('BIV:INC_SEVERITY_5');

Line 48: g_sev_2 := fnd_profile.value('BIV:INC_SEVERITY_2');

44: biv_core_pkg.biv_debug('Param Str:'||p_param_str,
45: g_report_code);
46: end if;
47: g_sev_1 := fnd_profile.value('BIV:INC_SEVERITY_1');
48: g_sev_2 := fnd_profile.value('BIV:INC_SEVERITY_2');
49: g_sev_3 := fnd_profile.value('BIV:INC_SEVERITY_3');
50: g_sev_4 := fnd_profile.value('BIV:INC_SEVERITY_4');
51: g_sev_5 := fnd_profile.value('BIV:INC_SEVERITY_5');
52:

Line 49: g_sev_3 := fnd_profile.value('BIV:INC_SEVERITY_3');

45: g_report_code);
46: end if;
47: g_sev_1 := fnd_profile.value('BIV:INC_SEVERITY_1');
48: g_sev_2 := fnd_profile.value('BIV:INC_SEVERITY_2');
49: g_sev_3 := fnd_profile.value('BIV:INC_SEVERITY_3');
50: g_sev_4 := fnd_profile.value('BIV:INC_SEVERITY_4');
51: g_sev_5 := fnd_profile.value('BIV:INC_SEVERITY_5');
52:
53: if g_sev_1 is null then g_sev_1 := 0; end if;

Line 50: g_sev_4 := fnd_profile.value('BIV:INC_SEVERITY_4');

46: end if;
47: g_sev_1 := fnd_profile.value('BIV:INC_SEVERITY_1');
48: g_sev_2 := fnd_profile.value('BIV:INC_SEVERITY_2');
49: g_sev_3 := fnd_profile.value('BIV:INC_SEVERITY_3');
50: g_sev_4 := fnd_profile.value('BIV:INC_SEVERITY_4');
51: g_sev_5 := fnd_profile.value('BIV:INC_SEVERITY_5');
52:
53: if g_sev_1 is null then g_sev_1 := 0; end if;
54: if g_sev_2 is null then g_sev_2 := 0; end if;

Line 51: g_sev_5 := fnd_profile.value('BIV:INC_SEVERITY_5');

47: g_sev_1 := fnd_profile.value('BIV:INC_SEVERITY_1');
48: g_sev_2 := fnd_profile.value('BIV:INC_SEVERITY_2');
49: g_sev_3 := fnd_profile.value('BIV:INC_SEVERITY_3');
50: g_sev_4 := fnd_profile.value('BIV:INC_SEVERITY_4');
51: g_sev_5 := fnd_profile.value('BIV:INC_SEVERITY_5');
52:
53: if g_sev_1 is null then g_sev_1 := 0; end if;
54: if g_sev_2 is null then g_sev_2 := 0; end if;
55: if g_sev_3 is null then g_sev_3 := 0; end if;

Line 291: WHERE a.incident_severity_id = fnd_profile.value('BIV:INC_SEVERITY_1');

287: BEGIN
288: -- get severity type
289: SELECT a.name INTO l_label_1
290: FROM cs_incident_severities_vl a
291: WHERE a.incident_severity_id = fnd_profile.value('BIV:INC_SEVERITY_1');
292:
293: -- get "Severity"
294: SELECT attribute_label_long INTO l_label_2
295: FROM ak_attributes_vl

Line 310: WHERE a.incident_severity_id = fnd_profile.value('BIV:INC_SEVERITY_2');

306: BEGIN
307: -- get severity type
308: SELECT a.name INTO l_label_1
309: FROM cs_incident_severities_vl a
310: WHERE a.incident_severity_id = fnd_profile.value('BIV:INC_SEVERITY_2');
311:
312: -- get "Severity"
313: SELECT attribute_label_long INTO l_label_2
314: FROM ak_attributes_vl

Line 329: WHERE a.incident_severity_id = fnd_profile.value('BIV:INC_SEVERITY_3');

325: BEGIN
326: -- get severity type
327: SELECT a.name INTO l_label_1
328: FROM cs_incident_severities_vl a
329: WHERE a.incident_severity_id = fnd_profile.value('BIV:INC_SEVERITY_3');
330:
331: -- get "Severity"
332: SELECT attribute_label_long INTO l_label_2
333: FROM ak_attributes_vl

Line 348: WHERE a.incident_severity_id = fnd_profile.value('BIV:INC_SEVERITY_4');

344: BEGIN
345: -- get severity type
346: SELECT a.name INTO l_label_1
347: FROM cs_incident_severities_vl a
348: WHERE a.incident_severity_id = fnd_profile.value('BIV:INC_SEVERITY_4');
349:
350: -- get "Severity"
351: SELECT attribute_label_long INTO l_label_2
352: FROM ak_attributes_vl

Line 367: WHERE a.incident_severity_id = fnd_profile.value('BIV:INC_SEVERITY_5');

363: BEGIN
364: -- get severity type
365: SELECT a.name INTO l_label_1
366: FROM cs_incident_severities_vl a
367: WHERE a.incident_severity_id = fnd_profile.value('BIV:INC_SEVERITY_5');
368:
369: -- get "Severity"
370: SELECT attribute_label_long INTO l_label_2
371: FROM ak_attributes_vl