Search Results create_lsf_rows

Overview

APPS.BEN_PD_COPY_TO_BEN_ONE is a PL/SQL package within the Oracle E-Business Suite Advanced Benefits (BEN) module. Its core business function is to copy benefits plan design (PD) configuration data — plans, options, eligibility profiles, and related setup entities — from one business group or legislative context into another target business group ("BEN_ONE"). This supports the common requirement to replicate an existing benefits plan design into a new or parallel environment without manually re-entering each setup element.

The package maintains an internal mapping and logging architecture. It defines a record type (g_pk_rec_type) that tracks the primary key column name, the old and new primary key values, the copy/reuse type, and the table route identifier for each entity being processed. A corresponding PL/SQL table (g_pk_tbl) accumulates these rows as the copy progresses. Separate log tables track which program, plan, option, plan-type, eligibility, and factor records were newly copied versus reused, along with running counters for each category. The header revision string (bepdccp1.pkh 120.3) places the origin of this package in the 2006 timeframe, and it remains the delivered implementation across both 12.1.1 and 12.2.2.

Key Procedures and Functions

The package exposes seventeen documented procedures and functions:

• LOG_DATA — Records copy and reuse activity into the package's internal log collections.
• BEN_CHK_COL_LEN — Validates the length of a column value against the target column definition before insert or update.
• INIT_LOG_TBL — Initializes the logging PL/SQL tables prior to a copy run.
• INIT_TABLE_DATA_IN_CER — Seeds data in BEN_COPY_ENTITY_RESULTS, the staging table that holds copy results.
• DATA_EXISTS_FOR_TABLE — Determines whether data already exists for a given table, supporting copy-versus-reuse decisions.
• CREATE_OR_UPDATE_FF — Handles creation or update of "FF" (flexfield-related) rows as part of the copy.
• RAISE_ERROR_MESSAGE — Raises a standardized error to the caller when a copy step fails.
• CREATE_ALL_LEAF_BEN_ROWS — Orchestrates creation of all leaf-level benefit rows across the entity hierarchy.

Eight additional procedures follow a uniform naming convention (CREATE_<entity>_ROWS) and each builds the row set for a specific plan-design entity:

• CREATE_FFF_ROWS — the function most commonly searched for; it creates "FFF" rows (the eligibility/factor flexfield rows) during the copy.
• CREATE_CLF_ROWS — creates compensation-level factor rows.
• CREATE_HWF_ROWS — creates hours-worked factor rows.
• CREATE_AGF_ROWS — creates age factor rows.
• CREATE_LSF_ROWS — creates length-of-service factor rows.
• CREATE_PFF_ROWS — creates another flexfield-related factor row set.
• CREATE_CLA_ROWS — creates coverage-level or coverage-amount rows.
• CREATE_ELP_ROWS — creates eligibility profile rows.
• CREATE_EGL_ROWS — creates eligibility grouping or eligibility-list rows.

Tables Accessed

The package reads and writes the principal Advanced Benefits configuration tables via APPS synonyms. These include BEN_ACTN_TYP (action types), BEN_BENFTS_GRP (benefits groups), BEN_ELIGY_PRFL_F and BEN_ELIGY_CRITERIA (eligibility profiles and their criteria), BEN_DPNT_CVG_ELIGY_PRFL_F (dependent coverage eligibility), BEN_CM_TYP_F (compensation types), BEN_AGE_FCTR, BEN_COMP_LVL_FCTR, and BEN_CMBN_AGE_LOS_FCTR (age, compensation-level, and age/length-of-service combined factors). Combination plan/option structures are referenced through BEN_CMBN_PLIP_F, BEN_CMBN_PTIP_F, and BEN_CMBN_PTIP_OPT_F, while BEN_BNFTS_BAL_F holds benefits balance definitions. BEN_COPY_ENTITY_RESULTS is the staging table populated by INIT_TABLE_DATA_IN_CER and used throughout the copy. PQH_TRANSACTION_CATEGORIES links to HR transaction category definitions. The tables are accessed to read the source configuration and to write the replicated rows into the target business group.

Usage Notes

BEN_PD_COPY_TO_BEN_ONE is an internal helper package invoked as part of the "Copy Plan Design to Another Business Group" flow in the Advanced Benefits configuration forms and the related concurrent process. It is referenced by eight other packages, so it is not intended for direct invocation by custom code. Oracle does not publish a formal public API for it; the supported entry point remains the delivered copy form or concurrent program. Custom development that calls it directly risks breakage across patches and upgrades, since procedure signatures and internal logic are not guaranteed to remain stable. Configuration of the copy options (copy versus reuse) is controlled through the delivered user interface, which populates the copy/reuse types recorded in the package's mapping records.