7: function get_fact_mv_name
8: ( p_report_type in varchar2
9: , p_param in bis_pmv_page_parameter_tbl
10: , p_dim_bmap in number
11: , p_custom_output in out nocopy bis_query_attributes_tbl
12: , p_estimated in varchar2
13: )
14: return varchar2
15: is
278:
279: procedure get_tbl_sql
280: ( p_param in bis_pmv_page_parameter_tbl
281: , x_custom_sql out nocopy varchar2
282: , x_custom_output out nocopy bis_query_attributes_tbl
283: )
284: is
285:
286: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;
284: is
285:
286: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;
287: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
288: l_custom_output bis_query_attributes_tbl;
289: l_curr_suffix varchar2(3);
290: l_where_clause varchar2(10000);
291: l_viewby_select varchar2(200);
292: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
548:
549: procedure get_trd_sql
550: ( p_param in bis_pmv_page_parameter_tbl
551: , x_custom_sql out nocopy varchar2
552: , x_custom_output out nocopy bis_query_attributes_tbl
553: )
554: is
555:
556: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;
554: is
555:
556: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;
557: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
558: l_custom_output bis_query_attributes_tbl;
559: l_curr_suffix varchar2(3);
560: l_where_clause varchar2(10000);
561: l_viewby_select varchar2(200);
562: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
727:
728: procedure get_sum_tbl_sql
729: ( p_param in bis_pmv_page_parameter_tbl
730: , x_custom_sql out nocopy varchar2
731: , x_custom_output out nocopy bis_query_attributes_tbl
732: )
733: as
734:
735: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;
733: as
734:
735: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;
736: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
737: l_custom_output bis_query_attributes_tbl;
738: l_curr_suffix varchar2(3);
739: l_where_clause varchar2(10000);
740: l_viewby_select varchar2(200);
741: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
1014:
1015: procedure get_dtl_rpt_sql
1016: ( p_param in bis_pmv_page_parameter_tbl
1017: , x_custom_sql out nocopy varchar2
1018: , x_custom_output out nocopy bis_query_attributes_tbl
1019: )
1020: as
1021:
1022: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;
1020: as
1021:
1022: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;
1023: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
1024: l_custom_output bis_query_attributes_tbl;
1025: l_curr_suffix varchar2(3);
1026: l_where_clause varchar2(10000);
1027: l_viewby_select varchar2(200);
1028: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;