Search Results update_bis_bucket_wrapper

Overview

BIS_BUCKET_PVT is a private PL/SQL package in the APPS schema that implements the core processing logic for the Oracle EBS "BIS" (Business Intelligence System) Buckets framework. Buckets are functional groupings used throughout Oracle EBS Analytics and reporting to classify, rank, or segment data ranges — for example, ABC classifications, aging ranges, or profitability tiers. The package operates as the private (PVT) implementation layer beneath the public API BIS_BUCKET_PUB, exposing the actual business logic while shielding direct callers from the internal model. Its classification as PVT signals that it is not part of the supported public interface and should be invoked only through BIS_BUCKET_PUB or internal framework code. The package handles creation, maintenance, translation, validation, and retrieval of bucket definitions and their customizations, and it validates bucket type applicability, overlapping ranges, and discontinuous ranges.

Key Procedures and Functions

The 22 documented subprograms are organized into wrapper routines (invoked by BIS_BUCKET_PUB), core entity operations, and validation/utility helpers.

• Wrapper routines: CREATE_BIS_BUCKET_WRAPPER, UPDATE_BIS_BUCKET_WRAPPER, DELETE_BIS_BUCKET_WRAPPER, RETRIEVE_BIS_BUCKET_WRAPPER, and VALIDATE_BUCKET_WRAPPER provide the entry points invoked by the public API layer, handling error trapping and API-level context before delegating to the core routines.
• Core bucket operations: CREATE_BIS_BUCKET, UPDATE_BIS_BUCKET, DELETE_BIS_BUCKET, and RETRIEVE_BIS_BUCKET perform the insert, update, delete, and query logic against the bucket tables.
• Customization and translation: UPDATE_CUST_BUCKET maintains bucket customizations; TRANSLATE_BUCKET and RESET_BUCKET manage translated bucket text and reset behavior.
• Validation and utility: IS_BUCKET_TYPE_EXISTS, VALIDATE_BUCKET, VALIDATE_BUCKET_OVERLAPPING, VALIDATE_BUCKET_DISCONTINUOUS, VALIDATE_FROM_TO, and IS_VALID_APPLICATION_ID enforce bucket-type existence, non-overlapping and contiguous range rules, valid from/to boundaries, and application-id validity.
• Reporting and query helpers: GET_REPORT_LISTS returns bucket lists for reporting; POPULATE_LOC_BUCKET_RANGE_TBL populates a PL/SQL table (PLITBLM) of bucket ranges.

Tables Accessed

The package reads and writes the bucket entity tables: BIS_BUCKET and its translation table BIS_BUCKET_TL; BIS_BUCKET_CUSTOMIZATIONS and BIS_BUCKET_CUSTOMIZATIONS_TL for user-defined modifications and their translations; and the secure (_S) variants BIS_BUCKET_S and BIS_BUCKET_CUSTOMIZATIONS_S. Validation and lookup logic references FND_APPLICATION, FND_LANGUAGES, FND_LOOKUP_TYPES, FND_LOOKUP_VALUES, and AK_REGION_ITEMS. DUAL, DBMS_UTILITY, and PLITBLM support utility and PL/SQL table operations.

Usage Notes

BIS_BUCKET_PVT is intended for internal use. It is invoked by BIS_BUCKET_PUB, and its procedures also call each other (recursive dependency on itself). Custom code should call BIS_BUCKET_PUB rather than this package directly, since the PVT signature may change between releases. Typical invocation paths include EBS Analytics setup forms and concurrent programs that create or update buckets, and reporting utilities that use GET_REPORT_LISTS and POPULATE_LOC_BUCKET_RANGE_TBL. The package relies on FND_API for message and error handling conventions standard to EBS PL/SQL APIs.