Search Results irc_offer_status_history_api




Overview
Explore in AI Chat

Overview

The APPS.IRC_OFFER_STATUS_HISTORY_API package is a public application programming interface within the Oracle E-Business Suite iRecruitment module. Its business function is to maintain the audit trail of status transitions applied to candidate offers. When a recruiter or hiring manager moves an offer through its lifecycle — for example from a draft state to an extended or accepted state — the system must preserve an immutable record of when the change occurred, who performed it, and what remarks accompanied it. This package encapsulates the insert, update, and delete logic required to manipulate those history rows, isolating callers from the underlying table structures and enforcing the module's validation and who-column conventions.

The package belongs to the APPS schema and is classified as an API in the ETRM repository for both 12.1.1 and 12.2.2. Its object status is VALID, and it is exposed to the iRecruitment application stack through APPS synonyms, allowing other PL/SQL units to invoke it without schema qualification.

Key Procedures and Functions

The documented interface consists of three procedures:

  • CREATE_OFFER_STATUS_HISTORY — Inserts a new status history record for an offer. This is the primary entry point used whenever an offer transitions to a new status and a corresponding historical entry must be persisted.
  • UPDATE_OFFER_STATUS_HISTORY — Modifies an existing status history record. It is used to correct or amend history data that has already been written, such as adjusting descriptive text or associated notes.
  • DELETE_OFFER_STATUS_HISTORY — Removes a status history record. This is typically reserved for cleanup or rollback scenarios rather than normal transactional flow.

Parameter signatures are not enumerated in the ETRM metadata; callers should inspect the package specification in the target environment before invoking these routines directly. The repository does not document any additional functions beyond these three.

Tables Accessed

The package operates against two base tables through APPS synonyms:

  • IRC_OFFER_STATUS_HISTORY — The principal table holding the offer status change records. All three procedures read from or write to this table.
  • IRC_NOTES — The notes table used to store free-text commentary attached to history entries, enabling recruiters to record rationale alongside a status change.

Writes to these tables are subject to the standard iRecruitment who-column and audit conventions managed at the API layer rather than by the caller.

Usage Notes

IRC_OFFER_STATUS_HISTORY_API is not intended for direct end-user invocation. It is called programmatically from the iRecruitment offer maintenance flows, most notably by IRC_OFFERS_API, which references it when persisting offer lifecycle changes. The IRC_OFFER_STATUS_HISTORY_SWI package also references it, indicating that the history API participates in the module's server-side web interface logic used by the Oracle Applications Framework (OAF) pages that render the offer status history region.

Custom extensions and integrations that need to post offer status history records should call this package's procedures rather than performing direct DML against IRC_OFFER_STATUS_HISTORY, thereby preserving the validation and auditing behaviour enforced by the API. Because the package is a dependency of IRC_OFFERS_API, any change to its signature can cascade into the offer API; modifications should be regression tested against the standard iRecruitment offer pages and any concurrent programs that consume the offer history data.