Search Results create_vapro_results

Overview

BEN_PD_RATE_AND_CVG_MODULE is an Oracle EBS Advanced Benefits (OLTP) PL/SQL package owned by the APPS schema. Its documented status is VALID, and it is classified under ETRM as API classification OTHER, indicating that it is an internal processing module rather than a public, supported extension API. The package serves as the rate, coverage, and resulting-fact generation engine within the Oracle Benefits plan design architecture. It is invoked by higher-level plan design modules — BEN_PLAN_DESIGN_PLAN_MODULE, BEN_PLAN_DESIGN_PROGRAM_MODULE, BEN_PLAN_DESIGN_ELPRO_MODULE, and BEN_PDW_COPY_BEN_TO_STG — to produce, persist, and stage the derived rate, coverage, premium, and benefit-balance results that define a plan's configuration. The "PD" prefix confirms its position in the plan design layer, where eligibility, rate, and coverage rules are resolved and materialized for downstream use by benefits processing and the Benefits Data Warehouse staging process.

Key Procedures and Functions

ETRM documents eleven procedures or functions within this package. Each targets a specific result category generated during plan design:

• CREATE_RATE_RESULTS — generates rate results associated with plan design rate configurations.
• CREATE_COVERAGE_RESULTS — generates coverage results for plans and options.
• CREATE_PREMIUM_RESULTS — produces premium-related results.
• CREATE_DRPAR_RESULTS — produces dependent and related-person (designated recipient) results.
• CREATE_VAPRO_RESULTS — produces variable program results.
• CREATE_BNFT_POOL_RESULTS — produces benefit pool results.
• CREATE_SERVICE_RESULTS — produces service-based results used in rate and eligibility calculations.
• CREATE_POSTAL_RESULTS — produces postal or geographic results, typically supporting location-driven rates.
• CREATE_BNFT_BAL_RESULTS — produces benefit balance results.
• CREATE_BNFT_GROUP_RESULTS — produces benefit group results.
• CREATE_ACRS_PTIP_CVG_RESULTS — produces across-plan / participant-in-plan coverage results.

No parameter lists are documented in the ETRM metadata; the names indicate purpose rather than signature, and the routines are not published as callable APIs.

Tables Accessed

The package operates against a broad set of Benefits configuration and result tables through APPS synonyms, including BEN_ACRS_PTIP_CVG_F, BEN_ACTL_PREM_F, BEN_ACTL_PREM_VRBL_RT_F, BEN_ACTL_PREM_VRBL_RT_RL_F, BEN_ACTY_BASE_RT_CTFN_F, BEN_ACTY_BASE_RT_F, BEN_ACTY_RT_PTD_LMT_F, BEN_ACTY_RT_PYMT_SCHED_F, BEN_ACTY_VRBL_RT_F, BEN_AGE_FCTR, BEN_AGE_RT_F, BEN_APLCN_TO_BNFT_POOL_F, BEN_ASNT_SET_RT_F, BEN_BENFTS_GRP, and BEN_BENFTS_GRP_RT_F. Collectively these tables represent actual premium, activity base and variable rates, rate payment limits and schedules, age factors and age rates, assignment set rates, application-to-benefit-pool mappings, across-plan coverage, and benefit group definitions. The package reads these sources and writes the corresponding result records used in plan design and staged for the Benefits Data Warehouse.

Usage Notes

This package is normally invoked indirectly. In Oracle EBS 12.1.1 and 12.2.2 it is called by the plan design modules during plan configuration and saved process execution, and by BEN_PDW_COPY_BEN_TO_STG during extraction of Benefits configuration into the data warehouse staging tables. It also references itself, indicating internal recursion or shared helper logic. Because the routines are classified as OTHER rather than as a formal public API, direct calls from custom forms, concurrent programs, or custom PL/SQL are not supported and are discouraged. Customizations should use documented Benefits APIs and the standard plan design and data warehouse interfaces instead.