DBA Data[Home] [Help]

APPS.ISC_MAINT_WO_BACKLOG_RPT_PKG dependencies on BIS_QUERY_ATTRIBUTES_TBL

Line 10: , p_custom_output in out nocopy bis_query_attributes_tbl

6: function get_fact_mv_name
7: ( p_report_type in varchar2
8: , p_param in bis_pmv_page_parameter_tbl
9: , p_dim_bmap in number
10: , p_custom_output in out nocopy bis_query_attributes_tbl
11: )
12: return varchar2
13: is
14:

Line 214: , x_custom_output out nocopy bis_query_attributes_tbl

210:
211: procedure get_tbl_sql
212: ( p_param in bis_pmv_page_parameter_tbl
213: , x_custom_sql out nocopy varchar2
214: , x_custom_output out nocopy bis_query_attributes_tbl
215: )
216: is
217:
218: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;

Line 231: l_custom_output bis_query_attributes_tbl;

227:
228: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
229: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
230:
231: l_custom_output bis_query_attributes_tbl;
232:
233: l_cost_element varchar2(200);
234: l_curr_suffix varchar2(2);
235:

Line 471: , x_custom_output out nocopy bis_query_attributes_tbl

467:
468: procedure get_trd_sql
469: ( p_param in bis_pmv_page_parameter_tbl
470: , x_custom_sql out nocopy varchar2
471: , x_custom_output out nocopy bis_query_attributes_tbl
472: )
473: is
474:
475: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;

Line 487: l_custom_output bis_query_attributes_tbl;

483:
484: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
485: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
486:
487: l_custom_output bis_query_attributes_tbl;
488:
489: l_cost_element varchar2(200);
490: l_curr_suffix varchar2(2);
491:

Line 640: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

636:
637:
638: procedure get_cur_past_due_dtl_sql(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: IS
642:
643: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;
644: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;

Line 655: l_custom_output bis_query_attributes_tbl;

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

Line 868: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

864:
865:
866: procedure get_wo_bl_dtl_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,
867: x_custom_sql OUT NOCOPY VARCHAR2,
868: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
869: is
870:
871: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;
872: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;

Line 884: l_custom_output bis_query_attributes_tbl;

880:
881: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
882: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
883:
884: l_custom_output bis_query_attributes_tbl;
885:
886: l_curr_suffix varchar2(2);
887:
888: l_rank_order varchar2(100);

Line 1078: , x_custom_output out nocopy bis_query_attributes_tbl

1074:
1075: procedure get_pastdue_aging_sql
1076: ( p_param in bis_pmv_page_parameter_tbl
1077: , x_custom_sql out nocopy varchar2
1078: , x_custom_output out nocopy bis_query_attributes_tbl
1079: )
1080: as
1081: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;
1082: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;

Line 1093: l_custom_output bis_query_attributes_tbl;

1089:
1090: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
1091: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
1092:
1093: l_custom_output bis_query_attributes_tbl;
1094:
1095: l_curr_suffix varchar2(2);
1096:
1097: l_rank_order varchar2(100);