Results for “update_work_choices”
28 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.
- CREATE_SAVED_SEARCH — Stores a saved job search for a candidate so that the same criteria can be reused repeatedly. The person must already exist. On success the saved search is written to the database; on failure no record is created and an error is raised.
- UPDATE_SAVED_SEARCH — Modifies an existing saved search record.
- DELETE_SAVED_SEARCH — Removes a saved search belonging to a candidate.
- CREATE_VACANCY_CRITERIA — Creates vacancy criteria associated with a candidate's search or preference definition.
- UPDATE_VACANCY_CRITERIA — Amends previously stored vacancy criteria.
- DELETE_VACANCY_CRITERIA — Deletes vacancy criteria records.
- CREATE_WORK_CHOICES — Establishes work preference / work choice records for a candidate.
- UPDATE_WORK_CHOICES — Modifies existing work choice records.
- DELETE_WORK_CHOICES — Removes work choice records.
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.