Search Results irc_ino_del




Overview
Explore in AI Chat

Overview

IRC_INO_DEL is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite releases 12.1.1 and 12.2.2. It belongs to the Oracle iRecruitment application family; the "IRC" prefix denotes iRecruitment objects, while the "INO" and "DEL" segments identify the package as a notes-oriented deletion utility. Its documented API classification is OTHER, indicating that it is not a public, supported API but rather a specialized internal utility invoked by other iRecruitment code.

The package exists to support removal of note records maintained by the iRecruitment notes infrastructure. iRecruitment stores applicant, vacancy, and recruitment-activity notes in a central notes table, and deletion of those notes must be performed consistently with the surrounding business logic rather than through direct SQL. IRC_INO_DEL provides that controlled deletion path. The ETRM metadata lists a body status of VALID in the APPS schema, and the dependency listing shows that the package references the shared package IRC_INO_SHD, which is the iRecruitment notes shared-code package containing the common routines for note handling.

Key Procedures and Functions

The documented metadata identifies a single entry point:

  • DEL — The deletion routine. It removes a notes record from the iRecruitment notes table, applying whatever validation, referential checks, or cleanup logic iRecruitment requires before and after the row is removed. Because the ETRM record documents no parameter list, parameter details are not reproduced here; callers should inspect the package specification in the target environment before invoking it programmatically.

The package is documented with two procedures or functions in total, one of which is the public DEL routine. The remaining member is not individually enumerated in the metadata shown, and no parameter signatures are documented; these should be confirmed against the package specification in the specific EBS instance.

Tables Accessed

The ETRM documentation records one table referenced through APPS synonyms:

  • IRC_NOTES — The iRecruitment notes table. IRC_INO_DEL reads and deletes rows from this table as part of its DEL routine, removing the note identified by the caller. Depending on the internal implementation, the package may also consult related notes metadata, but IRC_NOTES is the only table explicitly documented.

The dependency listing additionally shows references to APPS.IRC_INO_SHD and to the SYS STANDARD package. IRC_INO_SHD supplies the shared notes routines and constants used by the deletion logic, and STANDARD is the standard PL/SQL package implicitly available to all PL/SQL units.

Usage Notes

IRC_INO_DEL is referenced by at least one other package, IRC_NOTES_API, which is the primary iRecruitment notes API. This relationship indicates that IRC_INO_DEL is normally invoked indirectly: application code or forms call IRC_NOTES_API, which in turn delegates deletion work to IRC_INO_DEL. Direct invocation from custom code is therefore discouraged, since the supported entry point for notes operations is IRC_NOTES_API.

Typical invocation scenarios include deletion of a note from the iRecruitment user interface, where a form or OA Framework page submits a deletion request that is routed through the notes API chain, and any concurrent or batch process that purges recruitment notes. Because the package is classified as OTHER rather than a public API, customizations should avoid binding directly to it; instead, use IRC_NOTES_API or, where a business requirement cannot be met through the API, perform deletions through carefully reviewed custom code. As with all direct data manipulation in EBS, note deletions should respect the surrounding transaction and audit requirements, and any customization should be validated against both 12.1.1 and 12.2.2 since the package is present and VALID in both releases.