Search Results check_leaving_reason

Overview

HR_ES_UTILITY is a Spanish localization utility package in the Oracle E-Business Suite 12.1.1 and 12.2.2 applications schema (APPS). Its principal business purpose is to centralize the validation, formatting, and uniqueness-checking of Spanish statutory identifiers used throughout the human resources and payroll modules. This includes national identity documents (DNI, NIF, NIE, CIF), Social Security numbers, bank account numbers in both domestic and IBAN formats, and work center or contribution account codes (CAC). The package also supplies supporting functions for name assembly, disability degree determination, and leaving-reason validation. By consolidating these rules in a single PL/SQL package, Oracle ensures consistent enforcement of Spanish legal and payroll requirements across employee, applicant, and contingent worker registration flows. The object is documented as VALID in the ETRM and classified with an API classification of OTHER, meaning it is a supporting service package rather than a published business API. Its primary consumers are the Spanish person-creation and update packages, making it a foundational component of the Spain HRMS localization rather than a user-facing interface.

Key Procedures and Functions

• VALIDATE_IDENTIFIER — general entry point for validating an identifier value against the appropriate Spanish document rules.
• CHECK_DNI, CHECK_NIF, CHECK_NIE — the three core identity document checks for Spanish nationals, legal entities, and foreign residents respectively.
• CHECK_CIF, VALIDATE_CIF, VALIDATE_CAC — validation of the company fiscal code (CIF) and the contribution account code.
• CHECK_IDENTIFIER_UNIQUE — verifies that an identifier has not already been assigned elsewhere.
• VALIDATE_CAC_LOOKUP — confirms the CAC against the HR lookups used by the localization.
• VALIDATE_ACCOUNT_NO, VALIDATE_NON_IBAN_ACC_NO, VALIDATE_IBAN_ACC — bank account validation for domestic, non-IBAN, and IBAN account formats.
• PER_ES_FULL_NAME — assembles a formatted full name from Spanish name components.
• CHECK_SSI, GET_SSNO, UNIQUE_SS — Social Security number retrieval, format checking, and uniqueness enforcement.
• CHECK_LEAVING_REASON — validates the reason recorded when an employee leaves.
• GET_DISABILITY_DEGREE — returns the recorded disability degree percentage for an individual.
• UNIQUE_CAC, UNIQUE_CIF — uniqueness checks for CAC and CIF values used across organizations and persons.
• VALIDATE_WC_SEC_REF — validates the work center reference for Social Security reporting.

Tables Accessed

The package reads HR_LOOKUPS to validate CAC and related lookup codes, and references HR_ALL_ORGANIZATION_UNITS and HR_ORGANIZATION_INFORMATION for organizational and work center data. Disability information is obtained from PER_DISABILITIES_F, while PER_SHARED_TYPES supplies shared type definitions used in validation. Payroll-side validation draws on PAY_ELEMENT_ENTRIES_F, PAY_ELEMENT_ENTRY_VALUES_F, PAY_USER_COLUMN_INSTANCES_F, and FF_FORMULAS_F, and DUAL is used for single-row computations. PLITBLM is referenced by dependent code. Most access is read-oriented, supporting validation and attribute retrieval rather than transactional writes.

Usage Notes

HR_ES_UTILITY is invoked indirectly rather than by end users. The ETRM dependency listing shows it is referenced by PER_ES_CREATE_APPLICANT, PER_ES_CREATE_CWK, PER_ES_CREATE_EMPLOYEE, PER_ES_ORG_INFO, PER_ES_UPDATE_PERSON, and PER_ES_TAX_SS_EMP_V, meaning it is called automatically whenever Spanish employees, applicants, or contingent workers are registered or updated, and when organization or tax/Social Security views are queried. Customizations and extensions that validate Spanish identifiers should call these routines instead of re-implementing the checks, so that validation logic remains consistent with Oracle's localized code. Because the package is not a published API and is classified as OTHER, direct custom invocation should be treated as a dependency on non-public internals, and any calls should be regression-tested during upgrades between 12.1.1 and 12.2.2.