Search Results delete_offer_a

Overview

IRC_OFFERS_BK3 is an Oracle E-Business Suite PL/SQL package body owned by the APPS schema that participates in the iRecruitment (IRC) offer management infrastructure. It is a generated API hook package, produced by the Oracle HRMS API Hook Pre-processor, as indicated by its header comment referencing iriofapi.pkb and its creation date of 30 March 2009. The package provides the "before" processing layer (denoted by the BK suffix) of a three-tier business logic architecture: the BK (before), BE (business entity), and BV/validation layers. Its principal role is to wrap offer deletion logic so that the HRMS application hooks, validation, and commit-unit controls can be applied consistently whenever an offer record is removed from the iRecruitment schema. The package is classified as OTHER in the ETRM metadata and is referenced by one other package.

Key Procedures and Functions

The package exposes two documented procedures, both dealing with offer deletion:

• DELETE_OFFER_A — The primary active hook procedure for deleting an offer. It accepts an object version number and an offer identifier. It sets the HR utility location markers for entry and exit, captures the current commit-unit number via hr_api.return_commit_unit, and conditionally invokes the business-entity implementation irc_offers_be3.DELETE_OFFER_A when hr_api.call_app_hooks returns true. Following the hook call, it terminates the validation set with hr_multi_message.end_validation_set and validates the commit unit using hr_api.validate_commit_unit, passing the operation name 'DELETE_OFFER' and the application code 'AP'.
• DELETE_OFFER_B — A stub procedure associated with the same deletion operation. Its body contains only entry and exit location markers and performs no functional work. Procedures with the _B suffix in HRMS-generated hook packages conventionally represent an alternate or supplementary hook point (often used to expose the API to different callers or to provide a placeholder for customization), and in this package it is empty.

Tables Accessed

The ETRM metadata for IRC_OFFERS_BK3 documents no tables referenced via APPS synonyms. This is consistent with the package's design as a thin hook wrapper: all direct DML against the underlying iRecruitment offer tables (such as IRC_OFFERS and its associated offer-detail tables) is performed by the business-entity package IRC_OFFERS_BE3, which this package delegates to at line 15. IRC_OFFERS_BK3 therefore owns no INSERT, UPDATE, or DELETE statements of its own.

Usage Notes

This package is not intended to be called directly by end users or custom code. It is invoked as part of the generated API stack when the iRecruitment offer deletion API is exercised — typically from the iRecruitment Professional and Manager responsibility forms, from concurrent programs that process offers, or from higher-level APIs that cascade offer deletions. When the user or a program searches for delete_offer, the relevant entry point is DELETE_OFFER_A, which ensures that HRMS application hooks fire before the business logic executes and that the commit unit remains consistent with the enclosing transaction. Customizations should be applied at the BE layer (IRC_OFFERS_BE3) or via the supported hook extension points rather than by editing this generated BK package, since the pre-processor regenerates it and will overwrite manual changes. Because DELETE_OFFER_B is an empty stub, it has no runtime effect in the shipped 12.1.1 / 12.2.2 codebase.