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_RES_PKG dependencies on BIV_DBI_TMPL_UTIL

Line 41: biv_dbi_tmpl_util.process_parameters

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: biv_dbi_tmpl_util.process_parameters
42: ( p_param => p_param
43: , p_report_type => 'RESOLVED'
44: , p_trend => 'N'
45: , x_view_by => l_view_by

Line 75: biv_dbi_tmpl_util.add_bucket_inner_query

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

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

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

Line 91: when l_view_by = biv_dbi_tmpl_util.g_PRODUCT then

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

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

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

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

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

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

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

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

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

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

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

Line 121: ' || biv_dbi_tmpl_util.get_bucket_outer_query

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

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

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

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

135: biv_dbi_tmpl_util.change_column('oset.c_closed_total','oset.p_closed_total','BIV_MEASURE12') ||
136: '
137: /* GT Average Time To Close Current */
138: , ' ||
139: biv_dbi_tmpl_util.rate_column('oset.c_time_to_close_total','oset.c_closed_total','BIV_MEASURE13','N') ||
140: '
141: /* GT Average Time To Close Change */
142: , ' ||
143: 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 143: biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('oset.c_time_to_close_total','oset.c_closed_total',null,'N')

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

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

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

Line 149: ' || biv_dbi_tmpl_util.get_bucket_outer_query

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

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

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

Line 164: biv_dbi_tmpl_util.get_category_drill_down( l_view_by

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

Line 169: biv_dbi_tmpl_util.drill_detail( g_closed_detail_rep_func

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

Line 175: biv_dbi_tmpl_util.bucket_detail_drill( g_closed_detail_rep_func

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

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

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

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

194:
195: biv_dbi_tmpl_util.override_order_by(l_view_by, p_param, l_stmt);
196:
197: -- the next line can be used to dump the contents of the PMV parameters as comments into stmt
198: -- l_stmt := l_stmt || biv_dbi_tmpl_util.dump_parameters(p_param);
199:
200: x_custom_sql := l_stmt;
201:
202: poa_dbi_util_pkg.get_custom_rolling_binds

Line 259: biv_dbi_tmpl_util.process_parameters

255: -- clear out the tables.
256: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
257: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
258:
259: biv_dbi_tmpl_util.process_parameters
260: ( p_param => p_param
261: , p_report_type => 'RESOLVED'
262: , p_trend => 'Y'
263: , 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_RESOLUTION_CYCLE_TIME'
297: , p_col_tbl => l_col_tbl
298: , p_col_name => 'time_to_resolution'
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 431: biv_dbi_tmpl_util.get_detail_page_function( l_drill_url, l_sr_id );

427: l_xtd varchar2(200);
428:
429: begin
430:
431: biv_dbi_tmpl_util.get_detail_page_function( l_drill_url, l_sr_id );
432:
433: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
434:
435: biv_dbi_tmpl_util.process_parameters

Line 435: biv_dbi_tmpl_util.process_parameters

431: biv_dbi_tmpl_util.get_detail_page_function( l_drill_url, l_sr_id );
432:
433: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
434:
435: biv_dbi_tmpl_util.process_parameters
436: ( p_param => p_param
437: , p_report_type => 'RESOLVED_DETAIL'
438: , x_where_clause => l_where_clause
439: , x_mv => l_mv

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

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

Line 451: biv_dbi_tmpl_util.bind_low_high

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

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

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

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

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