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_ESC_CUS_BLOG_PKG dependencies on FND_PROFILE

Line 16: l_check_val:=fnd_profile.value('BIV:INC_SEVERITY_1') ;

12: from ak_attributes_vl
13: where attribute_application_id = 862
14: and attribute_code='P_DASH_SR_VIEW_11';
15:
16: l_check_val:=fnd_profile.value('BIV:INC_SEVERITY_1') ;
17:
18: if l_check_val is not null then
19: execute immediate ' select description
20: from cs_incident_severities_vl

Line 56: l_check_val:= fnd_profile.value('BIV:INC_STATUS_1');

52:
53: l_label_m:=l_label_m1||' '||l_label_m3||' '||l_label_m2;
54:
55:
56: l_check_val:= fnd_profile.value('BIV:INC_STATUS_1');
57:
58:
59: if l_check_val is not null then
60: execute immediate ' select name

Line 99: l_check_val:= fnd_profile.value('BIV:INC_STATUS_2');

95:
96: l_label_m:=l_label_m1||' '||l_label_m3||' '||l_label_m2;
97:
98:
99: l_check_val:= fnd_profile.value('BIV:INC_STATUS_2');
100:
101:
102: if l_check_val is not null then
103: execute immediate ' select name

Line 140: l_check_val:= fnd_profile.value('BIV:INC_STATUS_3');

136:
137: l_label_m:=l_label_m1||' '||l_label_m3||' '||l_label_m2;
138:
139:
140: l_check_val:= fnd_profile.value('BIV:INC_STATUS_3');
141:
142:
143: if l_check_val is not null then
144: execute immediate ' select name

Line 193: l_debug varchar2(30) := fnd_profile.value('BIV:DEBUG');

189: x_session number;
190: x_sev_count number;
191: l_ttl_recs number;
192: l_ttl_meaning fnd_lookups.meaning % type;
193: l_debug varchar2(30) := fnd_profile.value('BIV:DEBUG');
194:
195: begin
196: x_session:=biv_core_pkg.get_session_id;
197:

Line 204: x_severity_id:=fnd_profile.value('BIV:INC_SEVERITY_1');

200: q3_str:=' ';
201: q4_str:=' ';
202: q5_str:=' ';
203: q6_str:=' ';
204: x_severity_id:=fnd_profile.value('BIV:INC_SEVERITY_1');
205:
206: biv_core_pkg.get_report_parameters(p_param_str);
207: biv_core_pkg.g_report_type:='RT';
208: if (l_debug = 'Y') then

Line 568: l_debug varchar2(30) := fnd_profile.value('BIV:DEBUG');

564: q4_str varchar2(4000);
565: x_sev_count number;
566: l_ttl_recs number;
567: l_ttl_meaning fnd_lookups.meaning % type;
568: l_debug varchar2(30) := fnd_profile.value('BIV:DEBUG');
569:
570: begin
571: x_session:=biv_core_pkg.get_session_id;
572: biv_core_pkg.clean_dcf_table('BIV_TMP_RT1');

Line 575: x_severity_id:=fnd_profile.value('BIV:INC_SEVERITY_1');

571: x_session:=biv_core_pkg.get_session_id;
572: biv_core_pkg.clean_dcf_table('BIV_TMP_RT1');
573:
574:
575: x_severity_id:=fnd_profile.value('BIV:INC_SEVERITY_1');
576: x_stat_1:=fnd_profile.value('BIV:INC_STATUS_1');
577: x_stat_2:=fnd_profile.value('BIV:INC_STATUS_2');
578: x_stat_3:=fnd_profile.value('BIV:INC_STATUS_3');
579:

Line 576: x_stat_1:=fnd_profile.value('BIV:INC_STATUS_1');

572: biv_core_pkg.clean_dcf_table('BIV_TMP_RT1');
573:
574:
575: x_severity_id:=fnd_profile.value('BIV:INC_SEVERITY_1');
576: x_stat_1:=fnd_profile.value('BIV:INC_STATUS_1');
577: x_stat_2:=fnd_profile.value('BIV:INC_STATUS_2');
578: x_stat_3:=fnd_profile.value('BIV:INC_STATUS_3');
579:
580: biv_core_pkg.g_report_id:='BIV_RT_ESC_SR';

Line 577: x_stat_2:=fnd_profile.value('BIV:INC_STATUS_2');

573:
574:
575: x_severity_id:=fnd_profile.value('BIV:INC_SEVERITY_1');
576: x_stat_1:=fnd_profile.value('BIV:INC_STATUS_1');
577: x_stat_2:=fnd_profile.value('BIV:INC_STATUS_2');
578: x_stat_3:=fnd_profile.value('BIV:INC_STATUS_3');
579:
580: biv_core_pkg.g_report_id:='BIV_RT_ESC_SR';
581: biv_core_pkg.get_report_parameters(p_param_str);

Line 578: x_stat_3:=fnd_profile.value('BIV:INC_STATUS_3');

574:
575: x_severity_id:=fnd_profile.value('BIV:INC_SEVERITY_1');
576: x_stat_1:=fnd_profile.value('BIV:INC_STATUS_1');
577: x_stat_2:=fnd_profile.value('BIV:INC_STATUS_2');
578: x_stat_3:=fnd_profile.value('BIV:INC_STATUS_3');
579:
580: biv_core_pkg.g_report_id:='BIV_RT_ESC_SR';
581: biv_core_pkg.get_report_parameters(p_param_str);
582: biv_core_pkg.g_report_type:='RT';

Line 870: l_debug varchar2(30) := fnd_profile.value('BIV:DEBUG');

866: x_session varchar2(50);
867: x_sev_count number;
868: l_ttl_recs number;
869: l_ttl_meaning fnd_lookups.meaning % type;
870: l_debug varchar2(30) := fnd_profile.value('BIV:DEBUG');
871:
872: begin
873: x_session:=biv_core_pkg.get_session_id;
874:

Line 877: x_severity_id:=fnd_profile.value('BIV:INC_SEVERITY_1');

873: x_session:=biv_core_pkg.get_session_id;
874:
875: biv_core_pkg.clean_dcf_table('BIV_TMP_RT1');
876:
877: x_severity_id:=fnd_profile.value('BIV:INC_SEVERITY_1');
878:
879: biv_core_pkg.get_report_parameters(p_param_str);
880: biv_core_pkg.g_report_type:='RT';
881: if (l_debug = 'Y') then