Results for “pe_aei_flex”

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

Overview

The PL/SQL package APPS.PE_AEI_FLEX is an internal Oracle E-Business Suite component associated with the Application Entry Interface (AEI) framework, a module within Oracle Human Resources / Oracle Payroll used to load and validate external data records into the EBS data model. In Oracle EBS 12.1.1 and 12.2.2, this package serves a single, narrow purpose: it centralizes the validation logic applied to descriptive flexfields (DFFs) belonging to the entity records processed by the AEI. The package is declared AUTHID CURRENT_USER, meaning that all database object references it makes are resolved in the schema of the calling user; this is the standard pattern used by AEI routines to allow the business event layer to operate under the schema that owns the entity data.

The package header derives from the source file peaeifli.pkh, and the header comment identifies it as having been ported through the standard 11.5.10 development stream before being carried into the 12.x code line. It is classified as an "Other" API and is explicitly marked "Internal Development Use Only," which places it outside Oracle's supported public API surface.

Key Procedures and Functions

ETRM documents exactly one callable program unit in this package:

• DF — The core validation driver for descriptive flexfield processing. The procedure accepts an entity record structure (declared as p_rec of type pe_aei_shd.g_rec_type) and routes the record to the appropriate flexfield validation routines based on the entity reference field value contained in that record. The documentation notes two failure modes: the reference field value is not supported by the package, or the reference field value is NULL while one or more of the associated attribute arguments are populated. The latter condition reflects a structural rule in the AEI model that descriptive flexfield attributes cannot be supplied without a corresponding reference value. On success, control returns to the calling API and processing continues.

Tables Accessed

The ETRM metadata lists no tables referenced through APPS synonyms for this package. This is consistent with the source header, which shows that the DF procedure performs validation dispatch logic rather than direct SQL. Any actual flexfield segment validation is delegated to the validation procedures it invokes, and consequently any table access would be inherited from those downstream units rather than declared here. The only data structure the package directly consumes is the pe_aei_shd.g_rec_type record passed in by the caller.

Usage Notes

PE_AEI_FLEX is invoked indirectly. It is not exposed to Oracle Forms or to concurrent program parameters, and it is designed to be called from within the AEI record-processing pipeline after an entity record has been assembled into the shared record structure. No other package in the documented inventory references it, which reinforces its position as a private helper rather than a reusable API.

Because the header marks the package "Internal Development Use Only," customizations should not call PE_AEI_FLEX directly. Developers extending AEI flexfield behavior should instead intercept the higher-level AEI interfaces or use the supported flexfield value-set mechanisms. Any direct dependency on this package risks breakage during patching or upgrade between 12.1.1 and 12.2.2, and no documented extension points exist for the DF procedure.