Search Results irc_notes_swi




Overview
Explore in AI Chat

Overview

The APPS.IRC_NOTES_SWI package is a server-side PL/SQL component within the Oracle E-Business Suite iRecruitment application module. The "IRC" prefix identifies objects belonging to the iRecruitment product family, while the "SWI" suffix conventionally denotes a "Server Web Interface" wrapper package. Packages bearing this naming convention serve as thin programmatic shells that expose underlying business logic to Oracle Application Framework (OAF) pages, JSP-based self-service screens, and other web-tier components. In the context of iRecruitment, IRC_NOTES_SWI provides the persistence interface for managing notes attached to recruitment entities such as candidates, applications, requisitions, and vacancies.

The package is owned by the APPS schema and is documented with a status of VALID in both EBS 12.1.1 and 12.2.2 environments. Its API classification is recorded as OTHER, distinguishing it from seed data, concurrent program, or form-based objects. All procedures execute under the standard APPS schema privileges and rely on APPS synonyms to reach the underlying iRecruitment data model.

Key Procedures and Functions

Three documented procedures constitute the public interface of IRC_NOTES_SWI:

  • CREATE_NOTE — Inserts a new note record into the iRecruitment notes store. It is invoked when a recruiter or candidate submits a fresh note through the self-service interface, capturing the note text and associating it with the parent recruitment entity.
  • UPDATE_NOTE — Modifies the content or attributes of an existing note. This supports edit operations performed from the notes region of iRecruitment OAF pages, including revisions to note text made after initial capture.
  • DELETE_NOTE — Removes a previously created note. This supports the retraction or cleanup of notes that are no longer relevant to the recruitment record.

Each procedure abstracts the row-level Data Manipulation Language operations required to maintain note integrity, ensuring that web-tier callers do not issue direct DML against the underlying tables. The documentation does not expose parameter signatures; callers should consult the package specification in the EBS instance for exact argument lists.

Tables Accessed

The ETRM excerpt for IRC_NOTES_SWI does not enumerate specific base tables, and no APPS synonyms are catalogued in the documented metadata. In practice, a notes Server Web Interface package of this nature operates against the iRecruitment notes entity and its associated parent tables, which are typically prefixed with IRC_. The package's dependency list confirms a dependency on APPS.HR_API, the Oracle HRMS public API layer, along with the standard SYS.STANDARD package. The HR_API dependency indicates that note operations may invoke HRMS business logic — for example, to resolve person or assignment context — rather than acting purely on standalone iRecruitment tables.

Usage Notes

IRC_NOTES_SWI is typically invoked from the middle tier rather than from concurrent programs or batch jobs. The primary callers are OAF-based iRecruitment pages and the associated entity object or view object layer, which delegate note create, update, and delete actions to this package. The ETRM metadata records that the package is referenced by zero other packages, confirming it functions as a leaf-level service component rather than a shared library. Under Oracle EBS 12.2.2, the package executes within the same APPS schema context as in 12.1.1, with no documented structural differences. Customizations that extend note handling should call these procedures rather than performing direct DML, in order to preserve validation, audit, and HR_API integration behavior. Because the package is documented as VALID, it is safe to reference from custom code, though standard Oracle support guidelines apply.