5: function get_fact_mv_name
6: ( p_report_type in varchar2
7: , p_param in bis_pmv_page_parameter_tbl
8: , p_dim_bmap in number
9: , p_custom_output in out nocopy bis_query_attributes_tbl
10: )
11: return varchar2
12: is
13:
213:
214: procedure get_tbl_sql
215: ( p_param in bis_pmv_page_parameter_tbl
216: , x_custom_sql out nocopy varchar2
217: , x_custom_output out nocopy bis_query_attributes_tbl
218: )
219: is
220:
221: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;
229:
230: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
231: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
232:
233: l_custom_output bis_query_attributes_tbl;
234:
235: l_cost_element varchar2(200);
236: l_curr_suffix varchar2(2);
237:
516:
517: procedure get_trd_sql
518: ( p_param in bis_pmv_page_parameter_tbl
519: , x_custom_sql out nocopy varchar2
520: , x_custom_output out nocopy bis_query_attributes_tbl
521: )
522: is
523:
524: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;
532:
533: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
534: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
535:
536: l_custom_output bis_query_attributes_tbl;
537:
538: l_cost_element varchar2(200);
539: l_curr_suffix varchar2(2);
540:
710:
711: procedure get_late_cmpl_age
712: ( p_param in bis_pmv_page_parameter_tbl
713: , x_custom_sql out nocopy varchar2
714: , x_custom_output out nocopy bis_query_attributes_tbl
715: )
716: is
717:
718: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;
727:
728: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
729: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
730:
731: l_custom_output bis_query_attributes_tbl;
732:
733: l_cost_element varchar2(200);
734: l_curr_suffix varchar2(2);
735:
846:
847:
848: PROCEDURE get_wo_dtl_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,
849: x_custom_sql OUT NOCOPY VARCHAR2,
850: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
851: IS
852:
853: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;
854: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
861:
862: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
863: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
864:
865: l_custom_output bis_query_attributes_tbl;
866:
867: l_curr_suffix varchar2(2);
868:
869: l_rank_order varchar2(100);
1060:
1061:
1062: PROCEDURE get_wo_late_dtl_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,
1063: x_custom_sql OUT NOCOPY VARCHAR2,
1064: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
1065: IS
1066:
1067: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;
1068: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
1076:
1077: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
1078: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
1079:
1080: l_custom_output bis_query_attributes_tbl;
1081:
1082: l_curr_suffix varchar2(2);
1083:
1084: l_rank_order varchar2(100);