Search Results process_offers_api

Overview

IRC_VARIABLE_COMP_ELEMENT_SWI is an Oracle EBS package body owned by APPS that functions as a Server-side Wrapper Interface (SWI) for the variable compensation element functionality within Oracle iRecruitment. It resides in the IRC product schema and provides the outer PL/SQL entry points that Application Programming Interface (API) users invoke to create, modify, and delete variable compensation records associated with recruitment vacancies. In an ETRM (E-Business Suite Technical Reference Manual) context the SWI layer sits on top of the transactional API — here IRC_VARIABLE_COMP_ELEMENT_API — and handles concerns that the core API does not: savepoint management, business-event handling, multiple-message detection, surrogate and user-key registration, and the translation of API warning booleans into user-visible messages.

The business function it supports is the capture of variable compensation data (for example, commission or bonus entitlement terms) against a vacancy so that recruiting administrators, hiring managers, or external channels can record the compensation structure tied to a requisition.

Key Procedures and Functions

• CREATE_VARIABLE_COMPENSATION — Creates a new variable compensation element record. The procedure validates input, converts the standard API boolean parameters from their constant equivalents, issues a savepoint (CREATE_VARIABLE_COMP_SWI), initializes multiple-message detection through HR_MULTI_MESSAGE, and then delegates to IRC_VARIABLE_COMP_ELEMENT_API.CREATE_VARIABLE_COMPENSATION. It returns the object version number and return status to the caller.
• DELETE_VARIABLE_COMPENSATION — Removes an existing variable compensation element record. It follows the same wrapper pattern: savepoint, message-list initialization, delegation to the underlying API's delete routine, and warning-to-message conversion.
• PROCESS_API — A generic dispatcher routine that routes a caller's operation to the appropriate create or delete path, providing a single entry point for consumers who supply an action indicator. This is a common SWI convention that lets forms and concurrent processes call one procedure regardless of the intended operation.

Each procedure follows a consistent structure: location tracking via HR_UTILITY.SET_LOCATION, savepoint issuance for rollback safety, constant-to-boolean conversion via HR_API.CONSTANT_TO_BOOLEAN, and multiple-message enabling so that several warnings can be collected and surfaced in one pass.

Tables Accessed

The package operates predominantly through the API layer rather than issuing direct DML, but the documented dependencies are:

• IRC_VARIABLE_COMP_ELEMENTS — The base table holding variable compensation element records. It is read and written through IRC_VARIABLE_COMP_ELEMENT_API, which the SWI delegates to.
• XMLDOM — Part of the Oracle XML Developer's Kit PL/SQL DOM package, used in the message-handling machinery to build the message list structure.
• XMLPARSER — Supplies the XML parsing calls required by HR_MULTI_MESSAGE when assembling warning and error messages.

Usage Notes

The package is invoked from Oracle iRecruitment forms and business flows when vacancy variable compensation data is entered or removed, and it may be called directly by custom code or concurrent programs that need to manipulate the same records in a validated, message-aware manner. Because it is an SWI wrapper, callers should pass the p_validate flag in the standard HR_API convention and inspect p_return_status rather than relying on exceptions. The associated tables carry WHO columns and an object_version_number, so concurrent updates must honor optimistic locking. Developers extending this area should call the API or SWI rather than updating IRC_VARIABLE_COMP_ELEMENTS directly.