APPS.ISC_FS_TRV_TIM_DIS_VAR_RPT_PKG dependencies on BIS_QUERY_ATTRIBUTES_TBL

Line 14: , p_custom_output in out NOCOPY bis_query_attributes_tbl

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

Line 87: , x_custom_output out nocopy bis_query_attributes_tbl

83:
84: procedure get_time_var_sql
85: ( p_param in bis_pmv_page_parameter_tbl
86: , x_custom_sql out nocopy varchar2
87: , x_custom_output out nocopy bis_query_attributes_tbl
88: )
89: is
90:
91: l_dimension_tbl isc_fs_rpt_util_pkg.t_dimension_tbl;

Line 93: l_custom_output bis_query_attributes_tbl;

89: is
90:
91: l_dimension_tbl isc_fs_rpt_util_pkg.t_dimension_tbl;
92: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
93: l_custom_output bis_query_attributes_tbl;
94: l_curr_suffix varchar2(3);
95: l_where_clause varchar2(10000);
96: l_viewby_select varchar2(400); -- needed to be increased from 200
97: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

Line 363: , x_custom_output out nocopy bis_query_attributes_tbl

359:
360: procedure get_dist_var_sql
361: ( p_param in bis_pmv_page_parameter_tbl
362: , x_custom_sql out nocopy varchar2
363: , x_custom_output out nocopy bis_query_attributes_tbl
364: )
365: is
366:
367: l_dimension_tbl isc_fs_rpt_util_pkg.t_dimension_tbl;

Line 369: l_custom_output bis_query_attributes_tbl;

365: is
366:
367: l_dimension_tbl isc_fs_rpt_util_pkg.t_dimension_tbl;
368: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
369: l_custom_output bis_query_attributes_tbl;
370: l_curr_suffix varchar2(3);
371: l_where_clause varchar2(10000);
372: l_viewby_select varchar2(400); -- needed to be increased from 200
373: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

Line 640: , x_custom_output out nocopy bis_query_attributes_tbl

636:
637: procedure get_time_var_dtr_sql
638: ( p_param in bis_pmv_page_parameter_tbl
639: , x_custom_sql out nocopy varchar2
640: , x_custom_output out nocopy bis_query_attributes_tbl
641: )
642: is
643:
644: l_dimension_tbl isc_fs_rpt_util_pkg.t_dimension_tbl;

Line 656: l_custom_output bis_query_attributes_tbl;

652:
653: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
654: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
655:
656: l_custom_output bis_query_attributes_tbl;
657:
658: l_curr_suffix varchar2(2);
659:
660: l_rank_order varchar2(100);

Line 782: , x_custom_output out nocopy bis_query_attributes_tbl

778:
779: procedure get_dist_var_dtr_sql
780: ( p_param in bis_pmv_page_parameter_tbl
781: , x_custom_sql out nocopy varchar2
782: , x_custom_output out nocopy bis_query_attributes_tbl
783: )
784: is
785: l_dimension_tbl isc_fs_rpt_util_pkg.t_dimension_tbl;
786: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;

Line 797: l_custom_output bis_query_attributes_tbl;

793:
794: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
795: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
796:
797: l_custom_output bis_query_attributes_tbl;
798:
799: l_curr_suffix varchar2(2);
800:
801: l_rank_order varchar2(100);