Search Results pe_aei_shd




Overview
Explore in AI Chat

Overview

PE_AEI_SHD is a PL/SQL package body in the APPS schema that supports the Assignment Extra Information (AEI) feature within Oracle Human Resources / Oracle Payroll in EBS 12.1.1 and 12.2.2. The object name embeds "SHD," which by convention in the Oracle E-Business Suite denotes a shadow package — a stable, synchronised interface generated to match an underlying API or database object. PE_AEI_SHD functions as the programmatic layer through which assignment-level extra information is validated, retrieved, and maintained.

Assignment Extra Information provides customer-defined descriptive flexfield-style data segments attached to an assignment record. Downstream payroll processing, benefits, and reporting logic frequently require AEI values; PE_AEI_SHD centralises the access and update logic so that these callers do not manipulate the base table directly. The ETRM classification records this object as an OTHER API, distinguishing it from the formally published interfaces, yet it remains a valid and referenced component of the HR API stack.

Key Procedures and Functions

The 12.2.2 metadata documents five callable components. Each serves a distinct role in the package's lifecycle and control flow:

  • CONSTRAINT_ERROR — Handles integrity or constraint violation conditions encountered during AEI processing, allowing the package to surface a structured error rather than propagating an unhandled exception.
  • API_UPDATING — Indicates whether the package is operating in an update context, allowing callers and internal logic to branch between insert and update behaviour.
  • LCK — Implements record-level locking against the assignment extra information row, protecting concurrent modifications and preserving read consistency.
  • CONVERT_ARGS — Normalises or converts arguments supplied by the calling program into the internal representation expected by the AEI access routines.
  • SET_CALLED_FROM_FORM — Establishes the calling context, recording whether invocation originated from an Oracle Forms session. This affects validation and error-handling paths.

Tables Accessed

The dependency listing identifies two principal data objects. PER_ASSIGNMENT_EXTRA_INFO is the base HR table storing assignment-level extra information records; the package reads and writes it as part of its retrieval and maintenance duties. ALL_CONSTRAINTS is referenced so that constraint definitions — name, type, and status — can be inspected at runtime to support the CONSTRAINT_ERROR logic. Both are accessed through APPS synonyms. Additional runtime dependencies include HR_API and HR_UTILITY, which supply the standard HR error-handling and date/utility primitives used throughout the package.

Usage Notes

PE_AEI_SHD is not invoked directly by users; it is engaged by the Assignment Extra Information form, by concurrent programs, and by custom extensions that require assignment-level AEI values. The SET_CALLED_FROM_FORM routine confirms the intended Forms integration path, while HR_API usage ensures that errors raised during processing follow standard HR messaging conventions. Because the package is not referenced by other database objects in the dependency report but is listed as being referenced by eight documented packages, custom code should treat it as an internal interface: callers should prefer the surrounding HR APIs where available, and any direct use should mirror the argument conversion and locking sequence the package enforces. Validating against a current ETRM extract is advisable before extending or wrapping it in a customisation.