Search Results create_popl_result

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:

• BEN_ACTN_TYP — action type definitions governing lifecycle events on plan design records.
• BEN_BNFT_RSTRN_CTFN_F — benefit restriction certifications tied to plan eligibility.
• BEN_COPY_ENTITY_RESULTS — stores the outcome rows produced by copy operations, the primary destination for the CREATE_*_RESULT routines.
• BEN_CSS_RLTD_PER_PER_IN_LER_F — related person-per-period data within Life Event Rules.
• BEN_CUSTOM_REGION_ITEMS and BEN_CWB_WKSHT_GRP — worksheet grouping and custom region configuration.
• BEN_DSGN_RQMT_F and BEN_DSGN_RQMT_RLSHP_TYP — design requirement records and their relationship types.
• BEN_ELIG_TO_PRTE_RSN_F — eligibility-to-participate reason codes.
• BEN_ENRT_CTFN_F, BEN_ENRT_PERD, and BEN_ENRT_PERD_FOR_PL_F — enrollment certification and enrollment period definitions.
• BEN_GD_OR_SVC_TYP — goods or services type reference data.
• BEN_LEE_RSN_F and BEN_LEE_RSN_RL_F — life event reason codes and their relationship records.

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.