Search Results commit_insert

Overview

IRC_VACANCY_COMMIT is an internal PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified as an OTHER-type API rather than a public business API. It is a member of the Oracle iRecruitment (IRC) product family and serves as the persistence layer for recruitment vacancy and posting data. Its primary business function is to commit staged or in-progress recruitment transactions — vacancy headers, posting contents, recruiting team assignments, agency vacancies, recruitment activities, and competence-element mappings — into the underlying iRecruitment base tables. The package also exposes a rejection routine used to discard a pending transaction that should not be persisted. Because it is not a formally published interface, it is best understood as a supporting plumbing package that the iRecruitment business logic calls to finalize multi-table inserts, updates, and deletes in a controlled fashion.

Key Procedures and Functions

The package exposes 46 documented procedures and functions. The most prominent group is the generic transaction-level routines:

• REJECT_TRANSACTION — discards a pending recruitment transaction without persisting it.
• COMMIT_INSERT — persists a newly created vacancy or related transaction.
• COMMIT_UPDATE — persists changes to an existing recruitment record.

The bulk of the package consists of table- and entity-specific commit routines, following a consistent COMMIT_<operation>_<entity> naming convention. Insert, delete, and update variants are provided for competence elements (COMMIT_I/D/U_COMPETENCE_ELEMENT), posting content (COMMIT_I/D/U_POSTING_CONTENT), recruiting activity assignments (COMMIT_I/D/U_REC_ACTIVITY_FOR), recruiting team members (COMMIT_I/D/U_REC_TEAM_MEMBER), agency vacancies (COMMIT_I/D/U_AGENCY_VACANCY), and recruitment activities (COMMIT_I/D/U_RECRUITMENT_ACTIVITY). Each routine isolates the DML for a single child entity, allowing the caller to sequence writes across a vacancy's dependent records. No parameter signatures are exposed in the documented metadata; the procedures should be treated as internal and referenced by name and purpose only.

Tables Accessed

Through APPS synonyms, the package reads and writes the core iRecruitment and related HR tables:

• IRC_AGENCY_VACANCIES, IRC_POSTING_CONTENTS, IRC_REC_TEAM_MEMBERS, IRC_ALL_RECRUITING_SITES, IRC_SEARCH_CRITERIA, IRC_VARIABLE_COMP_ELEMENTS — the primary iRecruitment vacancy, posting, team, site, and competence storage tables that the commit routines populate.
• PER_COMPETENCE_ELEMENTS, PER_RECRUITMENT_ACTIVITIES, PER_RECRUITMENT_ACTIVITY_FOR — Oracle Human Resources tables holding competence definitions and recruitment activity data referenced by the vacancy transaction.
• HR_WIP_TRANSACTIONS — the work-in-progress transaction table used to stage or track pending recruitment changes.
• FND_FORM_FUNCTIONS — Oracle Application Object Library, referenced for form-function metadata.
• XMLDOM, XMLPARSER, XSLPROCESSOR — XML processing objects used to parse or transform recruitment content, such as posting text.
• HR_API, STANDARD — PL/SQL dependencies supporting HR business logic and standard language constructs.

Usage Notes

IRC_VACANCY_COMMIT is invoked indirectly. In Oracle EBS 12.1.1 and 12.2.2 it is called from the iRecruitment forms and underlying business logic when a recruiter saves, submits, or finalizes a vacancy and its dependent records; the COMMIT_* routines are called in sequence to write each entity, with REJECT_TRANSACTION available to abort a pending transaction. The documented metadata records that the package is referenced by no other packages ("Referenced by 0 other packages"), indicating it sits at or near the top of the iRecruitment call chain and is not a shared utility. It should not be treated as a supported public API for custom development: because it is classified as OTHER and its parameters are not published, direct calls from customer extensions are discouraged. Customizations should instead use the supported iRecruitment APIs or concurrent programs, leaving IRC_VACANCY_COMMIT to be driven by the standard application flow.