Search Results irc_variable_comp_element_api




Overview
Explore in AI Chat

Overview

The APPS.IRC_VARIABLE_COMP_ELEMENT_API package body is a public PL/SQL API within the Oracle E-Business Suite iRecruitment (IRC) module. It provides the programmatic interface for managing variable compensation elements, which are the configurable components that make up an offer's variable compensation structure during the recruitment and offer-management lifecycle. In Oracle EBS 12.1.1 and 12.2.2, recruiters and offer administrators define variable compensation components—such as bonuses, incentives, or commissions—that apply to a candidate's offer. This API encapsulates the business logic and validation rules that govern the creation and removal of these elements, ensuring that the underlying iRecruitment tables remain consistent regardless of whether the operation originates from a form, a concurrent process, or custom code. The package body is marked VALID in the ETRM repository, confirming that it compiles cleanly against its dependencies in the supported releases.

Key Procedures and Functions

The package exposes two documented public procedures:

  • CREATE_VARIABLE_COMPENSATION — Creates a variable compensation element record. This procedure validates the incoming element attributes, applies iRecruitment business rules for variable compensation, and performs the insert into the underlying element table.
  • DELETE_VARIABLE_COMPENSATION — Removes an existing variable compensation element. It verifies that the element is eligible for deletion and processes the removal consistently with the referential expectations of the recruitment data model.

Both procedures rely on shared infrastructure delivered by HR_API and HR_UTILITY, which supply standard Oracle HRMS API error handling, message retrieval, and utility routines. The package body also delegates its physical DML work to the private helper programs IRC_VCE_INS and IRC_VCE_DEL, and uses the table handlers IRC_VARIABLE_COMP_ELEMENT_BK1 and IRC_VARIABLE_COMP_ELEMENT_BK2 for row-level operations. This layered design keeps the public API thin while centralizing insert/delete logic in reusable handlers.

Tables Accessed

Working through the documented dependencies, the package reads and writes the iRecruitment variable compensation element base table through the APPS synonym layer; the private units IRC_VCE_INS and IRC_VCE_DEL are the components that carry out the actual INSERT and DELETE statements. The IRC_VARIABLE_COMP_ELEMENT_BK1 and IRC_VARIABLE_COMP_ELEMENT_BK2 handlers provide the surrounding row-level logic and validation queries. Because the API is the supported entry point, direct DML against the base table should be avoided; all attribute changes and validations are funnelled through this package so that standard HRMS who-columns, error stacks, and messaging remain intact.

Usage Notes

IRC_VARIABLE_COMP_ELEMENT_API is typically invoked from iRecruitment offer and variable compensation forms, from concurrent programs that seed or maintain compensation element setups, and from custom PL/SQL extensions that need to create or delete variable compensation elements as part of a broader recruitment integration. The ETRM documentation notes that the package is referenced by one other database object, indicating that at least one internal or dependent component calls into it rather than writing to the base table directly. When calling the API, developers should follow the standard Oracle HRMS API pattern: initialize the business group and environment (for example via HR_API / FND_GLOBAL), supply all mandatory attributes, call the procedure, and then inspect the returned error table for validation messages. Because the package is not documented as referenced by external interfaces beyond its single dependent object, custom code should treat it as the authoritative, supported mechanism for variable compensation element maintenance rather than issuing ad hoc SQL.