Search Results log_data

Overview

APPS.BEN_PD_COPY_TO_BEN_ONE is a PL/SQL package body in the Oracle E-Business Suite Advanced Benefits (OLTP) module. Its core purpose is to copy benefit plan design configuration data from one source entity into the BEN schema tables — a "copy to BEN" operation — so that eligibility profiles, benefit groups, plan-in-program relationships, and related compensation and factor configurations are propagated and initialized for downstream enrollment and eligibility processing. The header comment ($Header: bepdccp1.pkb 120.24 … noship $) indicates the package belongs to the benefits plan design component and has evolved through multiple patch revisions.

The package also provides a reusable datetrack-mode resolution utility, get_dt_modes, which translates user-supplied DateTrack operation semantics (CORRECTION, UPDATE, UPDATE_OVERRIDE, UPDATE_CHANGE_INSERT, INSERT) into the HR API constants (hr_api.g_correction, hr_api.g_update, hr_api.g_update_override, hr_api.g_update_change_insert) and derives an update flag. This logic relies on comparing the effective date against the effective start date and checking the end date against hr_api.g_eot.

Key Procedures and Functions

• LOG_DATA / INIT_LOG_TBL — Initialize and populate a logging table used to record copy activity and diagnostics.
• BEN_CHK_COL_LEN / RAISE_ERROR_MESSAGE — Validate column lengths and raise standardized application error messages during the copy process.
• INIT_TABLE_DATA_IN_CER — Initialize working data in the BEN_COPY_ENTITY_RESULTS staging table, the central results repository for the copy operation.
• DATA_EXISTS_FOR_TABLE — Determine whether rows already exist for a given target table, supporting idempotent create-or-update behavior.
• CREATE_OR_UPDATE_FF — Create or update flexible-formula related configuration entries.
• The CREATE_*_ROWS family — CREATE_ALL_LEAF_BEN_ROWS, CREATE_FFF_ROWS, CREATE_CLF_ROWS, CREATE_HWF_ROWS, CREATE_AGF_ROWS, CREATE_LSF_ROWS, CREATE_PFF_ROWS, CREATE_CLA_ROWS, CREATE_ELP_ROWS, and CREATE_EGL_ROWS — each inserts the appropriate rows for a specific plan-design construct (eligibility profiles, eligibility criteria, plan-in-program and program-in-plan options, compensation-level and age/service factors, and related benefit groupings).

Note: procurement of exact parameter lists is omitted intentionally; the documented signature confirms procedures accept effective dates, DML operation strings, and DateTrack mode variables.

Tables Accessed

• BEN_COPY_ENTITY_RESULTS — staging/audit of copy results, driven by INIT_TABLE_DATA_IN_CER.
• BEN_ELIGY_PRFL_F, BEN_ELIGY_CRITERIA, BEN_DPNT_CVG_ELIGY_PRFL_F — eligibility profile and dependent coverage eligibility configuration.
• BEN_COMP_LVL_FCTR, BEN_AGE_FCTR, BEN_CMBN_AGE_LOS_FCTR, BEN_CMBN_PLIP_F, BEN_CMBN_PTIP_F, BEN_CMBN_PTIP_OPT_F — factors and combined plan/program option tables.
• BEN_BENFTS_GRP, BEN_CM_TYP_F, BEN_ACTN_TYP, BEN_BNFTS_BAL_F — benefit groups, compensation types, action types, and balance configuration.
• PQH_TRANSACTION_CATEGORIES — transaction category reference for datetracked operations.

Usage Notes

The package is referenced by 8 other benefit packages, indicating it sits within the plan-design copy chain rather than being invoked directly from a form. It is typically called by higher-level benefit plan configuration APIs and concurrent processes that duplicate a plan or template to a target business group. Because the logic is date-effective and uses HR DateTrack constants, callers must supply valid effective dates and a DML operation; the get_dt_modes utility resolves the correct mode. Given its location in the BEN schema and its reliance on the BEN_COPY_ENTITY_RESULTS staging area, it is most commonly exercised during plan-design setup, template application, and benefits configuration migration in EBS 12.1.1 and 12.2.2.