Results for “delete_transaction”

50+ results




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

Overview

APPS.BEN_CWB_ASG_UPDATE is the Compensation Workbench Transaction Update package within Oracle E-Business Suite Advanced Benefits (Oracle iRecruitment/Compensation Workbench). Its documented purpose is to insert records into the BEN_TRANSACTION table whenever performance rating or promotion details are updated on the Compensation Workbench worksheet. The package forms part of the Compensation Workbench (CWB) transaction pipeline, which captures worksheet-level changes and routes them for downstream processing by the benefits and compensation engines.

The package header carries the identifier bencwbau.pkh and was created in February 2003 by maagrawa, with subsequent revisions introducing global budgeting support, deletion capability, person name parameters, and performance-override handling. The most recent documented change (version 115.7, September 2006) addressed a fix (reference 5531065) enabling the use of Performance Overrides, but only when the worksheet is accessed through Self-Service. The package uses AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking user rather than the definer, which is significant for any custom code that calls it.

Two private package constants are declared in the specification: g_ws_asg_rec_type (value 'CWBASG') and g_ws_perf_rec_type (value 'CWBPERF'), used to tag assignment-level and performance-level worksheet record types respectively. A private cursor g_txn retrieves the 27 descriptive flexfield attribute columns (attribute1 through attribute27) from BEN_TRANSACTION for a given transaction ID and transaction type.

Key Procedures and Functions

  • PROCESS_RATING — Processes performance rating changes captured on the Compensation Workbench worksheet. It creates or updates the corresponding transaction record in BEN_TRANSACTION. The version history indicates that from version 115.6 the group plan ID (group_pl_id) is passed as a plan reference to this routine, and that performance overrides are honoured only when the worksheet is used through Self-Service (version 115.7).
  • PROCESS_PROMOTIONS — Processes promotion detail changes made on the worksheet, again persisting them to BEN_TRANSACTION. Like PROCESS_RATING, it receives the group plan ID as a plan reference following the version 115.6 change.
  • DELETE_TRANSACTION — Added to the specification in version 115.2 (March 2004) to allow a transaction previously written by this package to be removed. This supports reversal of worksheet changes and cleanup of stale staging records.

The ETRM classification lists five documented procedures or functions in total, of which PROCESS_RATING, PROCESS_PROMOTIONS and DELETE_TRANSACTION are the named public ones shown in the specification. No parameter lists are documented in the available metadata, and none should be assumed beyond the plan-reference and person-name parameters noted in the version history.

Tables Accessed

The package reads and writes several core Advanced Benefits, HR and Payroll tables through APPS synonyms:

Usage Notes

BEN_CWB_ASG_UPDATE is not a user-facing API; it is invoked internally when a worksheet user saves a performance rating or promotion change in the Compensation Workbench. The version history specifically ties the performance-override behaviour to Self-Service worksheet usage, so callers from other entry points (for example, the Professional/PP flow referenced in version 115.4) may follow a different code path. The package is referenced by four other packages in the ETRM repository, which is consistent with its role as a shared persistence helper rather than an entry point.

Because the package is declared AUTHID CURRENT_USER, any custom code invoking it directly must run under a user with the necessary privileges on the underlying tables. Customisations should treat the package as version-sensitive: Oracle patched the behaviour of performance overrides in 2006, and earlier or later patch levels may alter which parameters are accepted by PROCESS_RATING and PROCESS_PROMOTIONS. Direct DML against BEN_TRANSACTION in place of calling this package is not advisable, since the package also updates BEN_CWB_PERSON_INFO and audit records as part of the same logical transaction. Test any integration against the target patch level (12.1.1 or 12.2.2) before production deployment.