Search Results derive_per_add_address




Overview
Explore in AI Chat

Overview

HR_JP_UTILITY is a localization utility package owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It is classified in the E-Business Suite Technical Reference Manual (ETRM) as an "OTHER" API, meaning it is not a public, supported business API but an internal helper package whose routines are consumed by other Oracle-delivered modules, principally the Japanese localizations of Oracle Human Resources and Oracle Payroll. The package is defined with AUTHID CURRENT_USER and does not encapsulate a single business transaction; instead it provides reusable formatting and derivation primitives that other programs call to produce correctly structured Japanese person names, retrieve localized parameters, and derive address information in the Japanese legislative format.

Key Procedures and Functions

The documented interface exposes five routines:

  • PER_JP_FULL_NAME — A function that returns a formatted full name for a person using the Japanese name convention. It accepts the standard person name attributes (first name, middle names, last name, known as, title, suffix, pre-name adjunct) together with a large set of PER_INFORMATION flexfield values (PER_INFORMATION1 through PER_INFORMATION30) and returns the composed name as a VARCHAR2.
  • PER_JP_ORDER_NAME — A companion function introduced under Bug 3680631/Bug 3690631 that returns a person's name in the ordering required by Japanese business documents. It takes the same name and PER_INFORMATION attributes as PER_JP_FULL_NAME.
  • GET_PARAMETER — A utility function that retrieves a stored parameter value, providing centralized access to configuration values used by the Japanese localization routines.
  • DERIVE_HR_LOC_ADDRESS — A function that derives a location-level address in the Human Resources address structure, producing the localized address representation required for HR locations.
  • DERIVE_PER_ADD_ADDRESS — A function that derives a person-level address, corresponding to the search term derive_per_add_address. It assembles the Japanese-formatted address for a person record so that downstream processes and reports render addresses consistently.

Tables Accessed

The ETRM metadata documents a single referenced table: PAY_PAYROLL_ACTIONS, accessed through an APPS synonym. This table is the payroll action repository and is typically read to resolve action context, action status, or legislative information relevant to the parameter and derivation logic. The remaining documented functionality of the package is flexfield- and attribute-driven, operating on the parameter values passed into the name-formatting functions rather than on additional base tables.

Usage Notes

HR_JP_UTILITY is an internal localization helper. It is not referenced by any other documented package in the ETRM (referenced-by count of zero), which indicates its callers are forms, concurrent programs, and other Oracle-delivered PL/SQL units rather than a published package-to-package dependency chain. Because the package runs with AUTHID CURRENT_USER, privileges are evaluated against the invoking schema, so custom callers should be granted appropriate access to the package and the underlying PAY_PAYROLL_ACTIONS synonym.

Typical invocation scenarios include Japanese HR person and address forms, payroll action processing where a formatted person name or address is required, and custom reports or interfaces that must reproduce Oracle's Japanese name ordering and address derivation. The presence of PER_INFORMATION1 through PER_INFORMATION30 in both name functions reflects the heavy reliance on descriptive flexfield context: callers must supply the flexfield values so the function can apply the correct Japanese name composition rules. Cross-reference the packaged body in the APPS schema or the latest ETRM entry before relying on any routine, since the interface is Oracle-internal, unsupported for direct modification, and may change between patch levels such as 12.1.1 and 12.2.2.