Results for “irc_search_criteria_api”

44 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IRC_SEARCH_CRITERIA_API is a public PL/SQL API belonging to the iRecruitment (IRC) product family within Oracle E-Business Suite. It is owned by the APPS schema and declared with AUTHID CURRENT_USER, meaning that execution privileges and unqualified name resolution are evaluated against the calling schema rather than the defining schema. The package provides the programmatic foundation for the search and preference capabilities used by candidates throughout the iRecruitment self-service experience. Its documented scope covers three distinct but related business constructs: saved job searches, vacancy criteria, and work preferences (work choices). Together these allow a candidate to define, persist, modify, and remove the parameters that describe what kind of work they are seeking and under what conditions they are willing to accept it. The API header identifies the package as licensed for use with iRecruitment and classifies it as a public API, indicating that it is a supported integration point rather than an internal implementation detail.

Key Procedures and Functions

The package exposes nine documented procedures, organized as three logical groups of create, update, and delete operations.

The documented parameters on the create operations follow a consistent pattern: a validation-only flag, an effective date used to validate lookup values against their active date ranges, the person identifier, and free-text or coded attributes describing the search. These include a search name, a free-text location of interest, a travel distance in miles, and geocode location data. Business validation is performed by the API before any write occurs.

Tables Accessed

The package operates against a single documented base table, IRC_SEARCH_CRITERIA, accessed through an APPS synonym. This table persists the saved searches, vacancy criteria, and work choices that the API manages. All nine procedures ultimately read from or write to this table, which acts as the unified store for candidate search and preference data. Because the API is a public, supported interface, direct DML against the underlying table is discouraged; applications should route changes through these procedures so that validation logic, effective dating, and error handling remain intact.

Usage Notes

IRC_SEARCH_CRITERIA_API is referenced by four other packages in the EBS data model, indicating that it sits beneath higher-level iRecruitment functionality. In practice it is invoked from the iRecruitment candidate self-service pages, where a candidate saves a job search, refines vacancy criteria, or updates work preferences. It may also be called from concurrent programs that process or migrate candidate preference data, and from custom extensions or integrations that need to create or maintain search criteria on behalf of candidates. When invoking the create procedures, callers should use the validate flag first to confirm that all validation checks pass before committing changes, and should supply an effective date appropriate to the lookup values being used.