Search Results ben_cwb_dyn_calc_pkg




Overview
Explore in AI Chat

Overview

APPS.BEN_CWB_DYN_CALC_PKG is a PL/SQL package within the Oracle E-Business Suite Advanced Benefits (OLTP) module that supports the Compensation Workbench (CWB) feature set. Its principal role is to execute dynamic calculations for compensation workbench processing — that is, the runtime evaluation of user-defined calculation definitions, conditions, and equations that determine monetary or rate-based outcomes (such as proposed salary, bonus, or merit allocations) for a group of persons being processed in a CWB plan. The package header (bencwbdc.pkh) carries a version header dated 2008, consistent with the 12.1.1 code baseline; the object remains present and documented in 12.2.2 under owner APPS with an API classification of OTHER, indicating it is an internal supporting package rather than a formal public API.

Key Procedures and Functions

The package documents a single public procedure: RUN_DYNAMIC_CALCULATIONS. Its purpose is to drive the dynamic calculation cycle for a defined population within a compensation workbench group and plan context. The procedure accepts parameters identifying the group/person-in-life-event and group plan identifiers, an effective or event-occurred date, and a boolean flag controlling whether errors are raised to the caller. Broadly, the procedure evaluates the active calculation definitions and their associated conditions and equations against the persons and rates held in the CWB person information and person rates structures, producing calculated results used downstream by CWB allocation and review screens. No additional public procedures or functions are documented.

Tables Accessed

The package reads and/or writes the following tables via APPS synonyms:

  • BEN_CALC_DEFINITIONS — the master definition records that describe which dynamic calculations apply.
  • BEN_CALC_CONDITIONS — eligibility and filter conditions that gate whether a calculation is executed for a given person or context.
  • BEN_CALC_EQUATIONS — the equation components evaluated to derive calculated amounts.
  • BEN_CWB_PERSON_INFO — person-level CWB data supplying the inputs and receiving calculated outcomes.
  • BEN_CWB_PERSON_RATES — rates (for example salary or target rates) used as equation inputs.
  • BEN_CWB_PL_DSGN — plan design configuration that governs CWB plan behavior.
  • BEN_TRANSACTION — records benefit/compensation transactions resulting from processing.
  • PLITBLM — the generic PL/SQL index-by table (nested table) used for in-memory collection handling during processing.

Usage Notes

RUN_DYNAMIC_CALCULATIONS is typically invoked as an internal engine call, not directly by end users. It is referenced by three other packages in the ETRM dependency set, which act as the orchestrating layers for CWB plan processing, batch recalculation, or person-level recalculation triggered from the Compensation Workbench forms. In practice, invocation occurs when a compensation administrator recalculates dynamic amounts for a group/plan, when plan design changes require recomputation, or when batch concurrent processing refreshes CWB calculated values. Because the package is classified as OTHER rather than a supported public API, custom extensions should avoid calling it directly and instead operate through the supported CWB entry points. Direct dependencies on the package signature or on its underlying tables risk breakage across patches and upgrades, particularly between the 12.1.1 and 12.2.2 code lines.