Results for “get_ssno”
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:
- CHECK_DNI, CHECK_NIF, CHECK_NIE, VALIDATE_IDENTIFIER — validate the corresponding Spanish identity document types. CHECK_NIF implements the modulus-23 letter table shown in the source; each returns a success/failure indicator.
- PER_ES_FULL_NAME — derives the formatted Spanish full name from the person record's name components.
- VALIDATE_ACCOUNT_NO, VALIDATE_NON_IBAN_ACC_NO, VALIDATE_IBAN_ACC — validate bank account data, distinguishing legacy Spanish CCC accounts from IBAN-formatted accounts.
- CHECK_IDENTIFIER_UNIQUE, UNIQUE_CAC, UNIQUE_CIF, UNIQUE_SS — enforce uniqueness of person identifiers, CAC (Código de Actividad y Establecimiento) codes, CIF (company tax) codes, and Social Security numbers respectively.
- VALIDATE_CAC_LOOKUP, VALIDATE_CIF, VALIDATE_CAC — validate the structure and value of CAC/CIF identifiers, including lookup-driven checks.
- CHECK_LEAVING_REASON — validates that a termination/leaving reason supplied is acceptable per Spanish rules.
- CHECK_SSI, GET_SSNO, GET_DISABILITY_DEGREE — retrieve Social Security affiliation data and the declared disability degree for an employee.
- VALIDATE_WC_SEC_REF — validates the Workers' Compensation sector reference used in Spanish payroll reporting.
Tables Accessed
The package reads and, in the uniqueness checkers, implicitly queries the following objects via APPS synonyms:
- PER_DISABILITIES_F — supplies the disability degree returned by GET_DISABILITY_DEGREE.
- PER_SHARED_TYPES — provides shared lookup/type values used by the validation routines.
- HR_ALL_ORGANIZATION_UNITS, HR_ORGANIZATION_INFORMATION — resolve organization-level attributes such as CAC/CIF and Social Security affiliations.
- PAY_ELEMENT_ENTRIES_F, PAY_ELEMENT_ENTRY_VALUES_F — provide payroll element entry context for Social Security and related validations.
- PAY_USER_COLUMN_INSTANCES_F — supplies user-defined column instance data referenced by localization validations.
- FF_FORMULAS_F — used where Spanish localization formulas must be resolved.
- DUAL and PLITBLM — used for scalar evaluation and PL/SQL table/list handling respectively.
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.
-
PACKAGE: APPS.HR_ES_UTILITY 12.1.1
-
PACKAGE: APPS.HR_ES_UTILITY 12.2.2
-
PACKAGE: APPS.HR_ES_UTILITY 12.1.1
-
PACKAGE: APPS.HR_ES_UTILITY 12.2.2