Search Results update_vrbl_rt_elig_prfl

Overview

The APPS.BEN_VRBL_RT_ELIG_PRFL_API package body is a member of the Oracle EBS Advanced Benefits (BEN) public API family. It manages the intersection entity that links a Variable Rate Profile (BEN_VRBL_RT_PRFL) to an Eligibility Profile (BEN_ELIGY_PRFL), stored in the BEN_VRBL_RT_ELIG_PRFL_F table. In benefit plan design, a variable rate profile defines the rate structure and calculation basis for a plan or option, while an eligibility profile determines which persons qualify. The BEN_VRBL_RT_ELIG_PRFL record binds these two definitions together and additionally carries a mandatory flag that controls whether the eligibility restriction attached to the variable rate must be satisfied. This package is the supported programmatic interface for creating, maintaining, and removing those associations in a datetracked (date-effective) environment, allowing customers and integrators to build rate and eligibility linkages without writing directly to the underlying tables.

Key Procedures and Functions

The package exposes four documented program units:

• CREATE_VRBL_RT_ELIG_PRFL — Inserts a new association between a variable rate profile and an eligibility profile. It accepts the business group, the variable rate profile identifier, the eligibility profile identifier, the mandatory flag, and the descriptive VEP_ATTRIBUTE flexfield columns (category plus attributes 1 through 30). It returns the generated primary key (p_vrbl_rt_elig_prfl_id) together with the effective start and end dates assigned to the new row. A p_validate switch permits the caller to exercise all validation logic and roll back, without committing data.
• UPDATE_VRBL_RT_ELIG_PRFL — Modifies an existing variable-rate/eligibility association. It uses the datetracked update pattern, changing the mandatory flag, flexfield attributes, or related references while preserving the effective-dating history required by Advanced Benefits.
• DELETE_VRBL_RT_ELIG_PRFL — Removes an association, applying the package's deletion semantics against the date-effective row in BEN_VRBL_RT_ELIG_PRFL_F.
• LCK — A locking helper that acquires a row-level lock on the target record before a modification, protecting against concurrent updates within the same session or transaction.

Tables Accessed

The package's documented DML surface is BEN_VRBL_RT_ELIG_PRFL_F, accessed through the APPS synonym. This is the datetracked base table holding the variable-rate-profile to eligibility-profile mapping. CREATE_VRBL_RT_ELIG_PRFL inserts into it, UPDATE_VRBL_RT_ELIG_PRFL updates the effective-dated rows, and DELETE_VRBL_RT_ELIG_PRFL removes or end-dates rows depending on datetrack mode. The LCK routine issues the select-for-update needed to serialize access to the same row. Validation performed by the API references the parent BEN_VRBL_RT_PRFL and BEN_ELIGY_PRFL definitions and the standard BEN validation mechanisms, but the package's own write target is BEN_VRBL_RT_ELIG_PRFL_F.

Usage Notes

This API is invoked through the standard three-tier Oracle EBS pattern: the BEN_VRBL_RT_ELIG_PRFL_API wrapper is called from higher-level business APIs, benefit forms, or batch processes, while the underlying work is delegated to a private _BK (business knowledge) layer. The three documented referencing packages indicate that other BEN APIs depend on it for maintaining rate-to-eligibility links. Typical invocation contexts include the Variable Rate Profile and Eligibility Profile setup forms in the Benefits responsibility, and custom PL/SQL or concurrent programs performing bulk benefit configuration migration. Callers should run under a valid APPS session, pass a business group identifier, and honor the p_validate convention to test data before committing. Because the table is date-effective, updates and deletes should be performed with awareness of datetrack mode; the LCK procedure should precede any read-modify-write sequence. The VEP_ATTRIBUTE columns are descriptive flexfield segments available for customer-specific extensions.