Search Results notification_handler

Overview

APPS.AP_WFAPPROVAL_PKG is the Oracle Payables package that integrates the Oracle Workflow engine with the invoice approval lifecycle in Oracle E-Business Suite. Its principal responsibility is to evaluate approval routing rules, identify eligible approvers, record approval history, and drive workflow notifications for invoices submitted through the Payables Invoice Approval workflow. The package bridges Payables transaction data with the Workflow Notification system, ensuring that invoices requiring approval are properly routed, escalated, and audited.

The package originated in the AP module (source header references apiawges.pls) and remains a core component in both EBS 12.1.1 and 12.2.2. All procedures conform to the standard Workflow PL/SQL API signature: itemtype, itemkey, actid, funcmode, and an OUT resultout parameter. This signature allows each procedure to be invoked directly from a Workflow function activity defined in the Invoice Approval process.

Key Procedures and Functions

• AP_ACCOUNTING_FLEX — Function returning the concatenated accounting flexfield string for a given code combination identifier, using a segment name and set of books.
• AP_DIST_ACCOUNTING_FLEX — Function returning the accounting flexfield string for a specific invoice distribution.
• IAW_PO_CHECK — Workflow-callable procedure that evaluates purchase order-related conditions during approval routing.
• GET_APPROVER — Determines and returns the approver for a given workflow item, central to the approval routing logic.
• UPDATE_HISTORY — Workflow-callable procedure that updates the approval history record for an item as its state changes.
• INSERT_HISTORY — Overloaded procedure that inserts approval history rows, available both as a Workflow activity and as a direct call accepting invoice, iteration, org, and status parameters.
• ESCALATE_REQUEST — Handles escalation of an approval request when a notification times out or requires reassignment.
• SET_ATTRIBUTE_VALUES — Populates workflow item attributes for the invoice being processed.
• NOTIFICATION_HANDLER — The notification-response handler invoked by the Workflow Notification System once an approver acts on an approval notification. It processes the response and returns the outcome through resultout.
• IAW_RAISE_EVENT — Raises a business event for invoice approval, accepting an event name, item key, and org identifier.
• GET_ATTRIBUTE_VALUE — Function that retrieves a named attribute value for an invoice or distribution.
• UPDATE_INVOICE_STATUS — Added under Bug 5968183 to synchronize invoice approval status when the associated workflow is cancelled.

Tables Accessed

The package reads and writes Payables approval and transaction tables, including AP_INVOICES_ALL and AP_INVOICES for invoice headers, and AP_INVOICE_DISTRIBUTIONS / AP_INVOICE_DISTRIBUTIONS_ALL for distribution-level detail. Approval history is persisted in AP_INV_APRVL_HIST, AP_INV_APRVL_HIST_ALL, and AP_INV_APRVL_HIST_S. Purchase order context is drawn from PO_HEADERS / PO_HEADERS_ALL and PO_DISTRIBUTIONS / PO_DISTRIBUTIONS_ALL. Approver identity is resolved through PER_ALL_PEOPLE_F, while PA_EXP_ORGS_IT supplies organization context. WF_PARAMETER_LIST_T is used for Workflow parameter handling, and DUAL supports simple evaluations.

Usage Notes

AP_WFAPPROVAL_PKG is primarily invoked indirectly by the Oracle Workflow Invoice Approval process. Each procedure mapping to the standard Workflow signature is registered as a function activity, executed when the process reaches that node. NOTIFICATION_HANDLER in particular is configured as the response-handling function for approval notifications, so it executes when an approver submits a response. The package is also callable from Payables forms and concurrent programs that manage approval status, and from custom code through the APPS schema synonym. Because the package is referenced by no other documented packages, it is best regarded as an integration endpoint between Payables and Workflow rather than a reusable utility library.