Search Results ben_plan_design_plan_module




Overview
Explore in AI Chat

Overview

The APPS.BEN_PLAN_DESIGN_PLAN_MODULE package is a PL/SQL module within the Oracle E-Business Suite Advanced Benefits (Oracle Benefits) application. Its role is to support the Plan Design infrastructure, which defines and manages the configurable attributes, eligibility rules, enrollment conditions, and result records associated with benefit plans and programs. Within the Benefits architecture, Plan Design objects are stored as reusable definitions that can be copied, staged, and propagated across benefit plan hierarchies and legal entities.

The package is classified under the OTHER API category, indicating that it is a supporting internal module rather than a published public API. It operates as a component that constructs and persists the "result" rows generated when Plan Design definitions are processed, copied, or staged. Its dependency listing (SYS, STANDARD) confirms only standard Oracle-supplied database schemas are referenced at the compilation level.

Key Procedures and Functions

The ETRM metadata documents eight procedures/functions whose names follow a consistent naming convention (CREATE_*_RESULT), indicating that each one generates a specific category of Plan Design result record:

  • CREATE_PLAN_RESULT — creates the Plan-level result record, representing the primary plan definition outcome.
  • CREATE_POPL_RESULT — creates the result record associated with a Plan Option / program-level artifact.
  • CREATE_LER_RESULT — creates the result record for a Life Event Rule (LER) definition.
  • CREATE_OIPL_RESULT — creates the result record for an Other Input Plan Link / related plan definition.
  • CREATE_OPT_RESULT — creates the result record for a Plan Option (OPT) definition.
  • CREATE_PL_TYP_RESULT — creates the result record for a Plan Type definition.
  • CREATE_YR_PERD_RESULT — creates the result record for a Year Period definition.

Each routine is invoked as part of a larger Plan Design processing sequence to materialize the corresponding definition into a result set that can be consumed by downstream copy or staging operations.

Tables Accessed

The package reads and writes several Advanced Benefits configuration and condition tables, including:

Usage Notes

This package is not intended for direct invocation by end users or external interfaces. It is referenced by four other Benefits packages: BEN_PDW_COPY_BEN_TO_STG (copy from Benefits to staging), BEN_PLAN_DESIGN_PROGRAM_MODULE (program-level plan design), BEN_PLAN_DESIGN_TXNS_API (plan design transactions), and PQH_GSP_HR_TO_STAGE (HR-to-stage propagation). It is also self-referenced, confirming internal calls among its own result-creation routines.

Typical invocation occurs during Plan Design copy, staging, and propagation processes — often triggered through concurrent programs or the Plan Design workbench in the Benefits Forms UI. Custom code should treat the package as a private implementation component and avoid direct calls, relying instead on the documented public Benefits APIs and the surrounding copy/staging processes.