Results for “pe_aei_del”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PE_AEI_DEL is a PL/SQL package in the APPS schema that supports the Oracle EBS Human Resources (HR) and Oracle Payroll modules. Its name reflects its core responsibility: it is the deletion handler for the "Assignment Extra Information" (AEI) framework. Assignment Extra Information is a configurable, descriptive-flexfield-style capability that allows customers to capture supplementary attributes against an assignment record beyond the standard PER_ASSIGNMENTS columns. The special "AEI" mechanism stores these values in the PER_ASSIGNMENT_EXTRA_INFO table, and the application logic that governs the lifecycle of those values — including removal — is encapsulated in this package.

The package is classified as OTHER in the ETRM repository and is currently VALID across the 12.1.1 and 12.2.2 releases. It is a dependent, internal building block rather than a top-level user-facing API.

Key Procedures and Functions

Two documented procedures are associated with the package. The ETRM metadata records the package as exposing the DEL procedure, which performs the actual deletion of assignment extra information rows. The naming convention indicates a focused, single-responsibility operation: when an assignment extra information record is to be logically or physically removed, DEL is the entry point responsible for cascading that removal through the AEI layer.

Internally, PE_AEI_DEL also references APPS.PE_AEI_SHD, its shadow-table counterpart. This relationship suggests that the DEL operation maintains the corresponding shadow/audit records so that the AEI data remains consistent for the AEI retrieval path. No parameter lists are documented in the ETRM repository; consumers should not assume a public signature and should obtain the actual specification from the source before invoking it directly.

Tables Accessed

The single documented table referenced through APPS synonyms is PER_ASSIGNMENT_EXTRA_INFO. This is the base table that stores the assignment-level extra information values keyed to an assignment. PE_AEI_DEL writes to this table, deleting the rows associated with the AEI being processed. The associated shadow object PE_AEI_SHD is referenced to keep the shadow copy in step with the base table, a common pattern in the HR AEI framework.

Usage Notes

PE_AEI_DEL is not intended as a standalone, user-invoked API. It is invoked from within the HR assignment infrastructure. ETRM records that two other packages depend on it: HR_ASSIGNMENT_EXTRA_INFO_API, the principal public API for managing assignment extra information, and GHR_CORR_CANC_SF52, a correction/ cancellation form handler. This dependency topology confirms that deletion of extra information is triggered indirectly — typically when an end user clears or removes an AEI value from the Assignment Extra Information form, or when a correction or cancellation process in Oracle Payroll/HR removes the underlying assignment data. Custom code should not call PE_AEI_DEL unless it is intentionally replicating full AEI maintenance and accepts responsibility for shadow-table consistency; the recommended integration path is HR_ASSIGNMENT_EXTRA_INFO_API. Because the package body is not exposed in the ETRM documentation, developers extending or troubleshooting it should decompile the package specification and body in an environment matching the target release (12.1.1 or 12.2.2) rather than relying on assumptions about its parameters or error handling.