Results for “hr_java_conv_util_ss”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

HR_JAVA_CONV_UTIL_SS is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite, documented and valid in both release 12.1.1 and 12.2.2. Its name indicates its role as a Java conversion utility within the Oracle HRMS (Human Resources Management System) product family. The package provides server-side conversion and error-handling helpers used by HRMS Java-based components and by PL/SQL code that must exchange data with those components. It is classified as "OTHER" in the ETRM API classification scheme, meaning it is an internal utility rather than a public, declaratively published business API, and direct customer invocation is not a supported integration path.

The package does not own business data and does not implement any HR transactional logic. Instead, it standardizes the way scalar values and error text are translated between the Java layer and the database layer. This supports the OAF and Java-based self-service pages in the HRMS stack, where consistent type conversion and consistent error messaging are required to keep behavior aligned between the middle-tier and the database.

Key Procedures and Functions

The documented interface exposes three program units:

• GET_BOOLEAN — Returns a boolean representation of a value supplied by the caller. It is used where an HRMS Java component or PL/SQL routine must normalize a stored or transmitted value into a true/false result.
• GET_NUMBER — Returns a numeric representation of a value supplied by the caller. It supports conversion of values arriving from the Java/middle tier or from character-based storage into a NUMBER suitable for arithmetic or comparison within PL/SQL.
• GET_FORMATTED_ERROR_MESSAGE — Returns a consistently formatted error message string. It relies on the HR_MESSAGE package to resolve message text and applies conversion formatting so the message can be returned to a Java caller or logged.

Parameter lists are not documented in the ETRM metadata and should be confirmed against the deployed package specification in each environment before use.

Tables Accessed

The ETRM dependency record does not list any application tables accessed directly by HR_JAVA_CONV_UTIL_SS. The package depends on the package specifications HR_JAVA_CONV_UTIL_SS (its own specification), HR_MESSAGE, and HR_UTILITY, and on the SYS STANDARD package. Message text and utility validations are therefore obtained through HR_MESSAGE and HR_UTILITY rather than through direct SQL against HRMS base tables. Consequently, the package is effectively stateless with respect to HR business data, and any table access it does perform is indirect, through those dependency packages.

Usage Notes

HR_JAVA_CONV_UTIL_SS is referenced by 25 other database objects, confirming its role as a shared internal utility rather than an entry-point API. Typical invocation points include Java-based HRMS self-service flows, OAF controllers and model code, and PL/SQL routines that must present values or messages in a Java-compatible format. It may also be reached indirectly from concurrent programs and forms that call the referencing packages.

Because the package is classified as OTHER and is not referenced by any of the objects it calls, it should be treated as Oracle-internal. Customizations should not call it directly; the supported approach is to use the documented public HRMS APIs, which in turn reach this utility. It should not be modified, and any diagnostic work involving it should begin with the deployed specification to establish actual signatures.