DBA Data[Home] [Help]

APPS.ISC_FS_INV_RPT_PKG dependencies on BIS_QUERY_ATTRIBUTES_TBL

Line 7: , p_custom_output in out nocopy bis_query_attributes_tbl

3: function get_fact_mv_name
4: ( p_report_type in varchar2
5: , p_param in bis_pmv_page_parameter_tbl
6: , p_dim_bmap in number
7: , p_custom_output in out nocopy bis_query_attributes_tbl
8: )
9: return varchar2
10: is
11: l_comparison_type varchar2(20);

Line 108: , x_custom_output out nocopy bis_query_attributes_tbl

104:
105: procedure get_tbl_sql
106: ( p_param in bis_pmv_page_parameter_tbl
107: , x_custom_sql out nocopy varchar2
108: , x_custom_output out nocopy bis_query_attributes_tbl
109: )
110: is
111:
112: l_dimension_tbl isc_fs_rpt_util_pkg.t_dimension_tbl;

Line 114: l_custom_output bis_query_attributes_tbl;

110: is
111:
112: l_dimension_tbl isc_fs_rpt_util_pkg.t_dimension_tbl;
113: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
114: l_custom_output bis_query_attributes_tbl;
115: l_curr_suffix varchar2(3);
116: l_where_clause varchar2(10000);
117: l_viewby_select varchar2(400); -- needed to be increased from 200
118: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

Line 472: , x_custom_output out nocopy bis_query_attributes_tbl

468:
469: procedure get_trd_sql
470: ( p_param in bis_pmv_page_parameter_tbl
471: , x_custom_sql out nocopy varchar2
472: , x_custom_output out nocopy bis_query_attributes_tbl
473: )
474: is
475:
476: l_dimension_tbl isc_fs_rpt_util_pkg.t_dimension_tbl;

Line 478: l_custom_output bis_query_attributes_tbl;

474: is
475:
476: l_dimension_tbl isc_fs_rpt_util_pkg.t_dimension_tbl;
477: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
478: l_custom_output bis_query_attributes_tbl;
479: l_curr_suffix varchar2(3);
480: l_where_clause varchar2(10000);
481: l_viewby_select varchar2(400); -- needed to be increased from 200
482: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;