DBA Data[Home] [Help]

APPS.ISC_FS_MTTR_RPT_PKG dependencies on BIS_QUERY_ATTRIBUTES_TBL

Line 13: , p_custom_output in out nocopy bis_query_attributes_tbl

9: function get_fact_mv_name
10: ( p_report_type in varchar2
11: , p_param in bis_pmv_page_parameter_tbl
12: , p_dim_bmap in number
13: , p_custom_output in out nocopy bis_query_attributes_tbl
14: )
15: return varchar2
16: is
17:

Line 261: , x_custom_output out nocopy bis_query_attributes_tbl

257:
258: procedure get_tbl_sql
259: ( p_param in bis_pmv_page_parameter_tbl
260: , x_custom_sql out nocopy varchar2
261: , x_custom_output out nocopy bis_query_attributes_tbl
262: )
263: is
264:
265: l_dimension_tbl isc_fs_rpt_util_pkg.t_dimension_tbl;

Line 267: l_custom_output bis_query_attributes_tbl;

263: is
264:
265: l_dimension_tbl isc_fs_rpt_util_pkg.t_dimension_tbl;
266: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
267: l_custom_output bis_query_attributes_tbl;
268: l_curr_suffix varchar2(3);
269: l_where_clause varchar2(10000);
270: l_viewby_select varchar2(400); -- needed to be increased from 200
271: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

Line 533: , x_custom_output out nocopy bis_query_attributes_tbl

529:
530: procedure get_trd_sql
531: ( p_param in bis_pmv_page_parameter_tbl
532: , x_custom_sql out nocopy varchar2
533: , x_custom_output out nocopy bis_query_attributes_tbl
534: )
535: is
536:
537: l_dimension_tbl isc_fs_rpt_util_pkg.t_dimension_tbl;

Line 539: l_custom_output bis_query_attributes_tbl;

535: is
536:
537: l_dimension_tbl isc_fs_rpt_util_pkg.t_dimension_tbl;
538: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
539: l_custom_output bis_query_attributes_tbl;
540: l_curr_suffix varchar2(3);
541: l_where_clause varchar2(10000);
542: l_viewby_select varchar2(400); -- needed to be increased from 200
543: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

Line 693: , x_custom_output out nocopy bis_query_attributes_tbl

689:
690: procedure get_dtl_rpt_sql
691: ( p_param in bis_pmv_page_parameter_tbl
692: , x_custom_sql out nocopy varchar2
693: , x_custom_output out nocopy bis_query_attributes_tbl
694: )
695: as
696:
697: l_dimension_tbl isc_fs_rpt_util_pkg.t_dimension_tbl;

Line 699: l_custom_output bis_query_attributes_tbl;

695: as
696:
697: l_dimension_tbl isc_fs_rpt_util_pkg.t_dimension_tbl;
698: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
699: l_custom_output bis_query_attributes_tbl;
700: l_curr_suffix varchar2(3);
701: l_where_clause varchar2(10000);
702: l_viewby_select varchar2(400); -- needed to be increased from 200
703: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;