DBA Data[Home] [Help]

APPS.ISC_MAINT_WO_CST_RPT_PKG dependencies on BIS_QUERY_ATTRIBUTES_TBL

Line 11: , p_custom_output in out nocopy bis_query_attributes_tbl

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

Line 282: , x_custom_output out nocopy bis_query_attributes_tbl

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;

Line 288: l_custom_output bis_query_attributes_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;

Line 552: , x_custom_output out nocopy bis_query_attributes_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;

Line 558: l_custom_output bis_query_attributes_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;

Line 731: , x_custom_output out nocopy bis_query_attributes_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;

Line 737: l_custom_output bis_query_attributes_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;

Line 1018: , x_custom_output out nocopy bis_query_attributes_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;

Line 1024: l_custom_output bis_query_attributes_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;