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_TMP_RT1

Line 121: l_param_str biv_tmp_rt1.col1 % type;

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');
125: g_session_id := biv_core_pkg.get_session_id;

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

140: if l_mgr_id is not null then
141: l_url_param := l_url_param || 'P_MGR_ID' || g_v_sp || l_mgr_id || g_p_sp;
142: end if;
143:
144: l_select := 'INSERT INTO biv_tmp_rt1(report_code,session_id,col2, col3, col4, ';
145: l_select := l_select || 'col5, col6, col7, col8,col20) ';
146: l_select := l_select || 'SELECT :l_report_code,:x_session_id,stat.name, ';
147: l_select := l_select || '''BIV_RT_SR_SEV' || g_p_sp || 'jtfBinId';
148: l_select := l_select || g_v_sp || 'BIV_RT_SR_SEV' || g_p_sp;

Line 218: from biv_tmp_rt1

214: --
215: -- Add total Row
216: --
217: select count(*) into 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),

Line 233: insert into biv_tmp_rt1 (report_code,session_id,

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,
235: col3, col5, col7)
236: select l_report_code, g_session_id, l_ttl_meaning, sum(col4),
237: sum(col6), sum(col8), 'TTL_ROW',

Line 241: from biv_tmp_rt1

237: sum(col6), sum(col8), 'TTL_ROW',
238: l_param_str || 'P_CHNL' || g_v_sp || 'WEB',
239: l_param_str || 'P_CHNL' || g_v_sp || 'PHONE',
240: l_param_str || 'P_ESC_SR' || g_v_sp || 'Y'
241: from biv_tmp_rt1
242: where report_code = l_report_code
243: and session_id = g_session_id;
244: end if;
245: --

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 302: l_select := l_select || 'INSERT INTO biv_tmp_rt1(report_code,session_id,col2,col3,col4,col5,col6) ';

298: end if;
299: l_url_param := l_url_param || 'P_BLOG' || g_v_sp || 'Y' || g_p_sp;
300:
301: If ( l_esc is not NULL ) then
302: l_select := l_select || 'INSERT INTO biv_tmp_rt1(report_code,session_id,col2,col3,col4,col5,col6) ';
303: l_select := l_select || 'select :l_report_code,:g_session_id,c.NAME, ';
304: l_select := l_select || '''BIV_SERVICE_REQUEST'||g_p_sp||'jtfBinId'||g_v_sp;
305: l_select := l_select || 'BIV_SERVICE_REQUEST';
306: l_select := l_select || g_p_sp||'P_ESC_SR'||g_v_sp||'Y'||g_p_sp||'P_STS_ID'||g_v_sp;

Line 338: l_select := l_select || 'INSERT INTO biv_tmp_rt1(report_code,session_id,col2,col3,col4,col5,col6) ';

334: l_where := l_where || ' and r.reference_code = ''ESC'' ';
335: l_where := l_where || ' and task.task_type_id = 22 ';
336: l_where := l_where || ' group by c.NAME,c.incident_severity_id ';
337: else
338: l_select := l_select || 'INSERT INTO biv_tmp_rt1(report_code,session_id,col2,col3,col4,col5,col6) ';
339: l_select := l_select || 'select :l_report_code,:g_session_id,c.NAME, ';
340: l_select := l_select || '''BIV_SERVICE_REQUEST'||g_p_sp||'jtfBinId'||g_v_sp;
341: l_select := l_select || 'BIV_SERVICE_REQUEST';
342: l_select := l_select || g_p_sp||'P_CHNL'||g_v_sp||l_channel||g_p_sp||'P_STS_ID'||g_v_sp;