Search Results check_period_of_enrollment

Overview

APPS.BEN_EVALUATE_RATE_PROFILES is a PL/SQL package in the Oracle E-Business Suite 12.1.1 and 12.2.2 Benefits (BEN) module. It serves as the eligibility and rate-profile evaluation engine that determines whether a participant qualifies for a given benefit offering and, once qualified, which rate structure should apply. The package bridges the gap between the raw eligibility criteria stored against a program, plan, or option and the actual rate calculation performed during enrollment or premium processing.

The package is classified under the ETRM as API classification OTHER, indicating it functions primarily as an internal engine invoked by other Benefits processes rather than as a published, callable integration API. Its status is VALID in both releases, and it is documented with 56 procedures and functions, reflecting the breadth of eligibility attributes the engine must interrogate.

Key Procedures and Functions

The documented procedures reveal a design centered on discrete eligibility checks, each responsible for validating one participant or assignment attribute against configured criteria:

• MAIN — Orchestrates the overall evaluation flow, sequencing the individual checks.
• INIT_GLOBALS — Initializes package-level global variables and context before evaluation begins.
• CHECK_PERIOD_OF_ENROLLMENT — Validates whether the participant falls within the permitted enrollment window.
• Attribute checks including CHECK_BRGNG_UNIT, CHECK_BENEFITS_GRP, CHECK_ORG_UNIT, CHECK_WK_LOCATION, CHECK_LGL_ENTY, CHECK_GRADE, CHECK_LBR_UNION, CHECK_PYRL, CHECK_SCHED_HRS, CHECK_HRS_WKD, CHECK_PCT_FLTM, CHECK_FL_TM_PT, CHECK_PER_TYP, and CHECK_EE_STAT — each evaluates a specific eligibility criterion such as bargaining unit, benefits group, grade, payroll, scheduled hours, or employment status.
• Additional checks such as CHECK_LOA_RSN, CHECK_ZIP_CODE_RNG, and CHECK_PY_BSS extend coverage to leave-of-absence reasons, geographic ranges, and payroll basis.

Together these procedures determine qualification outcomes and drive the selection of the applicable rate profile. No parameter lists are documented in the metadata; only purposes are inferred from the procedure names.

Tables Accessed

The package reads participant and eligibility data through APPS synonyms. Core person and assignment data come from PER_ALL_PEOPLE_F, PER_ALL_ASSIGNMENTS_F, PER_ADDRESSES, and PER_ASSIGNMENT_STATUS_TYPES, providing the attributes evaluated by the CHECK routines. Benefits configuration and eligibility tables include BEN_LER_F, BEN_PER_IN_LER, BEN_CBR_PER_IN_LER, BEN_CBR_QUALD_BNF, BEN_ELIG_PER_F, BEN_ELIG_PER_OPT_F, BEN_ELIG_PER_ELCTBL_CHC, BEN_ELIG_DPNT, BEN_ELIG_CVRD_DPNT_F, BEN_OIPL_F, and BEN_PGM_F. These supply the eligibility criteria, qualified beneficiary records, dependent eligibility, and plan/program definitions against which the checks are compared.

Usage Notes

BEN_EVALUATE_RATE_PROFILES is referenced by four other packages — BEN_DETERMINE_VARIABLE_RATES, BEN_EFC_ADJUSTMENTS, BEN_PREM_PL_OIPL_MONTHLY, and BEN_USE_CVG_RT_DATE — and depends on BEN_DETERMINE_RATES. It is therefore invoked internally during rate determination, premium processing, and flexible-credit adjustment flows rather than through direct form invocation. Developers extending Benefits logic should treat it as an internal engine callable from dependent packages, not as a public integration API.