Search Results hri_oltp_pmv_util_param




Overview
Explore in AI Chat

Overview

APPS.HRI_OLTP_PMV_UTIL_PARAM is a utility package body within the Oracle E-Business Suite Human Resources Intelligence (HRMSi) and Daily Business Intelligence (DBI) reporting framework. Its role is to manage and normalize the parameter values that drive the materialized views, PMV (Performance Management Viewer) regions, and OLTP-based summary queries used throughout the HR analytics layer. In Oracle EBS 12.1.1 and 12.2.2, the PMV reporting engine depends on a consistent mechanism for interpreting user-supplied runtime parameters — date ranges, dimension key filters, hierarchy levels, and "All"/NULL selection semantics — and this package provides that mechanism.

The package body encapsulates helper logic that decides whether a parameter value actually restricts a query result set, populates bind variable tables with properly typed and formatted values (including Oracle date literals), and retrieves parameter definitions stored in tables. Because PMV queries are typically generated dynamically, the utility functions here are essential to constructing valid SQL at runtime without embedding user input directly into query text.

Key Procedures and Functions

  • GET_PARAMETERS_FROM_TABLE — The single documented procedure in the package metadata. It retrieves parameter definitions and their associated values from a backing table (referenced through the APPS synonym PLITBLM) and returns them for use in the calling PMV or reporting process. It forms the entry point through which runtime parameter configuration is loaded into the reporting engine.
  • IS_PARAMETER_SET — From the source excerpt, this function determines whether a restricting parameter value has actually been supplied by a user. It returns FALSE when the value is NULL or corresponds to the "All" indicator (the conventional "-1" sentinel), and TRUE otherwise. This allows downstream query builders to decide whether to apply a WHERE clause restriction.
  • FILL_IN_BIND_TABLE — Populates the PMV bind table structure with time and dimension parameters, converting date values into Oracle TO_DATE literals and copying metadata-driven bind strings into the parameter record. This is used to assemble the binding context for dynamically generated PMV SQL.

Tables Accessed

The package references the APPS synonym PLITBLM. In the HRMSi/DBI schema, this table stores PMV and parameter-related definition data used by the performance management reporting layer. GET_PARAMETERS_FROM_TABLE reads from this source to supply the parameter values and metadata consumed by the reporting engine. No other tables are documented in the ETRM metadata for this package.

Usage Notes

HRI_OLTP_PMV_UTIL_PARAM is not intended for direct end-user invocation; it is an internal utility. It is referenced by 48 other database objects according to the ETRM metadata, indicating broad reuse across the HRMSi PMV stack. The package is typically called from within other PL/SQL packages that build and execute PMV queries, from DBI dashboards and Performance Management Viewer regions, and from concurrent programs that refresh or render analytical content. Its classification as OTHER (rather than a public API) means it should be treated as a private support routine. Customizations should avoid calling it directly, because parameter-passing conventions and the "-1"/NULL "All" semantics are internal design details that may change between point releases of 12.1.1 and 12.2.2.