Search Results pe_pei_del




Overview
Explore in AI Chat

Overview

PE_PEI_DEL is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the deletion of person extra information records within the Oracle HRMS (Human Resources Management System) product family. Person Extra Information, exposed through the PER_PEOPLE_EXTRA_INFO entity, stores supplemental, user-defined attributes attached to a person or assignment record — for example, legislative data, security clearance details, or customer-defined descriptive fields configured through the Extra Information Types (EIT) framework. The PE_PEI_DEL package provides the deletion-side counterpart to the standard person extra information APIs, allowing dependent processes to remove extra information rows in a controlled manner rather than issuing direct DML.

In the Oracle EBS 12.1.1 and 12.2.2 reference documentation, the package is classified with an API classification of OTHER, indicating it is an internal utility rather than a fully published, externally supported public API. Its status is VALID in the APPS schema, and it is documented as referencing the shadow/seed package APPS.PE_PEI_SHD together with the SYS.STANDARD package, and as being referenced by GHR_CORR_CANC_SF52, HR_PERSON_EXTRA_INFO_API, and recursively by itself.

Key Procedures and Functions

The ETRM metadata documents a single procedure within the package:

  • DEL — The sole documented program unit, responsible for deleting person extra information data. It encapsulates the removal logic for PER_PEOPLE_EXTRA_INFO rows on behalf of callers such as the HR Person Extra Information API and correction/ cancellation routines. Because the underlying table is date-tracked, the procedure is understood to handle the corresponding effective-dating and shadow-table maintenance, delegating physical row handling to PE_PEI_SHD.

The documentation does not expose a public parameter list for DEL, and none should be assumed. Package-level state and private helper routines, if any, are not enumerated in the ETRM extract and are therefore omitted here.

Tables Accessed

Two base tables are documented as accessed via APPS synonyms:

  • PER_PEOPLE_EXTRA_INFO — The primary target. This is the date-tracked table holding extra information records for persons. The DEL procedure removes or logically terminates rows in this table in accordance with Oracle HRMS date-tracked delete semantics.
  • FND_USER — Accessed to resolve the current application user, typically for audit and WHO-column (created_by/updated_by and related) population during the delete, ensuring the operation is attributable and consistent with Oracle Applications audit conventions.

The package additionally references the shadow package PE_PEI_SHD, which performs the underlying physical manipulation of date-tracked data on behalf of PE_PEI_DEL.

Usage Notes

PE_PEI_DEL is an internal dependency rather than a directly invoked end-user API. It is referenced by HR_PERSON_EXTRA_INFO_API, the standard entry point for creating, updating, and deleting person extra information from forms, concurrent programs, and custom code. It is also referenced by GHR_CORR_CANC_SF52, indicating participation in correction and cancellation processing within the HRMS correction framework. Customizations should invoke HR_PERSON_EXTRA_INFO_API rather than calling PE_PEI_DEL directly, since the API enforces validation, security, and date-tracked integrity. Direct calls bypass documented preconditions and are not supported. Developers tracing deletion behavior for EIT data should treat this package as the lowest-level delete layer, with PE_PEI_SHD handling shadow-table mechanics beneath it.