Results for “ben_cwb_webadi_utils”

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

Overview

The APPS.BEN_CWB_WEBADI_UTILS package body is a utility layer within the Oracle E-Business Suite Advanced Benefits (BEN) module, specifically supporting Compensation Workbench (CWB) functionality. It serves as the backend engine that processes WebADI (Web Applications Desktop Integrator) transactions against Compensation Workbench worksheets. In Oracle EBS 12.1.1 and 12.2.2, Compensation Workbench enables managers to allocate compensation such as salaries, bonuses, and grades to their direct reports through spreadsheet-driven interfaces.

This package encapsulates the logic required to create, update, lock, and delete CWB layouts, and to manipulate the data that flows between the WebADI spreadsheet and the underlying CWB database structures. It also provides cryptographic helpers (via DBMS_OBFUSCATION_TOOLKIT) and binary conversion routines used for secure tokenization or session handling. The package is classified as an "OTHER" API type, indicating it is not a formally published public interface but a supporting utility layer invoked internally by WebADI and CWB processes.

Key Procedures and Functions

The package exposes 25 documented procedures and functions. The layout lifecycle procedures include CREATE_CWB_LAYOUT, UPDATE_CWB_LAYOUT, UPDATE_CWB_CUSTOM_LAYOUT, LOCK_CWB_LAYOUT, UNLOCK_CWB_LAYOUT, and DELETE_CUSTOM_DATA, which together manage worksheet layout definitions and their state. MANIPULATE_SELECTED_DATA, CHK_ENTRY_IN_CUSTOM_TABLE, CHECK_HIDDEN_WORKSHEET_COLUMNS, and UPSERT_WEBADI_DOWNLOAD_RECORDS govern how WebADI-generated rows are validated, hidden or surfaced as columns, and merged into CWB tables.

Compensation calculation routines include VALIDATE_GRADE_RANGE, GET_NEW_SALARY, GET_PROPOSED_GRADE_RANGE, GET_PROPOSED_GRADE_MID, GET_PROPOSED_GRADE_COMPARATIO, and GET_GROUP_PER_IN_LER_ID, which derive grade/range and comparatio values for proposed allocations. The cryptographic and binary helpers ENCRYPT, DECRYPT, BIN2INT, and INT2BIN provide obfuscation and type conversion utilities used in WebADI parameter passing.

Tables Accessed

The package reads and writes CWB and Benefits tables through APPS synonyms. BEN_CUSTOM_REGION_ITEMS and BEN_CWB_PL_DSGN store customized plan design and region metadata, while BEN_CWB_PERSON_INFO and BEN_CWB_PERSON_RATES hold participant data and rate values used during compensation calculations. BEN_TRANSACTION and BEN_TRANSACTION_S record benefit transactions generated through the WebADI flow.

Layout management relies on BNE_INTERFACES_B, BNE_INTERFACE_COLS_B, BNE_INTERFACE_COLS_TL, BNE_LAYOUTS_B, BNE_LAYOUT_BLOCKS_B, and BNE_LAYOUT_COLS from the BNE (WebADI) schema. Grade-based salary logic draws on PAY_GRADE_RULES_F.

Usage Notes

This package is invoked indirectly through Compensation Workbench WebADI worksheet uploads and downloads, not through direct user calls. It is referenced by two other packages within APPS, confirming its role as a shared utility layer. Developers extending CWB WebADI behavior should treat it as a support dependency rather than a public API, since parameter contracts are undocumented and the package is marked OTHER.