Search Results ben_evaluate_elig_criteria




Overview
Explore in AI Chat

Overview

PQH_POPL_CRITERIA_OVRRD is an Oracle EBS PL/SQL package owned by the APPS schema that supports the population criteria override mechanism used across Oracle Advanced Benefits and Oracle Payroll configuration. In the EBS 12.1.1 and 12.2.2 data models, eligibility and rate determination logic is frequently driven by configurable population criteria — the rules that decide whether a person, assignment, or benefit group qualifies for a plan, option, or rate. PQH_POPL_CRITERIA_OVRRD provides the programmatic layer that stores, retrieves, and initializes overrides applied to those criteria, allowing an administrator or a calling process to substitute or amend the criteria evaluated at runtime without altering the underlying population definition itself.

The package status is VALID in the documented environment, and ETRM classifies it as an OTHER API type, meaning it is an internal supporting package rather than a formally published public API. Its principal significance is architectural: it sits beneath BEN_EVALUATE_ELIG_CRITERIA and BEN_EVALUATE_ELIG_PROFILES, both of which are central to benefits eligibility evaluation, and beneath PQH_RBC_RATE_RETRIEVAL, which governs rate retrieval in the Payroll/HR rate-by-criteria framework.

Key Procedures and Functions

ETRM documents three callable units within the package.

  • INIT_CRITERIA_OVERRIDE_TBL — Initializes the in-memory or session-level structure that holds criteria override definitions. Calling code invokes this before subsequent override operations to ensure a clean, consistent state for the override collection used during a single evaluation cycle.
  • INSERT_CRITERIA_OVERRIDE — Registers a new criteria override, adding an override entry to the override table so that subsequent evaluations honor the substituted or amended criterion value. This is the write path for the override mechanism.
  • GET_CRITERIA_OVERRIDE — Retrieves the applicable override for a given criteria context, returning the override value to the caller so that eligibility or rate logic can apply it in place of the standard criterion. This is the read path consumed by the benefits and rate retrieval packages.

No parameter lists are asserted here; the documented metadata names the units and their roles only.

Tables Accessed

The documented table reference for this package, resolved through APPS synonyms, is PLITBLM. PLITBLM is a standard Oracle HRMS PL/SQL index-by or PL/SQL table work structure used to pass collections of identifiers and values between HRMS packages; in this context it carries the criteria override records manipulated by the three procedures above. The package does not appear to own or persist business data in its own table but instead operates on the shared in-memory table construct used by the surrounding eligibility and rate engine.

Usage Notes

PQH_POPL_CRITERIA_OVRRD is not normally invoked directly from a form or concurrent program by end users. ETRM lists it as referenced by three other packages: BEN_EVALUATE_ELIG_CRITERIA, BEN_EVALUATE_ELIG_PROFILES, and PQH_RBC_RATE_RETRIEVAL. The presence of BEN_EVALUATE_ELIG_CRITERIA in the dependency list is directly relevant to the user search term "ben_evaluate_elig_criteria" — that user-facing eligibility evaluation API depends on this package to obtain any criteria overrides that must be applied before standard eligibility rules execute.

Typical invocation therefore follows a predictable sequence: a calling package invokes INIT_CRITERIA_OVERRIDE_TBL to reset the override collection, optionally calls INSERT_CRITERIA_OVERRIDE to seed overrides, and then relies on GET_CRITERIA_OVERRIDE during evaluation. Custom code extending benefits eligibility or rate retrieval should treat this package as an internal dependency and, where possible, use the documented higher-level APIs instead of calling these procedures directly, since behavior is bound to the internal PLITBLM structure and the surrounding evaluation context.