Search Results validate_compare

Overview

APPS.BIS_AK_REGION_PUB is a public PL/SQL package in the Oracle E-Business Suite Applications (APPS) schema that manages the definition, persistence, and validation of "regions" and "region items" used by Oracle Business Intelligence System (BIS) performance management dashboards. Regions represent the container objects that organize performance measures, KPIs, and comparisons into dashboard layouts, while region items represent the individual measures and comparisons placed within a region. The package acts as a controlled public API layer over the underlying AK_REGIONS, AK_REGIONS_TL, and AK_REGION_ITEMS tables, shielding callers from direct DML and centralizing validation logic. It is classified as a PUB (public) API and is documented in ETRM as VALID in both 12.1.1 and 12.2.2. The user search term "bis_pmv_region_items_pvt" is directly relevant: BIS_PMV_REGION_ITEMS_PVT is one of the eight packages documented as referencing BIS_AK_REGION_PUB, confirming that this package is a foundational dependency for the performance management region-items private layer.

Key Procedures and Functions

The package exposes 34 documented procedures and functions. The core DML routines are INSERT_REGION_ROW, UPDATE_REGION_ROW, and DELETE_REGION_ROW, which manage the region header records in AK_REGIONS and its translation table. INSERT_REGION_ITEM_ROW, UPDATE_REGION_ITEM_ROW, and DELETE_REGION_ITEM_ROW perform equivalent operations on individual region items. Bulk deletion is handled by DELETE_REGION_AND_REGION_ITEMS, DELETE_REGION_ITEMS, and DELETE_EXT_REGION_ITEMS, the last targeting extended region item definitions. Validation utilities include VALID_DATABASE_OBJECT, AK_OBJECT_EXISTS (checking whether an AK object is registered), and IS_MEASURE_TYPE and IS_COMPARE_TYPE, which classify a region item by type. VALIDATE_MEASURE and VALIDATE_COMPARE enforce measure- and comparison-specific business rules. Record retrieval and manipulation are supported by GET_REGION_ITEM_REC, UPDATE_REGION_ITEM_ATTR, and the LOCK_REGION_ROW concurrency control routine. INSERT_AK_OBJECT registers the region as an AK object, AK_DATA_SET provides dataset handling, and IS_MEASURE_TYPE, IS_COMPARE_TYPE, VALIDATE_MEASURE, and VALIDATE_COMPARE together form the validation core of the API. No parameter signatures are documented in ETRM; the procedure set reflects a consistent CRUD-plus-validation pattern typical of Oracle public APIs.

Tables Accessed

BIS_AK_REGION_PUB operates through APPS synonyms on the following tables: AK_REGIONS stores region header definitions; AK_REGIONS_TL holds language-specific translated region names and descriptions; AK_REGION_ITEMS stores the items associated with each region; BIS_AK_REGION_ITEM_EXTENSION provides extended attributes for region items beyond the base AK_REGION_ITEMS columns; AK_ATTRIBUTES is used during attribute validation and updates; AK_OBJECTS registers the region as an attributable AK object; and USER_OBJECTS supports VALID_DATABASE_OBJECT by confirming existence of underlying database objects. Documented dependencies also include BISBV_PERFORMANCE_MEASURES and BIS_COMMON_UTILS for measure sourcing and shared utilities, plus the FND_API and STANDARD packages.

Usage Notes

Because this is a PUB-classified API, it is intended for invocation from other BIS/BSC packages rather than through user-facing Forms. Documented callers include BIS_PMV_REGION_ITEMS_PVT, BIS_PMV_REGION_PVT, BIS_PAGE_PUB, BIS_MEASURE_PVT, BIS_UTIL, BSC_KPI_PVT, BSC_BIS_KPI_CRUD_PUB, and BSC_MIGRATION. This confirms its role in dashboard page and KPI composition as well as in BSC migration routines that insert or migrate region and region-item data. Custom code should use these procedures rather than direct DML on AK_REGIONS or AK_REGION_ITEMS to preserve translation handling, extension records, and validation behavior. The LOCK_REGION_ROW routine should be used before updates in concurrent scenarios to prevent lost updates.