Results for “irc_vce_rkd”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IRC_VCE_RKD is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM API classification of OTHER. It forms part of the Oracle iRecruitment vacancy management infrastructure, specifically handling the row-level processing associated with vacancy records. The "_RKD" suffix follows the Oracle EBS table-handler naming convention, where the "D" designates delete-related processing. This package is the deletion handler counterpart to the row-level insert and update handlers that accompany a transactional base table. The source header, identified as irvcerhi.pkh and dated 2005, indicates the package was originally generated from Oracle's table-handler generation templates during the iRecruitment development cycle and has been preserved unchanged through the 12.1.1 and 12.2.2 releases. Its declared purpose is to execute the post-delete logic required when a vacancy-level variable compensation row is removed, ensuring that any dependent bookkeeping, such as auditing, denormalized column maintenance, or derived data cleanup, is performed consistently.

Key Procedures and Functions

The package exposes a single documented procedure, positioned within the "after delete" region of the specification:

• AFTER_DELETE — The designated post-delete processing routine for the vacancy variable compensation entity. It is invoked after a row has been physically removed from the base table, allowing the handler to carry out follow-on actions that must occur only once the delete has succeeded. The procedure receives identification and versioning context for the affected vacancy record, including the vacancy identifier and the object version number, which supports optimistic locking and audit trail integrity. The presence of AUTHID CURRENT_USER means the package executes with the privileges of the invoking schema rather than the definer, so callers must themselves hold the necessary DML privileges on the underlying objects.

No other procedures or functions are documented in the specification; the package is intentionally narrow in scope and mirrors the standard generated table-handler pattern.

Tables Accessed

The ETRM metadata for this package does not list any tables referenced through APPS synonyms. This is consistent with the typical behavior of an "after delete" handler stub in a generated table-handler package: the specification declares the interface, while any actual DML against the underlying iRecruitment vacancy variable compensation table resides in an accompanying body, which the metadata excerpt does not enumerate. In practice, the handler operates in the context of the vacancy variable compensation base table and may touch audit or history tables maintained by the iRecruitment vacancy model, but no table-level dependencies are documented at this classification level.

Usage Notes

IRC_VCE_RKD is not intended for direct invocation by end users or concurrent programs. It is called programmatically by the higher-level iRecruitment vacancy APIs and business logic whenever a variable compensation row associated with a vacancy is deleted. The metadata confirms that the package is referenced by one other package, which is the expected pattern: the orchestrating vacancy API delegates delete processing to this handler rather than embedding the logic inline. Because the "after" handler fires only after the base row is gone, customizations should not assume the deleted row remains queryable. Customers extending iRecruitment should invoke the parent vacancy API rather than calling AFTER_DELETE directly, both to preserve object version checking and to ensure that any subscription or audit logic registered against the vacancy entity executes in the correct order. As with all APPS-owned seeded packages in 12.1.1 and 12.2.2, modifications are unsupported and should be replaced by wrapping custom logic around the public vacancy APIs.