Search Results check_numiv_override




Overview
Explore in AI Chat

Overview

The APPS.HR_NL_ASG_EXTRA_INFO_CHECKS package body is a Dutch (Netherlands) localization component within Oracle Human Resources. Its business purpose is to enforce validation rules against assignment-level extra information (Extra Information Types, or EITs) for Dutch legislations, and to support the valueset validation logic those EIT segments depend on. In Oracle EBS, Extra Information Types are implemented as descriptive flexfields attached to the PER_ASSIGNMENT_EXTRA_INFO entity, and the values a user may enter in those segments are frequently validated against lookup-like valuesets that are context-sensitive to the assignment currently being maintained. This package exists to make that context sensitivity reliable, so that validators evaluated during form navigation see the correct assignment rather than a stale or missing value.

The package is documented with the API classification OTHER, indicating it is an internal supporting PL/SQL unit rather than a public, customer-facing API, and it is referenced by three other packages.

Key Procedures and Functions

  • SET_ASG_ID — The procedure corresponding to the user's search term. Its documented role, per the header comment in the source, is to "set the Profile PER_ASSIGNMENT_ID to the Current Assignment for Valueset to validate correctly." It accepts an assignment identifier and writes that value into the PER_ASSIGNMENT_ID profile option via FND_PROFILE.PUT, so that valueset validation performed downstream resolves against the assignment the user is actually editing.
  • ASG_CHECK_NUMIV_OVERRIDE — An assignment-level check routine (the name suggests "check numeric IV override") associated with Dutch assignment extra information validation logic.
  • CHECK_NUMIV_OVERRIDE — A companion check routine for the same NUMIV override validation area, invoked in the assignment extra information context.

No public parameter lists for the latter two procedures are asserted here; only their names and evident validation purpose are documented.

Tables Accessed

  • PER_ALL_ASSIGNMENTS_F — The core assignment entity. It supplies and/or validates the assignment record whose extra information is being checked.
  • PER_ASSIGNMENT_EXTRA_INFO — The assignment descriptive flexfield storage table in which the Dutch Extra Information Type segment values are held and validated.

These are referenced through APPS synonyms, consistent with standard EBS schema access patterns.

Usage Notes

The source metadata shows a guarded call to HR_UTILITY.CHK_PRODUCT_INSTALL('Oracle Human Resources', 'NL'), added under the identifier for GSI Bug 5472781. This means SET_ASG_ID only performs its profile update when the Dutch Human Resources product is installed; otherwise it is a no-op. This guard prevents the package from altering profile state in non-Dutch environments.

Typical invocation occurs from the Oracle HRMS assignment Extra Information form flow, where valueset validation must know the current assignment. Calling SET_ASG_ID immediately before validation ensures the PER_ASSIGNMENT_ID profile reflects the in-progress assignment. Custom code extending Dutch assignment EIT validation may call these routines similarly, but since the package is classified as an internal implementation unit rather than a published API, direct customer calls should be treated as unsupported and subject to change in patching.