Search Results start_approval_wf

Overview

PO_APPROVAL_REMINDER_SV is an Oracle E-Business Suite PL/SQL server-side package owned by the APPS schema and classified under the OTHER API category. Its name and header comments identify it as the "PO Approval Workflow server procedures" package, belonging to the library PO_APPROVAL_WF_SV and originally authored by WLAU in July 1997. The package provides the procedural backbone that supports reminder and notification processing within the Oracle Purchasing approval workflow, particularly for documents that remain unapproved or that require acceptance handling. It is an internal, workflow-facing package rather than a public, documented API used by external integrations, and the ETRM classifies it as an "S/V" (server-side view/procedure) type object.

Key Procedures and Functions

The package exposes 19 documented procedures and functions. Only a subset has detectable descriptive names in the source header excerpt, and the remainder are documented only by name:

• Select_Unapprove_docs — selects documents that are in an unapproved state for subsequent reminder processing.
• Process_unapprove_reqs — handles unapproved requisition documents.
• Process_unapprove_pos — handles unapproved purchase order documents.
• Process_unapprove_releases — handles unapproved releases (against blanket or other agreements).
• Process_po_acceptance — processes acceptance notifications for purchase orders.
• Process_rel_acceptance — processes acceptance notifications for releases.
• Process_rfq_quote — processes RFQ quote-related reminders.
• Start_Approval_Reminder — initiates the approval reminder workflow for a given document, accepting the document header ID, document number, type, subtype, release number, agent ID, and workflow item key as inputs, then launching the appropriate reminder notification.
• Set_Doc_Type — sets or resolves the document type context for reminder processing.

Additional documented members include IS_ACTIVE, ITEM_EXIST, PROCESS_PO_TEMP_LABOR_LINES, START_PO_LINE_REMINDER_WF, and GET_PO_LINE_REMINDER_TYPE, which together support activity checks, item existence validation, temporary labor line processing, and line-level reminder workflow initiation.

Tables Accessed

The package reads and writes through APPS synonyms to the core Oracle Purchasing and Workflow tables. The primary document tables are PO_HEADERS, PO_HEADERS_ALL, PO_LINES, PO_LINES_ALL, PO_LINE_LOCATIONS, and PO_LINE_LOCATIONS_ALL, which supply the header, line, and shipment context required to identify documents needing reminders. Requisition data comes from PO_REQUISITION_HEADERS, PO_REQUISITION_HEADERS_ALL, PO_REQUISITION_LINES, and PO_REQUISITION_LINES_ALL. Release information is drawn from PO_RELEASES and PO_RELEASES_ALL. Acceptance processing reads and updates PO_ACCEPTANCES. Document type classification is resolved through PO_DOCUMENT_TYPES, and user/agent identification for workflow routing relies on FND_USER.

Usage Notes

PO_APPROVAL_REMINDER_SV is referenced by nine other packages, indicating it is a shared dependency within the Purchasing approval workflow infrastructure rather than a standalone entry point. It is invoked when the approval workflow needs to generate reminder notifications for documents that have not yet been approved or that require acceptance acknowledgment, including PO lines, requisitions, releases, and RFQ quotes. Developers searching the term start_approval_wf should note that this package's Start_Approval_Reminder procedure is the documented entry point for launching approval reminders, and the closely related START_PO_LINE_REMINDER_WF procedure launches line-level reminder workflows. Because the package is classified as OTHER and is an internal workflow component, it is not recommended for direct invocation from custom code; instead, customizations should hook into the approval workflow definitions that call these procedures.