Search Results irc_ino_ins




Overview
Explore in AI Chat

Overview

IRC_INO_SHD is a shared utility package in the APPS schema that supports the iRecruitment "Interview and Offer" (INO) module family. Its name follows the Oracle EBS naming convention for a shadow or shared helper package ("_SHD"), indicating that it is not intended to be called directly by end users or external integrations, but rather acts as a common dependency for the sibling DML packages that manage iRecruitment offer, interview, and note records.

The package encapsulates cross-cutting logic reused by the INSERT, UPDATE, DELETE, and BUSINESS-rule wrappers in the INO package group. Documented metadata classifies it as an "OTHER" API rather than a public or private business API, confirming it is an internal implementation artifact. Its primary consumers are IRC_INO_INS, IRC_INO_UPD, IRC_INO_DEL, IRC_INO_BUS, and itself, all of which reference it for shared validation, locking, and DML-status handling.

Key Procedures and Functions

The ETRM metadata documents five callable units within the package. Parameter lists are not published, so only their purposes are described.

  • RETURN_API_DML_STATUS — Returns the outcome of the most recent DML operation performed through the package group, allowing calling packages or forms to determine whether an insert, update, or delete succeeded, and to surface an appropriate message to the user.
  • CONSTRAINT_ERROR — Centralises handling of Oracle constraint violations (for example unique or foreign key exceptions) raised during iRecruitment note and offer DML, translating them into application-level error conditions.
  • API_UPDATING — Indicates or sets the "API is updating" state, used to guard against re-entrant or recursive DML while a calling API is mid-transaction.
  • LCK — Performs the row-level locking routine required before an update or delete, ensuring concurrency safety when multiple users act on the same iRecruitment record.
  • CONVERT_ARGS — Normalises or converts incoming arguments into the canonical types/formats expected by the underlying DML statements, shielding callers from representation differences.

Tables Accessed

According to the documented dependency list, the package references ALL_CONSTRAINTS, IRC_NOTES, and DBMS_LOB (through APPS synonyms).

  • ALL_CONSTRAINTS — Queried to identify constraint definitions, supporting the CONSTRAINT_ERROR routine in interpreting and reporting violations.
  • IRC_NOTES — The iRecruitment notes table, which stores free-text notes attached to recruitment entities such as offers and interviews; the package participates in its DML.
  • DBMS_LOB — The Oracle-supplied LOB package, used to manipulate large note bodies held in CLOB columns of IRC_NOTES.

Usage Notes

IRC_INO_SHD is an internal helper and should not normally be invoked from custom code. It is called implicitly whenever the public-facing INO APIs (IRC_INO_INS, IRC_INO_UPD, IRC_INO_DEL, IRC_INO_BUS) execute, and therefore runs during standard iRecruitment operations such as creating or amending offer and interview notes from the iRecruitment forms and related concurrent programs.

Developers extending or debugging iRecruitment note handling may inspect the package when diagnosing DML status or constraint errors, but the supported integration surface remains the documented INO APIs. Because it depends on ALL_CONSTRAINTS and DBMS_LOB and is referenced by four sibling packages, changes to it can affect the entire INO package group; it should be treated as read-only reference code unless a patch is explicitly supplied by Oracle. Its status is VALID in the APPS schema for both EBS 12.1.1 and 12.2.2.