Search Results ben_cpe_del




Overview
Explore in AI Chat

Overview

BEN_CPE_DEL is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite that supports the Benefits module's "Copy Person/Entity" (CPE) processing framework. Its role is to perform deletion of staged benefit copy-entity result records after a person or entity copy operation has completed, been rolled back, or been cancelled. The CPE framework in Oracle Advanced Benefits allows administrators to replicate a set of benefit enrollments, eligibility determinations, and related setup records from a source person or entity to one or more target persons or entities. Because each copy operation stages intermediate result rows before final commitment, a controlled mechanism is required to purge those staging rows when they are no longer needed. BEN_CPE_DEL provides that mechanism.

The package is documented in the ETRM as an "OTHER" classified API with a status of VALID, indicating it is an active, compiled database object in the APPS schema. Its dependency graph shows it references BEN_CPE_SHD, the shadow (history/audit) table associated with the CPE result table, confirming that the deletion logic is aware of the shadow table used for audit tracking.

Key Procedures and Functions

The documented interface exposes a single procedure, DEL. As the name implies, DEL encapsulates the removal of copy-entity result data from the CPE staging tables. Because the metadata does not publish the formal parameter list, the exact signature is not reproduced here; however, in the CPE processing model the procedure is typically called with identifying keys that scope the deletion to a specific copy-entity run, source or target person, or result set, so that unrelated staging rows are preserved.

The package body also references itself (BEN_CPE_DEL is listed as referencing BEN_CPE_DEL), which is consistent with internal, possibly overloaded or recursive invocation patterns used to process multiple result groups in sequence. No other public procedures or functions are documented beyond DEL.

Tables Accessed

  • BEN_COPY_ENTITY_RESULTS — the primary staging table for copy-entity processing. BEN_CPE_DEL deletes rows from this table (accessed through the APPS synonym) to remove intermediate or obsolete copy results.
  • BEN_CPE_SHD — the shadow table that captures audited or historical versions of CPE result rows. Its presence in the dependency list indicates the deletion logic interacts with audit history, either by relying on shadow rows for reference or by maintaining referential consistency between the base and shadow tables.

Usage Notes

BEN_CPE_DEL is not intended as an end-user-facing API. It is an internal service routine invoked by the broader CPE orchestration layer, most notably BEN_COPY_ENTITY_RESULTS_API, which the ETRM notes references BEN_CPE_DEL. In practice, deletion is triggered as part of the lifecycle of a copy-entity operation: when results are accepted and committed, when a run is rolled back, or when administrators clear aborted or stale copy attempts.

Customizations that call this package directly should do so cautiously, because bypassing the standard orchestration may leave orphaned rows in BEN_COPY_ENTITY_RESULTS or its shadow table and can interfere with subsequent CPE runs. The recommended approach is to invoke the standard copy-entity APIs and concurrent processes, letting them manage deletion internally. Because the exact parameter list is not exposed in the documentation, integrators should obtain the signature from the package specification in the target environment before calling DEL programmatically.