Search Results create_offer_status_history




Overview
Explore in AI Chat

Overview

The APPS.IRC_OFFER_STATUS_HISTORY_API package body provides the programmatic interface for maintaining the status history of offers managed within Oracle EBS iRecruitment. Every time an offer transitions between states — for example from pending to accepted, declined, or placed on hold — a corresponding history row must be recorded so that recruiters, hiring managers, and administrators retain a complete audit trail of the offer lifecycle. The package encapsulates the insert, update, and delete operations against the offer status history table, together with the associated note records, sheltering callers from the underlying table structure and enforcing the business rules that govern status transitions.

As a member of the iRecruitment public API family, the package is classified as an API in the ETRM inventory for 12.1.1 and 12.2.2. The header identifies the file as iriosapi.pkb, version 120.3.12000000.2, a NOSHIP-tier script, confirming that this is shipped, supported application code rather than a customer-specific extension.

Key Procedures and Functions

  • CREATE_OFFER_STATUS_HISTORY — Inserts a new history record documenting a change in offer status. It accepts the target offer identifier, the new offer status, an effective date, a status change date, and optional change reason, decline reason, and note text. The procedure returns the generated status history identifier and the object version number for the new row. The documented body shows explicit handling of the HOLD status, where the status change date is adjusted so that the prior status remains chronologically one second earlier, enabling time-based retrieval of the record preceding the hold.
  • UPDATE_OFFER_STATUS_HISTORY — Modifies an existing status history record, supporting correction of dates, reasons, notes, or status values, and maintaining the object version number for optimistic locking.
  • DELETE_OFFER_STATUS_HISTORY — Removes a status history record, typically used when an offer or its history is purged during data cleanup or rollback of an erroneous transition.

Tables Accessed

  • IRC_OFFER_STATUS_HISTORY — The primary table maintained by this package. All three procedures write to it: CREATE_OFFER_STATUS_HISTORY inserts new transition rows, UPDATE_OFFER_STATUS_HISTORY amends them, and DELETE_OFFER_STATUS_HISTORY removes them.
  • IRC_NOTES — Referenced to persist the optional note text attached to a status change. The documented body declares local variables for a note identifier and note object version number, indicating that the API creates or updates an IRC_NOTES row and associates it with the status history record.

Usage Notes

The package is typically invoked from the iRecruitment Offer/Applicant forms whenever a recruiter changes an offer status, and from any concurrent program or workflow activity that automates offer progression. Because the procedures carry validation and note-handling logic internally — including savepoint issuance, date truncation, and HOLD-status sequencing — custom code should call these APIs rather than performing direct inserts or updates against IRC_OFFER_STATUS_HISTORY. The package is referenced by two other packages in the ETRM repository, confirming its role as a reusable dependency for higher-level offer processing modules. Direct DML bypasses the object version number management and note linkage, risking inconsistencies in the audit trail.