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_DBI_CLO_PKG dependencies on POA_DBI_UTIL_PKG

Line 28: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;

24: l_stmt varchar2(32767);
25:
26: l_bucket_rec bis_bucket_pub.bis_bucket_rec_type;
27:
28: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
29: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
30:
31: l_custom_output bis_query_attributes_tbl;
32:

Line 29: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

25:
26: l_bucket_rec bis_bucket_pub.bis_bucket_rec_type;
27:
28: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
29: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
30:
31: l_custom_output bis_query_attributes_tbl;
32:
33: l_to_date_type VARCHAR2 (3) ;

Line 39: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();

35:
36: begin
37:
38: -- clear out the tables.
39: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
40: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
41:
42: biv_dbi_tmpl_util.process_parameters
43: ( p_param => p_param

Line 40: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();

36: begin
37:
38: -- clear out the tables.
39: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
40: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
41:
42: biv_dbi_tmpl_util.process_parameters
43: ( p_param => p_param
44: , p_report_type => 'CLOSED'

Line 64: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl

60: l_to_date_type := 'RLX';
61: END IF;
62:
63:
64: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl
65: , p_col_name => 'closed_count'
66: , p_alias_name => 'closed'
67: , p_to_date_type => l_to_date_type
68: );

Line 70: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl

66: , p_alias_name => 'closed'
67: , p_to_date_type => l_to_date_type
68: );
69:
70: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl
71: , p_col_name => 'total_time_to_close'
72: , p_alias_name => 'time_to_close'
73: , p_to_date_type => l_to_date_type
74: );

Line 82: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

78: , p_col_tbl => l_col_tbl
79: , p_col_name => 'time_to_close'
80: , p_alias_name => 'close_bucket'
81: , p_grand_total => 'Y'
82: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS
83: , p_to_date_type => l_to_date_type
84: , x_bucket_rec => l_bucket_rec
85: );
86:

Line 203: poa_dbi_util_pkg.get_custom_rolling_binds

199: -- l_stmt := l_stmt || biv_dbi_tmpl_util.dump_parameters(p_param);
200:
201: x_custom_sql := l_stmt;
202:
203: poa_dbi_util_pkg.get_custom_rolling_binds
204: ( p_custom_output => l_custom_output
205: , p_xtd => l_xtd
206: );
207:

Line 246: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;

242: l_stmt varchar2(32767);
243:
244: l_bucket_rec bis_bucket_pub.bis_bucket_rec_type;
245:
246: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
247: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
248:
249: l_custom_output bis_query_attributes_tbl;
250:

Line 247: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

243:
244: l_bucket_rec bis_bucket_pub.bis_bucket_rec_type;
245:
246: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
247: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
248:
249: l_custom_output bis_query_attributes_tbl;
250:
251: l_to_date_type VARCHAR2 (3) ;

Line 257: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();

253:
254: begin
255:
256: -- clear out the tables.
257: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
258: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
259:
260: biv_dbi_tmpl_util.process_parameters
261: ( p_param => p_param

Line 258: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();

254: begin
255:
256: -- clear out the tables.
257: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
258: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
259:
260: biv_dbi_tmpl_util.process_parameters
261: ( p_param => p_param
262: , p_report_type => 'CLOSED'

Line 281: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl

277: ELSE
278: l_to_date_type := 'RLX';
279: END IF;
280:
281: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl
282: , p_col_name => 'closed_count'
283: , p_alias_name => 'closed'
284: , p_to_date_type => l_to_date_type
285: , p_grand_total => 'N'

Line 288: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl

284: , p_to_date_type => l_to_date_type
285: , p_grand_total => 'N'
286: );
287:
288: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl
289: , p_col_name => 'total_time_to_close'
290: , p_alias_name => 'time_to_close'
291: , p_to_date_type => l_to_date_type
292: , p_grand_total => 'N'

Line 301: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

297: , p_col_tbl => l_col_tbl
298: , p_col_name => 'time_to_close'
299: , p_alias_name => 'close_bucket'
300: , p_grand_total => 'N'
301: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS
302: , p_to_date_type => l_to_date_type
303: , x_bucket_rec => l_bucket_rec
304: );
305:

Line 370: poa_dbi_util_pkg.get_custom_trend_binds

366: -- l_stmt := l_stmt || biv_dbi_tmpl_util.dump_parameters(p_param);
367:
368: x_custom_sql := l_stmt;
369:
370: poa_dbi_util_pkg.get_custom_trend_binds
371: ( x_custom_output => l_custom_output
372: , p_xtd => l_xtd
373: , p_comparison_type => l_comparison_type
374: );

Line 376: poa_dbi_util_pkg.get_custom_rolling_binds

372: , p_xtd => l_xtd
373: , p_comparison_type => l_comparison_type
374: );
375:
376: poa_dbi_util_pkg.get_custom_rolling_binds
377: ( p_custom_output => l_custom_output
378: , p_xtd => l_xtd
379: );
380:

Line 383: poa_dbi_util_pkg.get_custom_day_binds(p_custom_output => l_custom_output,

379: );
380:
381: IF(l_xtd = 'DAY')
382: THEN
383: poa_dbi_util_pkg.get_custom_day_binds(p_custom_output => l_custom_output,
384: p_as_of_date => l_as_of_date,
385: p_comparison_type => l_comparison_type);
386: null;
387: END IF;

Line 422: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

418: l_order_by varchar2(100);
419: l_drill_url varchar2(500);
420: l_sr_id varchar2(100);
421:
422: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
423: l_custom_output bis_query_attributes_tbl;
424: l_as_of_date date;
425:
426: l_xtd varchar2(200);

Line 431: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();

427: begin
428:
429: biv_dbi_tmpl_util.get_detail_page_function( l_drill_url, l_sr_id );
430:
431: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
432:
433: biv_dbi_tmpl_util.process_parameters
434: ( p_param => p_param
435: , p_report_type => 'CLOSED_DETAIL'