DBA Data[Home] [Help]

APPS.ISC_DEPOT_RPT_UTIL_PKG dependencies on BIS_QUERY_ATTRIBUTES_TBL

Line 46: , p_custom_output IN OUT nocopy bis_query_attributes_tbl);

42: , p_short_name IN varchar2
43: , p_dim_level IN varchar2
44: , p_low IN varchar2
45: , p_high IN varchar2
46: , p_custom_output IN OUT nocopy bis_query_attributes_tbl);
47:
48: PROCEDURE GET_BUCKET_RANGE_ID (p_parameter_id IN VARCHAR2 ,
49: x_bucket_range_ids_tbl OUT NOCOPY bucket_range_typ);
50:

Line 57: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL

53: ,p_pcategory_flag IN VARCHAR2
54: ,p_rtype_flag IN VARCHAR2
55: ,p_repair_type IN VARCHAR2
56: ,p_bucket_flag IN VARCHAR2
57: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL
58: ,x_where_clause OUT NOCOPY VARCHAR2);
59:
60: -- process_parameters
61: -- Generic routine to process the parameters passed in from the PMV

Line 79: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

75: x_mv_type OUT NOCOPY VARCHAR2,
76: x_aggregation_flag OUT NOCOPY NUMBER,
77: p_mv_set IN VARCHAR2,
78: p_trend IN VARCHAR2,
79: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
80:
81: IS
82: l_dim_map poa_dbi_util_pkg.poa_dbi_dim_map;
83: l_dim_bmap NUMBER := 0;

Line 521: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL

517: ,p_pcategory_flag IN VARCHAR2
518: ,p_rtype_flag IN VARCHAR2
519: ,p_repair_type IN VARCHAR2
520: ,p_bucket_flag IN VARCHAR2
521: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL
522: ,x_where_clause OUT NOCOPY VARCHAR2)
523: IS
524: l_parameter_id VARCHAR2(20);
525: l_bucket_short_name BIS_BUCKET.SHORT_NAME%TYPE;

Line 630: x_custom_output OUT NOCOPY bis_query_attributes_tbl)

626: p_dim_level IN VARCHAR2,
627: p_bucket_short_name IN BIS_BUCKET.SHORT_NAME%TYPE,
628: p_col_name IN VARCHAR2,
629: x_where_clause IN OUT NOCOPY VARCHAR2,
630: x_custom_output OUT NOCOPY bis_query_attributes_tbl)
631: IS
632:
633: l_parameter_id VARCHAR2(20);
634: l_length NUMBER;

Line 711: , p_custom_output IN OUT nocopy bis_query_attributes_tbl

707: , p_short_name IN varchar2
708: , p_dim_level IN varchar2
709: , p_low IN varchar2
710: , p_high IN varchar2
711: , p_custom_output IN OUT nocopy bis_query_attributes_tbl
712: )
713: IS
714: l_range_low number;
715: l_range_high number;

Line 768: p_custom_output := bis_query_attributes_tbl();

764: end if;
765: end if;
766:
767: if p_custom_output is null then
768: p_custom_output := bis_query_attributes_tbl();
769: end if;
770:
771: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
772: