Search Results ben_pd_copy_to_ben_five




Overview
Explore in AI Chat

Overview

APPS.BEN_PD_COPY_TO_BEN_FIVE is a server-side PL/SQL package that belongs to the Oracle Advanced Benefits (Oracle Benefits) module of Oracle E-Business Suite. Its name follows the established Oracle naming convention in which the BEN prefix identifies Benefits objects and the PD (plan design) component signals that the package participates in the configuration copy mechanism used within Plan Design. This package is one member of a numbered family of copy routines (BEN_PD_COPY_TO_BEN_ONE, BEN_PD_COPY_TO_BEN_TWO, and so on) that rely on each other to duplicate complex benefits plan design configuration between plan years or across design environments. Its central purpose, as reflected in the single documented program unit CREATE_RATE_ROWS, is to generate the rate and premium rows that underpin cost calculation for a benefits plan.

The object is owned by the APPS schema and its documented status is VALID in the ETRM repository for 12.1.1 and 12.2.2. It is classified as an OTHER API rather than a public or private PL/SQL API, which indicates that it is an internal implementation package that Oracle EBS product code calls on behalf of Plan Design, rather than an integration point intended for direct customer invocation.

Key Procedures and Functions

The ETRM documentation records one program unit for this package: CREATE_RATE_ROWS. Consistent with the package's role in the plan design copy process, CREATE_RATE_ROWS is responsible for constructing the rate rows required by a benefits plan as part of copying or replicating plan design data into the corresponding Benefits structures. It operates against the activity rate, premium, and variable rate tables enumerated below to derive and insert the rate records that the Benefits engine later uses during eligibility and cost processing. Parameter details are not published in the available metadata and are therefore not reproduced here. No other procedures or functions are documented for this object.

Tables Accessed

Through APPS synonyms, the package reads from and writes to a set of Benefits plan design and rate configuration tables. The principal groups are:

CREATE_RATE_ROWS is the primary program unit that interfaces with these tables, selecting configuration data and inserting the resulting rate and premium rows.

Usage Notes

BEN_PD_COPY_TO_BEN_FIVE is invoked indirectly. It is referenced by BEN_PD_COPY_TO_BEN_TWO and by the Plan Design processing packages GHR_FEHB_PLAN_DESIGN, GHR_TSP_PLAN_DESIGN, and GHR_TSP_CATCHUP_PLAN_DESIGN, each of which calls it as part of a larger copy or catch-up operation. In practice this means the package executes when a user performs a Plan Design copy that touches activity rates, premiums, or variable rates, or when a catch-up process reconciles plan design data across periods. Because the object sits in the APPS schema and is classified as an internal OTHER API, it should not be called directly from custom code; customers requiring rate data should use supported Benefits APIs or the standard Plan Design forms and concurrent programs.