Search Results irc_vce_del




Overview
Explore in AI Chat

Overview

IRC_VCE_DEL is a PL/SQL package body owned by the APPS schema that supports the deletion lifecycle of variable compensation elements within the Oracle iRecruitment module. IRC_VARIABLE_COMP_ELEMENTS stores the compensation element definitions that drive iRecruitment vacancy and offer calculations. The IRC_VCE_DEL package encapsulates the logic required to remove or invalidate those element records safely, preserving referential integrity against related entity tables and dependent business logic. Its classification in the ETRM repository is OTHER, indicating that it is an internal supporting API rather than a public, documented extension point. The package is marked VALID in the documented environment, and it is not referenced by any other database object, confirming its role as a terminal component in the dependency chain.

Key Procedures and Functions

ETRM documents a single procedure for this package:

  • del — The deletion routine for variable compensation element records. It coordinates the physical removal of rows from IRC_VARIABLE_COMP_ELEMENTS with the associated validation, business rule, and referential checks. The documented signature count of one procedure confirms that the package exposes a focused, single-purpose interface rather than a broad set of operations. No additional functions or overloads are registered in the ETRM metadata.

The procedure delegates much of its work to supporting packages listed in the dependency tree, including IRC_VCE_BUS (business rules), IRC_VCE_RKD (row key deletion handling), IRC_VCE_SHD (shadow table maintenance), HR_API, HR_MULTI_MESSAGE, and HR_UTILITY. This delegation pattern is consistent with Oracle HRMS-family APIs, where a thin deletion wrapper invokes shared date-tracking and message-handling utilities.

Tables Accessed

The package operates on one documented table through its APPS synonym:

  • IRC_VARIABLE_COMP_ELEMENTS — The primary target of the delete operation. The del procedure removes or logically terminates records in this table, which holds the definitions that link variable compensation components to recruitment offers and vacancies. Because the package is a deletion routine, the operation is write-intensive rather than read-oriented, with any reads serving to validate existence and referential status before removal.

The dependency on IRC_VCE_RKD and IRC_VCE_SHD indicates that the physical delete interacts with both the primary key deletion triggers and any shadow or history table associated with the same entity. Dependent objects also include STANDARD and HR_UTILITY, confirming that standard Oracle error-handling and date-efficacy routines are used.

Usage Notes

IRC_VCE_DEL is typically invoked indirectly. Standard iRecruitment forms and concurrent processes that manage variable compensation elements call the IRC_VCE_BUS business layer, which in turn routes deletion requests to this package. Because the ETRM metadata states that IRC_VCE_DEL is not referenced by any database object, it is not exposed through public synonyms, views, or scheduled jobs; it is a private implementation detail behind the business API.

Custom code that needs to remove variable compensation element records should call the documented business API rather than IRC_VCE_DEL directly. Direct invocation bypasses the validation and messaging conventions enforced by HR_API and HR_MULTI_MESSAGE, and it may leave shadow or history records inconsistent. The package behaves identically in Oracle EBS 12.1.1 and 12.2.2, as the ETRM metadata for 12.2.2 shows no structural change to the procedure list or table references. Developers should treat IRC_VCE_DEL as an internal, version-stable component and rely on the supported business layer for all maintenance operations.