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

Line 624: biv_dbi_tmpl_util.process_parameters

620: -- clear out the tables.
621: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
622: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
623:
624: biv_dbi_tmpl_util.process_parameters
625: ( p_param => p_param
626: , p_report_type => 'BACKLOG_AGE'
627: , p_trend => 'N'
628: , x_view_by => l_view_by

Line 638: l_backlog_type := biv_dbi_tmpl_util.get_backlog_type(p_param);

634: , x_join_tbl => l_join_tbl
635: , x_as_of_date => l_as_of_date
636: );
637:
638: l_backlog_type := biv_dbi_tmpl_util.get_backlog_type(p_param);
639:
640: IF(l_xtd IN ('DAY','WTD','MTD','QTD','YTD') )
641: THEN
642: l_to_date_type := 'YTD';

Line 669: biv_dbi_tmpl_util.add_bucket_inner_query

665: , p_alias_name => 'backlog_age'
666: , p_to_date_type => l_to_date_type
667: );
668:
669: biv_dbi_tmpl_util.add_bucket_inner_query
670: ( p_short_name => 'BIV_DBI_BACKLOG_AGING'
671: , p_col_tbl => l_col_tbl
672: , p_col_name => case l_backlog_type
673: when 'ESCALATED' then 'escalated_age'

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

682: );
683:
684: l_stmt := 'select
685: ' ||
686: biv_dbi_tmpl_util.get_view_by_col_name(l_view_by) || ' VIEWBY ' ||
687: ', oset.' || l_view_by_col_name || ' VIEWBYID ' ||
688: case
689: when l_view_by = biv_dbi_tmpl_util.g_PRODUCT then
690: ', v.description'

Line 689: when l_view_by = biv_dbi_tmpl_util.g_PRODUCT then

685: ' ||
686: biv_dbi_tmpl_util.get_view_by_col_name(l_view_by) || ' VIEWBY ' ||
687: ', oset.' || l_view_by_col_name || ' VIEWBYID ' ||
688: case
689: when l_view_by = biv_dbi_tmpl_util.g_PRODUCT then
690: ', v.description'
691: else
692: ', null'
693: end

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

697: /* Backlog Current */
698: , nvl(oset.c_backlog,0) BIV_MEASURE2
699: /* Backlog Change */
700: , ' ||
701: biv_dbi_tmpl_util.change_column('oset.c_backlog'
702: ,'oset.p_backlog'
703: ,'BIV_MEASURE4') ||
704: '
705: /* Average Age Prior */

Line 707: biv_dbi_tmpl_util.rate_column('oset.p_backlog_age'

703: ,'BIV_MEASURE4') ||
704: '
705: /* Average Age Prior */
706: , ' ||
707: biv_dbi_tmpl_util.rate_column('oset.p_backlog_age'
708: ,'oset.p_backlog'
709: ,'BIV_MEASURE5'
710: ,'N') ||
711: '

Line 714: biv_dbi_tmpl_util.rate_column('oset.c_backlog_age'

710: ,'N') ||
711: '
712: /* Average Age Current */
713: , ' ||
714: biv_dbi_tmpl_util.rate_column('oset.c_backlog_age'
715: ,'oset.c_backlog'
716: ,'BIV_MEASURE6'
717: ,'N') ||
718: '

Line 721: biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('oset.c_backlog_age'

717: ,'N') ||
718: '
719: /* Average Age Change */
720: , ' ||
721: biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('oset.c_backlog_age'
722: ,'oset.c_backlog'
723: ,null
724: ,'N')
725: ,biv_dbi_tmpl_util.rate_column('oset.p_backlog_age'

Line 725: ,biv_dbi_tmpl_util.rate_column('oset.p_backlog_age'

721: biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('oset.c_backlog_age'
722: ,'oset.c_backlog'
723: ,null
724: ,'N')
725: ,biv_dbi_tmpl_util.rate_column('oset.p_backlog_age'
726: ,'oset.p_backlog'
727: ,null
728: ,'N')
729: ,'BIV_MEASURE8'

Line 733: ' || biv_dbi_tmpl_util.get_bucket_outer_query

729: ,'BIV_MEASURE8'
730: ,'N') ||
731: '
732: /* Aging Buckets */
733: ' || biv_dbi_tmpl_util.get_bucket_outer_query
734: ( p_bucket_rec => l_bucket_rec
735: , p_column_name_base => 'oset.c_age_bucket'
736: , p_alias_base => 'BIV_MEASURE10'
737: , p_total_flag => 'N'

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

744: /* GT Backlog Current */
745: , nvl(oset.c_backlog_total,0) BIV_MEASURE11
746: /* GT Backlog Change */
747: , ' ||
748: biv_dbi_tmpl_util.change_column('oset.c_backlog_total'
749: ,'oset.p_backlog_total'
750: ,'BIV_MEASURE12') ||
751: '
752: /* GT Average Age Current */

Line 754: biv_dbi_tmpl_util.rate_column('oset.c_backlog_age_total'

750: ,'BIV_MEASURE12') ||
751: '
752: /* GT Average Age Current */
753: , ' ||
754: biv_dbi_tmpl_util.rate_column('oset.c_backlog_age_total'
755: ,'oset.c_backlog_total'
756: ,'BIV_MEASURE13'
757: ,'N') ||
758: '

Line 761: biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('oset.c_backlog_age_total'

757: ,'N') ||
758: '
759: /* GT Average Age Change */
760: , ' ||
761: biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('oset.c_backlog_age_total'
762: ,'oset.c_backlog_total'
763: ,null
764: ,'N')
765: ,biv_dbi_tmpl_util.rate_column('oset.p_backlog_age_total'

Line 765: ,biv_dbi_tmpl_util.rate_column('oset.p_backlog_age_total'

761: biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('oset.c_backlog_age_total'
762: ,'oset.c_backlog_total'
763: ,null
764: ,'N')
765: ,biv_dbi_tmpl_util.rate_column('oset.p_backlog_age_total'
766: ,'oset.p_backlog_total'
767: ,null
768: ,'N')
769: ,'BIV_MEASURE14'

Line 773: ' || biv_dbi_tmpl_util.get_bucket_outer_query

769: ,'BIV_MEASURE14'
770: ,'N') ||
771: '
772: /* GT Aging Buckets */
773: ' || biv_dbi_tmpl_util.get_bucket_outer_query
774: ( p_bucket_rec => l_bucket_rec
775: , p_column_name_base => 'oset.c_age_bucket'
776: , p_alias_base => 'BIV_MEASURE15'
777: , p_total_flag => 'Y'

Line 785: biv_dbi_tmpl_util.get_category_drill_down(l_view_by, case

781: end
782: ) ||
783: '
784: , ' ||
785: biv_dbi_tmpl_util.get_category_drill_down(l_view_by, case
786: when p_distribution = 'N' then
787: g_backlog_age_rep_func
788: else
789: g_backlog_age_dbn_rep_func

Line 791: biv_dbi_tmpl_util.drill_detail( g_backlog_detail_rep_func

787: g_backlog_age_rep_func
788: else
789: g_backlog_age_dbn_rep_func
790: end) ||
791: biv_dbi_tmpl_util.drill_detail( g_backlog_detail_rep_func
792: , 0
793: , null
794: , 'BIV_ATTRIBUTE6') ||
795: case

Line 797: biv_dbi_tmpl_util.bucket_detail_drill( g_backlog_detail_rep_func

793: , null
794: , 'BIV_ATTRIBUTE6') ||
795: case
796: when p_distribution = 'N' then
797: biv_dbi_tmpl_util.bucket_detail_drill( g_backlog_detail_rep_func
798: , l_bucket_rec
799: , 'BIV_ATTRIBUTE7' )
800: else
801: null

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

812: , p_generate_viewby => 'Y'
813: );
814: -- unset_last_collection;
815:
816: biv_dbi_tmpl_util.override_order_by(l_view_by, p_param, l_stmt);
817:
818: -- the next line can be used to dump the contents of the PMV parameters as comments into stmt
819: -- l_stmt := l_stmt || biv_dbi_tmpl_util.dump_parameters(p_param);
820:

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

815:
816: biv_dbi_tmpl_util.override_order_by(l_view_by, p_param, l_stmt);
817:
818: -- the next line can be used to dump the contents of the PMV parameters as comments into stmt
819: -- l_stmt := l_stmt || biv_dbi_tmpl_util.dump_parameters(p_param);
820:
821: x_custom_sql := l_stmt;
822:
823: biv_dbi_tmpl_util.bind_age_dates

Line 823: biv_dbi_tmpl_util.bind_age_dates

819: -- l_stmt := l_stmt || biv_dbi_tmpl_util.dump_parameters(p_param);
820:
821: x_custom_sql := l_stmt;
822:
823: biv_dbi_tmpl_util.bind_age_dates
824: ( p_param => p_param
825: , p_current_name => '&AGE_CURRENT_ASOF_DATE' -- these will be the text you actually use in your sql stmt.
826: , p_prior_name => '&AGE_PREVIOUS_ASOF_DATE' --
827: , p_custom_output => l_custom_output );

Line 883: biv_dbi_tmpl_util.process_parameters

879: -- clear out the tables.
880: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
881: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
882:
883: biv_dbi_tmpl_util.process_parameters
884: ( p_param => p_param
885: , p_report_type => 'BACKLOG_AGE'
886: , p_trend => 'Y'
887: , x_view_by => l_view_by

Line 897: l_backlog_type := biv_dbi_tmpl_util.get_backlog_type(p_param);

893: , x_join_tbl => l_join_tbl
894: , x_as_of_date => l_as_of_date
895: );
896:
897: l_backlog_type := biv_dbi_tmpl_util.get_backlog_type(p_param);
898:
899: IF(l_xtd IN ('DAY','WTD','MTD','QTD','YTD') )
900: THEN
901: l_to_date_type := 'YTD';

Line 929: biv_dbi_tmpl_util.add_bucket_inner_query

925: , p_to_date_type => l_to_date_type
926: , p_grand_total => 'N'
927: );
928:
929: biv_dbi_tmpl_util.add_bucket_inner_query
930: ( p_short_name => 'BIV_DBI_BACKLOG_AGING'
931: , p_col_tbl => l_col_tbl
932: , p_col_name => case l_backlog_type
933: when 'ESCALATED' then 'escalated_age'

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

948: /* Backlog Current */
949: , nvl(iset.c_backlog,0) BIV_MEASURE2
950: /* Backlog Change */
951: , ' ||
952: biv_dbi_tmpl_util.change_column('iset.c_backlog'
953: ,'iset.p_backlog'
954: ,'BIV_MEASURE4') ||
955: '
956: /* Average Age Prior */

Line 958: biv_dbi_tmpl_util.rate_column('iset.p_backlog_age'

954: ,'BIV_MEASURE4') ||
955: '
956: /* Average Age Prior */
957: , ' ||
958: biv_dbi_tmpl_util.rate_column('iset.p_backlog_age'
959: ,'iset.p_backlog'
960: ,'BIV_MEASURE5'
961: ,'N') ||
962: '

Line 965: biv_dbi_tmpl_util.rate_column('iset.c_backlog_age'

961: ,'N') ||
962: '
963: /* Average Age Current */
964: , ' ||
965: biv_dbi_tmpl_util.rate_column('iset.c_backlog_age'
966: ,'iset.c_backlog'
967: ,'BIV_MEASURE6'
968: ,'N') ||
969: '

Line 972: biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('iset.c_backlog_age'

968: ,'N') ||
969: '
970: /* Average Age Change */
971: , ' ||
972: biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('iset.c_backlog_age'
973: ,'iset.c_backlog'
974: ,null
975: ,'N')
976: ,biv_dbi_tmpl_util.rate_column('iset.p_backlog_age'

Line 976: ,biv_dbi_tmpl_util.rate_column('iset.p_backlog_age'

972: biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('iset.c_backlog_age'
973: ,'iset.c_backlog'
974: ,null
975: ,'N')
976: ,biv_dbi_tmpl_util.rate_column('iset.p_backlog_age'
977: ,'iset.p_backlog'
978: ,null
979: ,'N')
980: ,'BIV_MEASURE8'

Line 984: ' || biv_dbi_tmpl_util.get_bucket_outer_query

980: ,'BIV_MEASURE8'
981: ,'N') ||
982: '
983: /* Aging Buckets */
984: ' || biv_dbi_tmpl_util.get_bucket_outer_query
985: ( p_bucket_rec => l_bucket_rec
986: , p_column_name_base => 'iset.c_age_bucket'
987: , p_alias_base => 'BIV_MEASURE10'
988: , p_total_flag => 'N'

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

1023: );
1024: -- unset_last_collection;
1025:
1026: -- the next line can be used to dump the contents of the PMV parameters as comments into stmt
1027: -- l_stmt := l_stmt || biv_dbi_tmpl_util.dump_parameters(p_param);
1028: -- l_stmt := l_stmt || biv_dbi_tmpl_util.get_trace_file_name;
1029:
1030: x_custom_sql := l_stmt;
1031:

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

1024: -- unset_last_collection;
1025:
1026: -- the next line can be used to dump the contents of the PMV parameters as comments into stmt
1027: -- l_stmt := l_stmt || biv_dbi_tmpl_util.dump_parameters(p_param);
1028: -- l_stmt := l_stmt || biv_dbi_tmpl_util.get_trace_file_name;
1029:
1030: x_custom_sql := l_stmt;
1031:
1032: -- RAVI Temp SOlution

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

1100: l_as_of_date date;
1101:
1102: begin
1103:
1104: biv_dbi_tmpl_util.get_detail_page_function( l_drill_url, l_sr_id );
1105:
1106: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
1107:
1108: biv_dbi_tmpl_util.process_parameters

Line 1108: biv_dbi_tmpl_util.process_parameters

1104: biv_dbi_tmpl_util.get_detail_page_function( l_drill_url, l_sr_id );
1105:
1106: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
1107:
1108: biv_dbi_tmpl_util.process_parameters
1109: ( p_param => p_param
1110: , p_report_type => 'BACKLOG_DETAIL'
1111: , x_where_clause => l_where_clause
1112: , x_xtd => l_xtd

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

1117: , x_as_of_date => l_as_of_date
1118: );
1119:
1120: if l_where_clause like '%%' then
1121: l_where_clause := replace(l_where_clause,'fact. in (&'||biv_dbi_tmpl_util.g_AGING||')'
1122: ,'(&RANGE_LOW is null or fact.age >= &RANGE_LOW) and (&RANGE_HIGH is null or fact.age < &RANGE_HIGH)');
1123:
1124: biv_dbi_tmpl_util.bind_low_high
1125: ( p_param

Line 1124: biv_dbi_tmpl_util.bind_low_high

1120: if l_where_clause like '%%' then
1121: l_where_clause := replace(l_where_clause,'fact. in (&'||biv_dbi_tmpl_util.g_AGING||')'
1122: ,'(&RANGE_LOW is null or fact.age >= &RANGE_LOW) and (&RANGE_HIGH is null or fact.age < &RANGE_HIGH)');
1123:
1124: biv_dbi_tmpl_util.bind_low_high
1125: ( p_param
1126: , 'BIV_DBI_BACKLOG_AGING'
1127: , '&RANGE_LOW'
1128: , '&RANGE_HIGH'

Line 1133: l_backlog_type := biv_dbi_tmpl_util.get_backlog_type(p_param);

1129: , l_custom_output );
1130:
1131: end if;
1132:
1133: l_backlog_type := biv_dbi_tmpl_util.get_backlog_type(p_param);
1134:
1135: if l_backlog_type = 'ESCALATED' then
1136: l_where_clause := l_where_clause || ' and fact.escalated_date is not null';
1137: elsif l_backlog_type = 'UNOWNED' then

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

1137: elsif l_backlog_type = 'UNOWNED' then
1138: l_where_clause := l_where_clause || ' and fact.unowned_date is not null';
1139: end if;
1140:
1141: l_order_by := biv_dbi_tmpl_util.get_order_by(p_param);
1142: if l_order_by like '% DESC%' then
1143: if l_order_by like '%BIV_MEASURE12%' then
1144: l_order_by := 'fact.incident_date desc, fact.incident_id desc';
1145: else

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

1193: and fact.incident_id = i.incident_id' || l_join_where || '
1194: and (fact.rnk between &START_INDEX and &END_INDEX or &END_INDEX = -1)
1195: &ORDER_BY_CLAUSE
1196: '
1197: --|| biv_dbi_tmpl_util.dump_parameters(p_param)
1198: ;
1199:
1200: poa_dbi_util_pkg.get_custom_balance_binds
1201: ( p_custom_output => l_custom_output

Line 1202: , p_balance_fact => biv_dbi_tmpl_util.get_balance_fact(null)

1198: ;
1199:
1200: poa_dbi_util_pkg.get_custom_balance_binds
1201: ( p_custom_output => l_custom_output
1202: , p_balance_fact => biv_dbi_tmpl_util.get_balance_fact(null)
1203: , p_xtd => l_xtd
1204: );
1205:
1206: biv_dbi_tmpl_util.bind_age_dates

Line 1206: biv_dbi_tmpl_util.bind_age_dates

1202: , p_balance_fact => biv_dbi_tmpl_util.get_balance_fact(null)
1203: , p_xtd => l_xtd
1204: );
1205:
1206: biv_dbi_tmpl_util.bind_age_dates
1207: ( p_param => p_param
1208: , p_current_name => '&AGE_CURRENT_ASOF_DATE' -- these will be the text you actually use in your sql stmt.
1209: , p_prior_name => '&AGE_PREVIOUS_ASOF_DATE' --
1210: , p_custom_output => l_custom_output );

Line 1213: biv_dbi_tmpl_util.bind_yes_no

1209: , p_prior_name => '&AGE_PREVIOUS_ASOF_DATE' --
1210: , p_custom_output => l_custom_output );
1211:
1212:
1213: biv_dbi_tmpl_util.bind_yes_no
1214: ( '&YES'
1215: , '&NO'
1216: , l_custom_output );
1217: