Search Results irc_vce_ins




Overview
Explore in AI Chat

Overview

IRC_VCE_SHD is a shared PL/SQL package in the APPS schema that belongs to the Oracle iRecruitment component-version element framework. The "VCE" prefix designates Variable Compensation Element functionality, and the "_SHD" suffix indicates that the package supplies shared (common) logic consumed by the surrounding set of VCE packages rather than acting as a standalone entry point. The package is classified as OTHER in the ETRM API registry, meaning it is an internal utility package rather than a public, externally callable business API.

In Oracle EBS 12.1.1 and 12.2.2, IRC_VCE_SHD functions as a support layer for the DML handlers that manage rows in IRC_VARIABLE_COMP_ELEMENTS. It centralizes the mechanics that every insert, update, and delete operation requires — locking, constraint validation, API header maintenance, and argument conversion — so that the individual operation packages remain thin wrappers around their specific DML statements. The object is documented as VALID in the APPS schema and carries a dependency on the SYS STANDARD package and PUBLIC.ALL_CONSTRAINTS, confirming that it performs generic constraint interrogation at runtime.

Key Procedures and Functions

The ETRM metadata documents five procedures and functions within the package. Parameter lists are not published, so only their documented roles are described here.

  • RETURN_API_DML_STATUS — Returns the outcome of the most recent API DML operation. It provides callers with a consolidated status value so that the insert, update, and delete packages can report success or failure to their own callers without re-deriving the result.
  • CONSTRAINT_ERROR — Handles constraint violations raised during DML against the component-element table. It interrogates ALL_CONSTRAINTS to identify the offending constraint and translates the raw Oracle error into a meaningful, managed exception.
  • API_UPDATING — Flags or tracks that an API-driven update is in progress. This is used to distinguish API-initiated changes from direct table maintenance and to guard against re-entrant or conflicting modification paths.
  • LCK — Acquires the row-level lock required before a component-element record may be altered or removed. It ensures concurrency safety across the VCE operation packages.
  • CONVERT_ARGS — Normalizes and converts argument values passed in by the operation packages into the datatypes and formats expected by the underlying table columns.

Tables Accessed

The package references two objects through APPS synonyms. IRC_VARIABLE_COMP_ELEMENTS is the principal business table; the shared routines read from it to validate the current state of a row and support the lock-and-modify sequence used by the DML handlers. ALL_CONSTRAINTS is the Oracle data dictionary view consulted by CONSTRAINT_ERROR, which maps an ORA- error back to the specific integrity constraint that was violated so that the failure can be described accurately to the caller.

Usage Notes

IRC_VCE_SHD is not intended to be called directly from forms, concurrent programs, or custom code. It is referenced by four peer packages — IRC_VCE_BUS, IRC_VCE_DEL, IRC_VCE_INS, and IRC_VCE_UPD — with each referencing the shared logic more than once, reflecting repeated use of the locking, status, and constraint routines within a single transaction. Customizations that need to insert, update, or delete iRecruitment variable compensation element records should call IRC_VCE_INS, IRC_VCE_UPD, or IRC_VCE_DEL respectively. Because the insert path is the entry point users reach when searching for "irc_vce_ins", the shared package is effectively invoked on every one of those calls. Any modification to IRC_VCE_SHD therefore has an immediate cross-cutting impact on all four operation packages, and it should be treated as a controlled, high-risk change object during upgrades or patching between 12.1.1 and 12.2.2.