Results for “fetch_drvd_factor_result”

8 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.BEN_PDW_COPY_BEN_TO_STG is a PL/SQL package body that supports the Benefits copy-entity framework used by Oracle EBS Advanced Benefits during the "PDW" (Person/Data Warehouse staging) copy process. Its central responsibility is to read source Benefits configuration and enrollment rows and mirror them into the staging/result structures that drive the generic copy-engine mechanism. The package collaborates with the underlying copy transaction infrastructure — notably PQH_COPY_ENTITY_TXNS and BEN_COPY_ENTITY_RESULTS — to record each DML operation performed during a copy run, so that downstream processing can identify which entity instances were reused, created, or displayed.

In Oracle EBS 12.1.1 and 12.2.2, the package is catalogued with API classification OTHER, indicating it is an internal, non-public interface rather than a supported API. The header identifies a build at the 12.2.0 code line (bepdwstg.pkb 120.20.12020000.2), confirming its relevance across both documented releases.

Key Procedures and Functions

The package exposes 37 documented procedures and functions. Their purposes are summarized below.

Tables Accessed

The package reads and writes the following tables via APPS synonyms:

Usage Notes

BEN_PDW_COPY_BEN_TO_STG is invoked internally by the Benefits copy framework, not directly by end users. It is referenced by three other packages, which call its copy routines as part of a larger entity-copy transaction. Typical invocation paths include the Benefits configuration copy concurrent programs and related forms that initiate copying of a plan, program, or eligibility setup across business groups or effective dates.

Because the package is classified as OTHER and carries an internal header, it must not be called from custom code as if it were a supported API; its signature and behavior are subject to change between patch levels. Where custom development requires similar functionality, supported Benefits APIs or the standard copy forms should be used. The presence of the string "cconn" in user searches likely reflects an internal connection or session identifier associated with this package rather than a documented object name.