Search Results bis_utilities_pvt




Overview
Explore in AI Chat

Overview

APPS.BIS_INDICATOR_REGION_PUB is a public PL/SQL package in the Oracle E-Business Suite Business Intelligence System (BIS) product family. Its function is to manage the persistence of user-specific indicator selections that are associated with regions of a BIS indicator dashboard or portal page. In other words, the package governs which performance indicators a given user has chosen to display within a designated region of the application's indicator framework.

The package is classified as a public (PUB) API, which signals that it is intended for supported external invocation by other application modules and by custom extensions rather than being restricted to internal use. Its status is recorded as VALID, and it is owned by the APPS schema. The user search term "bis_utilities_pvt" is relevant here because BIS_UTILITIES_PVT appears in the dependency documentation as one of the objects that references BIS_INDICATOR_REGION_PUB, placing this package within the shared utility and presentation layer of the BIS indicator subsystem.

Key Procedures and Functions

The documented interface exposes five procedures or functions that cover the full lifecycle of a user's indicator selection record:

  • CREATE_USER_IND_SELECTION — Inserts a new user indicator selection, recording the indicators a user has chosen for a region.
  • RETRIEVE_USER_IND_SELECTIONS — Returns the indicator selections previously saved for a user, typically for rendering the region.
  • UPDATE_USER_IND_SELECTION — Modifies an existing selection record to reflect changes in the user's chosen indicators.
  • DELETE_USER_IND_SELECTIONS — Removes selection records, for example when a user clears a region or resets preferences.
  • A fifth documented routine — the metadata enumerates five total entries; the four above represent the create, retrieve, update, and delete operations that dominate the API surface.

As a public API, the package follows Oracle's API conventions, including use of FND_API, referenced in its dependency list, which provides standardized error handling and message stacking.

Tables Accessed

The package operates against the BIS_USER_IND_SELECTIONS table, accessed through an APPS synonym. This is the primary store for user-level indicator choices mapped to regions. The HTP table reference indicates that the package may emit HTML output when indicator regions are rendered to a browser-based dashboard. PLITBLM is an Oracle PL/SQL-supplied package used for manipulating PL/SQL tables and collections, which the API likely employs to pass sets of indicator identifiers between procedures.

Usage Notes

BIS_INDICATOR_REGION_PUB is referenced by twelve other packages, including BIS_ACTUAL_PUB, BIS_ACTUAL_PVT, BIS_INDICATOR_REGION_PVT, BIS_INDICATOR_REGION_UI_PVT, BIS_PMF_REG_SERVICE_PVT, BIS_PORTLET_PMREGION, BIS_UTILITIES_PVT, and alert packages such as GL_BIS_ALERTS_PKG, HR_BIS_ALERTS, OE_BIS_ALERTS, and POA_BIS_ALERTS. This dependency footprint confirms that the package is invoked from dashboard UI code, portlet rendering logic, and alert processing flows. It depends in turn on BIS_TARGET_LEVEL_PUB, BIS_UTILITIES_PUB, and FND_API. Administrators and developers should treat it as a supported entry point for managing user indicator selections, while avoiding direct DML against BIS_USER_IND_SELECTIONS in order to preserve API consistency.