DBA Data[Home] [Help]

APPS.ISC_FS_TECH_UTL_RPT_PKG dependencies on BIS_QUERY_ATTRIBUTES_TBL

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: begin

Line 63: , x_custom_output out nocopy bis_query_attributes_tbl

59:
60: procedure get_tbl_sql
61: ( p_param in bis_pmv_page_parameter_tbl
62: , x_custom_sql out nocopy varchar2
63: , x_custom_output out nocopy bis_query_attributes_tbl
64: )
65: is
66:
67: l_dimension_tbl isc_fs_rpt_util_pkg.t_dimension_tbl;

Line 69: l_custom_output bis_query_attributes_tbl;

65: is
66:
67: l_dimension_tbl isc_fs_rpt_util_pkg.t_dimension_tbl;
68: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
69: l_custom_output bis_query_attributes_tbl;
70: l_curr_suffix varchar2(3);
71: l_where_clause varchar2(10000);
72: l_viewby_select varchar2(400); -- needed to be increased from 200
73: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

Line 418: , x_custom_output out nocopy bis_query_attributes_tbl

414:
415: procedure get_trd_sql
416: ( p_param in bis_pmv_page_parameter_tbl
417: , x_custom_sql out nocopy varchar2
418: , x_custom_output out nocopy bis_query_attributes_tbl
419: )
420: is
421:
422: l_dimension_tbl isc_fs_rpt_util_pkg.t_dimension_tbl;

Line 424: l_custom_output bis_query_attributes_tbl;

420: is
421:
422: l_dimension_tbl isc_fs_rpt_util_pkg.t_dimension_tbl;
423: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
424: l_custom_output bis_query_attributes_tbl;
425: l_curr_suffix varchar2(3);
426: l_where_clause varchar2(10000);
427: l_viewby_select varchar2(400); -- needed to be increased from 200
428: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;