Search Results get_params




Overview
Explore in AI Chat

Overview

APPS.BIV_DBI_PARAM_PKG is a server-side PL/SQL package that belongs to the Oracle EBS BIV (Business Intelligence Views / DBI) subsystem, as indicated by the source file header identifier bivsrvrpars.pls. The package is declared with AUTHID CURRENT_USER, meaning its procedures execute with the privileges of the invoking user schema rather than the definer, a convention common to utility packages that supply configuration values to callers across multiple schemas. Its documented purpose is to expose stored server parameters and default time-related settings used by the BIV/DBI reporting and analytics objects. The source header identifies revision 115.0, dated 2003/10/06, indicating the package dates to the earlier DBI generation of Oracle EBS and has remained largely unchanged through 12.1.1 and 12.2.2.

Key Procedures and Functions

The package exposes three documented program units, all functions:

  • GET_PARAMS — Returns a session- and region-specific parameter string. Its signature accepts a region code argument with a default of NULL, allowing callers to either request parameters scoped to a particular BIV region or request the general/server-level parameter set when no region is supplied. This function is the target of the user's "get_params" search and is the principal entry point of the package.
  • GET_DEF_TIME_PER — Returns the default time period setting. This value is used by BIV/DBI reporting components to establish the default periodicity or time period context for analytical queries.
  • GET_DEF_TIME_COMP — Returns the default time comparison setting, supplying the default basis on which period-over-period or comparative analysis is performed by the DBI reporting layer.

No other functions or procedures are declared in the documented package specification. No parameters beyond the optional region code on GET_PARAMS are documented.

Tables Accessed

The documented metadata lists no tables referenced through APPS synonyms. This is consistent with a parameter-retrieval package whose values are sourced from server parameter files, profile options, or BIV configuration tables not enumerated in the ETRM extract. Because the package is AUTHID CURRENT_USER and returns scalar VARCHAR2 values, it is expected to perform lightweight lookups rather than transactional reads or writes. Where dynamic references to configuration tables exist, they would resolve against the calling user's schema.

Usage Notes

The package is referenced by zero other packages per the documented metadata, indicating that its callers are not other PL/SQL packages but instead the BIV/DBI views, Oracle Forms-based DBI setup and reporting screens, and concurrent programs that render business intelligence content. In practice, GET_PARAMS is invoked when a DBI report or view must obtain its runtime parameter string, while GET_DEF_TIME_PER and GET_DEF_TIME_COMP are called at initialization to establish default time period and comparison semantics. Custom code integrating with DBI analytics may call these functions directly, secured by execute grants on the APPS package. Because the package is essentially static since 2003, integrators should treat it as a stable but legacy interface, and any dependency on return-value formatting should be validated against the specific 12.1.1 or 12.2.2 environment in use.