APPS.BIV_DBI_BAK_PKG dependencies on BIV_DBI_TMPL_UTIL

Line 22: if p_view_by = biv_dbi_tmpl_util.g_AGING then

18: is
19:
20: begin
21:
22: if p_view_by = biv_dbi_tmpl_util.g_AGING then
23: return 'null ' || p_alias;
24: end if;
25:
26: return 'case when &BIS_CURRENT_ASOF_DATE >= &LAST_COLLECTION then ' ||

Line 41: when biv_dbi_tmpl_util.g_SEVERITY then

37: '&BACKLOG_TYPE=UNOWNED'
38: end
39: || '&VIEW_BY_NAME=VIEW_BY_ID&VIEW_BY='
40: || case p_view_by
41: when biv_dbi_tmpl_util.g_SEVERITY then
42: biv_dbi_tmpl_util.g_STATUS
43: else
44: biv_dbi_tmpl_util.g_SEVERITY
45: end

Line 42: biv_dbi_tmpl_util.g_STATUS

38: end
39: || '&VIEW_BY_NAME=VIEW_BY_ID&VIEW_BY='
40: || case p_view_by
41: when biv_dbi_tmpl_util.g_SEVERITY then
42: biv_dbi_tmpl_util.g_STATUS
43: else
44: biv_dbi_tmpl_util.g_SEVERITY
45: end
46: || '&pParamIds=Y'' else null end '

Line 44: biv_dbi_tmpl_util.g_SEVERITY

40: || case p_view_by
41: when biv_dbi_tmpl_util.g_SEVERITY then
42: biv_dbi_tmpl_util.g_STATUS
43: else
44: biv_dbi_tmpl_util.g_SEVERITY
45: end
46: || '&pParamIds=Y'' else null end '
47: || p_alias;
48: end drill_across;

Line 62: if p_view_by = biv_dbi_tmpl_util.g_AGING then

58: is
59:
60: begin
61:
62: if p_view_by = biv_dbi_tmpl_util.g_AGING then
63: return 'null ' || p_alias;
64: end if;
65:
66: return 'case when &BIS_CURRENT_ASOF_DATE >= &LAST_COLLECTION then ' ||

Line 81: when biv_dbi_tmpl_util.g_SEVERITY then

77: '&BACKLOG_TYPE=UNOWNED'
78: end
79: || '&VIEW_BY_NAME=VIEW_BY_ID&VIEW_BY='
80: || case p_view_by
81: when biv_dbi_tmpl_util.g_SEVERITY then
82: biv_dbi_tmpl_util.g_STATUS
83: else
84: biv_dbi_tmpl_util.g_SEVERITY
85: end

Line 82: biv_dbi_tmpl_util.g_STATUS

78: end
79: || '&VIEW_BY_NAME=VIEW_BY_ID&VIEW_BY='
80: || case p_view_by
81: when biv_dbi_tmpl_util.g_SEVERITY then
82: biv_dbi_tmpl_util.g_STATUS
83: else
84: biv_dbi_tmpl_util.g_SEVERITY
85: end
86: || '&BIV_RES_STATUS=N&pParamIds=Y'' else null end '

Line 84: biv_dbi_tmpl_util.g_SEVERITY

80: || case p_view_by
81: when biv_dbi_tmpl_util.g_SEVERITY then
82: biv_dbi_tmpl_util.g_STATUS
83: else
84: biv_dbi_tmpl_util.g_SEVERITY
85: end
86: || '&BIV_RES_STATUS=N&pParamIds=Y'' else null end '
87: || p_alias;
88: end unr_drill_across;

Line 138: biv_dbi_tmpl_util.process_parameters

134: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
135: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
136:
137:
138: biv_dbi_tmpl_util.process_parameters
139: ( p_param => p_param
140: , p_report_type => 'BACKLOG'
141: , p_trend => 'N'
142: , x_view_by => l_view_by

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

178: );
179:
180: l_stmt := 'select
181: ' ||
182: biv_dbi_tmpl_util.get_view_by_col_name(l_view_by) || ' VIEWBY ' ||
183: ', oset.' || l_view_by_col_name || ' VIEWBYID ' ||
184: '
185: ' ||
186: case

Line 187: when l_view_by = biv_dbi_tmpl_util.g_PRODUCT then

183: ', oset.' || l_view_by_col_name || ' VIEWBYID ' ||
184: '
185: ' ||
186: case
187: when l_view_by = biv_dbi_tmpl_util.g_PRODUCT then
188: ', v.description'
189: else
190: ', null'
191: end

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

195: /* Backlog Current */
196: , nvl(oset.c_backlog,0) BIV_MEASURE2
197: /* Backlog Change */
198: , ' ||
199: biv_dbi_tmpl_util.change_column('oset.c_backlog'
200: ,'oset.p_backlog'
201: ,'BIV_MEASURE4') ||
202: '
203: /* Escalated Prior */

Line 209: biv_dbi_tmpl_util.change_column('oset.c_escalated'

205: /* Escalated Current */
206: , nvl(oset.c_escalated,0) BIV_MEASURE10
207: /* Escalated Change */
208: , ' ||
209: biv_dbi_tmpl_util.change_column('oset.c_escalated'
210: ,'oset.p_escalated'
211: ,'BIV_MEASURE12') ||
212: '
213: /* Unowned Prior */

Line 219: biv_dbi_tmpl_util.change_column('oset.c_unowned'

215: /* Unowned Current */
216: , nvl(oset.c_unowned,0) BIV_MEASURE14
217: /* Unowned Change */
218: , ' ||
219: biv_dbi_tmpl_util.change_column('oset.c_unowned'
220: ,'oset.p_unowned'
221: ,'BIV_MEASURE16') ||
222: '
223: /* GT Backlog Current */

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

223: /* GT Backlog Current */
224: , nvl(oset.c_backlog_total,0) BIV_MEASURE17
225: /* GT Backlog Change */
226: , ' ||
227: biv_dbi_tmpl_util.change_column('oset.c_backlog_total'
228: ,'oset.p_backlog_total'
229: ,'BIV_MEASURE18') ||
230: '
231: /* GT Escalated Current */

Line 235: biv_dbi_tmpl_util.change_column('oset.c_escalated_total'

231: /* GT Escalated Current */
232: , nvl(oset.c_escalated_total,0) BIV_MEASURE21
233: /* GT Escalated Change */
234: , ' ||
235: biv_dbi_tmpl_util.change_column('oset.c_escalated_total'
236: ,'oset.p_escalated_total'
237: ,'BIV_MEASURE22') ||
238: '
239: /* GT Unowned Current */

Line 243: biv_dbi_tmpl_util.change_column('oset.c_unowned_total'

239: /* GT Unowned Current */
240: , nvl(oset.c_unowned_total,0) BIV_MEASURE23
241: /* GT Unowned Change */
242: , ' ||
243: biv_dbi_tmpl_util.change_column('oset.c_unowned_total'
244: ,'oset.p_unowned_total'
245: ,'BIV_MEASURE24') ||
246: '
247: , ' ||

Line 248: biv_dbi_tmpl_util.get_category_drill_down( l_view_by, g_backlog_rep_func ) ||

244: ,'oset.p_unowned_total'
245: ,'BIV_MEASURE24') ||
246: '
247: , ' ||
248: biv_dbi_tmpl_util.get_category_drill_down( l_view_by, g_backlog_rep_func ) ||
249: '
250: , ' ||
251: drill_across('N','BACKLOG', 'oset.c_backlog', 'BIV_ATTRIBUTE6',l_view_by) ||
252: '

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

268: , p_filter_where => '(c_backlog > 0 or p_backlog > 0)'
269: , p_generate_viewby => 'Y'
270: );
271:
272: biv_dbi_tmpl_util.override_order_by(l_view_by, p_param, l_stmt);
273:
274: -- the next line can be used to dump the contents of the PMV parameters as comments into stmt
275: l_stmt := l_stmt || biv_dbi_tmpl_util.dump_parameters(p_param);
276:

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

271:
272: biv_dbi_tmpl_util.override_order_by(l_view_by, p_param, l_stmt);
273:
274: -- the next line can be used to dump the contents of the PMV parameters as comments into stmt
275: l_stmt := l_stmt || biv_dbi_tmpl_util.dump_parameters(p_param);
276:
277:
278: x_custom_sql := l_stmt;
279: -- unset_last_collection;

Line 283: , p_balance_fact => biv_dbi_tmpl_util.get_balance_fact(l_mv)

279: -- unset_last_collection;
280:
281: poa_dbi_util_pkg.get_custom_balance_binds
282: ( p_custom_output => l_custom_output
283: , p_balance_fact => biv_dbi_tmpl_util.get_balance_fact(l_mv)
284: , p_xtd => l_xtd
285: );
286:
287: x_custom_output := l_custom_output;

Line 289: l_stmt := biv_dbi_tmpl_util.dump_binds(l_custom_output);

285: );
286:
287: x_custom_output := l_custom_output;
288:
289: l_stmt := biv_dbi_tmpl_util.dump_binds(l_custom_output);
290:
291: end get_tbl_sql;
292:
293: procedure get_dbn_tbl_sql

Line 322: biv_dbi_tmpl_util.process_parameters

318: -- clear out the tables.
319: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
320: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
321:
322: biv_dbi_tmpl_util.process_parameters
323: ( p_param => p_param
324: , p_report_type => 'BACKLOG'
325: , p_trend => 'N'
326: , x_view_by => l_view_by

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

360: );
361:
362: l_stmt := 'select
363: ' ||
364: biv_dbi_tmpl_util.get_view_by_col_name(l_view_by) || ' VIEWBY ' ||
365: ', oset.' || l_view_by_col_name || ' VIEWBYID ' ||
366: '
367: ' ||
368: case

Line 369: when l_view_by = biv_dbi_tmpl_util.g_PRODUCT then

365: ', oset.' || l_view_by_col_name || ' VIEWBYID ' ||
366: '
367: ' ||
368: case
369: when l_view_by = biv_dbi_tmpl_util.g_PRODUCT then
370: ', v.description'
371: else
372: ', null'
373: end

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

377: /* Backlog Current */
378: , nvl(oset.c_backlog,0) BIV_MEASURE2
379: /* Backlog Change */
380: , ' ||
381: biv_dbi_tmpl_util.change_column('oset.c_backlog'
382: ,'oset.p_backlog'
383: ,'BIV_MEASURE4') ||
384: '
385: /* Percent of Total Prior */

Line 387: biv_dbi_tmpl_util.rate_column('oset.p_backlog'

383: ,'BIV_MEASURE4') ||
384: '
385: /* Percent of Total Prior */
386: , ' ||
387: biv_dbi_tmpl_util.rate_column('oset.p_backlog'
388: ,'oset.p_backlog_total'
389: ,'BIV_MEASURE5') ||
390: '
391: /* Percent of Total Current */

Line 393: biv_dbi_tmpl_util.rate_column('oset.c_backlog'

389: ,'BIV_MEASURE5') ||
390: '
391: /* Percent of Total Current */
392: , ' ||
393: biv_dbi_tmpl_util.rate_column('oset.c_backlog'
394: ,'oset.c_backlog_total'
395: ,'BIV_MEASURE6') ||
396: '
397: /* Percent of Total Change */

Line 399: biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('oset.c_backlog'

395: ,'BIV_MEASURE6') ||
396: '
397: /* Percent of Total Change */
398: , ' ||
399: biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('oset.c_backlog'
400: ,'oset.c_backlog_total'
401: ,null)
402: ,biv_dbi_tmpl_util.rate_column('oset.p_backlog'
403: ,'oset.p_backlog_total'

Line 402: ,biv_dbi_tmpl_util.rate_column('oset.p_backlog'

398: , ' ||
399: biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('oset.c_backlog'
400: ,'oset.c_backlog_total'
401: ,null)
402: ,biv_dbi_tmpl_util.rate_column('oset.p_backlog'
403: ,'oset.p_backlog_total'
404: ,null)
405: ,'BIV_MEASURE8'
406: ,'N') ||

Line 410: biv_dbi_tmpl_util.rate_column('nvl(oset.p_escalated,0)'

406: ,'N') ||
407: '
408: /* Escalated Percent Prior */
409: , ' ||
410: biv_dbi_tmpl_util.rate_column('nvl(oset.p_escalated,0)'
411: ,'oset.p_backlog'
412: ,'BIV_MEASURE9') ||
413: '
414: /* Escalated Percent Current */

Line 416: biv_dbi_tmpl_util.rate_column('nvl(oset.c_escalated,0)'

412: ,'BIV_MEASURE9') ||
413: '
414: /* Escalated Percent Current */
415: , ' ||
416: biv_dbi_tmpl_util.rate_column('nvl(oset.c_escalated,0)'
417: ,'oset.c_backlog'
418: ,'BIV_MEASURE10') ||
419: '
420: /* Escalated Percent Change */

Line 422: biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('nvl(oset.c_escalated,0)'

418: ,'BIV_MEASURE10') ||
419: '
420: /* Escalated Percent Change */
421: , ' ||
422: biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('nvl(oset.c_escalated,0)'
423: ,'oset.c_backlog'
424: ,null)
425: ,biv_dbi_tmpl_util.rate_column('nvl(oset.p_escalated,0)'
426: ,'oset.p_backlog'

Line 425: ,biv_dbi_tmpl_util.rate_column('nvl(oset.p_escalated,0)'

421: , ' ||
422: biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('nvl(oset.c_escalated,0)'
423: ,'oset.c_backlog'
424: ,null)
425: ,biv_dbi_tmpl_util.rate_column('nvl(oset.p_escalated,0)'
426: ,'oset.p_backlog'
427: ,null)
428: ,'BIV_MEASURE12'
429: ,'N') ||

Line 433: biv_dbi_tmpl_util.rate_column('nvl(oset.p_unowned,0)'

429: ,'N') ||
430: '
431: /* Unowned Percent Prior */
432: , ' ||
433: biv_dbi_tmpl_util.rate_column('nvl(oset.p_unowned,0)'
434: ,'oset.p_backlog'
435: ,'BIV_MEASURE13') ||
436: '
437: /* Unowned Percent Current */

Line 439: biv_dbi_tmpl_util.rate_column('nvl(oset.c_unowned,0)'

435: ,'BIV_MEASURE13') ||
436: '
437: /* Unowned Percent Current */
438: , ' ||
439: biv_dbi_tmpl_util.rate_column('nvl(oset.c_unowned,0)'
440: ,'oset.c_backlog'
441: ,'BIV_MEASURE14') ||
442: '
443: /* Unowned Percent Change */

Line 445: biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('nvl(oset.c_unowned,0)'

441: ,'BIV_MEASURE14') ||
442: '
443: /* Unowned Percent Change */
444: , ' ||
445: biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('nvl(oset.c_unowned,0)'
446: ,'oset.c_backlog'
447: ,null)
448: ,biv_dbi_tmpl_util.rate_column('nvl(oset.p_unowned,0)'
449: ,'oset.p_backlog'

Line 448: ,biv_dbi_tmpl_util.rate_column('nvl(oset.p_unowned,0)'

444: , ' ||
445: biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('nvl(oset.c_unowned,0)'
446: ,'oset.c_backlog'
447: ,null)
448: ,biv_dbi_tmpl_util.rate_column('nvl(oset.p_unowned,0)'
449: ,'oset.p_backlog'
450: ,null)
451: ,'BIV_MEASURE16'
452: ,'N') ||

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

454: /* GT Backlog Current */
455: , nvl(oset.c_backlog_total,0) BIV_MEASURE17
456: /* GT Backlog Change */
457: , ' ||
458: biv_dbi_tmpl_util.change_column('oset.c_backlog_total'
459: ,'oset.p_backlog_total'
460: ,'BIV_MEASURE18') ||
461: '
462: /* GT Percent of Total Current */

Line 466: biv_dbi_tmpl_util.rate_column('nvl(oset.c_escalated_total,0)'

462: /* GT Percent of Total Current */
463: , 100 BIV_MEASURE19
464: /* GT Escalated Percent Current */
465: , ' ||
466: biv_dbi_tmpl_util.rate_column('nvl(oset.c_escalated_total,0)'
467: ,'oset.c_backlog_total'
468: ,'BIV_MEASURE21') ||
469: '
470: /* GT Escalated Percent Change */

Line 472: biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('nvl(oset.c_escalated_total,0)'

468: ,'BIV_MEASURE21') ||
469: '
470: /* GT Escalated Percent Change */
471: , ' ||
472: biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('nvl(oset.c_escalated_total,0)'
473: ,'oset.c_backlog_total'
474: ,null)
475: ,biv_dbi_tmpl_util.rate_column('nvl(oset.p_escalated_total,0)'
476: ,'oset.p_backlog_total'

Line 475: ,biv_dbi_tmpl_util.rate_column('nvl(oset.p_escalated_total,0)'

471: , ' ||
472: biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('nvl(oset.c_escalated_total,0)'
473: ,'oset.c_backlog_total'
474: ,null)
475: ,biv_dbi_tmpl_util.rate_column('nvl(oset.p_escalated_total,0)'
476: ,'oset.p_backlog_total'
477: ,null)
478: ,'BIV_MEASURE22'
479: ,'N') ||

Line 483: biv_dbi_tmpl_util.rate_column('nvl(oset.c_unowned_total,0)'

479: ,'N') ||
480: '
481: /* GT Unowned Percent Current */
482: , ' ||
483: biv_dbi_tmpl_util.rate_column('nvl(oset.c_unowned_total,0)'
484: ,'oset.c_backlog_total'
485: ,'BIV_MEASURE23') ||
486: '
487: /* GT Unowned Percent Change */

Line 489: biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('nvl(oset.c_unowned_total,0)'

485: ,'BIV_MEASURE23') ||
486: '
487: /* GT Unowned Percent Change */
488: , ' ||
489: biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('nvl(oset.c_unowned_total,0)'
490: ,'oset.c_backlog_total'
491: ,null)
492: ,biv_dbi_tmpl_util.rate_column('nvl(oset.p_unowned_total,0)'
493: ,'oset.p_backlog_total'

Line 492: ,biv_dbi_tmpl_util.rate_column('nvl(oset.p_unowned_total,0)'

488: , ' ||
489: biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('nvl(oset.c_unowned_total,0)'
490: ,'oset.c_backlog_total'
491: ,null)
492: ,biv_dbi_tmpl_util.rate_column('nvl(oset.p_unowned_total,0)'
493: ,'oset.p_backlog_total'
494: ,null)
495: ,'BIV_MEASURE24'
496: ,'N') ||

Line 502: biv_dbi_tmpl_util.rate_column('nvl(oset.p_escalated_total,0)'

498: /* KPI GT Backlog Prior */
499: , nvl(oset.p_backlog_total,0) BIV_MEASURE31
500: /* KPI GT Escalated Percent Prior */
501: , ' ||
502: biv_dbi_tmpl_util.rate_column('nvl(oset.p_escalated_total,0)'
503: ,'oset.p_backlog_total'
504: ,'BIV_MEASURE32') ||
505: '
506: /* KPI GT Unowned Percent Prior */

Line 508: biv_dbi_tmpl_util.rate_column('nvl(oset.p_unowned_total,0)'

504: ,'BIV_MEASURE32') ||
505: '
506: /* KPI GT Unowned Percent Prior */
507: , ' ||
508: biv_dbi_tmpl_util.rate_column('nvl(oset.p_unowned_total,0)'
509: ,'oset.p_backlog_total'
510: ,'BIV_MEASURE33') ||
511: '
512: , ' ||

Line 513: biv_dbi_tmpl_util.get_category_drill_down( l_view_by, g_backlog_dbn_rep_func ) ||

509: ,'oset.p_backlog_total'
510: ,'BIV_MEASURE33') ||
511: '
512: , ' ||
513: biv_dbi_tmpl_util.get_category_drill_down( l_view_by, g_backlog_dbn_rep_func ) ||
514: '
515: , ' ||
516: drill_across('Y','BACKLOG', 'oset.c_backlog', 'BIV_ATTRIBUTE6',l_view_by) ||
517: '

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

527: , p_filter_where => '(c_backlog > 0 or p_backlog > 0)'
528: , p_generate_viewby => 'Y'
529: );
530:
531: biv_dbi_tmpl_util.override_order_by(l_view_by, p_param, l_stmt);
532:
533: -- the next line can be used to dump the contents of the PMV parameters as comments into stmt
534: -- l_stmt := l_stmt || biv_dbi_tmpl_util.dump_parameters(p_param);
535:

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

530:
531: biv_dbi_tmpl_util.override_order_by(l_view_by, p_param, l_stmt);
532:
533: -- the next line can be used to dump the contents of the PMV parameters as comments into stmt
534: -- l_stmt := l_stmt || biv_dbi_tmpl_util.dump_parameters(p_param);
535:
536: x_custom_sql := l_stmt;
537: -- unset_last_collection;
538:

Line 542: , p_balance_fact => biv_dbi_tmpl_util.get_balance_fact(l_mv)

538:
539:
540: poa_dbi_util_pkg.get_custom_balance_binds
541: ( p_custom_output => l_custom_output
542: , p_balance_fact => biv_dbi_tmpl_util.get_balance_fact(l_mv)
543: , p_xtd => l_xtd
544: );
545:
546: x_custom_output := l_custom_output;

Line 580: biv_dbi_tmpl_util.process_parameters

576: -- clear out the tables.
577: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
578: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
579:
580: biv_dbi_tmpl_util.process_parameters
581: ( p_param => p_param
582: , p_report_type => 'BACKLOG'
583: , p_trend => 'N'
584: , x_view_by => l_view_by

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

620: );
621:
622: l_stmt := 'select
623: ' ||
624: biv_dbi_tmpl_util.get_view_by_col_name(l_view_by) || ' VIEWBY ' ||
625: ', oset.' || l_view_by_col_name || ' VIEWBYID ' ||
626: '
627: ' ||
628: case

Line 629: when l_view_by = biv_dbi_tmpl_util.g_PRODUCT then

625: ', oset.' || l_view_by_col_name || ' VIEWBYID ' ||
626: '
627: ' ||
628: case
629: when l_view_by = biv_dbi_tmpl_util.g_PRODUCT then
630: ', v.description'
631: else
632: ', null'
633: end

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

637: /* Backlog Current */
638: , nvl(oset.c_backlog,0) BIV_MEASURE2
639: /* Backlog Change */
640: , ' ||
641: biv_dbi_tmpl_util.change_column('oset.c_backlog'
642: ,'oset.p_backlog'
643: ,'BIV_MEASURE4') ||
644: '
645: /* Percent of Total Prior */

Line 647: biv_dbi_tmpl_util.rate_column('oset.p_backlog'

643: ,'BIV_MEASURE4') ||
644: '
645: /* Percent of Total Prior */
646: , ' ||
647: biv_dbi_tmpl_util.rate_column('oset.p_backlog'
648: ,'oset.p_backlog_total'
649: ,'BIV_MEASURE5') ||
650: '
651: /* Percent of Total Current */

Line 653: biv_dbi_tmpl_util.rate_column('oset.c_backlog'

649: ,'BIV_MEASURE5') ||
650: '
651: /* Percent of Total Current */
652: , ' ||
653: biv_dbi_tmpl_util.rate_column('oset.c_backlog'
654: ,'oset.c_backlog_total'
655: ,'BIV_MEASURE6') ||
656: '
657: /* Percent of Total Change */

Line 659: biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('oset.c_backlog'

655: ,'BIV_MEASURE6') ||
656: '
657: /* Percent of Total Change */
658: , ' ||
659: biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('oset.c_backlog'
660: ,'oset.c_backlog_total'
661: ,null)
662: ,biv_dbi_tmpl_util.rate_column('oset.p_backlog'
663: ,'oset.p_backlog_total'

Line 662: ,biv_dbi_tmpl_util.rate_column('oset.p_backlog'

658: , ' ||
659: biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('oset.c_backlog'
660: ,'oset.c_backlog_total'
661: ,null)
662: ,biv_dbi_tmpl_util.rate_column('oset.p_backlog'
663: ,'oset.p_backlog_total'
664: ,null)
665: ,'BIV_MEASURE8'
666: ,'N') ||

Line 670: biv_dbi_tmpl_util.rate_column('nvl(oset.p_escalated,0)'

666: ,'N') ||
667: '
668: /* Escalated Percent Prior */
669: , ' ||
670: biv_dbi_tmpl_util.rate_column('nvl(oset.p_escalated,0)'
671: ,'oset.p_backlog'
672: ,'BIV_MEASURE9') ||
673: '
674: /* Escalated Percent Current */

Line 676: biv_dbi_tmpl_util.rate_column('nvl(oset.c_escalated,0)'

672: ,'BIV_MEASURE9') ||
673: '
674: /* Escalated Percent Current */
675: , ' ||
676: biv_dbi_tmpl_util.rate_column('nvl(oset.c_escalated,0)'
677: ,'oset.c_backlog'
678: ,'BIV_MEASURE10') ||
679: '
680: /* Escalated Percent Change */

Line 682: biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('nvl(oset.c_escalated,0)'

678: ,'BIV_MEASURE10') ||
679: '
680: /* Escalated Percent Change */
681: , ' ||
682: biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('nvl(oset.c_escalated,0)'
683: ,'oset.c_backlog'
684: ,null)
685: ,biv_dbi_tmpl_util.rate_column('nvl(oset.p_escalated,0)'
686: ,'oset.p_backlog'

Line 685: ,biv_dbi_tmpl_util.rate_column('nvl(oset.p_escalated,0)'

681: , ' ||
682: biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('nvl(oset.c_escalated,0)'
683: ,'oset.c_backlog'
684: ,null)
685: ,biv_dbi_tmpl_util.rate_column('nvl(oset.p_escalated,0)'
686: ,'oset.p_backlog'
687: ,null)
688: ,'BIV_MEASURE12'
689: ,'N') ||

Line 693: biv_dbi_tmpl_util.rate_column('nvl(oset.p_unowned,0)'

689: ,'N') ||
690: '
691: /* Unowned Percent Prior */
692: , ' ||
693: biv_dbi_tmpl_util.rate_column('nvl(oset.p_unowned,0)'
694: ,'oset.p_backlog'
695: ,'BIV_MEASURE13') ||
696: '
697: /* Unowned Percent Current */

Line 699: biv_dbi_tmpl_util.rate_column('nvl(oset.c_unowned,0)'

695: ,'BIV_MEASURE13') ||
696: '
697: /* Unowned Percent Current */
698: , ' ||
699: biv_dbi_tmpl_util.rate_column('nvl(oset.c_unowned,0)'
700: ,'oset.c_backlog'
701: ,'BIV_MEASURE14') ||
702: '
703: /* Unowned Percent Change */

Line 705: biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('nvl(oset.c_unowned,0)'

701: ,'BIV_MEASURE14') ||
702: '
703: /* Unowned Percent Change */
704: , ' ||
705: biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('nvl(oset.c_unowned,0)'
706: ,'oset.c_backlog'
707: ,null)
708: ,biv_dbi_tmpl_util.rate_column('nvl(oset.p_unowned,0)'
709: ,'oset.p_backlog'

Line 708: ,biv_dbi_tmpl_util.rate_column('nvl(oset.p_unowned,0)'

704: , ' ||
705: biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('nvl(oset.c_unowned,0)'
706: ,'oset.c_backlog'
707: ,null)
708: ,biv_dbi_tmpl_util.rate_column('nvl(oset.p_unowned,0)'
709: ,'oset.p_backlog'
710: ,null)
711: ,'BIV_MEASURE16'
712: ,'N') ||

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

714: /* GT Backlog Current */
715: , nvl(oset.c_backlog_total,0) BIV_MEASURE17
716: /* GT Backlog Change */
717: , ' ||
718: biv_dbi_tmpl_util.change_column('oset.c_backlog_total'
719: ,'oset.p_backlog_total'
720: ,'BIV_MEASURE18') ||
721: '
722: /* GT Percent of Total Current */

Line 726: biv_dbi_tmpl_util.rate_column('nvl(oset.c_escalated_total,0)'

722: /* GT Percent of Total Current */
723: , 100 BIV_MEASURE19
724: /* GT Escalated Percent Current */
725: , ' ||
726: biv_dbi_tmpl_util.rate_column('nvl(oset.c_escalated_total,0)'
727: ,'oset.c_backlog_total'
728: ,'BIV_MEASURE21') ||
729: '
730: /* GT Escalated Percent Change */

Line 732: biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('nvl(oset.c_escalated_total,0)'

728: ,'BIV_MEASURE21') ||
729: '
730: /* GT Escalated Percent Change */
731: , ' ||
732: biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('nvl(oset.c_escalated_total,0)'
733: ,'oset.c_backlog_total'
734: ,null)
735: ,biv_dbi_tmpl_util.rate_column('nvl(oset.p_escalated_total,0)'
736: ,'oset.p_backlog_total'

Line 735: ,biv_dbi_tmpl_util.rate_column('nvl(oset.p_escalated_total,0)'

731: , ' ||
732: biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('nvl(oset.c_escalated_total,0)'
733: ,'oset.c_backlog_total'
734: ,null)
735: ,biv_dbi_tmpl_util.rate_column('nvl(oset.p_escalated_total,0)'
736: ,'oset.p_backlog_total'
737: ,null)
738: ,'BIV_MEASURE22'
739: ,'N') ||

Line 743: biv_dbi_tmpl_util.rate_column('nvl(oset.c_unowned_total,0)'

739: ,'N') ||
740: '
741: /* GT Unowned Percent Current */
742: , ' ||
743: biv_dbi_tmpl_util.rate_column('nvl(oset.c_unowned_total,0)'
744: ,'oset.c_backlog_total'
745: ,'BIV_MEASURE23') ||
746: '
747: /* GT Unowned Percent Change */

Line 749: biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('nvl(oset.c_unowned_total,0)'

745: ,'BIV_MEASURE23') ||
746: '
747: /* GT Unowned Percent Change */
748: , ' ||
749: biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('nvl(oset.c_unowned_total,0)'
750: ,'oset.c_backlog_total'
751: ,null)
752: ,biv_dbi_tmpl_util.rate_column('nvl(oset.p_unowned_total,0)'
753: ,'oset.p_backlog_total'

Line 752: ,biv_dbi_tmpl_util.rate_column('nvl(oset.p_unowned_total,0)'

748: , ' ||
749: biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('nvl(oset.c_unowned_total,0)'
750: ,'oset.c_backlog_total'
751: ,null)
752: ,biv_dbi_tmpl_util.rate_column('nvl(oset.p_unowned_total,0)'
753: ,'oset.p_backlog_total'
754: ,null)
755: ,'BIV_MEASURE24'
756: ,'N') ||

Line 762: biv_dbi_tmpl_util.rate_column('nvl(oset.p_escalated_total,0)'

758: /* KPI GT Backlog Prior */
759: , nvl(oset.p_backlog_total,0) BIV_MEASURE31
760: /* KPI GT Escalated Percent Prior */
761: , ' ||
762: biv_dbi_tmpl_util.rate_column('nvl(oset.p_escalated_total,0)'
763: ,'oset.p_backlog_total'
764: ,'BIV_MEASURE32') ||
765: '
766: /* KPI GT Unowned Percent Prior */

Line 768: biv_dbi_tmpl_util.rate_column('nvl(oset.p_unowned_total,0)'

764: ,'BIV_MEASURE32') ||
765: '
766: /* KPI GT Unowned Percent Prior */
767: , ' ||
768: biv_dbi_tmpl_util.rate_column('nvl(oset.p_unowned_total,0)'
769: ,'oset.p_backlog_total'
770: ,'BIV_MEASURE33') ||
771: '
772: , ' ||

Line 773: biv_dbi_tmpl_util.get_category_drill_down( l_view_by, g_backlog_dbn_rep_func||'@BIV_RES_STATUS=N' ) ||

769: ,'oset.p_backlog_total'
770: ,'BIV_MEASURE33') ||
771: '
772: , ' ||
773: biv_dbi_tmpl_util.get_category_drill_down( l_view_by, g_backlog_dbn_rep_func||'@BIV_RES_STATUS=N' ) ||
774: '
775: , ' ||
776: unr_drill_across('Y','BACKLOG', 'oset.c_backlog', 'BIV_ATTRIBUTE6',l_view_by) ||
777: '

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

787: , p_filter_where => '(c_backlog > 0 or p_backlog > 0)'
788: , p_generate_viewby => 'Y'
789: );
790:
791: biv_dbi_tmpl_util.override_order_by(l_view_by, p_param, l_stmt);
792:
793: -- the next line can be used to dump the contents of the PMV parameters as comments into stmt
794: -- l_stmt := l_stmt || biv_dbi_tmpl_util.dump_parameters(p_param);
795:

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

790:
791: biv_dbi_tmpl_util.override_order_by(l_view_by, p_param, l_stmt);
792:
793: -- the next line can be used to dump the contents of the PMV parameters as comments into stmt
794: -- l_stmt := l_stmt || biv_dbi_tmpl_util.dump_parameters(p_param);
795:
796: x_custom_sql := l_stmt;
797: -- unset_last_collection;
798:

Line 802: , p_balance_fact => biv_dbi_tmpl_util.get_balance_fact(l_mv)

798:
799:
800: poa_dbi_util_pkg.get_custom_balance_binds
801: ( p_custom_output => l_custom_output
802: , p_balance_fact => biv_dbi_tmpl_util.get_balance_fact(l_mv)
803: , p_xtd => l_xtd
804: );
805:
806: x_custom_output := l_custom_output;

Line 841: biv_dbi_tmpl_util.process_parameters

837: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
838: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
839:
840:
841: biv_dbi_tmpl_util.process_parameters
842: ( p_param => p_param
843: , p_report_type => 'BACKLOG'
844: , p_trend => 'Y'
845: , x_view_by => l_view_by

Line 895: biv_dbi_tmpl_util.change_column('iset.c_backlog'

891: /* Backlog Current */
892: , nvl(iset.c_backlog,0) BIV_MEASURE2
893: /* Backlog Change */
894: , ' ||
895: biv_dbi_tmpl_util.change_column('iset.c_backlog'
896: ,'iset.p_backlog'
897: ,'BIV_MEASURE4') ||
898: case
899: when p_distribution = 'N' then

Line 907: biv_dbi_tmpl_util.change_column('iset.c_escalated'

903: /* Escalated Current */
904: , nvl(iset.c_escalated,0) BIV_MEASURE10
905: /* Escalated Change */
906: , ' ||
907: biv_dbi_tmpl_util.change_column('iset.c_escalated'
908: ,'iset.p_escalated'
909: ,'BIV_MEASURE12') ||
910: '
911: /* Unowned Prior */

Line 917: biv_dbi_tmpl_util.change_column('iset.c_unowned'

913: /* Unowned Current */
914: , nvl(iset.c_unowned,0) BIV_MEASURE14
915: /* Unowned Change */
916: , ' ||
917: biv_dbi_tmpl_util.change_column('iset.c_unowned'
918: ,'iset.p_unowned'
919: ,'BIV_MEASURE16')
920: else
921: '

Line 924: biv_dbi_tmpl_util.rate_column('nvl(iset.p_escalated,0)'

920: else
921: '
922: /* Escalated Percent Prior */
923: , ' ||
924: biv_dbi_tmpl_util.rate_column('nvl(iset.p_escalated,0)'
925: ,'iset.p_backlog'
926: ,'BIV_MEASURE9') ||
927: '
928: /* Escalated Percent Current */

Line 930: biv_dbi_tmpl_util.rate_column('nvl(iset.c_escalated,0)'

926: ,'BIV_MEASURE9') ||
927: '
928: /* Escalated Percent Current */
929: , ' ||
930: biv_dbi_tmpl_util.rate_column('nvl(iset.c_escalated,0)'
931: ,'iset.c_backlog'
932: ,'BIV_MEASURE10') ||
933: '
934: /* Escalated Percent Change */

Line 936: biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('nvl(iset.c_escalated,0)'

932: ,'BIV_MEASURE10') ||
933: '
934: /* Escalated Percent Change */
935: , ' ||
936: biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('nvl(iset.c_escalated,0)'
937: ,'iset.c_backlog'
938: ,null)
939: ,biv_dbi_tmpl_util.rate_column('nvl(iset.p_escalated,0)'
940: ,'iset.p_backlog'

Line 939: ,biv_dbi_tmpl_util.rate_column('nvl(iset.p_escalated,0)'

935: , ' ||
936: biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('nvl(iset.c_escalated,0)'
937: ,'iset.c_backlog'
938: ,null)
939: ,biv_dbi_tmpl_util.rate_column('nvl(iset.p_escalated,0)'
940: ,'iset.p_backlog'
941: ,null)
942: ,'BIV_MEASURE12'
943: ,'N') ||

Line 947: biv_dbi_tmpl_util.rate_column('nvl(iset.p_unowned,0)'

943: ,'N') ||
944: '
945: /* Unowned Percent Prior */
946: , ' ||
947: biv_dbi_tmpl_util.rate_column('nvl(iset.p_unowned,0)'
948: ,'iset.p_backlog'
949: ,'BIV_MEASURE13') ||
950: '
951: /* Unowned Percent Current */

Line 953: biv_dbi_tmpl_util.rate_column('nvl(iset.c_unowned,0)'

949: ,'BIV_MEASURE13') ||
950: '
951: /* Unowned Percent Current */
952: , ' ||
953: biv_dbi_tmpl_util.rate_column('nvl(iset.c_unowned,0)'
954: ,'iset.c_backlog'
955: ,'BIV_MEASURE14') ||
956: '
957: /* Unowned Percent Change */

Line 959: biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('nvl(iset.c_unowned,0)'

955: ,'BIV_MEASURE14') ||
956: '
957: /* Unowned Percent Change */
958: , ' ||
959: biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('nvl(iset.c_unowned,0)'
960: ,'iset.c_backlog'
961: ,null)
962: ,biv_dbi_tmpl_util.rate_column('nvl(iset.p_unowned,0)'
963: ,'iset.p_backlog'

Line 962: ,biv_dbi_tmpl_util.rate_column('nvl(iset.p_unowned,0)'

958: , ' ||
959: biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('nvl(iset.c_unowned,0)'
960: ,'iset.c_backlog'
961: ,null)
962: ,biv_dbi_tmpl_util.rate_column('nvl(iset.p_unowned,0)'
963: ,'iset.p_backlog'
964: ,null)
965: ,'BIV_MEASURE16'
966: ,'N')

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

987: , p_use_grpid => 'N'
988: );
989:
990: -- the next line can be used to dump the contents of the PMV parameters as comments into stmt
991: -- l_stmt := l_stmt || biv_dbi_tmpl_util.dump_parameters(p_param);
992: -- l_stmt := l_stmt || biv_dbi_tmpl_util.get_trace_file_name;
993:
994: x_custom_sql := l_stmt;
995: -- unset_last_collection;

Line 992: -- l_stmt := l_stmt || biv_dbi_tmpl_util.get_trace_file_name;

988: );
989:
990: -- the next line can be used to dump the contents of the PMV parameters as comments into stmt
991: -- l_stmt := l_stmt || biv_dbi_tmpl_util.dump_parameters(p_param);
992: -- l_stmt := l_stmt || biv_dbi_tmpl_util.get_trace_file_name;
993:
994: x_custom_sql := l_stmt;
995: -- unset_last_collection;
996:

Line 1005: , p_balance_fact => biv_dbi_tmpl_util.get_balance_fact(l_mv)

1001: );
1002:
1003: poa_dbi_util_pkg.get_custom_balance_binds
1004: ( p_custom_output => l_custom_output
1005: , p_balance_fact => biv_dbi_tmpl_util.get_balance_fact(l_mv)
1006: , p_xtd => l_xtd
1007: );
1008:
1009:

Line 1020: l_stmt := biv_dbi_tmpl_util.dump_binds(l_custom_output);

1016: END IF;
1017:
1018: x_custom_output := l_custom_output;
1019:
1020: l_stmt := biv_dbi_tmpl_util.dump_binds(l_custom_output);
1021:
1022: end get_trd_sql;
1023:
1024: procedure get_dbn_trd_sql