Search Results pe_aei_ins




Overview
Explore in AI Chat

Overview

PE_AEI_SHD is a shared utility package in the Oracle E-Business Suite APPS schema that supports the family of Assignment Extra Information (AEI) APIs — the PL/SQL interfaces responsible for maintaining the PER_ASSIGNMENT_EXTRA_INFO entity within Oracle HRMS. The _SHD suffix identifies it as a "shared" or shadow package: rather than exposing a public API in its own right, it provides common internal services consumed by the visible AEI API packages such as PE_AEI_INS, PE_AEI_UPD, PE_AEI_DEL, PE_AEI_BUS, PE_AEI_FLEX, and PE_AEI_FLEX_DDF. Because these packages all manipulate assignment-level descriptive and extra information records, PE_AEI_SHD centralises the cross-cutting logic that would otherwise be duplicated across each API layer.

Key Procedures and Functions

The ETRM 12.2.2 metadata documents five subprograms within PE_AEI_SHD. Their names describe their roles within the shared infrastructure:

  • CONSTRAINT_ERROR — Raises or reports constraint violations encountered while validating or writing assignment extra information, allowing calling APIs to surface a consistent error to the user.
  • API_UPDATING — Indicates or governs whether an API-driven update is in progress; used by the AEI APIs to distinguish API-initiated changes from direct table maintenance for business-rule and auditing purposes.
  • LCK — Provides the locking routine used to serialise concurrent access to the AEI records, preventing lost updates when multiple sessions modify the same assignment's information.
  • CONVERT_ARGS — Converts or normalises arguments between the representations expected by the visible AEI APIs and the underlying shared logic, particularly where forms or flexfield-driven input differs in shape from the stored format.
  • SET_CALLED_FROM_FORM — Records whether the current invocation originates from an Oracle Forms session, enabling the shared code to adapt its behaviour and error handling to the forms context.

No parameter lists are documented in the metadata and none are invented here.

Tables Accessed

The package references two documented objects through APPS synonyms:

  • PER_ASSIGNMENT_EXTRA_INFO — the core AEI table holding assignment-level extra information. PE_AEI_SHD reads and validates against it as part of the shared insert, update, and delete support it provides to its callers.
  • ALL_CONSTRAINTS — the data dictionary view used to inspect constraint definitions, supporting the CONSTRAINT_ERROR subprogram's ability to identify and report the specific constraint that a failing DML operation has breached.

The dependency list also cites STANDARD (SYS), the standard package providing basic PL/SQL constructs.

Usage Notes

PE_AEI_SHD is an internal implementation package and is not intended for direct invocation by customers or extensions. It is referenced by eight documented packages — PER_PQH_SHR, PE_AEI_BUS, PE_AEI_DEL, PE_AEI_FLEX, PE_AEI_FLEX_DDF, PE_AEI_INS, PE_AEI_SHD itself, and PE_AEI_UPD — which form the supported entry points for AEI maintenance. Because the user search term pe_aei_ins corresponds to PE_AEI_INS, the practical relevance of PE_AEI_SHD is as the shared layer beneath the insert API: when PE_AEI_INS executes, it delegates locking, constraint handling, argument conversion, and form-context detection to this package. Customisations should call the public AEI APIs rather than PE_AEI_SHD directly. As a shared package, it may be covered by Oracle's standard generated wrapper synonyms in a multi-org or shared-schema configuration, and its body should never be modified outside a supported patch, since any change propagates to every dependent AEI API.