Search Results default_posting




Overview
Explore in AI Chat

Overview

The APPS.IRC_DEFAULT_POSTING_BE3 package body is an Oracle E-Business Suite Workflow Business Event (BE) subscription handler associated with the iRecruitment (IRC) module. The package was generated by the Oracle Workflow Business Event System code generation utility, as indicated by the header comment referencing hrapiwfe.pkb and the generation timestamp of 2008. Its business function is to raise business events on the Oracle Workflow event queue whenever a "Default Posting" record in iRecruitment is deleted, thereby allowing other subscribing components and applications to react to the deletion through the event-driven architecture.

The package conforms to the standard Oracle "BE3" naming convention, where a generated Business Event wrapper packages the logic needed to check event status, construct an XML payload, and invoke WF_EVENT.RAISE for a specific business event. This makes it part of the iRecruitment integration surface that supports workflow-driven notification and propagation of recruitment posting changes.

Key Procedures and Functions

The ETRM metadata documents one procedure for this package:

  • DELETE_DEFAULT_POSTING_A — The primary handler invoked when a Default Posting record is deleted. The procedure first determines the status of the workplace business event by calling WF_EVENT.TEST against the event name oracle.apps.per.irc.api.default_posting.delete_default_posting, and then responds based on the returned message.

Inside DELETE_DEFAULT_POSTING_A, the logic branches on the result of the event test:

  • If the status is 'MESSAGE', the procedure obtains a sequence key from PER_WF_EVENTS_S, constructs a temporary CLOB containing an XML payload with the default_posting_id value, and raises the business event via WF_EVENT.RAISE, passing the event name, key, and XML event data.
  • If the status is 'KEY', the procedure follows the alternate path used to obtain and return an event key without raising a full event message.

The procedure relies on HR_UTILITY.SET_LOCATION for instrumentation and FND_NUMBER.NUMBER_TO_CANONICAL to format the numeric default posting identifier for inclusion in the XML payload.

Tables Accessed

The documented database objects referenced by this package are:

  • PER_WF_EVENTS_S — A sequence accessed through an APPS synonym. The procedure selects PER_WF_EVENTS_S.NEXTVAL to generate a unique event key for each raised business event.
  • DBMS_LOB — Used to create and populate a temporary CLOB (DBMS_LOB.CREATETEMPORARY and DBMS_LOB.WRITEAPPEND) that carries the XML event data.
  • DUAL — Serves as the source for the sequence fetch used to allocate the event key.

No base application tables are directly read or written; persistence of the actual Default Posting deletion is handled by the calling form or API, while this package is responsible solely for event propagation.

Usage Notes

This package is not intended to be called directly by end users. It is invoked automatically by the Oracle Workflow Business Event System as the subscription handler for the iRecruitment Default Posting deletion business event. The event is raised during the standard deletion flow in the iRecruitment forms when a Default Posting record is removed, and the handler executes in that transactional context to publish the deletion to any downstream subscribers.

Typical triggers include the iRecruitment posting management screens and any custom or seeded code that deletes Default Posting records through the supported iRecruitment APIs. Because the package is generated code, it should not be manually modified; customizations should be implemented as separate business event subscriptions that consume the oracle.apps.per.irc.api.default_posting.delete_default_posting event. The ETRM metadata further notes that this package is referenced by one other package, indicating it participates in a broader event-handling dependency chain within the iRecruitment workflow integration layer.