Search Results result_type_cd




Overview
Explore in AI Chat

Overview

BEN_PD_MIGRATE is an Oracle E-Business Suite PL/SQL package body owned by the APPS schema and classified under the ETRM taxonomy as "OTHER." Its role is to migrate benefit plan-design data between the staging structures used by the Oracle Advanced Benefits (OAB) copy-entity framework and the persistent benefit tables that store the definitive definition of a plan. The package operates in the context of the copy entity transaction model, in which a copy operation is tracked by a copy entity transaction identifier, and intermediate results of the copy are staged before being committed to the target benefit model. The header comment embedded in the source, referencing bepdcmig.pkb 115.1 2003/09/02 and the "noship" flag, confirms the package originates from the initial delivery of the Benefits plan-design copy utility and has remained largely stable across releases, including 12.1.1 and 12.2.2.

Key Procedures and Functions

The ETRM metadata documents a single procedure on this package body:

  • MIGRATE_CER_ROWS — Migrates copy entity result rows produced during a plan-design copy transaction into the corresponding benefits-side structures. It is the entry point that consumes the staged result set and drives the write into BEN_COPY_ENTITY_RESULTS and its shadow table. The source excerpt also exposes the internal helper init_table_data_in_cer, which seeds the global g_table_data_in_cer collection used by BEN_PD_COPY_TO_BEN_ONE; this helper is private and is not exposed in the ETRM procedure list. No parameter lists are published in the metadata, and none are asserted here.

Tables Accessed

The package reads and writes the following documented tables through APPS synonyms:

  • PQH_COPY_ENTITY_RESULTS — read. Holds the copy entity results generated by the PQH (Human Resources) copy engine for a given copy entity transaction. The init_table_data_in_cer cursor selects table_route_id from this table filtered by copy_entity_txn_id, establishing which table routes participate in the migration.
  • PQH_TABLE_ROUTE — read. Joined to PQH_COPY_ENTITY_RESULTS to obtain the table_alias and table_route_id for each copied table, which drives population of the global g_table_data_in_cer collection used downstream.
  • BEN_COPY_ENTITY_RESULTS — written. The Benefits-side copy entity results table, which is the migration target for MIGRATE_CER_ROWS.
  • BEN_COPY_ENTITY_RESULTS_S — written. The shadow table for BEN_COPY_ENTITY_RESULTS, maintained alongside the base table to support the key-flex and DML tracking conventions used throughout Benefits.
  • PLITBLM — referenced. The standard PL/SQL table-of-messages utility table used for error and message logging during migration.

Usage Notes

BEN_PD_MIGRATE is not an end-user facing API. It is invoked internally by the Benefits plan-design copy processing chain, typically from concurrent programs or from the higher-level copy orchestration packages that coordinate a copy entity transaction. The search term src_copy_entity_result_id reflects the copy entity result identifier column that links staged PQH results to their Benefits counterparts; the package consumes the copy entity transaction identifier and resolves the result rows it drives. Because the package depends on global state held in BEN_PD_COPY_TO_BEN_ONE, callers must invoke the migration in the same session and sequence as the underlying copy, and any custom code that calls MIGRATE_CER_ROWS directly must first ensure that PQH_COPY_ENTITY_RESULTS and PQH_TABLE_ROUTE have been populated for the transaction. No other packages are documented as referencing this body, so it should be treated as a leaf implementation routine rather than a reusable public API.