DBA Data[Home] [Help]

APPS.ISC_FS_FTFR_RPT_PKG dependencies on BIS_QUERY_ATTRIBUTES_TBL

Line 51: , p_custom_output in out nocopy bis_query_attributes_tbl

47: function get_fact_mv_name
48: ( p_report_type in varchar2
49: , p_param in bis_pmv_page_parameter_tbl
50: , p_dim_bmap in number
51: , p_custom_output in out nocopy bis_query_attributes_tbl
52: )
53: return varchar2
54: is
55:

Line 308: , x_custom_output out nocopy bis_query_attributes_tbl

304:
305: procedure get_tbl_sql
306: ( p_param in bis_pmv_page_parameter_tbl
307: , x_custom_sql out nocopy varchar2
308: , x_custom_output out nocopy bis_query_attributes_tbl
309: )
310: is
311:
312: l_dimension_tbl isc_fs_rpt_util_pkg.t_dimension_tbl;

Line 314: l_custom_output bis_query_attributes_tbl;

310: is
311:
312: l_dimension_tbl isc_fs_rpt_util_pkg.t_dimension_tbl;
313: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
314: l_custom_output bis_query_attributes_tbl;
315: l_curr_suffix varchar2(3);
316: l_where_clause varchar2(10000);
317: l_viewby_select varchar2(400); -- needed to be increased from 200
318: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

Line 603: , x_custom_output out nocopy bis_query_attributes_tbl

599:
600: procedure get_trd_sql
601: ( p_param in bis_pmv_page_parameter_tbl
602: , x_custom_sql out nocopy varchar2
603: , x_custom_output out nocopy bis_query_attributes_tbl
604: )
605: is
606:
607: l_dimension_tbl isc_fs_rpt_util_pkg.t_dimension_tbl;

Line 609: l_custom_output bis_query_attributes_tbl;

605: is
606:
607: l_dimension_tbl isc_fs_rpt_util_pkg.t_dimension_tbl;
608: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
609: l_custom_output bis_query_attributes_tbl;
610: l_curr_suffix varchar2(3);
611: l_where_clause varchar2(10000);
612: l_viewby_select varchar2(400); -- needed to be increased from 200
613: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

Line 763: , x_custom_output out nocopy bis_query_attributes_tbl

759:
760: procedure get_dtl_rpt_sql
761: ( p_param in bis_pmv_page_parameter_tbl
762: , x_custom_sql out nocopy varchar2
763: , x_custom_output out nocopy bis_query_attributes_tbl
764: )
765: as
766:
767: l_dimension_tbl isc_fs_rpt_util_pkg.t_dimension_tbl;

Line 769: l_custom_output bis_query_attributes_tbl;

765: as
766:
767: l_dimension_tbl isc_fs_rpt_util_pkg.t_dimension_tbl;
768: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
769: l_custom_output bis_query_attributes_tbl;
770: l_curr_suffix varchar2(3);
771: l_where_clause varchar2(10000);
772: l_viewby_select varchar2(400); -- needed to be increased from 200
773: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;