Search Results comp_selection_rule

Overview

APPS.BEN_MAINTAIN_DESIGNEE_ELIG is a PL/SQL package within the Oracle E-Business Suite Advanced Benefits (Oracle Benefits) module. Its business function is to process and maintain designee eligibility for participants enrolled in benefit programs. In Oracle Benefits, a designee is a person — such as a dependent, beneficiary, or other designated individual — who receives benefits or is associated with a participant's benefit elections. Determining whether a given designee satisfies the eligibility criteria defined for a plan or program is a recurring and compute-intensive activity, particularly during life event processing, open enrollment, and scheduled eligibility runs. BEN_MAINTAIN_DESIGNEE_ELIG encapsulates that logic so it can be executed in batch, restarted on failure, and parallelized across multiple workers.

The package spec header (bendsgel.pkh, version 120.0.12010000.1) defines a substantial set of global cursors, cache structures, and record types. These include a report cache (g_rpt_cache), a log file cache (g_cache_log_file), a person process cache (g_cache_person_process) keyed on person actions, and a rich person record type (g_cache_person_rec) that aggregates attributes such as full name, date of birth, date of death, benefit group, postal code, assignment details, period of service dates, and pay period boundaries. It also references the profile option BEN_DSG_NO_CHG, which governs designee change behavior. This caching architecture indicates that the package is optimized for high-volume, set-based processing rather than single-record interactive calls.

Key Procedures and Functions

• PROCESS — The primary entry point that drives the designee eligibility maintenance run. It orchestrates the overall processing cycle, loading participant and designee data and evaluating eligibility.
• RESTART — Provides recovery capability, allowing an interrupted or failed eligibility run to be resumed without reprocessing completed work.
• DO_MULTITHREAD — Manages parallel execution, distributing the workload across multiple concurrent workers to improve throughput for large populations.
• PROCESS_DESIGNEE_ELIG — Performs the core per-designee eligibility evaluation logic, applying the applicable plan and program rules.
• COMP_SELECTION_RULE — Evaluates and applies selection or computation rules associated with benefit program configuration, determining how eligibility outcomes translate into designee selections.

Tables Accessed

The package reads and writes a broad set of Benefits and HR tables through APPS synonyms. Core Benefits tables include BEN_BENFTS_GRP (benefit group definition), BEN_PERSON_ACTIONS (person action records that anchor the process cache), BEN_PER_IN_LER (person life event records), BEN_BATCH_RANGES (batch partitioning for multithreaded runs), and BEN_BENEFIT_ACTIONS (benefit action definitions).

HR and payroll tables supply the participant and assignment context: PER_PERSON_TYPES and PER_PERSON_TYPE_USAGES_F, PER_ADDRESSES, PER_ASSIGNMENT_STATUS_TYPES, PER_PERIODS_OF_SERVICE, PER_TIME_PERIODS, PER_PAY_BASES, and PAY_ALL_PAYROLLS_F. Organizational data is drawn from HR_ALL_ORGANIZATION_UNITS and HR_ORGANIZATION_INFORMATION. Together these tables provide the demographic, employment, service, and payroll attributes required to evaluate designee eligibility accurately.

Usage Notes

BEN_MAINTAIN_DESIGNEE_ELIG is classified as an OTHER API, meaning it is not a public, supported interface but an internal processing engine. It is typically invoked by concurrent programs and by other Benefits packages rather than directly by end users. The ETRM metadata records that it is referenced by three other packages, consistent with its role as a shared eligibility engine. The presence of DO_MULTITHREAD, BEN_BATCH_RANGES, and RESTART confirms that it is designed to be launched as a multithreaded batch process that can be recovered after failure. Developers extending Benefits functionality should treat this package as internal and avoid direct calls, relying instead on the supported concurrent programs that drive it.