Search Results irc_default_posting_api




Overview
Explore in AI Chat

Overview

The APPS.IRC_DEFAULT_POSTING_API package is a public PL/SQL API within the Oracle E-Business Suite iRecruitment (IRC) application module. Its purpose is to manage the default posting records that govern how job requisitions and vacancies are published to internal and external recruitment channels. In Oracle iRecruitment, a "default posting" defines the reusable publication parameters applied when a recruitment requisition is made available to candidates, including the channels, durations, and visibility settings associated with a posting. This package provides the programmatic interface for creating, maintaining, and removing those default posting definitions.

The package resides in the APPS schema and is classified as an API in the ETRM metadata. It is documented as VALID in release 12.1.1 and 12.2.2. It depends on APPS.HR_API and the SYS.STANDARD package, consistent with the Oracle HRMS family of APIs, which standardise parameter handling, date validation, and error signalling through HR_API.

Key Procedures and Functions

The documented interface exposes three procedures:

  • CREATE_DEFAULT_POSTING — Inserts a new default posting definition. It accepts the attributes that describe the posting defaults and persists a new record for subsequent reuse when requisitions are published.
  • UPDATE_DEFAULT_POSTING — Modifies the attributes of an existing default posting record, allowing administrators to revise publication defaults without recreating them.
  • DELETE_DEFAULT_POSTING — Removes a default posting definition that is no longer required or has been superseded.

These procedures follow the standard Oracle HRMS API conventions, including p_validate, p_effective_date, and the p_*_id OUT parameters for returning the affected identifiers, along with the p_object_version_number used for optimistic locking. Parameter lists are not reproduced here; implementers should consult the package specification in the target instance for exact signatures.

Tables Accessed

The package operates against the iRecruitment default posting tables (principally IRC_DEFAULT_POSTINGS and its associated translation table), accessed through APPS synonyms. These tables store the publication defaults applied at requisition posting time. The metadata does not enumerate additional tables, but the transactional nature of the CREATE, UPDATE, and DELETE operations implies read/write access to the base default posting entity and any dependent child records, with rows maintained through the standard API rather than direct DML.

Usage Notes

This API is the supported entry point for maintaining default posting data and should be used in preference to direct table manipulation to preserve data integrity and business rules. It is typically invoked from the iRecruitment administrative forms and setup pages, and may be called from concurrent programs or custom PL/SQL that provision recruitment configuration. The package is referenced by the IRC_DEFAULT_POSTING_SWI (Server Web Interface) package, which exposes the API to the iRecruitment web UI, and is listed as referenced by one other APPS package. Because the API depends on HR_API, callers should supply an effective date and honour the standard validation and version-checking return values. Customisations should always invoke the API rather than issuing DML directly.