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

Line 54: biv_dbi_tmpl_util.process_parameters

50: -- clear out the tables.
51: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
52: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
53:
54: biv_dbi_tmpl_util.process_parameters
55: ( p_param => p_param
56: , p_report_type => 'ACTIVITY'
57: , p_trend => 'N'
58: , x_view_by => l_view_by

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

94: );
95:
96: l_stmt := 'select
97: ' ||
98: biv_dbi_tmpl_util.get_view_by_col_name(l_view_by) || ' VIEWBY ' || '
99: , oset.' || l_view_by_col_name || ' VIEWBYID ' ||
100: case
101: when l_view_by = biv_dbi_tmpl_util.g_PRODUCT then
102: ', v.description'

Line 101: when l_view_by = biv_dbi_tmpl_util.g_PRODUCT then

97: ' ||
98: biv_dbi_tmpl_util.get_view_by_col_name(l_view_by) || ' VIEWBY ' || '
99: , oset.' || l_view_by_col_name || ' VIEWBYID ' ||
100: case
101: when l_view_by = biv_dbi_tmpl_util.g_PRODUCT then
102: ', v.description'
103: else
104: ', null'
105: end

Line 113: biv_dbi_tmpl_util.change_column('oset.c_first_opened'

109: /* First Opened Current */
110: , nvl(oset.c_first_opened,0) BIV_MEASURE2
111: /* First Opened Change */
112: , ' ||
113: biv_dbi_tmpl_util.change_column('oset.c_first_opened'
114: ,'oset.p_first_opened'
115: ,'BIV_MEASURE4') ||
116: '
117: /* Reopened Prior */

Line 123: biv_dbi_tmpl_util.change_column('oset.c_reopened'

119: /* Reopened Current */
120: , nvl(oset.c_reopened,0) BIV_MEASURE6
121: /* Reopened Change */
122: , ' ||
123: biv_dbi_tmpl_util.change_column('oset.c_reopened'
124: ,'oset.p_reopened'
125: ,'BIV_MEASURE8') ||
126: '
127: /* Opened Prior */

Line 133: biv_dbi_tmpl_util.change_column('(nvl(oset.c_first_opened,0)+nvl(oset.c_reopened,0))'

129: /* Opened Current */
130: , nvl(oset.c_first_opened,0)+nvl(oset.c_reopened,0) BIV_MEASURE10
131: /* Opened Change */
132: , ' ||
133: biv_dbi_tmpl_util.change_column('(nvl(oset.c_first_opened,0)+nvl(oset.c_reopened,0))'
134: ,'(nvl(oset.p_first_opened,0)+nvl(oset.p_reopened,0))'
135: ,'BIV_MEASURE12') ||
136: '
137: /* Closed Prior */

Line 143: biv_dbi_tmpl_util.change_column('oset.c_closed'

139: /* Closed Current */
140: , nvl(oset.c_closed,0) BIV_MEASURE14
141: /* Closed Change */
142: , ' ||
143: biv_dbi_tmpl_util.change_column('oset.c_closed'
144: ,'oset.p_closed'
145: ,'BIV_MEASURE16') ||
146: '
147: /* Open to Close Ratio Prior */

Line 149: biv_dbi_tmpl_util.rate_column('(nvl(oset.p_first_opened,0)+nvl(oset.p_reopened,0))'

145: ,'BIV_MEASURE16') ||
146: '
147: /* Open to Close Ratio Prior */
148: , ' ||
149: biv_dbi_tmpl_util.rate_column('(nvl(oset.p_first_opened,0)+nvl(oset.p_reopened,0))'
150: ,'oset.p_closed','BIV_MEASURE17'
151: ,'N') ||
152: '
153: /* Open to Close Ratio Current */

Line 155: biv_dbi_tmpl_util.rate_column('(nvl(oset.c_first_opened,0)+nvl(oset.c_reopened,0))'

151: ,'N') ||
152: '
153: /* Open to Close Ratio Current */
154: , ' ||
155: biv_dbi_tmpl_util.rate_column('(nvl(oset.c_first_opened,0)+nvl(oset.c_reopened,0))'
156: ,'oset.c_closed'
157: ,'BIV_MEASURE18'
158: ,'N') ||
159: '

Line 162: biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('(nvl(oset.c_first_opened,0)+nvl(oset.c_reopened,0))'

158: ,'N') ||
159: '
160: /* Open to Close Ratio Change */
161: , ' ||
162: biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('(nvl(oset.c_first_opened,0)+nvl(oset.c_reopened,0))'
163: ,'oset.c_closed',null,'N')
164: ,biv_dbi_tmpl_util.rate_column('(nvl(oset.p_first_opened,0)+nvl(oset.p_reopened,0))'
165: ,'oset.p_closed',null,'N')
166: ,'BIV_MEASURE20'

Line 164: ,biv_dbi_tmpl_util.rate_column('(nvl(oset.p_first_opened,0)+nvl(oset.p_reopened,0))'

160: /* Open to Close Ratio Change */
161: , ' ||
162: biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('(nvl(oset.c_first_opened,0)+nvl(oset.c_reopened,0))'
163: ,'oset.c_closed',null,'N')
164: ,biv_dbi_tmpl_util.rate_column('(nvl(oset.p_first_opened,0)+nvl(oset.p_reopened,0))'
165: ,'oset.p_closed',null,'N')
166: ,'BIV_MEASURE20'
167: ,'N') ||
168: '

Line 173: biv_dbi_tmpl_util.change_column('oset.c_first_opened_total'

169: /* GT First Opened Current */
170: , nvl(oset.c_first_opened_total,0) BIV_MEASURE21
171: /* GT First Opened Change */
172: , ' ||
173: biv_dbi_tmpl_util.change_column('oset.c_first_opened_total'
174: ,'oset.p_first_opened_total'
175: ,'BIV_MEASURE22') ||
176: '
177: /* GT Repened Current */

Line 181: biv_dbi_tmpl_util.change_column('oset.c_reopened_total'

177: /* GT Repened Current */
178: , nvl(oset.c_reopened_total,0) BIV_MEASURE23
179: /* GT Repened Change */
180: , ' ||
181: biv_dbi_tmpl_util.change_column('oset.c_reopened_total'
182: ,'oset.p_reopened_total'
183: ,'BIV_MEASURE24') ||
184: '
185: /* GT Opened Current */

Line 189: biv_dbi_tmpl_util.change_column('(nvl(oset.c_first_opened_total,0)+nvl(oset.c_reopened_total,0))'

185: /* GT Opened Current */
186: , nvl(oset.c_first_opened_total,0)+nvl(oset.c_reopened_total,0) BIV_MEASURE25
187: /* GT Opened Change */
188: , ' ||
189: biv_dbi_tmpl_util.change_column('(nvl(oset.c_first_opened_total,0)+nvl(oset.c_reopened_total,0))'
190: ,'(nvl(oset.p_first_opened_total,0)+nvl(oset.p_reopened_total,0))'
191: ,'BIV_MEASURE26') ||
192: '
193: /* GT Closed Current */

Line 197: biv_dbi_tmpl_util.change_column('oset.c_closed_total'

193: /* GT Closed Current */
194: , nvl(oset.c_closed_total,0) BIV_MEASURE27
195: /* GT Closed Change */
196: , ' ||
197: biv_dbi_tmpl_util.change_column('oset.c_closed_total'
198: ,'oset.p_closed_total'
199: ,'BIV_MEASURE28') ||
200: '
201: /* GT Open to Close Ratio Current */

Line 203: biv_dbi_tmpl_util.rate_column('(nvl(oset.c_first_opened_total,0)+nvl(oset.c_reopened_total,0))'

199: ,'BIV_MEASURE28') ||
200: '
201: /* GT Open to Close Ratio Current */
202: , ' ||
203: biv_dbi_tmpl_util.rate_column('(nvl(oset.c_first_opened_total,0)+nvl(oset.c_reopened_total,0))'
204: ,'oset.c_closed_total'
205: ,'BIV_MEASURE29'
206: ,'N') ||
207: '

Line 210: biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('(nvl(oset.c_first_opened_total,0)+nvl(oset.c_reopened_total,0))'

206: ,'N') ||
207: '
208: /* GT Open to Close Ratio Change */
209: , ' ||
210: biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('(nvl(oset.c_first_opened_total,0)+nvl(oset.c_reopened_total,0))'
211: ,'oset.c_closed_total',null,'N')
212: ,biv_dbi_tmpl_util.rate_column('(nvl(oset.p_first_opened_total,0)+nvl(oset.p_reopened_total,0))'
213: ,'oset.p_closed_total',null,'N')
214: ,'BIV_MEASURE30'

Line 212: ,biv_dbi_tmpl_util.rate_column('(nvl(oset.p_first_opened_total,0)+nvl(oset.p_reopened_total,0))'

208: /* GT Open to Close Ratio Change */
209: , ' ||
210: biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('(nvl(oset.c_first_opened_total,0)+nvl(oset.c_reopened_total,0))'
211: ,'oset.c_closed_total',null,'N')
212: ,biv_dbi_tmpl_util.rate_column('(nvl(oset.p_first_opened_total,0)+nvl(oset.p_reopened_total,0))'
213: ,'oset.p_closed_total',null,'N')
214: ,'BIV_MEASURE30'
215: ,'N') ||
216: '

Line 222: biv_dbi_tmpl_util.get_category_drill_down( l_view_by , g_activity_rep_func ) ||

218: , nvl(oset.p_first_opened_total,0)+nvl(oset.p_reopened_total,0) BIV_MEASURE31
219: /* KPI GT Closed Prior */
220: , nvl(oset.p_closed_total,0) BIV_MEASURE32
221: , ' ||
222: biv_dbi_tmpl_util.get_category_drill_down( l_view_by , g_activity_rep_func ) ||
223: '
224: from
225: ( select * from ( ' || poa_dbi_template_pkg.status_sql
226: ( P_FACT_NAME => l_mv

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

235: 'c_closed > 0 or p_closed > 0)'
236: , P_GENERATE_VIEWBY => 'Y'
237: );
238:
239: biv_dbi_tmpl_util.override_order_by(l_view_by, p_param, l_stmt);
240:
241: -- the next line can be used to dump the contents of the PMV parameters as comments into stmt
242: -- l_stmt := l_stmt || biv_dbi_tmpl_util.dump_parameters(p_param);
243:

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

238:
239: biv_dbi_tmpl_util.override_order_by(l_view_by, p_param, l_stmt);
240:
241: -- the next line can be used to dump the contents of the PMV parameters as comments into stmt
242: -- l_stmt := l_stmt || biv_dbi_tmpl_util.dump_parameters(p_param);
243:
244: x_custom_sql := l_stmt;
245:
246: poa_dbi_util_pkg.get_custom_rolling_binds

Line 287: biv_dbi_tmpl_util.process_parameters

283: -- clear out the tables.
284: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
285: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
286:
287: biv_dbi_tmpl_util.process_parameters
288: ( p_param => p_param
289: , p_report_type => 'BACKLOG'
290: , p_trend => 'N'
291: , x_view_by => l_view_by

Line 349: l_balance_fact := biv_dbi_tmpl_util.get_balance_fact(l_mv);

345: l_backlog_stmt := replace(l_backlog_stmt,'fact.report_date','cal.report_date');
346: END IF;
347:
348:
349: l_balance_fact := biv_dbi_tmpl_util.get_balance_fact(l_mv);
350:
351: -- clear out the tables.
352: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
353: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();

Line 355: biv_dbi_tmpl_util.process_parameters

351: -- clear out the tables.
352: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
353: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
354:
355: biv_dbi_tmpl_util.process_parameters
356: ( p_param => p_param
357: , p_report_type => 'ACTIVITY'
358: , p_trend => 'N'
359: , x_view_by => l_view_by

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

422:
423: l_stmt := '
424: select
425: ' ||
426: biv_dbi_tmpl_util.get_view_by_col_name(l_view_by) || ' VIEWBY ' ||
427: ', oset.' || l_view_by_col_name || ' VIEWBYID ' ||
428: case
429: when l_view_by = biv_dbi_tmpl_util.g_PRODUCT then
430: ', v.description'

Line 429: when l_view_by = biv_dbi_tmpl_util.g_PRODUCT then

425: ' ||
426: biv_dbi_tmpl_util.get_view_by_col_name(l_view_by) || ' VIEWBY ' ||
427: ', oset.' || l_view_by_col_name || ' VIEWBYID ' ||
428: case
429: when l_view_by = biv_dbi_tmpl_util.g_PRODUCT then
430: ', v.description'
431: else
432: ', null'
433: end

Line 443: biv_dbi_tmpl_util.change_column('oset.c_opened'

439: /* Opened Current */
440: , oset.c_opened BIV_MEASURE3
441: /* Opened Change */
442: , ' ||
443: biv_dbi_tmpl_util.change_column('oset.c_opened'
444: ,'oset.p_opened'
445: ,'BIV_MEASURE5') ||
446: '
447: /* Closed Prior */

Line 453: biv_dbi_tmpl_util.change_column('oset.c_closed'

449: /* Closed Current */
450: , oset.c_closed BIV_MEASURE7
451: /* Closed Change */
452: , ' ||
453: biv_dbi_tmpl_util.change_column('oset.c_closed'
454: ,'oset.p_closed'
455: ,'BIV_MEASURE9') ||
456: '
457: /* Transfer Current */

Line 465: biv_dbi_tmpl_util.change_column('oset.c_backlog'

461: /* Backlog Current */
462: , oset.c_backlog BIV_MEASURE12
463: /* Backlog Change */
464: , ' ||
465: biv_dbi_tmpl_util.change_column('oset.c_backlog'
466: ,'oset.p_backlog'
467: ,'BIV_MEASURE14') ||
468: '
469: /* GT Beginning Backlog */

Line 474: biv_dbi_tmpl_util.change_column('oset.c_opened_total'

470: , oset.o_backlog_total BIV_MEASURE15
471: /* GT Opened Current */
472: , oset.c_opened_total BIV_MEASURE16
473: , ' ||
474: biv_dbi_tmpl_util.change_column('oset.c_opened_total'
475: ,'oset.p_opened_total'
476: ,'BIV_MEASURE17') ||
477: '
478: /* GT Closed Current */

Line 482: biv_dbi_tmpl_util.change_column('oset.c_closed_total'

478: /* GT Closed Current */
479: , oset.c_closed_total BIV_MEASURE18
480: /* GT Closed Change */
481: , ' ||
482: biv_dbi_tmpl_util.change_column('oset.c_closed_total'
483: ,'oset.p_closed_total'
484: ,'BIV_MEASURE19') ||
485: '
486: /* GT Transfer Current */

Line 492: biv_dbi_tmpl_util.change_column('oset.c_backlog_total'

488: /* GT Backlog Current */
489: , oset.c_backlog_total BIV_MEASURE21
490: /* Backlog Change */
491: , ' ||
492: biv_dbi_tmpl_util.change_column('oset.c_backlog_total'
493: ,'oset.p_backlog_total'
494: ,'BIV_MEASURE22') ||
495: '
496: , ' ||

Line 497: biv_dbi_tmpl_util.get_category_drill_down( l_view_by , g_activity_backlog_rep_func ) ||

493: ,'oset.p_backlog_total'
494: ,'BIV_MEASURE22') ||
495: '
496: , ' ||
497: biv_dbi_tmpl_util.get_category_drill_down( l_view_by , g_activity_backlog_rep_func ) ||
498: '
499: , ''pFunctionName=' || g_backlog_rep_func || '&VIEW_BY_NAME=VIEW_BY_ID&VIEW_BY='
500: || case l_view_by
501: when biv_dbi_tmpl_util.g_SEVERITY then

Line 501: when biv_dbi_tmpl_util.g_SEVERITY then

497: biv_dbi_tmpl_util.get_category_drill_down( l_view_by , g_activity_backlog_rep_func ) ||
498: '
499: , ''pFunctionName=' || g_backlog_rep_func || '&VIEW_BY_NAME=VIEW_BY_ID&VIEW_BY='
500: || case l_view_by
501: when biv_dbi_tmpl_util.g_SEVERITY then
502: biv_dbi_tmpl_util.g_STATUS
503: else
504: biv_dbi_tmpl_util.g_SEVERITY
505: end

Line 502: biv_dbi_tmpl_util.g_STATUS

498: '
499: , ''pFunctionName=' || g_backlog_rep_func || '&VIEW_BY_NAME=VIEW_BY_ID&VIEW_BY='
500: || case l_view_by
501: when biv_dbi_tmpl_util.g_SEVERITY then
502: biv_dbi_tmpl_util.g_STATUS
503: else
504: biv_dbi_tmpl_util.g_SEVERITY
505: end
506: || '&pParamIds=Y'' BIV_ATTRIBUTE6

Line 504: biv_dbi_tmpl_util.g_SEVERITY

500: || case l_view_by
501: when biv_dbi_tmpl_util.g_SEVERITY then
502: biv_dbi_tmpl_util.g_STATUS
503: else
504: biv_dbi_tmpl_util.g_SEVERITY
505: end
506: || '&pParamIds=Y'' BIV_ATTRIBUTE6
507: from (
508: select

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

540: 'oset.c_closed > 0 or oset.p_closed > 0 or ' ||
541: 'oset.c_backlog > 0 or oset.p_backlog > 0)' || '
542: &ORDER_BY_CLAUSE nulls last';
543:
544: biv_dbi_tmpl_util.override_order_by(l_view_by, p_param, l_stmt);
545:
546: -- the next line can be used to dump the contents of the PMV parameters as comments into stmt
547: -- l_stmt := l_stmt || biv_dbi_tmpl_util.dump_parameters(p_param);
548:

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

543:
544: biv_dbi_tmpl_util.override_order_by(l_view_by, p_param, l_stmt);
545:
546: -- the next line can be used to dump the contents of the PMV parameters as comments into stmt
547: -- l_stmt := l_stmt || biv_dbi_tmpl_util.dump_parameters(p_param);
548:
549: x_custom_sql := l_stmt;
550:
551: poa_dbi_util_pkg.get_custom_balance_binds

Line 596: biv_dbi_tmpl_util.process_parameters

592: -- clear out the tables.
593: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
594: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
595:
596: biv_dbi_tmpl_util.process_parameters
597: ( p_param => p_param
598: , p_report_type => 'ACTIVITY'
599: , p_trend => 'Y'
600: , x_view_by => l_view_by

Line 650: biv_dbi_tmpl_util.change_column('iset.c_first_opened'

646: /* First Opened Current */
647: , nvl(iset.c_first_opened,0) BIV_MEASURE2
648: /* First Opened Change */
649: , ' ||
650: biv_dbi_tmpl_util.change_column('iset.c_first_opened'
651: ,'iset.p_first_opened'
652: ,'BIV_MEASURE3') ||
653: '
654: /* Reopened Prior */

Line 660: biv_dbi_tmpl_util.change_column('iset.c_reopened'

656: /* Reopened Current */
657: , nvl(iset.c_reopened,0) BIV_MEASURE5
658: /* Reopened Change */
659: , ' ||
660: biv_dbi_tmpl_util.change_column('iset.c_reopened'
661: ,'iset.p_reopened'
662: ,'BIV_MEASURE6') ||
663: '
664: /* Opened Prior */

Line 670: biv_dbi_tmpl_util.change_column('(nvl(iset.c_first_opened,0)+nvl(iset.c_reopened,0))'

666: /* Opened Current */
667: , nvl(iset.c_first_opened,0)+nvl(iset.c_reopened,0) BIV_MEASURE8
668: /* Opened Change */
669: , ' ||
670: biv_dbi_tmpl_util.change_column('(nvl(iset.c_first_opened,0)+nvl(iset.c_reopened,0))'
671: ,'(nvl(iset.p_first_opened,0)+nvl(iset.p_reopened,0))'
672: ,'BIV_MEASURE10') ||
673: '
674: /* Closed Prior */

Line 680: biv_dbi_tmpl_util.change_column('iset.c_closed'

676: /* Closed Current */
677: , nvl(iset.c_closed,0) BIV_MEASURE12
678: /* Closed Change */
679: , ' ||
680: biv_dbi_tmpl_util.change_column('iset.c_closed'
681: ,'iset.p_closed'
682: ,'BIV_MEASURE14') ||
683: '
684: /* Open to Close Ratio Prior */

Line 686: biv_dbi_tmpl_util.rate_column('(nvl(iset.p_first_opened,0)+nvl(iset.p_reopened,0))'

682: ,'BIV_MEASURE14') ||
683: '
684: /* Open to Close Ratio Prior */
685: , ' ||
686: biv_dbi_tmpl_util.rate_column('(nvl(iset.p_first_opened,0)+nvl(iset.p_reopened,0))'
687: ,'iset.p_closed','BIV_MEASURE15'
688: ,'N') ||
689: '
690: /* Open to Close Ratio Current */

Line 692: biv_dbi_tmpl_util.rate_column('(nvl(iset.c_first_opened,0)+nvl(iset.c_reopened,0))'

688: ,'N') ||
689: '
690: /* Open to Close Ratio Current */
691: , ' ||
692: biv_dbi_tmpl_util.rate_column('(nvl(iset.c_first_opened,0)+nvl(iset.c_reopened,0))'
693: ,'iset.c_closed'
694: ,'BIV_MEASURE16'
695: ,'N') ||
696: '

Line 699: biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('(nvl(iset.c_first_opened,0)+nvl(iset.c_reopened,0))'

695: ,'N') ||
696: '
697: /* Open to Close Ratio Change */
698: , ' ||
699: biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('(nvl(iset.c_first_opened,0)+nvl(iset.c_reopened,0))'
700: ,'iset.c_closed',null,'N')
701: ,biv_dbi_tmpl_util.rate_column('(nvl(iset.p_first_opened,0)+nvl(iset.p_reopened,0))'
702: ,'iset.p_closed',null,'N')
703: ,'BIV_MEASURE18'

Line 701: ,biv_dbi_tmpl_util.rate_column('(nvl(iset.p_first_opened,0)+nvl(iset.p_reopened,0))'

697: /* Open to Close Ratio Change */
698: , ' ||
699: biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('(nvl(iset.c_first_opened,0)+nvl(iset.c_reopened,0))'
700: ,'iset.c_closed',null,'N')
701: ,biv_dbi_tmpl_util.rate_column('(nvl(iset.p_first_opened,0)+nvl(iset.p_reopened,0))'
702: ,'iset.p_closed',null,'N')
703: ,'BIV_MEASURE18'
704: ,'N');
705:

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

723: , p_use_grpid => 'N'
724: );
725:
726: -- the next line can be used to dump the contents of the PMV parameters as comments into stmt
727: -- l_stmt := l_stmt || biv_dbi_tmpl_util.dump_parameters(p_param);
728:
729: x_custom_sql := l_stmt;
730:
731: poa_dbi_util_pkg.get_custom_trend_binds

Line 787: biv_dbi_tmpl_util.process_parameters

783: -- clear out the tables.
784: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
785: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
786:
787: biv_dbi_tmpl_util.process_parameters
788: ( p_param => p_param
789: , p_report_type => 'BACKLOG'
790: , p_trend => 'Y'
791: , x_view_by => l_view_by

Line 840: l_balance_fact := biv_dbi_tmpl_util.get_balance_fact(l_mv);

836: , p_use_grpid => 'N'
837: );
838: -- unset_last_collection;
839:
840: l_balance_fact := biv_dbi_tmpl_util.get_balance_fact(l_mv);
841:
842:
843: -- clear out the tables.
844: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();

Line 847: biv_dbi_tmpl_util.process_parameters

843: -- clear out the tables.
844: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
845: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
846:
847: biv_dbi_tmpl_util.process_parameters
848: ( p_param => p_param
849: , p_report_type => 'ACTIVITY'
850: , p_trend => 'Y'
851: , x_view_by => l_view_by

Line 926: biv_dbi_tmpl_util.change_column('uset.c_opened'

922: /* Opened Current */
923: , uset.c_opened BIV_MEASURE3
924: /* Opened Change */
925: , ' ||
926: biv_dbi_tmpl_util.change_column('uset.c_opened'
927: ,'uset.p_opened'
928: ,'BIV_MEASURE4') ||
929: '
930: /* Closed Prior */

Line 936: biv_dbi_tmpl_util.change_column('uset.c_closed'

932: /* Closed Current */
933: , uset.c_closed BIV_MEASURE6
934: /* Closed Change */
935: , ' ||
936: biv_dbi_tmpl_util.change_column('uset.c_closed'
937: ,'uset.p_closed'
938: ,'BIV_MEASURE7') ||
939: '
940: /* Transfer Current */

Line 948: biv_dbi_tmpl_util.change_column('uset.c_backlog'

944: /* Backlog Current */
945: , uset.c_backlog BIV_MEASURE10
946: /* Backlog Change */
947: , ' ||
948: biv_dbi_tmpl_util.change_column('uset.c_backlog'
949: ,'uset.p_backlog'
950: ,'BIV_MEASURE12');
951: IF (l_xtd = 'WTD')
952: THEN

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

980: group by name, start_date, end_date
981: ) uset
982: order by start_date';
983:
984: biv_dbi_tmpl_util.override_order_by(l_view_by, p_param, l_stmt);
985:
986: -- the next line can be used to dump the contents of the PMV parameters as comments into stmt
987: -- l_stmt := l_stmt || biv_dbi_tmpl_util.dump_parameters(p_param);
988:

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

983:
984: biv_dbi_tmpl_util.override_order_by(l_view_by, p_param, l_stmt);
985:
986: -- the next line can be used to dump the contents of the PMV parameters as comments into stmt
987: -- l_stmt := l_stmt || biv_dbi_tmpl_util.dump_parameters(p_param);
988:
989: x_custom_sql := l_stmt;
990:
991: poa_dbi_util_pkg.get_custom_trend_binds