APPS.ISC_FS_INV_RPT_PKG dependencies on BIS_QUERY_ATTRIBUTES

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 132: l_custom_rec BIS_QUERY_ATTRIBUTES;

128: l_stmt1 varchar2(5000);
129: l_stmt2 varchar2(5000);
130: l_to_date varchar2(20);
131: l_to_date_type varchar2(20);
132: l_custom_rec BIS_QUERY_ATTRIBUTES;
133:
134: begin
135:
136: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

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;

Line 497: l_custom_rec BIS_QUERY_ATTRIBUTES;

493: l_stmt2 varchar2(15000);
494: l_to_date varchar2(20);
495: l_to_date_type varchar2(20);
496: l_rxtd varchar2(3);
497: l_custom_rec BIS_QUERY_ATTRIBUTES;
498:
499: begin
500:
501: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;