DBA Data[Home] [Help]

APPS.ISC_MAINT_WO_CMPL_RPT_PKG dependencies on BIS_QUERY_ATTRIBUTES_TBL

Line 9: , p_custom_output in out nocopy bis_query_attributes_tbl

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

Line 217: , x_custom_output out nocopy bis_query_attributes_tbl

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

Line 233: l_custom_output bis_query_attributes_tbl;

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

Line 520: , x_custom_output out nocopy bis_query_attributes_tbl

516:
517: procedure get_trd_sql
518: ( p_param in bis_pmv_page_parameter_tbl
519: , x_custom_sql out nocopy varchar2
520: , x_custom_output out nocopy bis_query_attributes_tbl
521: )
522: is
523:
524: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;

Line 536: l_custom_output bis_query_attributes_tbl;

532:
533: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
534: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
535:
536: l_custom_output bis_query_attributes_tbl;
537:
538: l_cost_element varchar2(200);
539: l_curr_suffix varchar2(2);
540:

Line 714: , x_custom_output out nocopy bis_query_attributes_tbl

710:
711: procedure get_late_cmpl_age
712: ( p_param in bis_pmv_page_parameter_tbl
713: , x_custom_sql out nocopy varchar2
714: , x_custom_output out nocopy bis_query_attributes_tbl
715: )
716: is
717:
718: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;

Line 731: l_custom_output bis_query_attributes_tbl;

727:
728: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
729: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
730:
731: l_custom_output bis_query_attributes_tbl;
732:
733: l_cost_element varchar2(200);
734: l_curr_suffix varchar2(2);
735:

Line 850: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

846:
847:
848: PROCEDURE get_wo_dtl_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,
849: x_custom_sql OUT NOCOPY VARCHAR2,
850: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
851: IS
852:
853: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;
854: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;

Line 865: l_custom_output bis_query_attributes_tbl;

861:
862: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
863: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
864:
865: l_custom_output bis_query_attributes_tbl;
866:
867: l_curr_suffix varchar2(2);
868:
869: l_rank_order varchar2(100);

Line 1064: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

1060:
1061:
1062: PROCEDURE get_wo_late_dtl_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,
1063: x_custom_sql OUT NOCOPY VARCHAR2,
1064: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
1065: IS
1066:
1067: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;
1068: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;

Line 1080: l_custom_output bis_query_attributes_tbl;

1076:
1077: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
1078: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
1079:
1080: l_custom_output bis_query_attributes_tbl;
1081:
1082: l_curr_suffix varchar2(2);
1083:
1084: l_rank_order varchar2(100);