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_DASH_BIN_PKG dependencies on BIV_CORE_PKG

Line 7: g_v_sp VARCHAR2(5) := biv_core_pkg.g_value_sep;

3: -- This package is used to render the picasso BIN in dashboard
4: -- all procedure are called by seeded AK_REGION via JTF
5:
6: g_err VARCHAR2(500);
7: g_v_sp VARCHAR2(5) := biv_core_pkg.g_value_sep;
8: g_p_sp VARCHAR2(5) := biv_core_pkg.g_param_sep;
9: g_session_id NUMBER := biv_core_pkg.get_session_id;
10: g_debug_flag VARCHAR2(1) := nvl(fnd_profile.value('BIV:DEBUG'),'N');
11: g_esc_frm_lst varchar2(500);

Line 8: g_p_sp VARCHAR2(5) := biv_core_pkg.g_param_sep;

4: -- all procedure are called by seeded AK_REGION via JTF
5:
6: g_err VARCHAR2(500);
7: g_v_sp VARCHAR2(5) := biv_core_pkg.g_value_sep;
8: g_p_sp VARCHAR2(5) := biv_core_pkg.g_param_sep;
9: g_session_id NUMBER := biv_core_pkg.get_session_id;
10: g_debug_flag VARCHAR2(1) := nvl(fnd_profile.value('BIV:DEBUG'),'N');
11: g_esc_frm_lst varchar2(500);
12: g_esc_whr_cls varchar2(2000);

Line 9: g_session_id NUMBER := biv_core_pkg.get_session_id;

5:
6: g_err VARCHAR2(500);
7: g_v_sp VARCHAR2(5) := biv_core_pkg.g_value_sep;
8: g_p_sp VARCHAR2(5) := biv_core_pkg.g_param_sep;
9: g_session_id NUMBER := biv_core_pkg.get_session_id;
10: g_debug_flag VARCHAR2(1) := nvl(fnd_profile.value('BIV:DEBUG'),'N');
11: g_esc_frm_lst varchar2(500);
12: g_esc_whr_cls varchar2(2000);
13: g_esc_sel_stt varchar2(2000);

Line 30: l_ogrp VARCHAR2(20) := biv_core_pkg.get_parameter_value(p_param_str,'P_OGRP');

26: l_total VARCHAR(500);
27: l_totalurl VARCHAR(3000);
28: l_url VARCHAR(3000);
29:
30: l_ogrp VARCHAR2(20) := biv_core_pkg.get_parameter_value(p_param_str,'P_OGRP');
31: l_agrp VARCHAR2(20) := biv_core_pkg.get_parameter_value(p_param_str,'P_AGRP');
32: l_mgr_id VARCHAR2(20) := biv_core_pkg.get_parameter_value(p_param_str,'P_MGR_ID');
33: BEGIN
34: biv_core_pkg.g_report_id := 'BIV_DASH_SR_BIN';

Line 31: l_agrp VARCHAR2(20) := biv_core_pkg.get_parameter_value(p_param_str,'P_AGRP');

27: l_totalurl VARCHAR(3000);
28: l_url VARCHAR(3000);
29:
30: l_ogrp VARCHAR2(20) := biv_core_pkg.get_parameter_value(p_param_str,'P_OGRP');
31: l_agrp VARCHAR2(20) := biv_core_pkg.get_parameter_value(p_param_str,'P_AGRP');
32: l_mgr_id VARCHAR2(20) := biv_core_pkg.get_parameter_value(p_param_str,'P_MGR_ID');
33: BEGIN
34: biv_core_pkg.g_report_id := 'BIV_DASH_SR_BIN';
35: biv_core_pkg.clean_dcf_table('BIV_TMP_BIN');

Line 32: l_mgr_id VARCHAR2(20) := biv_core_pkg.get_parameter_value(p_param_str,'P_MGR_ID');

28: l_url VARCHAR(3000);
29:
30: l_ogrp VARCHAR2(20) := biv_core_pkg.get_parameter_value(p_param_str,'P_OGRP');
31: l_agrp VARCHAR2(20) := biv_core_pkg.get_parameter_value(p_param_str,'P_AGRP');
32: l_mgr_id VARCHAR2(20) := biv_core_pkg.get_parameter_value(p_param_str,'P_MGR_ID');
33: BEGIN
34: biv_core_pkg.g_report_id := 'BIV_DASH_SR_BIN';
35: biv_core_pkg.clean_dcf_table('BIV_TMP_BIN');
36: g_session_id := biv_core_pkg.get_session_id;

Line 34: biv_core_pkg.g_report_id := 'BIV_DASH_SR_BIN';

30: l_ogrp VARCHAR2(20) := biv_core_pkg.get_parameter_value(p_param_str,'P_OGRP');
31: l_agrp VARCHAR2(20) := biv_core_pkg.get_parameter_value(p_param_str,'P_AGRP');
32: l_mgr_id VARCHAR2(20) := biv_core_pkg.get_parameter_value(p_param_str,'P_MGR_ID');
33: BEGIN
34: biv_core_pkg.g_report_id := 'BIV_DASH_SR_BIN';
35: biv_core_pkg.clean_dcf_table('BIV_TMP_BIN');
36: g_session_id := biv_core_pkg.get_session_id;
37: biv_core_pkg.get_report_parameters(p_param_str);
38:

Line 35: biv_core_pkg.clean_dcf_table('BIV_TMP_BIN');

31: l_agrp VARCHAR2(20) := biv_core_pkg.get_parameter_value(p_param_str,'P_AGRP');
32: l_mgr_id VARCHAR2(20) := biv_core_pkg.get_parameter_value(p_param_str,'P_MGR_ID');
33: BEGIN
34: biv_core_pkg.g_report_id := 'BIV_DASH_SR_BIN';
35: biv_core_pkg.clean_dcf_table('BIV_TMP_BIN');
36: g_session_id := biv_core_pkg.get_session_id;
37: biv_core_pkg.get_report_parameters(p_param_str);
38:
39: l_select := 'INSERT INTO biv_tmp_bin (report_code, session_id, col2, col3, col4) ';

Line 36: g_session_id := biv_core_pkg.get_session_id;

32: l_mgr_id VARCHAR2(20) := biv_core_pkg.get_parameter_value(p_param_str,'P_MGR_ID');
33: BEGIN
34: biv_core_pkg.g_report_id := 'BIV_DASH_SR_BIN';
35: biv_core_pkg.clean_dcf_table('BIV_TMP_BIN');
36: g_session_id := biv_core_pkg.get_session_id;
37: biv_core_pkg.get_report_parameters(p_param_str);
38:
39: l_select := 'INSERT INTO biv_tmp_bin (report_code, session_id, col2, col3, col4) ';
40: l_select := l_select || 'SELECT :report_id,:session_id,stat.name, ';

Line 37: biv_core_pkg.get_report_parameters(p_param_str);

33: BEGIN
34: biv_core_pkg.g_report_id := 'BIV_DASH_SR_BIN';
35: biv_core_pkg.clean_dcf_table('BIV_TMP_BIN');
36: g_session_id := biv_core_pkg.get_session_id;
37: biv_core_pkg.get_report_parameters(p_param_str);
38:
39: l_select := 'INSERT INTO biv_tmp_bin (report_code, session_id, col2, col3, col4) ';
40: l_select := l_select || 'SELECT :report_id,:session_id,stat.name, ';
41: l_select := l_select || '''BIV_SERVICE_REQUEST';

Line 61: biv_core_pkg.get_where_clause(l_table,x_where_clause);

57: l_select := l_select || '''||stat.incident_status_id||''' || g_p_sp || '''';
58: l_select := l_select || ',count(sr.incident_id) ';
59: -- Change for Bug 3386946
60: l_table := ' FROM cs_incidents_b_sec sr, cs_incident_statuses_vl stat ';
61: biv_core_pkg.get_where_clause(l_table,x_where_clause);
62: l_where := x_where_clause || '
63: and sr.incident_status_id = stat.incident_status_id
64: and stat.incident_subtype = ''INC''
65: and nvl(stat.close_flag,''N'') != ''Y''

Line 71: biv_core_pkg.biv_debug(l_query,biv_core_pkg.g_report_id);

67: ';
68: l_query := l_select || ' ' || l_table || ' ' || l_where;
69:
70: if g_debug_flag = 'Y' then
71: biv_core_pkg.biv_debug(l_query,biv_core_pkg.g_report_id);
72: commit;
73: end if;
74:
75: l_cur_id := DBMS_SQL.OPEN_CURSOR;

Line 77: biv_core_pkg.bind_all_variables(l_cur_id);

73: end if;
74:
75: l_cur_id := DBMS_SQL.OPEN_CURSOR;
76: DBMS_SQL.PARSE(l_cur_id,l_query,DBMS_SQL.NATIVE);
77: biv_core_pkg.bind_all_variables(l_cur_id);
78: DBMS_SQL.BIND_VARIABLE(l_cur_id,':report_id',biv_core_pkg.g_report_id);
79: DBMS_SQL.BIND_VARIABLE(l_cur_id,':session_id',biv_core_pkg.get_session_id);
80: l_return_num := DBMS_SQL.EXECUTE(l_cur_id);
81: DBMS_SQL.CLOSE_CURSOR(l_cur_id);

Line 78: DBMS_SQL.BIND_VARIABLE(l_cur_id,':report_id',biv_core_pkg.g_report_id);

74:
75: l_cur_id := DBMS_SQL.OPEN_CURSOR;
76: DBMS_SQL.PARSE(l_cur_id,l_query,DBMS_SQL.NATIVE);
77: biv_core_pkg.bind_all_variables(l_cur_id);
78: DBMS_SQL.BIND_VARIABLE(l_cur_id,':report_id',biv_core_pkg.g_report_id);
79: DBMS_SQL.BIND_VARIABLE(l_cur_id,':session_id',biv_core_pkg.get_session_id);
80: l_return_num := DBMS_SQL.EXECUTE(l_cur_id);
81: DBMS_SQL.CLOSE_CURSOR(l_cur_id);
82:

Line 79: DBMS_SQL.BIND_VARIABLE(l_cur_id,':session_id',biv_core_pkg.get_session_id);

75: l_cur_id := DBMS_SQL.OPEN_CURSOR;
76: DBMS_SQL.PARSE(l_cur_id,l_query,DBMS_SQL.NATIVE);
77: biv_core_pkg.bind_all_variables(l_cur_id);
78: DBMS_SQL.BIND_VARIABLE(l_cur_id,':report_id',biv_core_pkg.g_report_id);
79: DBMS_SQL.BIND_VARIABLE(l_cur_id,':session_id',biv_core_pkg.get_session_id);
80: l_return_num := DBMS_SQL.EXECUTE(l_cur_id);
81: DBMS_SQL.CLOSE_CURSOR(l_cur_id);
82:
83: -- Change for enh 2914005 starts

Line 85: l_total := biv_core_pkg.get_lookup_meaning('TOTAL');

81: DBMS_SQL.CLOSE_CURSOR(l_cur_id);
82:
83: -- Change for enh 2914005 starts
84: if l_return_num > 0 then
85: l_total := biv_core_pkg.get_lookup_meaning('TOTAL');
86: l_totalurl := 'BIV_SERVICE_REQUEST' || l_url;
87: l_totalurl := l_totalurl || g_p_sp || 'P_PREVR' || g_v_sp;
88: l_totalurl := l_totalurl || biv_core_pkg.g_report_id;
89: l_totalurl := l_totalurl || g_p_sp || 'P_TOTAL' || g_v_sp;

Line 88: l_totalurl := l_totalurl || biv_core_pkg.g_report_id;

84: if l_return_num > 0 then
85: l_total := biv_core_pkg.get_lookup_meaning('TOTAL');
86: l_totalurl := 'BIV_SERVICE_REQUEST' || l_url;
87: l_totalurl := l_totalurl || g_p_sp || 'P_PREVR' || g_v_sp;
88: l_totalurl := l_totalurl || biv_core_pkg.g_report_id;
89: l_totalurl := l_totalurl || g_p_sp || 'P_TOTAL' || g_v_sp;
90: l_totalurl := l_totalurl || 'Y';
91: insert into biv_tmp_bin (report_code,session_id,col2,col4,col3) select biv_core_pkg.g_report_id,biv_core_pkg.get_session_id,
92: l_total,decode(sum(col4),null,0,sum(col4)),l_totalurl from biv_tmp_bin;

Line 91: insert into biv_tmp_bin (report_code,session_id,col2,col4,col3) select biv_core_pkg.g_report_id,biv_core_pkg.get_session_id,

87: l_totalurl := l_totalurl || g_p_sp || 'P_PREVR' || g_v_sp;
88: l_totalurl := l_totalurl || biv_core_pkg.g_report_id;
89: l_totalurl := l_totalurl || g_p_sp || 'P_TOTAL' || g_v_sp;
90: l_totalurl := l_totalurl || 'Y';
91: insert into biv_tmp_bin (report_code,session_id,col2,col4,col3) select biv_core_pkg.g_report_id,biv_core_pkg.get_session_id,
92: l_total,decode(sum(col4),null,0,sum(col4)),l_totalurl from biv_tmp_bin;
93: end if;
94: -- Change for enh 2914005 ends
95: EXCEPTION

Line 100: biv_core_pkg.biv_debug(g_err,biv_core_pkg.g_report_id);

96: WHEN OTHERS THEN
97: if (g_debug_flag = 'Y') then
98: g_err := 'Err in BIV_DASH_BIN_PKG.load_sr_bin:' ||
99: substr(sqlerrm,1,500);
100: biv_core_pkg.biv_debug(g_err,biv_core_pkg.g_report_id);
101: end if;
102: END load_sr_bin;
103:
104: -- Service Request Summary Report - Monitor

Line 115: l_ogrp VARCHAR2(20) := biv_core_pkg.get_parameter_value(p_param_str,'P_OGRP');

111: l_where VARCHAR2(1000);
112: l_cur_id PLS_INTEGER;
113: l_return_num PLS_INTEGER := 0;
114: l_url_param VARCHAR2(50);
115: l_ogrp VARCHAR2(20) := biv_core_pkg.get_parameter_value(p_param_str,'P_OGRP');
116: l_agrp VARCHAR2(20) := biv_core_pkg.get_parameter_value(p_param_str,'P_AGRP');
117: l_mgr_id VARCHAR2(20) := biv_core_pkg.get_parameter_value(p_param_str,'P_MGR_ID');
118: l_ttl_recs number;
119: l_ttl_meaning fnd_lookups.meaning % type :=

Line 116: l_agrp VARCHAR2(20) := biv_core_pkg.get_parameter_value(p_param_str,'P_AGRP');

112: l_cur_id PLS_INTEGER;
113: l_return_num PLS_INTEGER := 0;
114: l_url_param VARCHAR2(50);
115: l_ogrp VARCHAR2(20) := biv_core_pkg.get_parameter_value(p_param_str,'P_OGRP');
116: l_agrp VARCHAR2(20) := biv_core_pkg.get_parameter_value(p_param_str,'P_AGRP');
117: l_mgr_id VARCHAR2(20) := biv_core_pkg.get_parameter_value(p_param_str,'P_MGR_ID');
118: l_ttl_recs number;
119: l_ttl_meaning fnd_lookups.meaning % type :=
120: biv_core_pkg.get_lookup_meaning('TOTAL');

Line 117: l_mgr_id VARCHAR2(20) := biv_core_pkg.get_parameter_value(p_param_str,'P_MGR_ID');

113: l_return_num PLS_INTEGER := 0;
114: l_url_param VARCHAR2(50);
115: l_ogrp VARCHAR2(20) := biv_core_pkg.get_parameter_value(p_param_str,'P_OGRP');
116: l_agrp VARCHAR2(20) := biv_core_pkg.get_parameter_value(p_param_str,'P_AGRP');
117: l_mgr_id VARCHAR2(20) := biv_core_pkg.get_parameter_value(p_param_str,'P_MGR_ID');
118: l_ttl_recs number;
119: l_ttl_meaning fnd_lookups.meaning % type :=
120: biv_core_pkg.get_lookup_meaning('TOTAL');
121: l_param_str biv_tmp_rt1.col1 % type;

Line 120: biv_core_pkg.get_lookup_meaning('TOTAL');

116: l_agrp VARCHAR2(20) := biv_core_pkg.get_parameter_value(p_param_str,'P_AGRP');
117: l_mgr_id VARCHAR2(20) := biv_core_pkg.get_parameter_value(p_param_str,'P_MGR_ID');
118: l_ttl_recs number;
119: l_ttl_meaning fnd_lookups.meaning % type :=
120: biv_core_pkg.get_lookup_meaning('TOTAL');
121: l_param_str biv_tmp_rt1.col1 % type;
122: BEGIN
123: biv_core_pkg.g_report_id := l_report_code;
124: biv_core_pkg.clean_dcf_table('BIV_TMP_RT1');

Line 123: biv_core_pkg.g_report_id := l_report_code;

119: l_ttl_meaning fnd_lookups.meaning % type :=
120: biv_core_pkg.get_lookup_meaning('TOTAL');
121: l_param_str biv_tmp_rt1.col1 % type;
122: BEGIN
123: biv_core_pkg.g_report_id := l_report_code;
124: biv_core_pkg.clean_dcf_table('BIV_TMP_RT1');
125: g_session_id := biv_core_pkg.get_session_id;
126: if (g_debug_flag = 'Y') then
127: biv_core_pkg.biv_debug('Start of Report, Params:'||

Line 124: biv_core_pkg.clean_dcf_table('BIV_TMP_RT1');

120: biv_core_pkg.get_lookup_meaning('TOTAL');
121: l_param_str biv_tmp_rt1.col1 % type;
122: BEGIN
123: biv_core_pkg.g_report_id := l_report_code;
124: biv_core_pkg.clean_dcf_table('BIV_TMP_RT1');
125: g_session_id := biv_core_pkg.get_session_id;
126: if (g_debug_flag = 'Y') then
127: biv_core_pkg.biv_debug('Start of Report, Params:'||
128: p_param_str,biv_core_pkg.g_report_id);

Line 125: g_session_id := biv_core_pkg.get_session_id;

121: l_param_str biv_tmp_rt1.col1 % type;
122: BEGIN
123: biv_core_pkg.g_report_id := l_report_code;
124: biv_core_pkg.clean_dcf_table('BIV_TMP_RT1');
125: g_session_id := biv_core_pkg.get_session_id;
126: if (g_debug_flag = 'Y') then
127: biv_core_pkg.biv_debug('Start of Report, Params:'||
128: p_param_str,biv_core_pkg.g_report_id);
129: end if;

Line 127: biv_core_pkg.biv_debug('Start of Report, Params:'||

123: biv_core_pkg.g_report_id := l_report_code;
124: biv_core_pkg.clean_dcf_table('BIV_TMP_RT1');
125: g_session_id := biv_core_pkg.get_session_id;
126: if (g_debug_flag = 'Y') then
127: biv_core_pkg.biv_debug('Start of Report, Params:'||
128: p_param_str,biv_core_pkg.g_report_id);
129: end if;
130: biv_core_pkg.get_report_parameters(p_param_str);
131:

Line 128: p_param_str,biv_core_pkg.g_report_id);

124: biv_core_pkg.clean_dcf_table('BIV_TMP_RT1');
125: g_session_id := biv_core_pkg.get_session_id;
126: if (g_debug_flag = 'Y') then
127: biv_core_pkg.biv_debug('Start of Report, Params:'||
128: p_param_str,biv_core_pkg.g_report_id);
129: end if;
130: biv_core_pkg.get_report_parameters(p_param_str);
131:
132: -- build extra params

Line 130: biv_core_pkg.get_report_parameters(p_param_str);

126: if (g_debug_flag = 'Y') then
127: biv_core_pkg.biv_debug('Start of Report, Params:'||
128: p_param_str,biv_core_pkg.g_report_id);
129: end if;
130: biv_core_pkg.get_report_parameters(p_param_str);
131:
132: -- build extra params
133: l_url_param := g_p_sp;
134: if l_ogrp is not null then

Line 169: biv_core_pkg.get_where_clause(l_table,x_where_clause);

165:
166:
167: l_table := 'FROM cs_incident_statuses_vl stat, cs_incidents_vl_sec sr ';
168:
169: biv_core_pkg.get_where_clause(l_table,x_where_clause);
170: -- table and where clause to get escalated SR count.
171: -- this will be used in get_esc_sr_backlog
172: -- Change for Bug 3386946
173: g_esc_frm_lst := ' from cs_incidents_b_sec sr,

Line 176: biv_core_pkg.get_where_clause(g_esc_frm_lst,g_esc_whr_cls);

172: -- Change for Bug 3386946
173: g_esc_frm_lst := ' from cs_incidents_b_sec sr,
174: jtf_task_references_b ref,
175: jtf_tasks_b task ';
176: biv_core_pkg.get_where_clause(g_esc_frm_lst,g_esc_whr_cls);
177: g_esc_whr_cls := g_esc_whr_cls || '
178: and sr.incident_id = ref.object_id
179: and ref.task_id = task.task_id
180: and ref.object_type_code = ''SR''

Line 188: biv_core_pkg.biv_debug('statement for escalated SR',

184: and sr.incident_status_id = :p_status ';
185: g_esc_sel_stt := 'select count(sr.incident_id)
186: ' || g_esc_frm_lst || g_esc_whr_cls;
187: if (g_debug_flag = 'Y') then
188: biv_core_pkg.biv_debug('statement for escalated SR',
189: biv_core_pkg.g_report_id);
190: biv_core_pkg.biv_debug(g_esc_sel_stt,biv_core_pkg.g_report_id);
191: end if;
192:

Line 189: biv_core_pkg.g_report_id);

185: g_esc_sel_stt := 'select count(sr.incident_id)
186: ' || g_esc_frm_lst || g_esc_whr_cls;
187: if (g_debug_flag = 'Y') then
188: biv_core_pkg.biv_debug('statement for escalated SR',
189: biv_core_pkg.g_report_id);
190: biv_core_pkg.biv_debug(g_esc_sel_stt,biv_core_pkg.g_report_id);
191: end if;
192:
193: l_where := x_where_clause || ' ' || '

Line 190: biv_core_pkg.biv_debug(g_esc_sel_stt,biv_core_pkg.g_report_id);

186: ' || g_esc_frm_lst || g_esc_whr_cls;
187: if (g_debug_flag = 'Y') then
188: biv_core_pkg.biv_debug('statement for escalated SR',
189: biv_core_pkg.g_report_id);
190: biv_core_pkg.biv_debug(g_esc_sel_stt,biv_core_pkg.g_report_id);
191: end if;
192:
193: l_where := x_where_clause || ' ' || '
194: and nvl(stat.close_flag,''N'') != ''Y''

Line 203: biv_core_pkg.biv_debug(l_query,l_report_code);

199:
200: l_query := l_select || ' ' || l_table || ' '|| l_where;
201:
202: if g_debug_flag = 'Y' then
203: biv_core_pkg.biv_debug(l_query,l_report_code);
204: commit;
205: end if;
206:
207: l_cur_id := DBMS_SQL.OPEN_CURSOR;

Line 209: biv_core_pkg.bind_all_variables(l_cur_id);

205: end if;
206:
207: l_cur_id := DBMS_SQL.OPEN_CURSOR;
208: DBMS_SQL.PARSE(l_cur_id,l_query,DBMS_SQL.NATIVE);
209: biv_core_pkg.bind_all_variables(l_cur_id);
210: DBMS_SQL.BIND_VARIABLE(l_cur_id,':l_report_code',l_report_code);
211: DBMS_SQL.BIND_VARIABLE(l_cur_id,':x_session_id' ,g_session_id);
212: l_return_num := DBMS_SQL.EXECUTE(l_cur_id);
213: DBMS_SQL.CLOSE_CURSOR(l_cur_id);

Line 222: biv_core_pkg.biv_debug('Total Records:' || to_char(l_ttl_recs),

218: from biv_tmp_rt1
219: where report_code = l_report_code
220: and session_id = g_session_id;
221: if (g_debug_flag = 'Y') then
222: biv_core_pkg.biv_debug('Total Records:' || to_char(l_ttl_recs),
223: l_report_code);
224: end if;
225: if (l_ttl_recs > 1 /*and l_ttl_recs < biv_core_pkg.g_disp*/) then
226: l_param_str := 'BIV_RT_SR_SEV' || g_p_sp || 'jtfBinId' ||

Line 225: if (l_ttl_recs > 1 /and l_ttl_recs < biv_core_pkg.g_disp/) then

221: if (g_debug_flag = 'Y') then
222: biv_core_pkg.biv_debug('Total Records:' || to_char(l_ttl_recs),
223: l_report_code);
224: end if;
225: if (l_ttl_recs > 1 /*and l_ttl_recs < biv_core_pkg.g_disp*/) then
226: l_param_str := 'BIV_RT_SR_SEV' || g_p_sp || 'jtfBinId' ||
227: g_v_sp || 'BIV_RT_SR_SEV' || g_p_sp || l_url_param ||
228: 'P_BLOG' || g_v_sp || 'Y' || g_p_sp;
229: if (g_debug_flag = 'Y') then

Line 230: biv_core_pkg.biv_debug('going to insert total row',

226: l_param_str := 'BIV_RT_SR_SEV' || g_p_sp || 'jtfBinId' ||
227: g_v_sp || 'BIV_RT_SR_SEV' || g_p_sp || l_url_param ||
228: 'P_BLOG' || g_v_sp || 'Y' || g_p_sp;
229: if (g_debug_flag = 'Y') then
230: biv_core_pkg.biv_debug('going to insert total row',
231: l_report_code);
232: end if;
233: insert into biv_tmp_rt1 (report_code,session_id,
234: col2,col4,col6,col8,col20,

Line 248: biv_core_pkg.biv_debug('End of Report',l_report_code);

244: end if;
245: --
246: --
247: if (g_debug_flag = 'Y') then
248: biv_core_pkg.biv_debug('End of Report',l_report_code);
249: end if;
250:
251: EXCEPTION
252: WHEN OTHERS THEN

Line 256: biv_core_pkg.biv_debug(g_err,l_report_code);

252: WHEN OTHERS THEN
253: if (g_debug_flag = 'Y') then
254: g_err := 'Err in BIV_DASH_BIN_PKG.load_sr_bin:' ||
255: substr(sqlerrm,1,500);
256: biv_core_pkg.biv_debug(g_err,l_report_code);
257: end if;
258:
259: END load_sr_sum_report;
260:

Line 271: l_channel VARCHAR2(30) := biv_core_pkg.get_parameter_value(p_param_str,'P_CHNL');

267: l_where VARCHAR2(1000);
268: l_cur_id PLS_INTEGER;
269: l_return_num PLS_INTEGER := 0;
270: l_report_code VARCHAR2(30) := 'BIV_RT_SR_SEV';
271: l_channel VARCHAR2(30) := biv_core_pkg.get_parameter_value(p_param_str,'P_CHNL');
272: l_status VARCHAR2(30) := biv_core_pkg.get_parameter_value(p_param_str,'P_STS_ID');
273: l_esc VARCHAR2(30) := biv_core_pkg.get_parameter_value(p_param_str,'P_ESC_SR');
274: l_url_param VARCHAR2(50);
275: l_ogrp VARCHAR2(20) := biv_core_pkg.get_parameter_value(p_param_str,'P_OGRP');

Line 272: l_status VARCHAR2(30) := biv_core_pkg.get_parameter_value(p_param_str,'P_STS_ID');

268: l_cur_id PLS_INTEGER;
269: l_return_num PLS_INTEGER := 0;
270: l_report_code VARCHAR2(30) := 'BIV_RT_SR_SEV';
271: l_channel VARCHAR2(30) := biv_core_pkg.get_parameter_value(p_param_str,'P_CHNL');
272: l_status VARCHAR2(30) := biv_core_pkg.get_parameter_value(p_param_str,'P_STS_ID');
273: l_esc VARCHAR2(30) := biv_core_pkg.get_parameter_value(p_param_str,'P_ESC_SR');
274: l_url_param VARCHAR2(50);
275: l_ogrp VARCHAR2(20) := biv_core_pkg.get_parameter_value(p_param_str,'P_OGRP');
276: l_agrp VARCHAR2(20) := biv_core_pkg.get_parameter_value(p_param_str,'P_AGRP');

Line 273: l_esc VARCHAR2(30) := biv_core_pkg.get_parameter_value(p_param_str,'P_ESC_SR');

269: l_return_num PLS_INTEGER := 0;
270: l_report_code VARCHAR2(30) := 'BIV_RT_SR_SEV';
271: l_channel VARCHAR2(30) := biv_core_pkg.get_parameter_value(p_param_str,'P_CHNL');
272: l_status VARCHAR2(30) := biv_core_pkg.get_parameter_value(p_param_str,'P_STS_ID');
273: l_esc VARCHAR2(30) := biv_core_pkg.get_parameter_value(p_param_str,'P_ESC_SR');
274: l_url_param VARCHAR2(50);
275: l_ogrp VARCHAR2(20) := biv_core_pkg.get_parameter_value(p_param_str,'P_OGRP');
276: l_agrp VARCHAR2(20) := biv_core_pkg.get_parameter_value(p_param_str,'P_AGRP');
277: l_mgr_id VARCHAR2(20) := biv_core_pkg.get_parameter_value(p_param_str,'P_MGR_ID');

Line 275: l_ogrp VARCHAR2(20) := biv_core_pkg.get_parameter_value(p_param_str,'P_OGRP');

271: l_channel VARCHAR2(30) := biv_core_pkg.get_parameter_value(p_param_str,'P_CHNL');
272: l_status VARCHAR2(30) := biv_core_pkg.get_parameter_value(p_param_str,'P_STS_ID');
273: l_esc VARCHAR2(30) := biv_core_pkg.get_parameter_value(p_param_str,'P_ESC_SR');
274: l_url_param VARCHAR2(50);
275: l_ogrp VARCHAR2(20) := biv_core_pkg.get_parameter_value(p_param_str,'P_OGRP');
276: l_agrp VARCHAR2(20) := biv_core_pkg.get_parameter_value(p_param_str,'P_AGRP');
277: l_mgr_id VARCHAR2(20) := biv_core_pkg.get_parameter_value(p_param_str,'P_MGR_ID');
278: BEGIN
279: biv_core_pkg.g_report_id := l_report_code;

Line 276: l_agrp VARCHAR2(20) := biv_core_pkg.get_parameter_value(p_param_str,'P_AGRP');

272: l_status VARCHAR2(30) := biv_core_pkg.get_parameter_value(p_param_str,'P_STS_ID');
273: l_esc VARCHAR2(30) := biv_core_pkg.get_parameter_value(p_param_str,'P_ESC_SR');
274: l_url_param VARCHAR2(50);
275: l_ogrp VARCHAR2(20) := biv_core_pkg.get_parameter_value(p_param_str,'P_OGRP');
276: l_agrp VARCHAR2(20) := biv_core_pkg.get_parameter_value(p_param_str,'P_AGRP');
277: l_mgr_id VARCHAR2(20) := biv_core_pkg.get_parameter_value(p_param_str,'P_MGR_ID');
278: BEGIN
279: biv_core_pkg.g_report_id := l_report_code;
280: biv_core_pkg.clean_dcf_table('BIV_TMP_RT1');

Line 277: l_mgr_id VARCHAR2(20) := biv_core_pkg.get_parameter_value(p_param_str,'P_MGR_ID');

273: l_esc VARCHAR2(30) := biv_core_pkg.get_parameter_value(p_param_str,'P_ESC_SR');
274: l_url_param VARCHAR2(50);
275: l_ogrp VARCHAR2(20) := biv_core_pkg.get_parameter_value(p_param_str,'P_OGRP');
276: l_agrp VARCHAR2(20) := biv_core_pkg.get_parameter_value(p_param_str,'P_AGRP');
277: l_mgr_id VARCHAR2(20) := biv_core_pkg.get_parameter_value(p_param_str,'P_MGR_ID');
278: BEGIN
279: biv_core_pkg.g_report_id := l_report_code;
280: biv_core_pkg.clean_dcf_table('BIV_TMP_RT1');
281: g_session_id := biv_core_pkg.get_session_id;

Line 279: biv_core_pkg.g_report_id := l_report_code;

275: l_ogrp VARCHAR2(20) := biv_core_pkg.get_parameter_value(p_param_str,'P_OGRP');
276: l_agrp VARCHAR2(20) := biv_core_pkg.get_parameter_value(p_param_str,'P_AGRP');
277: l_mgr_id VARCHAR2(20) := biv_core_pkg.get_parameter_value(p_param_str,'P_MGR_ID');
278: BEGIN
279: biv_core_pkg.g_report_id := l_report_code;
280: biv_core_pkg.clean_dcf_table('BIV_TMP_RT1');
281: g_session_id := biv_core_pkg.get_session_id;
282: if (g_debug_flag = 'Y') then
283: biv_core_pkg.biv_debug('Start of Report, Params:'||

Line 280: biv_core_pkg.clean_dcf_table('BIV_TMP_RT1');

276: l_agrp VARCHAR2(20) := biv_core_pkg.get_parameter_value(p_param_str,'P_AGRP');
277: l_mgr_id VARCHAR2(20) := biv_core_pkg.get_parameter_value(p_param_str,'P_MGR_ID');
278: BEGIN
279: biv_core_pkg.g_report_id := l_report_code;
280: biv_core_pkg.clean_dcf_table('BIV_TMP_RT1');
281: g_session_id := biv_core_pkg.get_session_id;
282: if (g_debug_flag = 'Y') then
283: biv_core_pkg.biv_debug('Start of Report, Params:'||
284: p_param_str,biv_core_pkg.g_report_id);

Line 281: g_session_id := biv_core_pkg.get_session_id;

277: l_mgr_id VARCHAR2(20) := biv_core_pkg.get_parameter_value(p_param_str,'P_MGR_ID');
278: BEGIN
279: biv_core_pkg.g_report_id := l_report_code;
280: biv_core_pkg.clean_dcf_table('BIV_TMP_RT1');
281: g_session_id := biv_core_pkg.get_session_id;
282: if (g_debug_flag = 'Y') then
283: biv_core_pkg.biv_debug('Start of Report, Params:'||
284: p_param_str,biv_core_pkg.g_report_id);
285: end if;

Line 283: biv_core_pkg.biv_debug('Start of Report, Params:'||

279: biv_core_pkg.g_report_id := l_report_code;
280: biv_core_pkg.clean_dcf_table('BIV_TMP_RT1');
281: g_session_id := biv_core_pkg.get_session_id;
282: if (g_debug_flag = 'Y') then
283: biv_core_pkg.biv_debug('Start of Report, Params:'||
284: p_param_str,biv_core_pkg.g_report_id);
285: end if;
286: biv_core_pkg.get_report_parameters(p_param_str);
287:

Line 284: p_param_str,biv_core_pkg.g_report_id);

280: biv_core_pkg.clean_dcf_table('BIV_TMP_RT1');
281: g_session_id := biv_core_pkg.get_session_id;
282: if (g_debug_flag = 'Y') then
283: biv_core_pkg.biv_debug('Start of Report, Params:'||
284: p_param_str,biv_core_pkg.g_report_id);
285: end if;
286: biv_core_pkg.get_report_parameters(p_param_str);
287:
288: -- build extra params

Line 286: biv_core_pkg.get_report_parameters(p_param_str);

282: if (g_debug_flag = 'Y') then
283: biv_core_pkg.biv_debug('Start of Report, Params:'||
284: p_param_str,biv_core_pkg.g_report_id);
285: end if;
286: biv_core_pkg.get_report_parameters(p_param_str);
287:
288: -- build extra params
289: l_url_param := g_p_sp;
290: if l_ogrp is not null then

Line 322: biv_core_pkg.get_where_clause(l_table,x_where_clause);

318: l_table := l_table || ' cs_incident_severities_vl c, ';
319: l_table := l_table || ' jtf_task_references_b r, ';
320: l_table := l_table || ' jtf_tasks_b task ';
321:
322: biv_core_pkg.get_where_clause(l_table,x_where_clause);
323:
324: l_where := x_where_clause || ' and sr.incident_status_id = stat.incident_status_id ';
325: l_where := l_where || ' and sr.incident_severity_id = c.incident_severity_id ';
326: --already coming from core pkg

Line 356: biv_core_pkg.get_where_clause(l_table,x_where_clause);

352: l_table := l_table || ' from cs_incidents_vl_sec sr, ';
353: -- l_table := l_table || ' cs_incident_statuses_b b, ';
354: l_table := l_table || ' cs_incident_severities_vl c ';
355:
356: biv_core_pkg.get_where_clause(l_table,x_where_clause);
357:
358: -- l_where := x_where_clause || ' and sr.incident_status_id = b.incident_status_id ';
359: l_where := x_where_clause;
360: l_where := l_where || ' and sr.incident_severity_id = c.incident_severity_id ';

Line 373: biv_core_pkg.biv_debug(l_query,l_report_code);

369:
370: l_query := l_select || ' ' || l_table || ' '|| l_where;
371:
372: if g_debug_flag = 'Y' then
373: biv_core_pkg.biv_debug(l_query,l_report_code);
374: commit;
375: end if;
376:
377: l_cur_id := DBMS_SQL.OPEN_CURSOR;

Line 379: biv_core_pkg.bind_all_variables(l_cur_id);

375: end if;
376:
377: l_cur_id := DBMS_SQL.OPEN_CURSOR;
378: DBMS_SQL.PARSE(l_cur_id,l_query,DBMS_SQL.NATIVE);
379: biv_core_pkg.bind_all_variables(l_cur_id);
380: DBMS_SQL.BIND_VARIABLE(l_cur_id,':l_report_code',l_report_code);
381: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_session_id',g_session_id);
382: l_return_num := DBMS_SQL.EXECUTE(l_cur_id);
383: DBMS_SQL.CLOSE_CURSOR(l_cur_id);

Line 385: biv_core_pkg.biv_debug('End of Report, Params:',

381: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_session_id',g_session_id);
382: l_return_num := DBMS_SQL.EXECUTE(l_cur_id);
383: DBMS_SQL.CLOSE_CURSOR(l_cur_id);
384: if (g_debug_flag = 'Y') then
385: biv_core_pkg.biv_debug('End of Report, Params:',
386: biv_core_pkg.g_report_id);
387: end if;
388:
389: EXCEPTION

Line 386: biv_core_pkg.g_report_id);

382: l_return_num := DBMS_SQL.EXECUTE(l_cur_id);
383: DBMS_SQL.CLOSE_CURSOR(l_cur_id);
384: if (g_debug_flag = 'Y') then
385: biv_core_pkg.biv_debug('End of Report, Params:',
386: biv_core_pkg.g_report_id);
387: end if;
388:
389: EXCEPTION
390: WHEN OTHERS THEN

Line 394: biv_core_pkg.biv_debug(g_err,l_report_code);

390: WHEN OTHERS THEN
391: if (g_debug_flag = 'Y') then
392: g_err := 'Err in BIV_DASH_BIN_PKG.load_srsev_report:' ||
393: substr(sqlerrm,1,500);
394: biv_core_pkg.biv_debug(g_err,l_report_code);
395: end if;
396:
397: END load_sr_sev_report;
398:

Line 404: l_channel VARCHAR2(30) := biv_core_pkg.get_parameter_value(p_param_str,'P_CHNL');

400: FUNCTION get_sr_sev_report_name(p_param_str IN VARCHAR2 /*DEFAULT NULL*/) RETURN VARCHAR2 IS
401: l_report_name VARCHAR2(100);
402: l_tmp VARCHAR2(100);
403: l_report_code VARCHAR2(30) := 'BIV_DASH_SR_SEV_REPORT';
404: l_channel VARCHAR2(30) := biv_core_pkg.get_parameter_value(p_param_str,'P_CHNL');
405: l_status VARCHAR2(30) := biv_core_pkg.get_parameter_value(p_param_str,'P_STS_ID');
406: l_esc VARCHAR2(30) := biv_core_pkg.get_parameter_value(p_param_str,'P_ESC_LVL');
407: BEGIN
408: -- get the first word in the report name

Line 405: l_status VARCHAR2(30) := biv_core_pkg.get_parameter_value(p_param_str,'P_STS_ID');

401: l_report_name VARCHAR2(100);
402: l_tmp VARCHAR2(100);
403: l_report_code VARCHAR2(30) := 'BIV_DASH_SR_SEV_REPORT';
404: l_channel VARCHAR2(30) := biv_core_pkg.get_parameter_value(p_param_str,'P_CHNL');
405: l_status VARCHAR2(30) := biv_core_pkg.get_parameter_value(p_param_str,'P_STS_ID');
406: l_esc VARCHAR2(30) := biv_core_pkg.get_parameter_value(p_param_str,'P_ESC_LVL');
407: BEGIN
408: -- get the first word in the report name
409: select attribute_label_long into l_report_name

Line 406: l_esc VARCHAR2(30) := biv_core_pkg.get_parameter_value(p_param_str,'P_ESC_LVL');

402: l_tmp VARCHAR2(100);
403: l_report_code VARCHAR2(30) := 'BIV_DASH_SR_SEV_REPORT';
404: l_channel VARCHAR2(30) := biv_core_pkg.get_parameter_value(p_param_str,'P_CHNL');
405: l_status VARCHAR2(30) := biv_core_pkg.get_parameter_value(p_param_str,'P_STS_ID');
406: l_esc VARCHAR2(30) := biv_core_pkg.get_parameter_value(p_param_str,'P_ESC_LVL');
407: BEGIN
408: -- get the first word in the report name
409: select attribute_label_long into l_report_name
410: from ak_attributes_vl

Line 450: l_channel VARCHAR2(30) := biv_core_pkg.get_parameter_value(p_param_str,'P_CHNL');

446: FUNCTION get_sr_sev_column_label(p_param_str IN VARCHAR2 /*DEFAULT NULL*/) RETURN VARCHAR2 IS
447: l_label VARCHAR2(100);
448: l_tmp VARCHAR2(100);
449: l_report_code VARCHAR2(30) := 'BIV_DASH_SR_SEV_REPORT';
450: l_channel VARCHAR2(30) := biv_core_pkg.get_parameter_value(p_param_str,'P_CHNL');
451: l_status VARCHAR2(30) := biv_core_pkg.get_parameter_value(p_param_str,'P_STS_ID');
452: l_esc VARCHAR2(30) := biv_core_pkg.get_parameter_value(p_param_str,'P_ESC_LVL');
453: BEGIN
454: -- get the first word in the report name

Line 451: l_status VARCHAR2(30) := biv_core_pkg.get_parameter_value(p_param_str,'P_STS_ID');

447: l_label VARCHAR2(100);
448: l_tmp VARCHAR2(100);
449: l_report_code VARCHAR2(30) := 'BIV_DASH_SR_SEV_REPORT';
450: l_channel VARCHAR2(30) := biv_core_pkg.get_parameter_value(p_param_str,'P_CHNL');
451: l_status VARCHAR2(30) := biv_core_pkg.get_parameter_value(p_param_str,'P_STS_ID');
452: l_esc VARCHAR2(30) := biv_core_pkg.get_parameter_value(p_param_str,'P_ESC_LVL');
453: BEGIN
454: -- get the first word in the report name
455: select attribute_label_long into l_label

Line 452: l_esc VARCHAR2(30) := biv_core_pkg.get_parameter_value(p_param_str,'P_ESC_LVL');

448: l_tmp VARCHAR2(100);
449: l_report_code VARCHAR2(30) := 'BIV_DASH_SR_SEV_REPORT';
450: l_channel VARCHAR2(30) := biv_core_pkg.get_parameter_value(p_param_str,'P_CHNL');
451: l_status VARCHAR2(30) := biv_core_pkg.get_parameter_value(p_param_str,'P_STS_ID');
452: l_esc VARCHAR2(30) := biv_core_pkg.get_parameter_value(p_param_str,'P_ESC_LVL');
453: BEGIN
454: -- get the first word in the report name
455: select attribute_label_long into l_label
456: from ak_attributes_vl

Line 518: biv_core_pkg.bind_all_variables(l_cur);

514: and ina.incident_status_id = p_status;
515: */
516: l_cur := dbms_sql.open_cursor;
517: dbms_sql.parse(l_cur,g_esc_sel_stt,dbms_sql.native);
518: biv_core_pkg.bind_all_variables(l_cur);
519: dbms_sql.bind_variable(l_cur,':p_status', p_status);
520: dbms_sql.define_column(l_cur,1,x_val);
521: l_dummy := dbms_sql.execute(l_cur);
522: IF dbms_sql.fetch_rows(l_cur) > 0 then