DBA Data[Home] [Help]

APPS.ISC_FS_TASK_BAC_AGING_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 312: , p_custom_output in out nocopy bis_query_attributes_tbl

308:
309: procedure get_curr_prior_dates
310: ( p_xtd in varchar2
311: , p_comparison_type in varchar2
312: , p_custom_output in out nocopy bis_query_attributes_tbl
313: )
314: is
315:
316: l_period_bit_tbl constant isc_fs_task_bac_age_etl_pkg.t_period_bit_tbl :=

Line 445: , x_custom_output out nocopy bis_query_attributes_tbl

441:
442: procedure get_tbl_sql
443: ( p_param in bis_pmv_page_parameter_tbl
444: , x_custom_sql out nocopy varchar2
445: , x_custom_output out nocopy bis_query_attributes_tbl
446: )
447: is
448:
449: l_dimension_tbl isc_fs_rpt_util_pkg.t_dimension_tbl;

Line 451: l_custom_output bis_query_attributes_tbl;

447: is
448:
449: l_dimension_tbl isc_fs_rpt_util_pkg.t_dimension_tbl;
450: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
451: l_custom_output bis_query_attributes_tbl;
452: l_curr_suffix varchar2(3);
453: l_where_clause varchar2(10000);
454: l_viewby_select varchar2(400); -- needed to be increased from 200
455: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

Line 717: , x_custom_output out nocopy bis_query_attributes_tbl

713:
714: procedure get_trd_sql
715: ( p_param in bis_pmv_page_parameter_tbl
716: , x_custom_sql out nocopy varchar2
717: , x_custom_output out nocopy bis_query_attributes_tbl
718: )
719: is
720:
721: l_dimension_tbl isc_fs_rpt_util_pkg.t_dimension_tbl;

Line 723: l_custom_output bis_query_attributes_tbl;

719: is
720:
721: l_dimension_tbl isc_fs_rpt_util_pkg.t_dimension_tbl;
722: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
723: l_custom_output bis_query_attributes_tbl;
724: l_curr_suffix varchar2(3);
725: l_where_clause varchar2(10000);
726: l_viewby_select varchar2(400); -- needed to be increased from 200
727: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

Line 933: , x_custom_output out nocopy bis_query_attributes_tbl

929:
930: procedure get_dtl_rpt_sql
931: ( p_param in bis_pmv_page_parameter_tbl
932: , x_custom_sql out nocopy varchar2
933: , x_custom_output out nocopy bis_query_attributes_tbl
934: )
935: as
936:
937: l_dimension_tbl isc_fs_rpt_util_pkg.t_dimension_tbl;

Line 939: l_custom_output bis_query_attributes_tbl;

935: as
936:
937: l_dimension_tbl isc_fs_rpt_util_pkg.t_dimension_tbl;
938: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
939: l_custom_output bis_query_attributes_tbl;
940: l_curr_suffix varchar2(3);
941: l_where_clause varchar2(10000);
942: l_viewby_select varchar2(400); -- needed to be increased from 200
943: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;