Search Results hrdpp_create_prtt_enrt_result




Overview
Explore in AI Chat

Overview

The APPS.HRDPP_CREATE_PRTT_ENRT_RESULT package is a PL/SQL database object residing in the APPS schema of an Oracle E-Business Suite 12.1.1 or 12.2.2 environment. It belongs to the HRDPP module family, which supports the Oracle HRMS "pump" architecture — a set of staged, batch-oriented tables and APIs used to load participant enrollment and related benefits/compensation data efficiently in bulk. The package is classified in the ETRM repository as an OTHER API, indicating that it is an internal utility rather than a formally published public interface, and it is not referenced by any other package (referenced-by count of zero). Its evident purpose is to create participant enrollment result records by inserting processed rows into the HR pump batch line tables, capturing both successful loads and exception conditions encountered during processing.

Key Procedures and Functions

ETRM documents seven callable units in the package:

  • DC — a helper routine whose short name is consistent with HRMS pump coding conventions; it participates in the data-creation path for enrollment result rows.
  • D — a companion helper routine typically used in the same processing sequence as DC.
  • N — an additional short-named utility routine supporting normalization or new-record logic within the enrollment result creation flow.
  • DD — a helper routine completing the short-name utility set, invoked as part of the internal method chain.
  • ND — the final short-named helper routine in the documented set.
  • INSERT_BATCH_LINES — the substantive procedure that inserts processed enrollment results into the HR pump batch line tables, forming the core of the package's function.
  • CALL — the entry-point procedure that orchestrates invocation of the internal helpers and the batch-line insertion logic.

The short-named routines (DC, D, N, DD, ND) are internal utilities that the package exposes but that are not intended for independent use; CALL and INSERT_BATCH_LINES carry the meaningful business behavior.

Tables Accessed

Through APPS synonyms the package reads and writes the HR pump staging tables:

Usage Notes

Because the package is classified as OTHER and has no documented inbound references, it is an internal implementation object, not a supported public API. It is normally invoked indirectly by the HRMS pump-driven enrollment processes, benefit enrollment batch jobs, or custom loaders that populate the HR pump batch structures. Custom code should avoid calling HRDPP_CREATE_PRTT_ENRT_RESULT directly; instead, developers should use the supported HRMS enrollment APIs and let the pump framework invoke this package as part of its internal processing. Direct invocation risks data inconsistency across the batch line, user key, and exception tables.