Search Results create_assignment_extra_info




Overview
Explore in AI Chat

Overview

APPS.HR_NL_ASG_EXTRA_INFO_CHECKS is a PL/SQL package that supports the Oracle EBS localization for the Netherlands (NL) within the Human Resources module. Its designated role is to service the Create_Assignment_Extra_Info before-process hook, a business event raised during the creation of assignment-level extra information records. The package is classified under the API classification "OTHER" in ETRM and is owned by the APPS schema.

The central business function of the package is to resolve and propagate the correct assignment identifier onto the extra information record being created. The header comment of the package source states explicitly that it is "Called from the Create_Assignment_Extra_Info Before Process Hook and sets the Assignment ID." This indicates the package acts as a validation and pre-processing component at the point where extra assignment information (such as statutory or country-specific attributes required for Dutch payroll and HR processing) is being written to the database. By ensuring the assignment identifier is correctly set before the create operation proceeds, the package guards the integrity of the relationship between extra information rows and the assignments to which they belong.

The package is referenced by three other packages in the ETRM metadata, which confirms that it forms part of a wider Netherlands-localization call chain rather than functioning in isolation.

Key Procedures and Functions

ETRM documents three procedures or functions for this package:

  • SET_ASG_ID — Assigns and sets the assignment identifier on the extra information record being processed. This procedure is the one most directly tied to the package's stated purpose and is invoked from the Create_Assignment_Extra_Info before-process hook, ensuring that the assignment context is established prior to the record's creation.
  • ASG_CHECK_NUMIV_OVERRIDE — Supports checking logic associated with the NUMIV override concept for the assignment. It operates on the assignment context to evaluate the override conditions relevant to that assignment.
  • CHECK_NUMIV_OVERRIDE — Provides the corresponding override validation check at the record level, complementing ASG_CHECK_NUMIV_OVERRIDE within the package's overall verification flow.

The documented source excerpt confirms the SET_ASG_ID signature declaration, revealing that it accepts the assignment identifier as an input parameter. No parameter lists are documented for the two override-related units, and none should be assumed.

Tables Accessed

The package accesses two tables through APPS synonyms:

  • PER_ALL_ASSIGNMENTS_F — the core Oracle HRMS assignments table, used to resolve or validate the assignment against which extra information is being maintained.
  • PER_ASSIGNMENT_EXTRA_INFO — the assignment extra information table, the target of the create operation during which this package executes.

These references confirm that the package reads assignment data to establish context and writes or adjusts the extra information record's assignment identifier.

Usage Notes

This package is not typically invoked directly by end users or developers. It is triggered automatically through the extra information create hook associated with assignment-level extra information processing for the Netherlands localization. In Oracle EBS 12.1.1 and 12.2.2, such hooks are configured so that the appropriate country-specific checks package is executed when extra information records are created or maintained through the standard HR forms or APIs.

Customizations that create assignment extra information programmatically should respect the same path by calling the supported extra information APIs, allowing the before-process hook to invoke HR_NL_ASG_EXTRA_INFO_CHECKS as designed. Direct calls are discouraged because the package assumes hook-provided context. The dependency of three other packages on this unit also implies that changes must be evaluated for downstream impact within the Dutch localization chain before deployment.