Search Results hrdpp_create_elig_cvrd_dpnt




Overview
Explore in AI Chat

Overview

HRDPP_CREATE_ELIG_CVRD_DPNT is an Oracle EBS PL/SQL package owned by the APPS schema and classified under the ETRM metadata as an "OTHER" API type. It forms part of the HRDPP (Human Resources Data Pump Processing) family of packages used by Oracle Advanced Benefits and related benefits processing infrastructure. Its name indicates its business purpose: creating eligible covered dependent records as part of the benefits data pump workflow. The HRDPP framework is used to stage, validate, and apply bulk benefit enrollment and eligibility data, and this package contributes the dependent-creation step that runs within that process.

The package is documented as VALID in both Oracle EBS 12.1.1 and 12.2.2, and ETRM records list seven callable procedures or functions. Its only external package-level dependency is the SYS.STANDARD package, which is a normal PL/SQL built-in and indicates no reliance on other custom APPS packages. No other APPS package is documented as referencing it, meaning it is normally invoked directly rather than being called from other PL/SQL APIs.

Key Procedures and Functions

ETRM records seven subprograms in this package. The metadata documents only short internal names for most of them, so their exact signatures are not reproduced here. The documented entries are:

  • DC, D, N, DD, and ND — short-named internal procedures registered by the package. These follow the common Oracle data pump pattern of intermediate processing steps, where each routine performs a discrete portion of the dependent creation logic, such as data retrieval, derivation, or record assembly. The abbreviated naming suggests private or internal helper routines rather than public entry points.
  • INSERT_BATCH_LINES — an explicitly named procedure whose purpose is to insert batch lines into the data pump staging tables. This is the routine that materializes the dependent records into the HR_PUMP_BATCH_LINES structure for subsequent validation and application.
  • CALL — the public entry point. In HRDPP-style packages, it is the routine invoked externally to start processing, accepting the parameters needed to identify the batch and any run mode.

No parameter lists are documented in the ETRM metadata, and none are inferred here.

Tables Accessed

Based on documented dependencies via APPS synonyms, the package reads from and writes to the following data pump tables:

These are the standard HRDPP staging structures, confirming that the package functions within the data pump staging layer rather than writing directly to benefits eligibility tables.

Usage Notes

HRDPP_CREATE_ELIG_CVRD_DPNT is a server-side API, not a form-bound package. It is normally invoked from concurrent programs, from the benefits data pump orchestration logic, or from custom PL/SQL that needs to stage eligible covered dependent data for later validation and application. Because dependent creation is a step within a multi-stage pump rather than a standalone operation, callers typically invoke the public CALL routine after the batch header and user keys have been established. Customizations should treat the short-named internal routines as private and avoid calling them directly, since Oracle does not guarantee their stability across patches or upgrades. All execution should occur as the APPS user or a user with equivalent HRDPP privileges.