Search Results get_max_cvg_thru_dt

Overview

The APPS.BEN_COBRA_REQUIREMENTS package is a core benefits engine component within Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 that supports the administration of Consolidated Omnibus Budget Reconciliation Act (COBRA) benefits. Its primary business function is to evaluate, establish, and maintain COBRA eligibility records for participants, covered dependents, and qualified beneficiaries following qualifying life events such as termination of employment, reduction in hours, divorce, or death of a covered employee. The package determines whether a participant remains eligible for continued coverage, calculates critical eligibility dates, and manages the financial obligations associated with COBRA continuation, including amounts due and payment allocation. The package is registered in the ETRM with a status of VALID under the APPS schema and is classified as an "OTHER" API type, indicating it is primarily an internal engine package rather than a public integration API.

Key Procedures and Functions

The package exposes twenty documented procedures and functions that collectively handle COBRA determination logic:

• Eligibility Determination: CHK_COBRA_ELIGIBILITY, CHECK_MAX_POE_ELIGIBILITY, CHK_ENRLD_OR_CVRD, and CHK_INIT_EVT evaluate whether a person qualifies for COBRA continuation based on enrollment status, coverage, and initiating events.
• Date Calculation: GET_LF_EVT_OCRD_DT, GET_CBR_ELIG_END_DT, GET_MAX_CVG_THRU_DT, and DETERMINE_COBRA_ELIG_DATES derive occurrence, eligibility end, and maximum coverage-through dates.
• Eligibility Updates: UPDATE_COBRA_ELIG_INFO, UPDATE_COBRA_INFO, UPDATE_DPNT_COBRA_INFO, END_COBRA_ELIGIBILITY, and END_PRTT_COBRA_ELIGIBILITY persist changes to COBRA eligibility and dependent records.
• Financial Processing: GET_AMOUNT_DUE, ALLOCATE_PAYMENT, GET_UNPAID_RATE, and GET_DUE_AND_PAYMENT_AMT compute premiums owed and apply payments.
• Supporting Validations: CHK_PGM_TYP, CHK_DSBLD, and GET_COMP_OBJECT_NAME perform program-type checks, disability validation, and object name resolution.

Tables Accessed

The package reads and writes multiple benefits base tables through APPS synonyms, including BEN_CBR_PER_IN_LER and BEN_PER_IN_LER for person-level eligibility records, BEN_CBR_QUALD_BNF for qualified beneficiaries, BEN_ELIG_CVRD_DPNT_F for covered dependents, BEN_LER_F and BEN_PER_INFO_CHG_CS_LER_F for life event records, BEN_PGM_F and BEN_PL_F for program and plan definitions, and BEN_ACTY_BASE_RT_F for rate facts. These access patterns reflect the package's role in tying eligibility outcomes to plans, programs, rates, and enrollment choices.

Usage Notes

BEN_COBRA_REQUIREMENTS is typically invoked indirectly rather than through direct user interaction. It is referenced by six other packages including BEN_MANAGE_LIFE_EVENTS, BEN_NEWLY_INELIGIBLE, BEN_CLOSE_ENROLLMENT, BEN_DERIVE_PART_AND_RATE_FACTS, BEN_EVALUATE_RATE_PROFILES, and BEN_ELIG_CVRD_DPNT_API, and calls HR_API for person data. It executes primarily during life event processing, enrollment closure, and eligibility batch routines triggered by concurrent programs, and may be called from custom extensions that extend standard COBRA logic. Overriding this package is not recommended; customizations should instead call the documented procedures.