Search Results l_update

Overview

BEN_PDW_MASS_UPD_RATES is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It belongs to the Oracle Advanced Benefits (BEN) product family and supports the mass update of benefit rates applied across a population of participants, plans, or program configurations. The package name incorporates the "PDW" prefix associated with the Public Data Warehouse style of set-based processing used in benefits administration, where changes are applied to large groups of records in a single operation rather than through individual form-based transactions.

The package operates within the DateTrack framework maintained by HR_API and HR_UTILITY. Its internal logic resolves the caller-supplied effective dates and DataTrack mode into a canonical mode such as correction, update, update override, or update change insert, then determines whether the row should be physically updated. The private get_dt_modes procedure, visible in the package source, exposes the variable l_update, which is a local boolean flag initialized to TRUE and toggled based on the incoming effective date, effective start date, effective end date, and DML operation. This flag governs whether the mass update proceeds against the underlying rate rows or is suppressed in favor of an insert or no-op, ensuring DateTrack integrity is preserved for benefit rate records.

Key Procedures and Functions

• UPLOAD_RATE — The single documented procedure within the package. It drives the mass upload of rate information into the benefits rate tables. It is the public entry point through which callers submit rate change data for processing, and it coordinates the DateTrack mode resolution and the resulting insert, update, or correction against the target rate entities.

The undocumented private routine get_dt_modes is referenced inside the source as the mechanism that maps an incoming DataTrack mode string and effective dates onto the appropriate HR_API constant. The l_update local variable it defines is the decisive switch that tells the mass update logic whether a physical update is warranted.

Tables Accessed

• BEN_ACTY_BASE_RT_F — The activity base rate table, holding the primary rate values that the mass update writes or corrects.
• BEN_VRBL_RT_PRFL_F — The variable rate profile table, used to associate rate definitions with the profiles affected by the mass update.
• PAY_INPUT_VALUES_F and PAY_INPUT_VALUES_F_TL — Payroll input value definitions and their translated names, used to resolve the input values to which benefit rates are attached.
• PQH_COPY_ENTITY_TXNS — The copy entity transaction table used by the Public Sector / HR copy framework to track transactional propagation of entity changes, supporting the set-based nature of the mass update.

Usage Notes

This package is an internal benefits utility rather than a general-purpose API. It is typically invoked from benefits concurrent programs or from higher-level benefits business flows that perform mass rate maintenance, and it may be called from custom code where bulk rate adjustments are required. Because it relies on HR_API DateTrack constants and on HR_UTILITY logging, callers must supply valid effective dates and a recognized DataTrack mode. The ETRM metadata records that no other documented packages reference BEN_PDW_MASS_UPD_RATES, indicating it sits at the outer edge of the benefits dependency graph. When the l_update flag resolves to FALSE, the operation is treated as effectively non-updating, which prevents unintended date-tracked corrections from overwriting historical rate records.