Search Results update_prtt_enrt_result

Overview

APPS.BEN_PRTT_ENRT_RESULT_API is a public PL/SQL API within the Oracle E-Business Suite Advanced Benefits (Oracle Benefits) module. Its name derives from "Participant Enrollment Result," and it serves as the authoritative programmatic interface for creating, maintaining, and removing participant enrollment result records that link a participant to the benefits in which they are enrolled. Enrollment results are the persistent outcome of benefit processing: whereas elections capture a participant's intent, the enrollment result captures the actual coverage, premium, rate, and covered dependent records that drive payroll deduction, carrier transmission, and reporting. This package therefore acts as the controlled gateway through which enrollment results are written, protecting the underlying tables from direct, unvalidated DML.

Key Procedures and Functions

The package exposes eighteen documented procedures and functions covering the full enrollment lifecycle:

• CREATE_ENROLLMENT / CREATE_PRTT_ENRT_RESULT — Create an enrollment and its associated participant enrollment result row.
• UPDATE_ENROLLMENT / UPDATE_PRTT_ENRT_RESULT — Modify an existing enrollment or enrollment result, applying the package's validation rules.
• DELETE_ENROLLMENT / DELETE_ENROLLMENT_W — Remove an enrollment; the "_W" variant provides the wrapper entry point used by calling processes.
• DELETE_PRTT_ENRT_RESULT — Delete a specific participant enrollment result record.
• VOID_ENROLLMENT — Void an enrollment while retaining audit history rather than physically removing it.
• LCK — Lock the enrollment result row to serialize concurrent modifications.
• MULTI_ROWS_EDIT — Perform bulk edits across multiple enrollment result rows.
• CHK_COVERAGE_ACROSS_PLAN_TYPES — Validate coverage consistency across different plan types.
• CALC_DPNT_CVG_DT / DETERMINE_DPNT_CVG_DT_CD — Calculate and determine the dependent coverage date and its date code.
• UNHOOK_BNF / UNHOOK_DPNT — Detach a beneficiary or dependent from an enrollment result.
• GET_BEN_PEN_UPD_DT_MODE — Retrieve the participant enrollment update date-mode setting.
• UPDATE_PERSON_TYPE_USAGES — Synchronize person type usage records associated with the enrollment.

Tables Accessed

The API operates against Benefit core and flexfield tables accessed through APPS synonyms:

• BEN_ENRT_BNFT, BEN_ENRT_PREM, BEN_ENRT_RT — Hold enrollment benefit, premium, and rate results, the principal records the API inserts and updates.
• BEN_ELIG_DPNT, BEN_ELIG_CVRD_DPNT_F, BEN_ELIG_PER_ELCTBL_CHC — Supply eligibility, covered dependent, and electable choice data used for validation.
• BEN_ACRS_PTIP_CVG_F, BEN_ACTY_BASE_RT_F, BEN_BNFT_PRVDD_LDGR_F, BEN_OIPL_F — Flexfield structures carrying across-plan-type coverage, activity base rate, provided benefit ledger, and option-in-plan information.
• BEN_EXT_CHG_EVT_LOG, BEN_LEE_RSN_F, BEN_LER_F, BEN_LER_CHG_DPNT_CVG_F, BEN_LE_CLSN_N_RSTR — Life event and change event data used when enrollment results are driven by life events.

Usage Notes

BEN_PRTT_ENRT_RESULT_API is an internal Benefits engine API invoked by the enrollment processing framework rather than called directly by end users. Its dependency list confirms that it is referenced by twenty-nine other packages, including BEN_ENROLLMENT_PROCESS, BEN_MANAGE_DEFAULT_ENRT, BEN_MANAGE_LIFE_EVENTS, BEN_AUTOMATIC_ENROLLMENTS, BEN_CLOSE_ENROLLMENT, and BEN_PROC_COMMON_ENRT_RSLT. It is also the target of the HRDPP_* PL/SQL batch loader entry points (HRDPP_CREATE_PRTT_ENRT_RESULT, HRDPP_UPDATE_PRTT_ENRT_RESULT, HRDPP_DELETE_PRTT_ENRT_RESULT), which support data-pump style loading of enrollment data. It depends on HR_API for person-level validation and STANDARD for standard PL/SQL behavior. Custom code can call this package, but doing so bypasses several framework-level validations and should be undertaken only with a clear understanding of the enrollment result data model; for most integrations the supported approach is to raise enrollment through the standard enrollment process or the HRDPP data loader, allowing this API to be invoked in its intended sequence.