Search Results hr_ni_chk_pkg




Overview
Explore in AI Chat

Overview

HR_NI_CHK_PKG is a PL/SQL package body owned by the APPS schema that supports statutory national identifier validation within Oracle E-Business Suite Human Resources. In the context of Oracle EBS 12.1.1 and 12.2.2, the package is classified under the "OTHER" API category and is documented as valid. Its principal role is to verify that a person's national identifier — most notably the United Kingdom National Insurance (NI) number — conforms to expected format rules and satisfies uniqueness constraints before the value is committed to the person record. The package draws on Oracle FastFormula infrastructure to obtain the formatting and validation rules defined for the business group, which allows the rules to be configured rather than hard-coded. HR_NI_CHK_PKG is not referenced by any other database object, but it is referenced by 23 other packages, indicating that it is a low-level utility called by higher-level HR processing routines rather than a top-level entry point.

Key Procedures and Functions

The ETRM documentation records five procedures and functions within the package body. The documented members include VALIDATE_NATIONAL_IDENTIFIER, CHK_NAT_ID_FORMAT, and CHECK_NI_UNIQUE.

  • VALIDATE_NATIONAL_IDENTIFIER — The principal validation routine, orchestrating the overall check of a supplied national identifier value and returning the outcome of that validation.
  • CHK_NAT_ID_FORMAT — Performs the format-level verification of the national identifier, confirming that the supplied value matches the pattern expected for the identifier type.
  • CHECK_NI_UNIQUE — Confirms that the national identifier is unique across person records, preventing duplicate identifiers from being stored.

The two remaining documented members are internal helper routines whose specific parameter signatures are not exposed in the available metadata. Consistent with Oracle development standards for this package, they support the public validation entry points rather than being invoked directly by external code.

Tables Accessed

The package reads and writes the following objects, accessible through APPS synonyms:

  • PER_ALL_PEOPLE_F and PER_PEOPLE_F — the person records against which the national identifier is validated and checked for uniqueness.
  • HR_ORGANIZATION_INFORMATION — organization-level configuration, including business group settings relevant to identifier rules.
  • FF_FORMULAS_F, FF_FORMULA_TYPES, and FF_COMPILED_INFO_F — the FastFormula definition and compilation tables used to resolve the configured validation and format rules.
  • PLITBLM — the PL/SQL table used by FastFormula execution for passing values to and from formula logic.

Supporting references include FF_EXEC and FF_COMPILED_INFO_F for formula execution, FND_MESSAGE for error message retrieval, FND_PROFILE for profile option values, and FND_DATE for date handling. HR_UTILITY and PER_BUSINESS_GROUPS provide shared HR utility and business group context.

Usage Notes

HR_NI_CHK_PKG is typically invoked indirectly. Because it is referenced by 23 other packages, it is most often called from higher-level HR person-maintenance logic, employee data loaders, and validation routines that run when a national identifier is entered or updated. It is not referenced by any other database object as a dependency target of its own, so direct invocation from custom code should be treated cautiously. Customers extending national identifier validation should prefer configuring the underlying FastFormula rules over modifying this package, since formula-driven rules are supported and upgrade-safe. Direct calls to the documented procedures are possible from custom PL/SQL where a format or uniqueness check is required independently of the standard HR flow.