Search Results irc_pending_data_api




Overview
Explore in AI Chat

Overview

IRC_PENDING_DATA_API is a PL/SQL package in the APPS schema that belongs to the Oracle iRecruitment module of Oracle E-Business Suite. Its central role is to manage pending data records used during the recruiting workflow — the transient or staged information generated as candidates, recruiters, and hiring managers interact with job applications, offers, and notifications. The package provides a controlled programmatic interface for creating, modifying, and removing rows in the IRC_PENDING_DATA table, and for orchestrating the downstream processing that converts pending activity into actionable recruiting events such as status changes, document generation, and notifications. Because it is classified as an API in the ETRM metadata, it is intended to be called by Oracle's own iRecruitment forms, concurrent programs, and companion packages rather than by ad hoc SQL. Its status is VALID, and it depends on the HR_API and FND_NODES objects, placing it at the intersection of human-resources and application-foundation infrastructure.

Key Procedures and Functions

The documented interface exposes five procedures and functions, each aligned to a stage of the pending-data lifecycle:

  • CREATE_PENDING_DATA — Inserts a new pending-data row, capturing the recruiting entity, context, and attributes required before further processing.
  • UPDATE_PENDING_DATA — Modifies an existing pending-data record, allowing attributes to be revised as recruitment activity evolves.
  • DELETE_PENDING_DATA — Removes a pending-data record once it has been consumed, superseded, or is no longer required.
  • PROCESS_APPLICATIONS — Drives the application-processing logic that evaluates pending application data and applies the resulting changes to recruiting and HR entities.
  • SEND_NOTIFICATIONS — Generates and dispatches notifications tied to pending activity, ensuring candidates and recruiters receive the expected workflow communications.

No parameter signatures are documented; callers should follow Oracle's published API conventions and validate input through the supporting validation logic.

Tables Accessed

The package operates against a broad set of APPS synonyms. The primary table is IRC_PENDING_DATA, the target of the create, update, and delete operations. Recruiting context is provided by IRC_ALL_RECRUITING_SITES, IRC_ASSIGNMENT_STATUSES, IRC_DOCUMENTS, PER_RECRUITMENT_ACTIVITIES, and PER_RECRUITMENT_ACTIVITY_FOR, while vacancy and assignment data come from PER_ALL_VACANCIES, PER_ALL_ASSIGNMENTS_F, PER_ASSIGNMENTS_S, PER_ALL_PEOPLE_F, and PER_PEOPLE_S. Security and access lookups draw on FND_USER, FND_RESPONSIBILITY, FND_SECURITY_GROUPS, and FND_NODES. These tables supply the identity, organizational, and eligibility information required for correct processing and notification delivery.

Usage Notes

IRC_PENDING_DATA_API is referenced by IRC_PENDING_DATA_SWI, the service-web-interface wrapper that exposes these operations to external or web-based callers, and by one other package. Typical invocation therefore occurs indirectly through iRecruitment forms and concurrent programs rather than through direct custom calls. Developers extending iRecruitment should prefer the SWI layer where possible; when calling the API directly, they must respect the documented sequence of create, process, and delete, and ensure FND security context is initialized so that responsibility and security-group lookups resolve correctly. Because processing may trigger notifications and HR API activity, calls should be committed with care.