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 BIV_DBI_TMPL_UTIL

Line 42: biv_dbi_tmpl_util.process_parameters

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'
45: , p_trend => 'N'
46: , x_view_by => l_view_by

Line 76: biv_dbi_tmpl_util.add_bucket_inner_query

72: , p_alias_name => 'time_to_close'
73: , p_to_date_type => l_to_date_type
74: );
75:
76: biv_dbi_tmpl_util.add_bucket_inner_query
77: ( p_short_name => 'BIV_DBI_CLOSURE_CYCLE_TIME'
78: , p_col_tbl => l_col_tbl
79: , p_col_name => 'time_to_close'
80: , p_alias_name => 'close_bucket'

Line 89: biv_dbi_tmpl_util.get_view_by_col_name(l_view_by) || ' VIEWBY ' ||

85: );
86:
87: l_stmt := 'select
88: ' ||
89: biv_dbi_tmpl_util.get_view_by_col_name(l_view_by) || ' VIEWBY ' ||
90: ', oset.' || l_view_by_col_name || ' VIEWBYID ' ||
91: case
92: when l_view_by = biv_dbi_tmpl_util.g_PRODUCT then
93: ', v.description'

Line 92: when l_view_by = biv_dbi_tmpl_util.g_PRODUCT then

88: ' ||
89: biv_dbi_tmpl_util.get_view_by_col_name(l_view_by) || ' VIEWBY ' ||
90: ', oset.' || l_view_by_col_name || ' VIEWBYID ' ||
91: case
92: when l_view_by = biv_dbi_tmpl_util.g_PRODUCT then
93: ', v.description'
94: else
95: ', null'
96: end

Line 104: biv_dbi_tmpl_util.change_column('oset.c_closed','oset.p_closed','BIV_MEASURE4') ||

100: /* Closed Current */
101: , nvl(oset.c_closed,0) BIV_MEASURE2
102: /* Closed Change */
103: , ' ||
104: biv_dbi_tmpl_util.change_column('oset.c_closed','oset.p_closed','BIV_MEASURE4') ||
105: '
106: /* Average Time To Close Prior */
107: , ' ||
108: biv_dbi_tmpl_util.rate_column('oset.p_time_to_close','oset.p_closed','BIV_MEASURE5','N') ||

Line 108: biv_dbi_tmpl_util.rate_column('oset.p_time_to_close','oset.p_closed','BIV_MEASURE5','N') ||

104: biv_dbi_tmpl_util.change_column('oset.c_closed','oset.p_closed','BIV_MEASURE4') ||
105: '
106: /* Average Time To Close Prior */
107: , ' ||
108: biv_dbi_tmpl_util.rate_column('oset.p_time_to_close','oset.p_closed','BIV_MEASURE5','N') ||
109: '
110: /* Average Time To Close Current */
111: , ' ||
112: biv_dbi_tmpl_util.rate_column('oset.c_time_to_close','oset.c_closed','BIV_MEASURE6','N') ||

Line 112: biv_dbi_tmpl_util.rate_column('oset.c_time_to_close','oset.c_closed','BIV_MEASURE6','N') ||

108: biv_dbi_tmpl_util.rate_column('oset.p_time_to_close','oset.p_closed','BIV_MEASURE5','N') ||
109: '
110: /* Average Time To Close Current */
111: , ' ||
112: biv_dbi_tmpl_util.rate_column('oset.c_time_to_close','oset.c_closed','BIV_MEASURE6','N') ||
113: '
114: /* Average Time To Close Change */
115: , ' ||
116: biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('oset.c_time_to_close','oset.c_closed',null,'N')

Line 116: biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('oset.c_time_to_close','oset.c_closed',null,'N')

112: biv_dbi_tmpl_util.rate_column('oset.c_time_to_close','oset.c_closed','BIV_MEASURE6','N') ||
113: '
114: /* Average Time To Close Change */
115: , ' ||
116: biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('oset.c_time_to_close','oset.c_closed',null,'N')
117: ,biv_dbi_tmpl_util.rate_column('oset.p_time_to_close','oset.p_closed',null,'N')
118: ,'BIV_MEASURE8'
119: ,'N') ||
120: '

Line 117: ,biv_dbi_tmpl_util.rate_column('oset.p_time_to_close','oset.p_closed',null,'N')

113: '
114: /* Average Time To Close Change */
115: , ' ||
116: biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('oset.c_time_to_close','oset.c_closed',null,'N')
117: ,biv_dbi_tmpl_util.rate_column('oset.p_time_to_close','oset.p_closed',null,'N')
118: ,'BIV_MEASURE8'
119: ,'N') ||
120: '
121: /* Time to Close Buckets */

Line 122: ' || biv_dbi_tmpl_util.get_bucket_outer_query

118: ,'BIV_MEASURE8'
119: ,'N') ||
120: '
121: /* Time to Close Buckets */
122: ' || biv_dbi_tmpl_util.get_bucket_outer_query
123: ( p_bucket_rec => l_bucket_rec
124: , p_column_name_base => 'oset.c_close_bucket'
125: , p_alias_base => 'BIV_MEASURE10'
126: , p_total_flag => 'N'

Line 136: biv_dbi_tmpl_util.change_column('oset.c_closed_total','oset.p_closed_total','BIV_MEASURE12') ||

132: /* GT Closed Current */
133: , nvl(oset.c_closed_total,0) BIV_MEASURE11
134: /* GT Closed Change */
135: , ' ||
136: biv_dbi_tmpl_util.change_column('oset.c_closed_total','oset.p_closed_total','BIV_MEASURE12') ||
137: '
138: /* GT Average Time To Close Current */
139: , ' ||
140: biv_dbi_tmpl_util.rate_column('oset.c_time_to_close_total','oset.c_closed_total','BIV_MEASURE13','N') ||

Line 140: biv_dbi_tmpl_util.rate_column('oset.c_time_to_close_total','oset.c_closed_total','BIV_MEASURE13','N') ||

136: biv_dbi_tmpl_util.change_column('oset.c_closed_total','oset.p_closed_total','BIV_MEASURE12') ||
137: '
138: /* GT Average Time To Close Current */
139: , ' ||
140: biv_dbi_tmpl_util.rate_column('oset.c_time_to_close_total','oset.c_closed_total','BIV_MEASURE13','N') ||
141: '
142: /* GT Average Time To Close Change */
143: , ' ||
144: biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('oset.c_time_to_close_total','oset.c_closed_total',null,'N')

Line 144: biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('oset.c_time_to_close_total','oset.c_closed_total',null,'N')

140: biv_dbi_tmpl_util.rate_column('oset.c_time_to_close_total','oset.c_closed_total','BIV_MEASURE13','N') ||
141: '
142: /* GT Average Time To Close Change */
143: , ' ||
144: biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('oset.c_time_to_close_total','oset.c_closed_total',null,'N')
145: ,biv_dbi_tmpl_util.rate_column('oset.p_time_to_close_total','oset.p_closed_total',null,'N')
146: ,'BIV_MEASURE14'
147: ,'N') ||
148: '

Line 145: ,biv_dbi_tmpl_util.rate_column('oset.p_time_to_close_total','oset.p_closed_total',null,'N')

141: '
142: /* GT Average Time To Close Change */
143: , ' ||
144: biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('oset.c_time_to_close_total','oset.c_closed_total',null,'N')
145: ,biv_dbi_tmpl_util.rate_column('oset.p_time_to_close_total','oset.p_closed_total',null,'N')
146: ,'BIV_MEASURE14'
147: ,'N') ||
148: '
149: /* GT Time to Close Buckets*/

Line 150: ' || biv_dbi_tmpl_util.get_bucket_outer_query

146: ,'BIV_MEASURE14'
147: ,'N') ||
148: '
149: /* GT Time to Close Buckets*/
150: ' || biv_dbi_tmpl_util.get_bucket_outer_query
151: ( p_bucket_rec => l_bucket_rec
152: , p_column_name_base => 'oset.c_close_bucket'
153: , p_alias_base => 'BIV_MEASURE15'
154: , p_total_flag => 'Y'

Line 162: biv_dbi_tmpl_util.rate_column('oset.p_time_to_close_total','oset.p_closed_total','BIV_MEASURE16','N') ||

158: ) ||
159: '
160: /* KPI GT Average Time To Close Prior */
161: , ' ||
162: biv_dbi_tmpl_util.rate_column('oset.p_time_to_close_total','oset.p_closed_total','BIV_MEASURE16','N') ||
163: '
164: , ' ||
165: biv_dbi_tmpl_util.get_category_drill_down( l_view_by
166: , case

Line 165: biv_dbi_tmpl_util.get_category_drill_down( l_view_by

161: , ' ||
162: biv_dbi_tmpl_util.rate_column('oset.p_time_to_close_total','oset.p_closed_total','BIV_MEASURE16','N') ||
163: '
164: , ' ||
165: biv_dbi_tmpl_util.get_category_drill_down( l_view_by
166: , case
167: when p_distribution = 'Y' then g_closure_dbn_rep_func
168: else g_closure_rep_func
169: end ) ||

Line 170: biv_dbi_tmpl_util.drill_detail( g_closed_detail_rep_func

166: , case
167: when p_distribution = 'Y' then g_closure_dbn_rep_func
168: else g_closure_rep_func
169: end ) ||
170: biv_dbi_tmpl_util.drill_detail( g_closed_detail_rep_func
171: , 0
172: , null
173: , 'BIV_ATTRIBUTE6') ||
174: case

Line 176: biv_dbi_tmpl_util.bucket_detail_drill( g_closed_detail_rep_func

172: , null
173: , 'BIV_ATTRIBUTE6') ||
174: case
175: when p_distribution = 'N' then
176: biv_dbi_tmpl_util.bucket_detail_drill( g_closed_detail_rep_func
177: , l_bucket_rec
178: , 'BIV_ATTRIBUTE7' )
179: else
180: null

Line 196: biv_dbi_tmpl_util.override_order_by(l_view_by, p_param, l_stmt);

192: , P_FILTER_WHERE => '(c_closed > 0 or p_closed > 0)'
193: , P_GENERATE_VIEWBY => 'Y'
194: );
195:
196: biv_dbi_tmpl_util.override_order_by(l_view_by, p_param, l_stmt);
197:
198: -- the next line can be used to dump the contents of the PMV parameters as comments into stmt
199: -- l_stmt := l_stmt || biv_dbi_tmpl_util.dump_parameters(p_param);
200:

Line 199: -- l_stmt := l_stmt || biv_dbi_tmpl_util.dump_parameters(p_param);

195:
196: biv_dbi_tmpl_util.override_order_by(l_view_by, p_param, l_stmt);
197:
198: -- the next line can be used to dump the contents of the PMV parameters as comments into stmt
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

Line 260: biv_dbi_tmpl_util.process_parameters

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'
263: , p_trend => 'Y'
264: , x_view_by => l_view_by

Line 295: biv_dbi_tmpl_util.add_bucket_inner_query

291: , p_to_date_type => l_to_date_type
292: , p_grand_total => 'N'
293: );
294:
295: biv_dbi_tmpl_util.add_bucket_inner_query
296: ( p_short_name => 'BIV_DBI_CLOSURE_CYCLE_TIME'
297: , p_col_tbl => l_col_tbl
298: , p_col_name => 'time_to_close'
299: , p_alias_name => 'close_bucket'

Line 316: biv_dbi_tmpl_util.change_column('iset.c_closed','iset.p_closed','BIV_MEASURE4') ||

312: /* Closed Current */
313: , nvl(iset.c_closed,0) BIV_MEASURE2
314: /* Closed Change */
315: , ' ||
316: biv_dbi_tmpl_util.change_column('iset.c_closed','iset.p_closed','BIV_MEASURE4') ||
317: '
318: /* Average Time To Close Prior */
319: , ' ||
320: biv_dbi_tmpl_util.rate_column('iset.p_time_to_close','iset.p_closed','BIV_MEASURE5','N') ||

Line 320: biv_dbi_tmpl_util.rate_column('iset.p_time_to_close','iset.p_closed','BIV_MEASURE5','N') ||

316: biv_dbi_tmpl_util.change_column('iset.c_closed','iset.p_closed','BIV_MEASURE4') ||
317: '
318: /* Average Time To Close Prior */
319: , ' ||
320: biv_dbi_tmpl_util.rate_column('iset.p_time_to_close','iset.p_closed','BIV_MEASURE5','N') ||
321: '
322: /* Average Time To Close Current */
323: , ' ||
324: biv_dbi_tmpl_util.rate_column('iset.c_time_to_close','iset.c_closed','BIV_MEASURE6','N') ||

Line 324: biv_dbi_tmpl_util.rate_column('iset.c_time_to_close','iset.c_closed','BIV_MEASURE6','N') ||

320: biv_dbi_tmpl_util.rate_column('iset.p_time_to_close','iset.p_closed','BIV_MEASURE5','N') ||
321: '
322: /* Average Time To Close Current */
323: , ' ||
324: biv_dbi_tmpl_util.rate_column('iset.c_time_to_close','iset.c_closed','BIV_MEASURE6','N') ||
325: '
326: /* Average Time To Close Change */
327: , ' ||
328: biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('iset.c_time_to_close','iset.c_closed',null,'N')

Line 328: biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('iset.c_time_to_close','iset.c_closed',null,'N')

324: biv_dbi_tmpl_util.rate_column('iset.c_time_to_close','iset.c_closed','BIV_MEASURE6','N') ||
325: '
326: /* Average Time To Close Change */
327: , ' ||
328: biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('iset.c_time_to_close','iset.c_closed',null,'N')
329: ,biv_dbi_tmpl_util.rate_column('iset.p_time_to_close','iset.p_closed',null,'N')
330: ,'BIV_MEASURE8'
331: ,'N') ||
332: '

Line 329: ,biv_dbi_tmpl_util.rate_column('iset.p_time_to_close','iset.p_closed',null,'N')

325: '
326: /* Average Time To Close Change */
327: , ' ||
328: biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('iset.c_time_to_close','iset.c_closed',null,'N')
329: ,biv_dbi_tmpl_util.rate_column('iset.p_time_to_close','iset.p_closed',null,'N')
330: ,'BIV_MEASURE8'
331: ,'N') ||
332: '
333: /* Time to Close Buckets */

Line 334: ' || biv_dbi_tmpl_util.get_bucket_outer_query

330: ,'BIV_MEASURE8'
331: ,'N') ||
332: '
333: /* Time to Close Buckets */
334: ' || biv_dbi_tmpl_util.get_bucket_outer_query
335: ( p_bucket_rec => l_bucket_rec
336: , p_column_name_base => 'iset.c_close_bucket'
337: , p_alias_base => 'BIV_MEASURE10'
338: , p_total_flag => 'N'

Line 366: -- l_stmt := l_stmt || biv_dbi_tmpl_util.dump_parameters(p_param);

362: , p_use_grpid => 'N'
363: );
364:
365: -- the next line can be used to dump the contents of the PMV parameters as comments into stmt
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

Line 429: biv_dbi_tmpl_util.get_detail_page_function( l_drill_url, l_sr_id );

425:
426: l_xtd varchar2(200);
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

Line 433: biv_dbi_tmpl_util.process_parameters

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'
436: , x_where_clause => l_where_clause
437: , x_mv => l_mv

Line 447: l_where_clause := replace(l_where_clause,'fact. in (&'||biv_dbi_tmpl_util.g_AGING||')'

443: );
444:
445:
446: if l_where_clause like '%%' then
447: l_where_clause := replace(l_where_clause,'fact. in (&'||biv_dbi_tmpl_util.g_AGING||')'
448: ,'(&RANGE_LOW is null or fact.age >= &RANGE_LOW) and (&RANGE_HIGH is null or fact.age < &RANGE_HIGH)');
449:
450: biv_dbi_tmpl_util.bind_low_high
451: ( p_param

Line 450: biv_dbi_tmpl_util.bind_low_high

446: if l_where_clause like '%%' then
447: l_where_clause := replace(l_where_clause,'fact. in (&'||biv_dbi_tmpl_util.g_AGING||')'
448: ,'(&RANGE_LOW is null or fact.age >= &RANGE_LOW) and (&RANGE_HIGH is null or fact.age < &RANGE_HIGH)');
449:
450: biv_dbi_tmpl_util.bind_low_high
451: ( p_param
452: , 'BIV_DBI_CLOSURE_CYCLE_TIME'
453: , '&RANGE_LOW'
454: , '&RANGE_HIGH'

Line 459: l_order_by := biv_dbi_tmpl_util.get_order_by(p_param);

455: , l_custom_output );
456:
457: end if;
458:
459: l_order_by := biv_dbi_tmpl_util.get_order_by(p_param);
460: if l_order_by like '% DESC%' then
461: if l_order_by like '%BIV_MEASURE11%' then
462: l_order_by := 'fact.closed_date desc, fact.incident_id desc';
463: else

Line 514: --|| biv_dbi_tmpl_util.dump_parameters(p_param)

510: and fact.incident_id = i.incident_id' || l_join_where || '
511: and (fact.rnk between &START_INDEX and &END_INDEX or &END_INDEX = -1)
512: &ORDER_BY_CLAUSE
513: '
514: --|| biv_dbi_tmpl_util.dump_parameters(p_param)
515: ;
516:
517: if l_custom_output is null then
518: l_custom_output := bis_query_attributes_tbl();