Search Results delete_variable_compensation_b




Overview
Explore in AI Chat

Overview

IRC_VARIABLE_COMP_ELEMENT_BK2 is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite. It belongs to the Oracle iRecruitment (IRC) product family and forms part of the HRMS API Hook framework that governs the manipulation of variable compensation data associated with recruitment vacancies. The package is classified under the "OTHER" API category in the ETRM repository, indicating that it is an internally generated component rather than a public, user-facing business API.

The body carries the standard header identifier irvceapi.pkb 120.0, dated 26 July 2005, and its code was auto-generated by the Oracle HRMS API Hook Pre-processor on 6 November 2008. This generation pattern is characteristic of the Business Key (BK) layer that Oracle HRMS inserts between the public API layer and the private entity layer, commonly labelled BK2 or BK3 depending on the hook sequence. Its principal business purpose is to provide a pre-processing hook point where customer-specific or vertical-specific logic can intercept the deletion of variable compensation elements attached to a vacancy before the core delete operation is executed.

Key Procedures and Functions

The package exposes two documented procedures, both named with the DELETE_VARIABLE_COMPENSATION prefix. No public functions are declared.

  • DELETE_VARIABLE_COMPENSATION_A — The active hook procedure for the delete operation. It establishes an HR utility location trace at entry, captures the current commit unit through hr_api.return_commit_unit, and conditionally invokes the corresponding procedure in irc_variable_comp_element_be2 when hr_api.call_app_hooks evaluates to true. On completion it closes the validation set with hr_multi_message.end_validation_set, validates the commit unit for the 'DELETE_VARIABLE_COMPENSATION' action under the 'AP' context, and records an exit trace location. This procedure wraps the hook invocation so that downstream extension logic is executed inside the correct transaction and validation scope.
  • DELETE_VARIABLE_COMPENSATION_B — The companion procedure in the hook pair. In the documented source it contains only entry and exit trace calls via hr_utility.set_location and no additional logic. It serves as a placeholder or secondary hook point that Oracle's generator emits consistently for every BK2 element, allowing customers to extend behaviour at a second stage without modifying the primary hook.

Tables Accessed

The ETRM documentation records no direct table references through APPS synonyms for this package body. This is consistent with its role as a hook dispatcher: the actual DML against the underlying iRecruitment variable compensation tables is performed by the downstream entity object (irc_variable_comp_element_be2) and its business object layer, not by the hook itself. Any SQL issued from within this package would be indirect, mediated through the called procedures rather than expressed as direct cursor or DML statements in the hook body.

Usage Notes

This package is not intended for direct invocation from forms, concurrent programs, or custom code. It is invoked automatically by the HRMS API framework whenever the delete operation for a variable compensation element is processed on a vacancy record. The framework calls the hook between the pre-processing and validation stages of the delete transaction, gated by the hr_api.call_app_hooks flag.

The package is referenced by one other package in the ETRM repository, confirming its position inside a layered call chain. Customisations should be applied through the supported hook mechanism rather than by editing this generated body, since the header comment explicitly states it was produced by the Oracle HRMS API Hook Pre-processor and any manual changes would be overwritten on regeneration. Commit unit validation and multi-message handling are already managed internally, so extension code placed in the hook should not issue its own commits.