DBA Data[Home] [Help]

APPS.ISC_FS_TASK_ACTIVITY_RPT_PKG dependencies on BIS_QUERY_ATTRIBUTES_TBL

Line 123: , p_custom_output in out nocopy bis_query_attributes_tbl

119: function get_fact_mv_name
120: ( p_report_type in varchar2
121: , p_param in bis_pmv_page_parameter_tbl
122: , p_dim_bmap in number
123: , p_custom_output in out nocopy bis_query_attributes_tbl
124: )
125: return varchar2
126: is
127:

Line 353: , x_custom_output out nocopy bis_query_attributes_tbl

349:
350: procedure get_tbl_sql
351: ( p_param in bis_pmv_page_parameter_tbl
352: , x_custom_sql out nocopy varchar2
353: , x_custom_output out nocopy bis_query_attributes_tbl
354: )
355: is
356:
357: l_dimension_tbl isc_fs_rpt_util_pkg.t_dimension_tbl;

Line 359: l_custom_output bis_query_attributes_tbl;

355: is
356:
357: l_dimension_tbl isc_fs_rpt_util_pkg.t_dimension_tbl;
358: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
359: l_custom_output bis_query_attributes_tbl;
360: l_curr_suffix varchar2(3);
361: l_where_clause varchar2(10000);
362: l_viewby_select varchar2(400); -- needed to be increased from 200
363: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

Line 605: , x_custom_output out nocopy bis_query_attributes_tbl

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

Line 611: l_custom_output bis_query_attributes_tbl;

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

Line 737: , x_custom_output out nocopy bis_query_attributes_tbl

733:
734: procedure get_dtl_rpt_sql
735: ( p_param in bis_pmv_page_parameter_tbl
736: , x_custom_sql out nocopy varchar2
737: , x_custom_output out nocopy bis_query_attributes_tbl
738: )
739: as
740:
741: l_dimension_tbl isc_fs_rpt_util_pkg.t_dimension_tbl;

Line 743: l_custom_output bis_query_attributes_tbl;

739: as
740:
741: l_dimension_tbl isc_fs_rpt_util_pkg.t_dimension_tbl;
742: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
743: l_custom_output bis_query_attributes_tbl;
744: l_curr_suffix varchar2(3);
745: l_where_clause varchar2(10000);
746: l_viewby_select varchar2(400); -- needed to be increased from 200
747: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;