Search Results irc_notification_prefs_s

Overview

APPS.IRC_CREATE_NOTIFICATION_PKG is a PL/SQL package body in the Oracle E-Business Suite Applications (APPS) schema, associated with the iRecruitment (IRC) product family. Its documented API classification is "OTHER," indicating it is not part of a formally published public API set but instead serves as an internal utility supporting iRecruitment notification behavior. The package is reported as VALID in ETRM 12.2.2 and performs the notification-generation logic that determines whether and how recruitment-related notifications are created for individuals based on their stored notification preferences.

In functional terms, the package exists to bridge recruitment business events with the notification preferences maintained by users. It evaluates preference records, resolves the recipient population through Oracle HRMS person and assignment data, and creates the corresponding notification entries. Because it depends on AD_PARALLEL_UPDATES_PKG, the package can also participate in parallel processing, suggesting that notification creation may be executed against large recipient sets, such as broad applicant or candidate audiences.

Key Procedures and Functions

The ETRM metadata documents a single procedure or function: CREATE_NOTIFICATION.

• CREATE_NOTIFICATION — The sole documented entry point. Its purpose is to generate notification records for the applicable recipients, using the notification preferences resolved for those parties. The procedure encapsulates the logic of matching a notification event to the preferences stored for each person and then producing the notification output. The metadata does not publish a parameter list, and no parameter details should be assumed beyond the procedure's evident role in driving notification creation.

Tables Accessed

The package body references the following tables (accessed through APPS synonyms), with the documented dependency set indicating the following roles:

• IRC_NOTIFICATION_PREFERENCES — The primary preference store. The procedure queries this table to determine which users have elected to receive a given class of recruitment notification.
• IRC_NOTIFICATION_PREFS_S — The sequence object associated with the notification preferences entity, used to generate primary keys for new preference or notification-related rows.
• PER_ALL_PEOPLE_F — The Oracle HRMS person datelined table, used to resolve the identity and current effective record of each recipient.
• PER_ALL_ASSIGNMENTS_F — The HRMS assignment datelined table, used to resolve the recipient's assignment context, which is typically required to determine business group, organization, or employment status relevant to notification eligibility.
• PLITBLM — The PL/SQL table (index-by-table) package used for in-memory collection handling within PL/SQL, supporting the assembly of recipient or preference data sets during processing.

Collectively these tables allow the package to move from a stored preference to an identified, valid recipient and to emit the resulting notification.

Usage Notes

APPS.IRC_CREATE_NOTIFICATION_PKG is an internal iRecruitment component rather than a public integration API. It is not referenced by any other database object per the documented metadata, which indicates it is invoked directly by application code, most likely from the iRecruitment notification framework, concurrent processing, or event-driven logic internal to the product.

Because the package is not referenced by other packages, customizations should treat it as unsupported for direct invocation. Where notification behavior must be extended, the supported approach is to configure notification preferences through the standard iRecruitment setup and self-service pages, which populate IRC_NOTIFICATION_PREFERENCES, rather than to call CREATE_NOTIFICATION directly. Its dependency on AD_PARALLEL_UPDATES_PKG further suggests that any execution is orchestrated by the application's notification or parallel-processing infrastructure, and timing, commit control, and error handling are managed by that calling framework.