APPS.ISC_DEPOT_RPT_UTIL_PKG dependencies on BIS_BUCKET

Line 525: l_bucket_short_name BIS_BUCKET.SHORT_NAME%TYPE;

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;
526:
527: BEGIN
528: IF (p_mv_set IN('BKLG','COSTS','CHARGES','MARGIN','MTTR','SRVC','CMPAGN1','BKLAGN1')) THEN
529: x_where_clause := x_where_clause || ' and fact.aggregation_flag = :AGGREGATION_FLAG' ;

Line 627: p_bucket_short_name IN BIS_BUCKET.SHORT_NAME%TYPE,

623: END GET_ADDITIONAL_WHERECLAUSE;
624:
625: PROCEDURE GET_BUCKET_WHERE_CLAUSE (p_param IN BIS_PMV_PAGE_PARAMETER_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

Line 717: l_bucket_rec bis_bucket_pub.bis_bucket_rec_type;

713: IS
714: l_range_low number;
715: l_range_high number;
716:
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;

Line 725: bis_bucket_pub.retrieve_bis_bucket

721: l_custom_rec BIS_QUERY_ATTRIBUTES;
722:
723: BEGIN
724:
725: bis_bucket_pub.retrieve_bis_bucket
726: ( p_short_name => p_short_name
727: , x_bis_bucket_rec => l_bucket_rec
728: , x_return_status => l_return_status
729: , x_error_tbl => l_error_tbl

Line 727: , x_bis_bucket_rec => l_bucket_rec

723: BEGIN
724:
725: bis_bucket_pub.retrieve_bis_bucket
726: ( p_short_name => p_short_name
727: , x_bis_bucket_rec => l_bucket_rec
728: , x_return_status => l_return_status
729: , x_error_tbl => l_error_tbl
730: );
731: