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_DASH_BIN_PKG

Line 1: PACKAGE BODY BIV_DASH_BIN_PKG AS

1: PACKAGE BODY BIV_DASH_BIN_PKG AS
2: -- $Header: bivdsbnb.pls 115.26 2004/01/23 04:53:11 vganeshk ship $ */
3: -- This package is used to render the picasso BIN in dashboard
4: -- all procedure are called by seeded AK_REGION via JTF
5:

Line 98: g_err := 'Err in BIV_DASH_BIN_PKG.load_sr_bin:' ||

94: -- Change for enh 2914005 ends
95: EXCEPTION
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;

Line 164: l_select := l_select || 'biv_dash_bin_pkg.get_esc_sr_backlog(1,stat.incident_status_id) ,''INDV_ROW''';

160: l_select := l_select || g_v_sp || 'BIV_RT_SR_SEV' || g_p_sp;
161: l_select := l_select || 'P_ESC_SR' || g_v_sp || 'Y' || g_p_sp;
162: l_select := l_select || 'P_STS_ID' || g_v_sp || '''||';
163: l_select := l_select || 'stat.incident_status_id||'''||l_url_param||''', ';
164: l_select := l_select || 'biv_dash_bin_pkg.get_esc_sr_backlog(1,stat.incident_status_id) ,''INDV_ROW''';
165:
166:
167: l_table := 'FROM cs_incident_statuses_vl stat, cs_incidents_vl_sec sr ';
168:

Line 254: g_err := 'Err in BIV_DASH_BIN_PKG.load_sr_bin:' ||

250:
251: EXCEPTION
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:

Line 313: l_select := l_select || 'BIV_DASH_BIN_PKG.get_hours(min(sr.incident_date)) ';

309: l_select := l_select || '''BIV_SERVICE_REQUEST'||g_p_sp||'jtfBinId'||g_v_sp;
310: l_select := l_select || 'BIV_SERVICE_REQUEST';
311: l_select := l_select || g_p_sp||'P_ESC_SR'||g_v_sp||'Y'||g_p_sp||'P_STS_ID'||g_v_sp;
312: l_select := l_select || l_status||g_p_sp||'P_SEV'||g_v_sp||'''||c.incident_severity_id||'''||l_url_param||''', ';
313: l_select := l_select || 'BIV_DASH_BIN_PKG.get_hours(min(sr.incident_date)) ';
314:
315: -- Change for Bug 3386946
316: l_table := l_table || ' from cs_incidents_vl_sec sr, ';
317: l_table := l_table || ' cs_incident_statuses_b stat, ';

Line 349: l_select := l_select || 'BIV_DASH_BIN_PKG.get_hours(min(sr.incident_date)) ';

345: l_select := l_select || '''BIV_SERVICE_REQUEST'||g_p_sp||'jtfBinId'||g_v_sp;
346: l_select := l_select || 'BIV_SERVICE_REQUEST';
347: l_select := l_select || g_p_sp||'P_CHNL'||g_v_sp||l_channel||g_p_sp||'P_STS_ID'||g_v_sp;
348: l_select := l_select || l_status||g_p_sp||'P_SEV'||g_v_sp||'''||c.incident_severity_id||'''||l_url_param||''', ';
349: l_select := l_select || 'BIV_DASH_BIN_PKG.get_hours(min(sr.incident_date)) ';
350:
351: -- Change for Bug 3386946
352: l_table := l_table || ' from cs_incidents_vl_sec sr, ';
353: -- l_table := l_table || ' cs_incident_statuses_b b, ';

Line 392: g_err := 'Err in BIV_DASH_BIN_PKG.load_srsev_report:' ||

388:
389: EXCEPTION
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: