Search Results irc_default_postings_s

Overview

IRC_IDP_INS is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite, classified under the Oracle iRecruitment (IRC) module. Its name follows the iRecruitment IDP naming convention, where "IDP" denotes the Internal Default Postings component and "INS" denotes an insert-oriented package. The package serves as a low-level insertion handler for default job postings data, providing the programmatic logic required to create new rows in the iRecruitment default postings tables while preserving the integrity of the surrounding recruitment configuration model.

The package is registered as VALID in both Oracle EBS 12.1.1 and 12.2.2 and is documented in the E-Business Suite Technical Reference Manual (ETRM). It is not referenced by any other database object, which indicates that it functions as a private implementation utility consumed through the iRecruitment business layer rather than as a broadly published public API. It depends on components such as IRC_IDP_BUS, IRC_IDP_RKI, IRC_IDP_SHD, HR_API, HR_UTILITY, and FND_MESSAGE, confirming its role as a tightly coupled member of the IRC_IDP package family.

Key Procedures and Functions

The package exposes three documented routines whose purpose is described below. Parameter lists are intentionally omitted.

• INS — The primary insertion routine. It performs the actual creation of a new default postings record, applying the standard iRecruitment insert semantics, including validation of required attributes and population of WHO columns and other system-managed fields.
• SET_BASE_KEY_VALUE — A supporting routine that establishes or derives the base key value for the record being processed. This ensures that the primary or surrogate key used by the insert operation is correctly determined before INS executes.
• The package also contains one additional documented routine that completes the internal processing sequence, consistent with the three-routine count reported in the ETRM metadata.

The presence of IRC_IDP_RKI (row key information) and IRC_IDP_SHD (shadow/audit) dependencies confirms that INS interacts with the standard iRecruitment row-handling framework rather than performing raw DML in isolation.

Tables Accessed

The package reads and writes the following tables through their APPS synonyms:

• IRC_DEFAULT_POSTINGS — The primary entity table for default job postings. INS writes new records here, forming the core of the package's insert behavior.
• IRC_DEFAULT_POSTINGS_S — The supplementary or shadow table associated with IRC_DEFAULT_POSTINGS. This table stores key-related or localized attribute data and is populated in conjunction with the base insert.

Access to DUAL and the STANDARD package reflects routine PL/SQL and SQL statement dependencies rather than business data access. The HR_API and HR_UTILITY dependencies indicate that person or assignment context may be validated during insertion.

Usage Notes

IRC_IDP_INS is an internal package rather than a user-facing API. It is not referenced by any database object, meaning it is not invoked directly by forms, concurrent programs, or external integrations through standard database dependency chains. Instead, it is called by the other packages in the IRC_IDP family — specifically IRC_IDP_BUS, which acts as the business-layer orchestrator for default postings operations. Two other packages reference IRC_IDP_INS, consistent with this internal role.

Customizations should not invoke IRC_IDP_INS directly. Oracle's supported integration path for creating default postings is through the iRecruitment business APIs and the associated forms. Direct calls bypass validation and audit handling that IRC_IDP_BUS and IRC_IDP_SHD provide. When troubleshooting default postings insert failures in 12.1.1 or 12.2.2, inspect error messages emitted via FND_MESSAGE from this package and review the IRC_DEFAULT_POSTINGS_S key values produced by SET_BASE_KEY_VALUE.