Search Results p_last_name

Overview

The APPS.HR_NL_UTILITY package body provides localized formatting and decoding utilities for the Netherlands (NL) legislative region within Oracle E-Business Suite Human Resources. Its primary business function is to assemble a person's full name according to Dutch conventions, combining the standard Oracle HR person-name attributes (first name, middle names, last name, known-as, title, suffix, and pre-name adjunct) with the thirty descriptive flexfield attributes (PER_INFORMATION1 through PER_INFORMATION30) defined on the person record. These flexfield attributes carry Netherlands-specific name components, such as academic titles and sub-academic titles, that must be rendered in a culturally correct order and format. The package therefore acts as the single source of truth for Dutch full-name derivation, ensuring consistent output across Oracle HR forms, reports, and self-service pages. The source header identifies the file as hrnlutil.pkb version 115.9, last modified in November 2003, which indicates the utility has been stable across the 12.1.1 and 12.2.2 releases. The package is classified as a utility (API classification OTHER) rather than a public business API, meaning it is intended for internal consumption by other Oracle applications code rather than direct customer invocation.

Key Procedures and Functions

The package body exposes a single documented function:

• PER_NL_FULL_NAME — Returns a VARCHAR2 value containing the fully formatted Dutch name for a person. It accepts the standard HR person-name attributes together with all thirty person descriptive flexfield attributes (p_per_information1 through p_per_information30) and composes the final display name. Internally the function invokes HR_GENERAL.DECODE_LOOKUP to translate coded lookup values into display text, including the TITLE lookup, the HR_NL_ACADEMIC_TITLE lookup (sourced from p_per_information10), and the HR_NL_SUB_ACADEMIC_TITLE lookup (sourced from p_per_information3). The function then applies Dutch ordering rules for the last name, pre-name adjunct, and related components. No other procedures or functions are documented for this package body.

Tables Accessed

According to the documented package metadata, the following objects are referenced through APPS synonyms:

• FND_SESSIONS — the standard Oracle Application Object Library session table, used to resolve session context, locale, and language information that influences lookup decoding.
• PER_ALL_PEOPLE_F — the core dated person table in Oracle HRMS, providing the person attributes (name components and flexfield values) that feed the formatting logic.
• PER_CONTACT_RELATIONSHIPS — the contact relationship table, consulted where a person is formatted in the context of a contact or related-party record.
• PER_PERSON_TYPES — the person type definitions, used to determine how a person should be categorized and consequently formatted.
• DUAL — the standard single-row pseudo-table, invoked for scalar evaluations and lookup decoding where no table access is otherwise required.

These accesses are read-only in nature; the package performs no DML against business tables.

Usage Notes

HR_NL_UTILITY.PER_NL_FULL_NAME is typically invoked from Oracle HRMS forms, reports, and PL/SQL business logic that must display a Dutch employee's or applicant's name in a legislatively correct manner. Because the package is a utility rather than a public API, direct custom calls are unusual but permissible where a developer needs the same Dutch name formatting used by seeded Oracle code. The function is stateless and deterministic with respect to its inputs, making it safe to call from concurrent programs, OAF pages, and custom PL/SQL. The package is referenced by zero other documented packages, confirming its role as a leaf-level utility. When adapting or troubleshooting name display for the Dutch legislation, developers should verify that the relevant flexfield attributes, particularly PER_INFORMATION3 and PER_INFORMATION10, are populated, since the decoded academic titles depend on them.