Search Results hr_number




Overview
Explore in AI Chat

Overview

HR_NUMBER is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under ETRM as an "OTHER" API. Its business function is to provide a standardised mechanism for converting human-readable values into canonical (internal) representations and back again — a capability used wherever Oracle EBS must normalise, store, and later re-render numeric or currency values in a form that is independent of locale-specific formatting. The package exposes seven documented conversion routines that fall into three families: number conversions (NUMBER_TO_CANONICAL, CANONICAL_TO_NUMBER), character-number conversions (CHARNUMBER_TO_NUMBER, CHARNUMBER_TO_CANONICAL, CANONICAL_TO_CHARNUMBER), and currency conversions (CANONICAL_TO_CHARCURRENCY, CHARCURRENCY_TO_CANONICAL). In Oracle EBS 12.1.1 and 12.2.2 the object is VALID in the APPS schema.

Key Procedures and Functions

The seven documented routines form three paired conversion groups:

  • NUMBER_TO_CANONICAL — converts a numeric value into the canonical representation used internally by Oracle EBS.
  • CANONICAL_TO_NUMBER — the inverse, returning a numeric value from a canonical representation.
  • CHARNUMBER_TO_NUMBER — parses a character-formatted number into a native numeric value.
  • CHARNUMBER_TO_CANONICAL — converts a character-formatted number directly into canonical form.
  • CANONICAL_TO_CHARNUMBER — renders a canonical number back to its character string form.
  • CANONICAL_TO_CHARCURRENCY — renders a canonical value as a character currency string.
  • CHARCURRENCY_TO_CANONICAL — parses a character currency string into canonical form.

Parameter lists are not documented in the ETRM metadata and should not be assumed; callers must verify signatures from the package specification in the target instance.

Tables Accessed

The only documented table reference is V$NLS_PARAMETERS, accessed through an APPS synonym. This is consistent with the package's locale-sensitive behaviour: NLS parameters such as NLS_NUMERIC_CHARACTERS and NLS_CURRENCY determine the decimal separator, group separator, and currency symbol used when parsing or rendering character-formatted numbers and currencies. The package does not appear to persist data to application tables; it functions as a stateless translation utility.

Usage Notes

HR_NUMBER is referenced by only one other documented package, PQP_GB_PSI_ADDRESS, which sits within the Oracle Payroll (PQP) UK legislative area — indicating that HR_NUMBER is used to normalise address-related numeric or currency data during payroll processing. It may be invoked from any PL/SQL context: concurrent programs, forms, or custom code that requires locale-independent canonical storage of numeric values. Because the routines are NLS-dependent, callers should ensure the session's NLS settings match the data being converted. The documented dependency chain shows HR_NUMBER depending on SYS.STANDARD only, confirming it is a low-level utility with no application-table footprint. Developers extending or diagnosing payroll address logic should treat HR_NUMBER as the canonical conversion layer and avoid duplicating its logic in custom code.