Results for “check_dni”

8 results




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

Overview

APPS.HR_ES_UTILITY is a Spanish localization utility package body (source file peesutil.pkb) delivered as part of the Oracle E-Business Suite Human Resources product family. Its role is to centralize the validation and derivation logic required by Spanish statutory and payroll requirements, principally the verification of national identity documents (DNI, NIF, NIE), bank account formats (IBAN and non-IBAN Spanish account numbers), and Social Security and tax identifiers. The package returns simple single-character or attribute-level results that are consumed by higher-level business logic; the excerpt shows the characteristic pattern of delegating the low-level format check to hr_ni_chk_pkg.chk_nat_id_format and then applying Spanish-specific rules such as the NIF check letter algorithm. Because it is registered as an OTHER API rather than a public interface, it should be regarded as an internal localization helper rather than a supported extension point. The same body is shipped in both 12.1.1 and 12.2.2, since the Spanish localization layer was not materially restructured by the 12.2 online-patching/AD-TXK changes.

Key Procedures and Functions

The package exposes 27 documented procedures and functions, all oriented toward validation or value retrieval:

Tables Accessed

The package reads and, in the uniqueness checkers, implicitly queries the following objects via APPS synonyms:

Usage Notes

HR_ES_UTILITY is invoked primarily from Spanish-localized Oracle HRMS forms (person and assignment maintenance), from Spanish payroll processes and FastFormulas, and from the six documented packages that reference it. Typical callers include Spanish person/assignment validation logic that fires during data entry, and payroll pre-processing that must confirm DNI/NIF/NIE and Social Security values before calculation. Because the package is classified as OTHER and is not a supported public API, customizations should call it only defensively — wrapping invocations in exception handlers and confirming the signature against the specific patch level, since the header identifies release-specific fixes (for example, Bug 3358291 introduced the SUBSTR truncation to 30 characters on the identifier value). Organizations extending Spanish localization should prefer the standard validation hooks and use this package as a reference implementation of the Spanish check-digit algorithms rather than as a stable integration point.