Search Results ap_web_export_wf




Overview
Explore in AI Chat

Overview

AP_WEB_EXPORT_WF is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suites Release 12.1.1 and 12.2.2. It sits within the Oracle Payables web-based (AP Web) subsystem and provides the workflow-facing glue layer used by the Internet Expenses and Payables self-service export processes. Its principal business function is to signal and manage workflow events associated with the export of expense reports and invoice-related documents into the Oracle Workflow engine. The package is classified as OTHER in the ETRM catalog, meaning it is a supporting technical utility rather than a public, certified API intended for external integration. The Status of VALID confirms the compiled body exists and resolves correctly against its dependencies in a standard patched environment.

The package carries no documented outbound references: AP_WEB_EXPORT_WF is not referenced by any other database object. It is consumed dynamically at runtime through the Workflow engine rather than being called directly by dependent PL/SQL units, which is typical for packages whose procedures are registered as workflow activity handlers.

Key Procedures and Functions

The ETRM metadata documents a single public procedure for this package:

  • RAISEREJECTIONEVENT — Raises a rejection event into the Oracle Workflow engine on behalf of the AP Web export process. Its purpose is to allow the export flow to notify the Workflow runtime that a document, expense report, or approval has been rejected, so that the corresponding workflow item is transitioned and the appropriate notifications or subsequent activities are triggered. Consistent with standard workflow integration practice, the procedure locates the relevant item via the Workflow engine and WF_ITEMS, then invokes the WF_ENGINE event APIs to raise the event. No parameter list is documented in the ETRM record and none should be assumed.

All other logic in the body is private and invoked internally by RAISEREJECTIONEVENT or by the Workflow runtime.

Tables Accessed

The ETRM metadata identifies two objects accessed by this package, both resolved through APPS synonyms:

  • WF_ITEMS — The Oracle Workflow item attribute repository. The package reads this table to resolve the workflow item (item type, item key, and associated attributes) that corresponds to the Payables or Expenses document under export, so that the rejection event is raised against the correct workflow instance.
  • DUAL — The standard Oracle single-row pseudo-table, used for statement-level evaluations such as retrieving sequence values, current dates, or performing function-only calls within a SQL context.

The package additionally depends on the APPS packages AP_WEB_UTILITIES_PKG, WF_CORE, and WF_ENGINE, which supply Workflow engine calls and shared AP Web utilities. These are code dependencies rather than table accesses and confirm that all Workflow interaction is routed through the supported engine APIs rather than by direct DML against Workflow tables.

Usage Notes

AP_WEB_EXPORT_WF is not intended to be called from customer-written SQL, forms personalization, or concurrent program PL/SQL. It is invoked internally by the Oracle Payables Internet Expenses and AP Web export flows, and, in the case of RAISEREJECTIONEVENT, is registered as a Workflow activity or event handler so that the Workflow engine can invoke it when the rejection condition arises. Custom code should not reference this package directly, because its procedures are subject to change across patch releases and are not covered by Oracle's public API compatibility guarantees. Integrators who need to raise rejection-style events in a custom flow should use the documented Oracle Workflow APIs (WF_ENGINE and the WF_EVENT family) rather than this private AP Web wrapper. Administrators troubleshooting stuck or misrouted expense report approvals may inspect AP_WEB_EXPORT_WF behavior through Workflow administration and the WF_ITEMS records for the affected item type.