APPS.ISC_MAINT_ASSET_DT_RPT_PKG dependencies on BIS_QUERY_ATTRIBUTES_TBL

Line 9: , p_custom_output in out nocopy bis_query_attributes_tbl

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:

Line 111: , x_custom_output out nocopy bis_query_attributes_tbl

107: procedure get_tbl_sql
108: (
109: p_param in bis_pmv_page_parameter_tbl
110: , x_custom_sql out nocopy varchar2
111: , x_custom_output out nocopy bis_query_attributes_tbl
112: )
113: is
114:
115: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;

Line 127: l_custom_output bis_query_attributes_tbl;

123: l_drill_down varchar2(1000);
124: l_drill_across varchar2 (1000);
125: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
126: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
127: l_custom_output bis_query_attributes_tbl;
128: l_cost_element varchar2(200);
129: l_curr_suffix varchar2(2);
130: l_viewby_select varchar2(200);
131: l_asset_grp_column varchar2(200);

Line 265: , x_custom_output out nocopy bis_query_attributes_tbl

261: procedure get_asset_dt_dtl_sql
262: (
263: p_param in bis_pmv_page_parameter_tbl
264: , x_custom_sql out nocopy varchar2
265: , x_custom_output out nocopy bis_query_attributes_tbl
266: )
267: is
268: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;
269: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;

Line 280: l_custom_output bis_query_attributes_tbl;

276: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
277: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
278: l_order_by varchar2(200);
279: l_asc_desc varchar2(100);
280: l_custom_output bis_query_attributes_tbl;
281: l_rank_order varchar2(100);
282: l_cost_element varchar2(200);
283: l_curr_suffix varchar2(2);
284: l_detail_col_tbl isc_maint_rpt_util_pkg.t_detail_column_tbl;

Line 459: , x_custom_output out nocopy bis_query_attributes_tbl

455: procedure get_trd_sql
456: (
457: p_param in bis_pmv_page_parameter_tbl
458: , x_custom_sql out nocopy varchar2
459: , x_custom_output out nocopy bis_query_attributes_tbl
460: )
461: is
462: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;
463: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;

Line 472: l_custom_output bis_query_attributes_tbl;

468: l_mv varchar2(10000);
469: l_stmt varchar2(32767);
470: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
471: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
472: l_custom_output bis_query_attributes_tbl;
473: l_cost_element varchar2(200);
474: l_curr_suffix varchar2(2);
475: l_viewby_select varchar2(200);
476: BEGIN