Results for “irc_idp_shd”

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

Overview

IRC_IDP_SHD is a shared private PL/SQL package owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It belongs to the Oracle iRecruitment (IRC) family of modules and supports the Default Postings business object, whose persistent data resides in the IRC_DEFAULT_POSTINGS table. The "_SHD" suffix follows the Oracle EBS convention for a "shadow" package — a secondary unit that is not the primary public API but rather a helper repository used across a family of sibling packages: IRC_DEFAULT_POSTING_API, IRC_IDP_BUS, IRC_IDP_DEL, IRC_IDP_INS, and IRC_IDP_UPD.

The package encapsulates common row-level logic so that the insert, update, delete, and business-rule packages do not duplicate it. Its API classification is "OTHER", indicating that it is not a formally published interface but an internal implementation detail of the iRecruitment Default Postings subsystem. The status of the object is VALID in both releases, indicating the compiled package and package body are free of standing compilation errors.

Key Procedures and Functions

Five procedures and functions are documented for IRC_IDP_SHD. Precise parameter lists are not published in the ETRM metadata and must not be assumed; the descriptions below reflect function only.

• RETURN_API_DML_STATUS — Returns the current DML status flag maintained by the package, allowing calling APIs to determine whether the most recent operation against the Default Postings object resulted in a pending insert, update, or delete. It supports the standard Oracle EBS API pattern in which a single call reports back whether the caller should commit or roll back.
• CONSTRAINT_ERROR — Centralizes handling of constraint violations raised during Default Postings DML. Rather than allowing a raw Oracle error to propagate, the routine allows sibling packages to translate a constraint failure into a consistent, user-facing business message.
• API_UPDATING — A boolean-style check indicating whether the package is currently executing within an API-driven update context. It guards recursion and prevents conflicting DML paths from being executed concurrently within the same session.
• LCK — Implements the locking primitive used by the Default Postings packages, typically issuing a SELECT FOR UPDATE against the affected row to serialize concurrent modification before the insert, update, or delete proceeds.
• CONVERT_ARGS — Transforms or normalizes incoming arguments before they are applied to the Default Postings record, providing a single point of conversion shared by the insert, update, and delete packages.

Tables Accessed

Two tables are documented as referenced through APPS synonyms:

• IRC_DEFAULT_POSTINGS — The core transactional table of the Default Postings feature, storing the posting defaults applied to requisitions and vacancies created through iRecruitment. IRC_IDP_SHD reads and locks rows here on behalf of IRC_IDP_INS, IRC_IDP_UPD, and IRC_IDP_DEL.
• ALL_CONSTRAINTS — The data dictionary view consulted to resolve constraint metadata, supporting the CONSTRAINT_ERROR routine by identifying which named constraint was violated.

The dependency listing also names PUBLIC (ALL_CONSTRAINTS) and SYS (STANDARD), reflecting ordinary PL/SQL runtime references rather than application tables.

Usage Notes

IRC_IDP_SHD is not invoked directly from Oracle Forms or concurrent programs. It is a support package called by the Default Postings API stack. IRC_DEFAULT_POSTING_API is the public entry point; IRC_IDP_BUS applies business rules; and IRC_IDP_INS, IRC_IDP_UPD, and IRC_IDP_DEL perform the physical DML. Each of those units depends on IRC_IDP_SHD for locking, argument conversion, DML status reporting, and constraint-error handling.

Customizations and extensions that need to manipulate Default Postings data should call IRC_DEFAULT_POSTING_API rather than IRC_IDP_SHD. Because the shadow package is an internal implementation artifact, Oracle may change its signature between releases without notice, and direct calls risk breaking on upgrade. The user search term "irc_idp_del" resolves to the delete package IRC_IDP_DEL, which is one of the five dependent units that reference IRC_IDP_SHD and which relies on its LCK and RETURN_API_DML_STATUS routines during row deletion.