Search Results hrdpp_create_ben_asg




Overview
Explore in AI Chat

Overview

HRDPP_CREATE_BEN_ASG is an Oracle EBS PL/SQL package owned by the APPS schema that supports the HR Data Pump (HRDPP) subsystem—the bulk data-loading framework used to move large volumes of HR and benefits assignment data into Oracle Human Resources and Oracle Advanced Benefits. The "HRDPP" prefix identifies the package as part of the HR Data Pump family of loaders, while the "CREATE_BEN_ASG" suffix indicates its specialized role in creating benefit assignment records during a batch load.

The package functions as a server-side worker invoked by the broader HR Data Pump orchestration layer. Rather than exposing a rich public API, it provides a set of low-level routines that transform staged rows in the HR Pump batch tables into validated benefit assignment rows, recording any rows that fail business rules into an exceptions table for later review. It carries an API classification of OTHER, meaning it is treated as an internal, non-public interface intended for use within the Data Pump processing flow rather than as a supported integration API.

In EBS 12.1.1 and 12.2.2 the object is reported as VALID, and its only external reference is to the SYS.STANDARD package. Notably, no other application package references it, confirming its status as a downstream, purpose-built loader rather than a shared utility.

Key Procedures and Functions

The ETRM metadata documents seven procedures/functions. Several names appear as abbreviations, which is consistent with internal Data Pump helper routines:

  • DC — a control/driver routine that contributes to the package's create-assignment processing logic.
  • D — a helper unit invoked within the batch creation flow.
  • N — a helper unit used in the same batch processing sequence.
  • DD — a further helper routine supporting assignment creation.
  • ND — a complementary helper routine.
  • INSERT_BATCH_LINES — inserts new rows into the HR Pump batch line staging tables; this is the principal write routine that persists benefit assignment data for subsequent validation and processing.
  • CALL — the public entry point that orchestrates the internal routines above.

Because full parameter signatures are not published in the ETRM excerpt, detailed argument lists are intentionally omitted here. The routines are intended to be executed as a group under CALL rather than individually.

Tables Accessed

All table access is performed through APPS synonyms over the HR Pump staging tables:

Usage Notes

HRDPP_CREATE_BEN_ASG is not intended for direct invocation by end users or custom code. It is typically called by HR Data Pump concurrent programs and the surrounding Data Pump framework when loading benefit assignment information in bulk. Because the package has internal (OTHER) classification and no downstream package dependencies, customization should avoid calling it directly; instead, integrations should use the supported Data Pump processes or standard benefits APIs. Its presence in a deployment confirms that the HR Pump benefits-assignment loader is installed and valid.