Search Results irc_offer_notifications_pkg




Overview
Explore in AI Chat

Overview

IRC_OFFER_NOTIFICATIONS_PKG is an Oracle EBS Applications (APPS) schema PL/SQL package belonging to the iRecruitment module. Its documented purpose is to manage the generation and delivery of notifications tied to the offer lifecycle within iRecruitment. When a recruiting administrator or manager extends an offer to an applicant, the system must communicate that event, track the applicant's response, and handle downstream circumstances such as an offer expiring, being placed on hold, being withdrawn, or being accepted or declined. This package centralizes that notification logic, insulating calling forms and workflows from the mechanics of building notification content and dispatching Workflow (WF) events.

The package is classified as an OTHER API within the ETRM metadata, meaning it is not a formal public interface but an internal implementation package invoked by iRecruitment's own forms, workflow processes, and concurrent logic. It is ETRM-validated and depends only on SYS.STANDARD and the SYS schema at the declared dependency level, with all business object access occurring through APPS synonyms.

Key Procedures and Functions

The package exposes ten documented procedures and functions, organized around URL generation and notification dispatch:

Tables Accessed

The package reads and writes the core iRecruitment and Oracle Human Resources entities needed to resolve recipients and render offer content:

Usage Notes

IRC_OFFER_NOTIFICATIONS_PKG is not intended for direct customer invocation; no other package references it, and it is not documented as a supported public API. It is invoked internally by iRecruitment offer management forms and by Workflow processes that fire at offer lifecycle milestones—extension, response, expiry, hold, withdrawal, and acceptance or decline. The URL-generating functions are typically called when constructing notification bodies so recipients can navigate directly to the relevant offer page. Customizations should avoid calling these procedures directly; instead, customers should subscribe to the underlying Workflow events or extend behavior through supported iRecruitment configuration. Because the package depends on FND profile options and responsibility data, output can vary with the runtime environment and the profile settings of the recipient's context.