Search Results get_assignment_type




Overview
Explore in AI Chat

Overview

APPS.PER_HU_ASSIGN_EXTRA_INFO is a Human Resources (HR) package body that encapsulates the assignment-level extra information logic required for the Hungarian (HU) localization of Oracle E-Business Suite. Extra information types (EITs) are the standard HR mechanism for capturing descriptive, country-specific, or customer-defined attributes that are not held on the core assignment record. This package provides the server-side validation and persistence routines invoked when a user creates or maintains an assignment extra information record of the type HU_ASG_CATEGORY.

The package is functional on both Oracle EBS 12.1.1 and 12.2.2. The embedded header comment (pehuaeip.pkb 120.1) indicates that the file is a non-shipped (noship) object at the 12.0/12.1 file level, and the presence of the GSI Bug 5472781 fix comment shows that this logic was extended specifically to support a Global Single Instance (GSI) customer requirement. The API classification recorded in ETRM is OTHER, meaning the package is a supporting/localization utility rather than a public, supported HR API. It is referenced by two other database packages and is therefore a dependency within the HU localization layer.

Key Procedures and Functions

Two procedures are documented for this package.

  • CREATE_HU_ASSIGN_EXTRA_INFO — Accepts the assignment identifier together with the information type, information category, and the two descriptive attribute values (information2 and information3) that constitute the HU assignment extra information record. Before allowing the record to be created, the procedure verifies that the Oracle Human Resources product and the HU localization are installed. When the information type is HU_ASG_CATEGORY, it opens an internal cursor named get_assignment_type, which selects the assignment_type from PER_ALL_ASSIGNMENTS_F for the supplied assignment identifier, constrained by the current fnd_sessions effective date. If the returned assignment type is C, message HR_HU_INVALID_ASG_CATG is raised, preventing the extra information from being attached to that assignment. The procedure then calls the internal chk_date routine to compare the two date-bearing information fields.
  • UPDATE_HU_ASSIGN_EXTRA_INFO — Performs the modification path for an existing assignment extra information record, identified by its primary key rather than by assignment. It contains the same internal get_assignment_type cursor definition, so the same assignment-type and HU category validation logic applies when an existing record is changed.

The internal private routine chk_date is also present in the body. It converts the two canonical date strings via fnd_date.canonical_to_date and, where both are populated, raises HR_HU_INVALID_ASG_CATG_DATE if the first date is later than the second. Both procedures rely on hr_utility.set_message and hr_utility.raise_error to surface validation failures through the standard HR message stack.

Tables Accessed

  • PER_ALL_ASSIGNMENTS_F — Read by the get_assignment_type cursor to determine the assignment_type of the target assignment, and to resolve the session effective date range.
  • FND_SESSIONS — Joined via userenv('sessionid') to obtain the effective date against which the assignment record is evaluated, ensuring the validation is performed as of the user's current session date.
  • PER_ASSIGNMENT_EXTRA_INFO — The base table holding the assignment extra information rows that the CREATE and UPDATE procedures populate or amend, subject to successful validation.

Usage Notes

The package is not a general-purpose public API. It is invoked implicitly from the OA Framework or Forms-based assignment extra information maintenance flow whenever a Hungarian assignment category record is entered or changed; standard callers reach it indirectly rather than by direct code call. Because of this implicit invocation, errors such as HR_HU_INVALID_ASG_CATG and HR_HU_INVALID_ASG_CATG_DATE appear as form-level validation messages rather than raw SQL errors.

Custom code should not call CREATE_HU_ASSIGN_EXTRA_INFO or UPDATE_HU_ASSIGN_EXTRA_INFO directly; the supported route for creating extra information in both releases is the HR extra information API (HR_ASSIGNMENT_EXTRA_INFO_API or its successor in HR EIT APIs). Direct invocation bypasses the multi-row/per-EIT orchestration performed by those APIs. Note the conditional product check: since the procedure body is wrapped in hr_utility.chk_product_install('Oracle Human Resources', 'HU'), the HU-specific validation only executes where the HU localization is installed, allowing the same code path to run safely in non-HU environments.