APPS.BIV_DASH_BIN_PKG dependencies on BIV_TMP_BIN

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 39: l_select := 'INSERT INTO biv_tmp_bin (report_code, session_id, col2, col3, col4) ';

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';
42:
43: /* Parameters being added to l_url rather than l_select to accomadate

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 92: l_total,decode(sum(col4),null,0,sum(col4)),l_totalurl from biv_tmp_bin;

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
96: WHEN OTHERS THEN