Results for “get_new_salary”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.BEN_CWB_WEBADI_UTILS is a PL/SQL utility package within the Oracle E-Business Suite Advanced Benefits (BEN) module, specifically serving the Compensation Workbench (CWB) and its WebADI integration layer. The package provides the server-side plumbing that allows WebADI (Web Applications Desktop Integrator) worksheets to be generated, customized, and downloaded against CWB layouts. Its header revision (bencwbadiutl.pkh 120.0, dated 2005) indicates it is a long-standing component carried forward across 12.1.1 and 12.2.2. The business purpose is to bridge WebADI's generic interface/layout metadata (the BNE tables) with CWB-specific compensation data, enabling administrators to define and tailor worksheet layouts, lock them during active use, and securely pass parameters between the workbook and the database. The package also encapsulates salary and grade-range lookups used to populate proposed compensation values on CWB worksheets.

Key Procedures and Functions

The package exposes 25 documented procedures and functions. Layout lifecycle management is handled by CREATE_CWB_LAYOUT, which builds a CWB layout from a base layout code, and UPDATE_CWB_LAYOUT, which refreshes a layout and returns a download switch indicating whether the workbook should be re-downloaded. UPDATE_CWB_CUSTOM_LAYOUT performs the equivalent operation for customized layouts, accepting plan and life-event context. Concurrency safeguards are provided by LOCK_CWB_LAYOUT and UNLOCK_CWB_LAYOUT, preventing conflicting edits to the same layout. Custom-data maintenance is handled by DELETE_CUSTOM_DATA, MANIPULATE_SELECTED_DATA (which adjusts display sequencing of selected interface columns), and CHK_ENTRY_IN_CUSTOM_TABLE, a validation function. Security-related functions include ENCRYPT and DECRYPT, used to protect parameter strings, supported by the low-level BIN2INT and INT2BIN conversion utilities.

Compensation calculation helpers include VALIDATE_GRADE_RANGE, GET_NEW_SALARY, GET_PROPOSED_GRADE_RANGE, GET_PROPOSED_GRADE_MID, and GET_PROPOSED_GRADE_COMPARATIO (comparatio). Worksheet presentation logic is supported by CHECK_HIDDEN_WORKSHEET_COLUMNS and GET_GROUP_PER_IN_LER_ID, which resolves the group assignment for a life-event record. The procedure UPSERT_WEBADI_DOWNLOAD_RECORDS inserts or updates the download staging records that WebADI consumes. Two composite types, column_rec/column_list and show_hide_data_tab, carry column and display-visibility metadata through these APIs.

Tables Accessed

The package reads and writes CWB-specific tables such as BEN_CWB_PERSON_INFO, BEN_CWB_PERSON_RATES, BEN_CWB_PL_DSGN, and BEN_CUSTOM_REGION_ITEMS, which hold participant details, rates, plan design, and custom region configuration respectively. It references BEN_TRANSACTION and BEN_TRANSACTION_S for transactional benefit data. WebADI metadata is sourced from BNE_INTERFACES_B, BNE_INTERFACE_COLS_B/TL, BNE_LAYOUTS_B, BNE_LAYOUT_BLOCKS_B, and BNE_LAYOUT_COLS, which define the available interfaces, columns, layouts, and layout columns. PAY_GRADE_RULES_F supplies grade and salary range rules used by the calculation functions. DBMS_OBFUSCATION_TOOLKIT and PLITBLM are used for encryption and PL/SQL table manipulation utilities.

Usage Notes

This package is primarily invoked indirectly through the CWB and WebADI flows rather than being called from end-user forms directly. Typical triggers include WebADI worksheet generation and download, where layout creation, locking, and upsert of download records occur; layout administration screens that customize CWB worksheets; and concurrent or background processes that refresh layout metadata. It is referenced by two other packages, indicating it acts as a shared utility layer. Custom code extending CWB should treat the encrypt/decrypt and lock/unlock routines as the sanctioned entry points for parameter security and concurrency control. Because the header revision is unchanged since 2005, the API surface is stable across 12.1.1 and 12.2.2.