Search Results ap_inv_aprvl_hist_s

Overview

APPS.AP_WORKFLOW_PKG is the Oracle Payables approval workflow engine. It is the PL/SQL package body that orchestrates the routing, notification, acceptance, rejection, and negotiation of accounts payable documents through Oracle Workflow. In Oracle E-Business Suite 12.1.1 and 12.2.2, this package acts as the integration layer between Payables invoice data and the Approval Management Engine (AME), determining which approvers are required for a given invoice, generating approval notifications, and updating approval history records as workflow activity progresses.

The package also supports supplier-facing negotiation and cancellation flows, including the processing of accept and reject responses from external suppliers and internal approvers who respond to purchase order matched and unmatched invoice events. Its status is documented as VALID in the APPS schema.

Key Procedures and Functions

The ETRM metadata documents 66 procedures and functions. The most significant include:

GET_APPROVER / GET_APPROVERS / GET_FIRST_APPROVER — Retrieve the approver or set of approvers applicable to an invoice, including the first approver in the routing sequence.
IDENTIFY_APPROVERS — Determines and records the approvers responsible for a document based on approval rules.
LAUNCH_APPROVAL_NOTIFICATIONS / LAUNCH_NEG_NOTIFICATIONS — Generate and dispatch approval and negotiation workflow notifications to the appropriate recipients.
PROCESS_DOC_APPROVAL / PROCESS_DOC_REJECTION — Handle approver approval and rejection responses and update the document state accordingly.
PROCESS_ACK_POMATCHED / PROCESS_ACK_POUNMATCHED / PROCESS_REL_POMATCHED / PROCESS_REL_POUNMATCHED — Process acknowledgement and release responses for purchase order matched and unmatched invoices.
PROCESS_ACCEPT_INT / PROCESS_ACCEPT_EXT / PROCESS_CANCEL_INV_BY_SUP — Process internal and external acceptance responses and supplier-initiated invoice cancellation requests.
CHECK_HEADER_REQUIREMENTS / CHECK_LINE_REQUIREMENTS — Validate whether invoice header and line level approval requirements are satisfied.
IS_NEGOTIABLE_FLOW / IS_IT_INTERNAL — Determine whether a document qualifies for a negotiation flow and whether a party is internal.
GET_SUPPLIER_CONTACT — Resolve supplier contact information used in negotiation notifications.

Tables Accessed

The package reads and writes the principal Payables invoice tables, including AP_INVOICES_ALL and AP_INVOICE_LINES_ALL for header and line data, and AP_INVOICE_DISTRIBUTIONS_ALL for distribution detail. Approval routing and history are persisted in AP_INV_APRVL_HIST, AP_INV_APRVL_HIST_ALL, and AP_INV_APRVL_HIST_S, with AP_APINV_APPROVERS and AP_APPROVERS_LIST_GT holding approver assignments and working sets. Holds and hold codes are accessed through AP_HOLDS_ALL and AP_HOLD_CODES. Supplier and party information comes from AP_SUPPLIERS, HZ_PARTIES, and HZ_PARTY_SITES, while FND_USER supports approver identity resolution. Negotiation history is captured in AP_NEGOTIATION_HIST_S.

Usage Notes

AP_WORKFLOW_PKG is invoked primarily by Oracle Workflow business events and notification response handlers during the invoice approval lifecycle, rather than being called directly by end users. It is referenced by six other packages and is central to the Payables approval workflow configuration. The references to AME_API, AME_API2, and AME_UTIL indicate that approval rule evaluation is delegated to the Approval Management Engine. Customizations that bypass this package risk leaving approval history (including AP_INV_APRVL_HIST_S) inconsistent, so extensions should invoke the documented procedures through supported workflow integration points.

SYNONYM: APPS.AP_INV_APRVL_HIST_S 12.1.1
owner:APPS, object_type:SYNONYM, object_name:AP_INV_APRVL_HIST_S, status:VALID,
SYNONYM: APPS.AP_INV_APRVL_HIST_S 12.2.2
owner:APPS, object_type:SYNONYM, object_name:AP_INV_APRVL_HIST_S, status:VALID,
SEQUENCE: AP.AP_INV_APRVL_HIST_S 12.1.1
owner:AP, object_type:SEQUENCE, object_name:AP_INV_APRVL_HIST_S, status:VALID,
SEQUENCE: AP.AP_INV_APRVL_HIST_S 12.2.2
owner:AP, object_type:SEQUENCE, object_name:AP_INV_APRVL_HIST_S, status:VALID,
12.1.1 DBA Data 12.1.1
PACKAGE BODY: APPS.AP_WORKFLOW_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:AP_WORKFLOW_PKG, status:VALID,
12.1.1 DBA Data 12.1.1
12.2.2 DBA Data 12.2.2
PACKAGE BODY: APPS.AP_IAW_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:AP_IAW_PKG, status:VALID,
PACKAGE BODY: APPS.AP_IAW_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:AP_IAW_PKG, status:VALID,
PACKAGE BODY: APPS.AP_WFAPPROVAL_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:AP_WFAPPROVAL_PKG, status:VALID,
PACKAGE BODY: APPS.AP_WFAPPROVAL_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:AP_WFAPPROVAL_PKG, status:VALID,
12.2.2 DBA Data 12.2.2
PACKAGE BODY: APPS.AP_WORKFLOW_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:AP_WORKFLOW_PKG, status:VALID,
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
APPS.AP_IAW_PKG dependencies on AP_INV_APRVL_HIST_S 12.1.1
APPS.AP_WFAPPROVAL_PKG dependencies on AP_INV_APRVL_HIST_S 12.1.1
APPS.AP_WORKFLOW_PKG dependencies on AP_INV_APRVL_HIST_S 12.1.1
APPS.AP_IAW_PKG dependencies on AP_INV_APRVL_HIST_S 12.2.2
APPS.AP_WFAPPROVAL_PKG dependencies on AP_INV_APRVL_HIST_S 12.2.2
APPS.AP_WORKFLOW_PKG dependencies on AP_INV_APRVL_HIST_S 12.2.2
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1