Search Results process_doc_approval

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:

• IDENTIFY_APPROVERS / GET_APPROVERS / GET_APPROVER / GET_FIRST_APPROVER — resolve the approval hierarchy for an invoice and return the approver(s) who must act next.
• CHECK_HEADER_REQUIREMENTS / CHECK_LINE_REQUIREMENTS — validate whether header- and line-level data meet the conditions required before approval can proceed.
• LAUNCH_APPROVAL_NOTIFICATIONS / LAUNCH_NEG_NOTIFICATIONS — generate and send the approval notifications to the identified approvers, including negotiation-related notifications.
• PROCESS_DOC_APPROVAL / PROCESS_DOC_REJECTION — apply the result of an approver's decision, updating approval history and advancing or terminating the workflow.
• PROCESS_ACCEPT_INT / PROCESS_ACCEPT_EXT — handle acceptance of internal and external invoice types.
• PROCESS_ACK_POMATCHED / PROCESS_REL_POMATCHED / PROCESS_ACK_POUNMATCHED / PROCESS_REL_POUNMATCHED — process acknowledgement and release actions for PO-matched and unmatched invoices.
• PROCESS_CANCEL_INV_BY_SUP — manage supplier-initiated invoice cancellation.
• IS_NEGOTIABLE_FLOW / IS_IT_INTERNAL — classification helpers that determine whether an invoice follows a negotiable flow or an internal flow.
• GET_SUPPLIER_CONTACT — retrieve the supplier contact used in workflow communication.

Tables Accessed

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

• AP_INVOICES_ALL / AP_INVOICES — the invoice header, supplying and receiving approval status.
• AP_INVOICE_LINES_ALL / AP_INVOICE_DISTRIBUTIONS_ALL — line and distribution detail used in requirement checks and matching logic.
• AP_INV_APRVL_HIST / AP_INV_APRVL_HIST_ALL / AP_INV_APRVL_HIST_S — the invoice approval history, where decisions and approver actions are recorded.
• AP_APINV_APPROVERS / AP_APPROVERS_LIST_GT — approver assignments and the global temporary list of resolved approvers.
• AP_HOLDS_ALL / AP_HOLD_CODES — holds that block approval.
• AP_NEGOTIATION_HIST_S — negotiation history for negotiable flows.
• AP_SUPPLIERS / HZ_PARTIES / FND_USER — supplier and user data resolved into approver and contact identities.

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.