Search Results hrdpp_delete_elig_cvrd_dpnt




Overview
Explore in AI Chat

Overview

HRDPP_DELETE_ELIG_CVRD_DPNT is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite. It belongs to the Oracle Advanced Benefits (OLAM / OAB) family of "HRDPP" packages, which are used by the Benefits Proration and Participation (pump) engine to stage, process, and reconcile eligibility and coverage data during benefits processing runs. The name of the package explicitly describes its purpose: it deletes eligible covered dependent records as part of the dependent processing phase of a benefits activity (for example, an Open Enrollment or a life-event suspension and reinstatement cycle).

The package is classified as an "OTHER" API in ETRM, meaning it is not published as a supported external application programming interface but is instead invoked internally by the application tier. Its status is VALID on both 12.1.1 and 12.2.2, and its only listed dependency at the database level is the SYS.STANDARD package. The package contains a package specification and a package body.

Key Procedures and Functions

Seven procedures/functions are documented in ETRM for this package:

  • DC, D, N, DD, ND — These are the short, cryptic entry points that characterise Oracle's HRDPP utilities. Each corresponds to a specific deletion mode applied to eligible covered dependents. The single letters identify the scope of the delete (for example, deletion by date combinations or by person/assignment), while the double-letter variants act as overloaded or extended forms that combine two deletion criteria. They exist so that the benefits pump can call exactly the delete semantics required by the processing step that has been triggered, without the caller needing to build the underlying DML.
  • INSERT_BATCH_LINES — Builds and inserts the batch line records required before the delete routines execute. The pump engine works through staging tables that hold pending changes; this procedure populates those staging rows for the dependent records that are candidates for deletion, ensuring each action is traceable and recoverable.
  • CALL — The public dispatcher procedure. External or internal callers invoke CALL, which then routes control to the appropriate delete routine (D, N, DC, DD, or ND) based on the parameters supplied by the pump engine. This indirection allows the package to be invoked from a single, stable entry point while the underlying deletion logic remains modular.

No parameter lists are published for these procedures in the ETRM metadata, and none should be assumed.

Tables Accessed

The package reads and writes the standard Advanced Benefits pump staging tables through APPS synonyms:

Reads are used to identify which eligible covered dependents are to be removed; writes stage the corresponding delete lines and exceptions.

Usage Notes

This package is invoked exclusively by the Oracle Advanced Benefits processing engine. It is triggered during benefits participation processing, when the application must remove dependent coverage eligibility records — typically during life event processing, dependent ineligibility handling, or open enrollment re-evaluation. It is not intended to be called directly from custom forms, concurrent program registrations, or client-side code. The ETRM metadata records zero referencing packages, which reinforces its role as a leaf-level utility inside the pump processing chain rather than a shared API. Customers performing data correction on dependent records should use supported Oracle APIs (such as ben_dependent_api or the Benefits PL/SQL interfaces) rather than invoking HRDPP_DELETE_ELIG_CVRD_DPNT directly, since direct calls bypass validations and audit expectations. Any diagnostic work should reference the batch line tables above to confirm that expected delete actions were staged and completed.