Results for “per_pse_del”

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

Overview

PER_PSE_DEL is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2. Its name follows the Oracle HRMS naming convention in which "PER" denotes the Human Resources product family, "PSE" abbreviates Position Structure Element, and "DEL" indicates a deletion utility. The package therefore serves as the low-level deletion handler for rows in the PER_POS_STRUCTURE_ELEMENTS table, which stores the individual elements (positions and their subordinate nodes) that make up a position hierarchy.

Position hierarchies in Oracle HRMS define reporting and roll-up relationships between positions. When a hierarchy is restructured — for example, when a position is removed from a hierarchy, an entire hierarchy is reorganized, or a position is end-dated — the corresponding structure element rows must be removed in a controlled fashion that respects the shadow (audit) table and any dependent business logic. PER_PSE_DEL encapsulates that controlled removal logic so that callers do not issue ad hoc DML against PER_POS_STRUCTURE_ELEMENTS directly.

Key Procedures and Functions

ETRM documents a single procedure for this package: DEL. Consistent with Oracle's convention for HRMS utility packages, DEL performs the physical or logical removal of one or more position structure element records on behalf of the caller. It is the sole documented entry point and the package's interface to the rest of the application.

The metadata does not publish the formal parameter list for DEL; parameters are not invented here. In practice, a deletion utility of this type is invoked with identifiers that scope the deletion to a specific structure element or hierarchy version. Because the package has a companion shadow object (PER_PSE_SHD), the DEL procedure is expected to interact with the audit-enabled counterpart so that deletions are reflected consistently in the shadow table.

Tables Accessed

The only documented table reference is PER_POS_STRUCTURE_ELEMENTS, accessed through an APPS synonym. This is the base table in which position hierarchy elements are stored. DEL operates against this table to remove structure element rows as directed by its caller.

In addition, the dependency metadata records that PER_PSE_DEL references PER_PSE_SHD, the shadow table maintained by Oracle HRMS for auditing and date-tracked history of position structure elements. The presence of this dependency indicates that inserts, updates, or deletes performed by DEL on the base table are mirrored into the shadow table so that the audited history of the hierarchy remains complete.

Usage Notes

PER_PSE_DEL is not an end-user-facing component. It is invoked indirectly, typically from the position hierarchy maintenance functions in Oracle HRMS, or programmatically by the public position hierarchy API. The dependency report confirms that HR_POS_HIERARCHY_ELE_API references PER_PSE_DEL; the hierarchy API therefore delegates element-level deletions to this package rather than performing them inline. The package is also listed as referenced by itself, which is consistent with internal, recursive-style calls within the package body.

Because the package writes to an audited HRMS entity, it should not be called directly from custom code without first invoking the supported public API. Direct invocation bypasses validations, security, and date-tracking rules enforced at the API layer and can leave PER_POS_STRUCTURE_ELEMENTS and PER_PSE_SHD inconsistent. When custom extensions must remove hierarchy elements, the supported HR_POS_HIERARCHY_ELE_API entry points should be used, allowing PER_PSE_DEL to perform the underlying deletion under proper control.