Search Results get_parameter_value

Overview

APPS.HR_JP_PARAMETERS_PKG is a Japanese localization utility package within the Oracle E-Business Suite Human Resources (HR) module. Its role is to provide a simple, centralized key-value store for configuration parameters that are specific to Japanese statutory and localization requirements, such as social insurance rates, tax thresholds, and other regulatory constants that vary by legislation or installation. Rather than hard-coding such values across multiple forms, reports, and concurrent programs, the localization layer persists them in a single table and retrieves them through this package.

The package declares AUTHID CURRENT_USER and is owned by the APPS schema, meaning it executes with the privileges of the calling session and relies on APPS synonyms to reach its underlying table. This design is typical of EBS localization helper packages, which are intended to be called from within the EBS runtime (forms, concurrent managers, or other PL/SQL) rather than exposed as a standalone API. The header comment ($Header: hrjpparm.pkh 115.1 99/10/12 02:10:41 porting ship $) indicates the specification has been stable since the original porting shipment, reflecting its narrow, well-defined purpose.

Key Procedures and Functions

The package exposes two documented program units:

• GET_PARAMETER_VALUE — a function that returns a parameter value as a VARCHAR2. It accepts an owner identifier and a parameter name, and resolves the stored value for that owner/name combination. This is the function users most commonly reference when searching for "get_parameter_value," since it is the read access point for Japanese HR configuration data.
• PUT_PARAMETER_VALUE — a procedure that writes or updates a parameter value for a given owner and parameter name. It is the maintenance counterpart to the getter, used to set or refresh stored configuration values.

The specification includes a commented-out pragma restrict_references(get_parameter_value, WNDS, WNPS, RNPS), which historically asserted that the function writes no database state and reads no package state. This is consistent with a read-only lookup function, though the pragma is not active in the shipped source.

Tables Accessed

The package reads and writes the HR_JP_PARAMETERS table, accessed through an APPS synonym. This table is the persistence layer for the owner/name/value triples manipulated by the two program units. GET_PARAMETER_VALUE performs the lookup query, while PUT_PARAMETER_VALUE performs the insert or update. No other tables are documented as referenced by this package.

Usage Notes

HR_JP_PARAMETERS_PKG is invoked as an internal localization service rather than through a user-facing API. Typical callers include Japanese HR forms, concurrent programs, and other PL/SQL packages that need to resolve a localized parameter at runtime. The ETRM metadata records that the package is referenced by one other package, confirming its role as a dependency within the Japanese HR localization code base. Custom code extending Japanese HR functionality can call GET_PARAMETER_VALUE to retrieve configured values and PUT_PARAMETER_VALUE to maintain them, but should preserve the owner/parameter-name conventions used by the seeded localization so that existing callers continue to resolve values correctly.