Search Results per_hu_full_name




Overview
Explore in AI Chat

Overview

The APPS.HR_HU_UTILITY package is a regional utility package within the Oracle E-Business Suite Human Resources (HR) module, specifically targeted at the Hungarian (HU) localization. It provides standardized validation and formatting routines for Hungarian personal and tax-related data, supporting statutory requirements that differ from the generic global HR model. The package is classified as an OTHER API under the APPS schema and is defined with AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking user rather than the definer. Its header (paying attention to the $Header: pehuutil.pkh 115.2 marker) confirms it has shipped since at least the 11.5 code line and remains present through EBS 12.1.1 and 12.2.2, where it is most commonly surfaced when developers or users search for the name-formatting entry point per_hu_full_name.

Key Procedures and Functions

ETRM documents nine callable units in this package. Rather than reproducing signatures, their purposes are as follows:

  • VALIDATE_ACCOUNT_NO — Validates a Hungarian account number and returns a numeric status indicator.
  • VALIDATE_ACCOUNT_ENTERED — Checks whether an account number value has been supplied/entered.
  • CHECK_TAX_IDENTIFICATION_NO — Validates a Hungarian tax identification number.
  • VALIDATE_SS_NO — Validates a social security number against Hungarian rules.
  • VALIDATE_TAX_NO — Validates a general tax number.
  • VALIDATE_CS_NO — Validates a community/company registration style number used in local statutory reporting.
  • CHECK_TAX_IDENTIFIER_UNIQUE — Determines whether a given tax identifier is unique, i.e. not already assigned to another person record.
  • PER_HU_FULL_NAME — The most searched entry point. It assembles a person's display name from the standard PER name components (first name, middle names, last name, known as, title, suffix, pre-name adjunct) together with up to thirty PER_INFORMATION descriptive flexfield segments, applying the Hungarian convention that places the family name before the given name. It returns a single VARCHAR2.
  • PER_HU_ORDER_NAME — Produces the Hungarian "order name" form of the same set of input attributes, used for official documents and correspondence where the local ordering convention is mandatory.

Tables Accessed

The package references two tables through APPS synonyms. PER_ALL_PEOPLE_F is the core HR person entity; it is queried primarily to support the uniqueness and identifier checks (notably CHECK_TAX_IDENTIFIER_UNIQUE), which must confirm that a candidate tax identifier is not already held by an existing person record, honoring the effective-dated nature of that table. DUAL is used for the pure-formatting and validation functions, which operate only on their input parameters and require no persistent data access; DUAL serves as the conventional single-row source in those code paths.

Usage Notes

HR_HU_UTILITY is typically invoked from the Hungarian localization of the People form and related person-entry screens, where PER_HU_FULL_NAME and PER_HU_ORDER_NAME are called to render names in the statutory Hungarian order and the VALIDATE_* and CHECK_* routines are wired into field-level validation. The package is also callable from concurrent programs and custom PL/SQL that populate or verify Hungarian person and tax data, and ETRM records that it is referenced by one other package. Because the formatting functions take the full set of PER information flexfield segments, callers should pass the person's complete attribute set to obtain a correctly composed result. When extending or debugging localized name formatting in 12.1.1 or 12.2.2, per_hu_full_name is the appropriate documented entry point.