Search Results p_assignment_extra_info_id

Overview

HR_ASSIGNMENT_EXTRA_INFO_BK2 is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the Oracle HRMS API Hook family and is classified in the ETRM repository as an "OTHER" API object. The package serves as a generated wrapper layer around the assignment extra information business logic in the Human Resources module. Its purpose is to expose the descriptive flexfield (DFF) attribute and information columns of the PER_ASSIGNMENT_EXTRA_INFO entity through a stable, callable API surface so that calling code does not need to reference the underlying base tables directly.

The source header identifies the file as peaeiapi.pkb, version 115.4, dated 2002/12/13, and confirms that the code was produced automatically by the Oracle HRMS API Hook Pre-processor on 2013/08/13. This generation pattern is characteristic of HRMS hook packages, where the "_BK2" suffix denotes a backup or secondary hook variant retained for backward compatibility within the HRMS extensibility framework.

Key Procedures and Functions

The ETRM metadata documents two procedures for this package body:

• UPDATE_ASSIGNMENT_EXTRA_INFO_A — The primary update procedure. It accepts the assignment extra information identifier (P_ASSIGNMENT_EXTRA_INFO_ID) together with the full descriptive flexfield payload: the AEI attribute category and twenty attribute columns (P_AEI_ATTRIBUTE1 through P_AEI_ATTRIBUTE20), the information category, and the information columns (P_AEI_INFORMATION1 onward). Its role is to write changes to the extra information record identified by the primary key.
• UPDATE_ASSIGNMENT_EXTRA_INFO_B — The corresponding "before" hook procedure, which the API hook framework invokes prior to the main update. It follows the same naming convention used throughout HRMS hook packages, where the "_B" variant carries the pre-update logic or serves as the business-event entry point.

The user search term p_assignment_extra_info_id maps directly to the first parameter of UPDATE_ASSIGNMENT_EXTRA_INFO_A, confirming that this identifier is the primary key used to locate the target record during an update operation.

Tables Accessed

The ETRM metadata records no table references resolved through APPS synonyms for this package. In practice, the package operates against the assignment extra information storage underlying the PER_ASSIGNMENT_EXTRA_INFO entity, manipulating the descriptive flexfield context and segment columns for a given assignment. Because the body is generated code, the actual DML is typically delegated to the base HRMS API package rather than executed inline, which explains the absence of direct synonym-based table references in the repository.

Usage Notes

This package is not intended for direct invocation by end users or casual custom code. It is invoked by the Oracle HRMS API Hook Pre-processor framework whenever an assignment's extra information is created or modified, for example through the Assignment form or through programmatic calls into the HRMS assignment APIs. One other package in the APPS schema is documented as referencing this package, indicating that it participates in a small dependency chain within the HRMS API layer.

Developers extending assignment extra information should call the documented HRMS assignment API rather than HR_ASSIGNMENT_EXTRA_INFO_BK2 directly, and should treat the "_BK2" package as a compatibility hook whose contents may be regenerated by Oracle during patching. Any customizations should be placed in the supported hook points or in customer-owned packages to avoid being overwritten during upgrade or patch application.