Search Results bis_lov_pub

Overview

BIS_LOV_PUB is a public PL/SQL package in the APPS schema that provides the list-of-values (LOV) framework used by Oracle E-Business Suite Business Intelligence System (BIS) and Enterprise Planning and Performance Management modules. It encapsulates the server-side logic required to populate, render, and manage the selection lists (LOVs) presented to users in BIS indicator and dashboard forms. The API is classified as PUB, indicating it is a published interface intended to be called by other application code rather than an internal helper. In Oracle EBS 12.1.1 and 12.2.2 this package underpins the dynamic LOV behavior in the HTML-based BIS indicator regions, allowing users to search for and select business indicators, dimensions, and related reference data directly within the application UI.

The package has a status of VALID and its dependencies confirm its central role: it references the internal utility package BIS_UTILITIES_PVT and the SYS package STANDARD, and it is itself referenced by BIS_INDICATOR_REGION_UI_PVT and BIS_INTERMEDIATE_LOV_PVT, as well as being recursively referenced within its own body.

Key Procedures and Functions

The documented API exposes ten procedures and functions. The principal entry point is MAIN, which orchestrates the overall LOV request lifecycle. LOV_SEARCH performs the actual query execution against the LOV data source, while LOV_DATA assembles and returns the result set for display. LOV_BUTTONS generates the button controls associated with the LOV region. CONCAT_STRING is a helper that concatenates display components, and LOVJSCRIPT and EDITLOVJSCRIPT emit the JavaScript required for client-side LOV interaction and editing. SETGLOBALVAR populates global variables used to carry LOV state between requests.

Together these routines form a coherent pipeline: a search request (LOV_SEARCH) is resolved and rendered (LOV_DATA, LOV_BUTTONS, LOVJSCRIPT), with supporting string and session-state utilities (CONCAT_STRING, SETGLOBALVAR) and an editing variant (EDITLOVJSCRIPT) for modification scenarios. No parameter lists are documented in the ETRM metadata; callers should consult the package specification in the database for exact signatures.

Tables Accessed

The documented table references are indirect and resolve through APPS synonyms: DBMS_SQL and PLITBLM. DBMS_SQL is the Oracle-supplied dynamic SQL package, which indicates that BIS_LOV_PUB builds and executes LOV queries dynamically rather than against fixed, statically named tables. This design allows the LOV framework to serve heterogeneous indicator and dimension queries without hard-coding table names. PLITBLM is the PL/SQL internal table-index-by-binary-integer package used for collection handling, supporting the assembly of result rows before they are returned to the calling region. Because the metadata lists no application data tables directly, the actual business data is fetched indirectly through the dynamic SQL statements constructed at runtime.

Usage Notes

BIS_LOV_PUB is typically invoked indirectly rather than called from custom code. Its documented callers are BIS_INDICATOR_REGION_UI_PVT, which renders the indicator region UI, and BIS_INTERMEDIATE_LOV_PVT, which builds intermediate LOV structures. In a standard EBS 12.1.1 or 12.2.2 deployment, a user opening a BIS indicator or dashboard form triggers these callers, which in turn invoke BIS_LOV_PUB to deliver the LOV content and associated JavaScript. Customizations or extensions that need to embed a BIS-style LOV should call the PUB entry points (MAIN, LOV_SEARCH, LOV_DATA) rather than reimplementing the logic. Because the package relies on DBMS_SQL for dynamic queries, performance and SQL execution privileges for the invoking schema must be verified during any upgrade or cloning activity, and the package should be recompiled after patches that alter its dependencies.