Search Results ap_workflow_pkg




Overview
Explore in AI Chat

Overview

APPS.AP_WORKFLOW_PKG is the core PL/SQL package within Oracle Payables that drives the Oracle Workflow-based invoice approval lifecycle in Oracle E-Business Suite 12.1.1 and 12.2.2. It is the engine behind the Invoice Approval Workflow (IAW), the framework that routes invoices through configurable approver hierarchies and executes the business actions triggered when an invoice is approved, rejected, cancelled, or identified as matching or not matching a purchase order. The package is owned by the APPS schema and holds a VALID status.

In business terms, AP_WORKFLOW_PKG determines who must approve a given invoice, dispatches the corresponding notifications, records the outcome against the invoice approval history, and orchestrates follow-on processing such as cancellation, void, or negotiation handling. Because approval rules in Payables are largely data-driven and customer-configurable, this package is invoked repeatedly at runtime rather than being limited to setup.

Key Procedures and Functions

The package exposes 66 documented procedures and functions. Representative routines include:

Tables Accessed

Through APPS synonyms, the package reads and writes the principal Payables approval tables:

Usage Notes

AP_WORKFLOW_PKG is referenced by six other packages, including AP_APPROVAL_PKG, AP_CANCEL_PKG, AP_HOLDS_PKG, AP_VOID_PKG, AP_ISP_UTILITIES_PKG, and the XML Publisher report package AP_APXIAWRE_XMLP_PKG, and it also references itself recursively. It is typically invoked indirectly through the Payables Invoice Workbench approval actions, concurrent workflow background processes, and the Invoice Approval Workflow, rather than being called from custom code. Customizations should treat it as an internal package and avoid direct calls, relying instead on supported workflow and approval APIs.