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:
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
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;
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;
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;
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;
717: l_bucket_rec bis_bucket_pub.bis_bucket_rec_type;
718: l_return_status varchar2(3);
719: l_error_tbl bis_utilities_pub.error_tbl_type;
720:
721: l_custom_rec BIS_QUERY_ATTRIBUTES;
722:
723: BEGIN
724:
725: bis_bucket_pub.retrieve_bis_bucket
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: