Search Results process_response_app_forward

Overview

POR_AME_REQ_WF_PVT is a private Oracle E-Business Suite PL/SQL package that integrates Oracle Approvals Management (AME) with the Oracle Purchasing requisition approval workflow. The package belongs to the APPS schema and is classified as a private (PVT) API, meaning it is intended for internal consumption by the approval workflow infrastructure rather than for direct customer invocation. Its header identifies application ID 201, confirming that AME operates under the Purchasing application context. The "_WF" designation reflects its role as the workflow-facing glue between the Workflow engine's notification and activity model and AME's rules engine, while the "_REQ" designation scopes it specifically to requisition approval rather than purchase order approval.

The package resolves approvers, launches parallel approval branches, captures approver responses, and maintains the Purchasing action history that provides an audit trail of who approved, rejected, forwarded, or timed out on a requisition. It is a runtime component of the AME-driven approval process and executes whenever a requisition enters the approval workflow.

Key Procedures and Functions

• GET_NEXT_APPROVERS — Determines the next set of approvers for the current requisition approval activity, typically by querying the AME rules engine and returning the resulting approver list to the workflow.
• LAUNCH_PARALLEL_APPROVAL — Initiates parallel approval branches, allowing multiple approvers or approval groups to act concurrently rather than sequentially.
• PROCESS_RESPONSE_APPROVE — Handles the workflow callback when an approver approves the requisition, updating approval status and progressing the workflow.
• PROCESS_RESPONSE_REJECT — Handles the callback when an approver rejects the requisition, terminating approval and returning the document to the requester for correction.
• PROCESS_RESPONSE_TIMEOUT — Handles expiry of an approval notification that was not acted upon within the configured time limit.
• PROCESS_RESPONSE_FORWARD — Processes an approver's decision to forward the notification to another user.
• PROCESS_RESPONSE_APP_FORWARD — Processes an approve-and-forward action, where the approver both approves and routes the notification onward.
• INSERT_ACTION_HISTORY — Inserts an initial entry into the Purchasing action history for the approval action.
• UPDATE_ACTION_HISTORY_APPROVE, UPDATE_ACTION_HISTORY_REJECT, UPDATE_ACTION_HISTORY_TIMEOUT, UPDATE_ACTION_HISTORY_FORWARD, UPDATE_ACTION_HISTORY_NO_ACT — Update the existing action history record to reflect the approver's disposition: approval, rejection, timeout, forwarding, or no action taken.
• PROCESS_BEAT_BY_FIRST — Implements the "beat by first" parallel approval behavior, in which the first approver response in a parallel block supersedes the remaining outstanding notifications.
• IS_AME_EXCEPTION — Evaluates whether a raised condition constitutes an AME exception requiring special handling.
• PROCESS_RESPONSE_EXCEPTION — Handles the exception path when AME cannot resolve an approver or encounters a rules error.

Tables Accessed

• PO_REQUSITION_HEADERS_ALL — The requisition header being approved; read to establish document context.
• PO_HEADERS_ALL — Purchasing document header accessed for document type and organizational context.
• PO_ACTION_HISTORY — The primary write target, recording each approver action against the requisition.
• PO_DOCUMENT_TYPES / PO_DOCUMENT_TYPES_ALL_B — Supply the document type definition used to classify the approval action.
• PO_WF_ITEMKEY_S — Maps workflow item keys to Purchasing documents.
• WF_ITEMS, WF_ITEM_ACTIVITY_STATUSES, WF_NOTIFICATIONS — Workflow runtime tables used to inspect item state, activity status, and notification status.
• FND_USER — Resolves approver usernames and originator identity.
• PER_ALL_PEOPLE_F, PER_ALL_ASSIGNMENTS_F, PER_ASSIGNMENT_STATUS_TYPES — HR tables used to derive approver person and assignment information, including active assignment status.
• PLITBLM — The standard PL/SQL table-to-varchar2 conversion utility used for messaging and diagnostics.

Usage Notes

POR_AME_REQ_WF_PVT is not a public API and should never be called directly from custom code. It is invoked exclusively by the Oracle Purchasing requisition approval workflow, which calls these procedures as workflow function activities, binding ITEMTYPE, ITEMKEY, ACTID, and FUNCMODE and receiving RESULTOUT as the standard workflow function signature. The package is referenced by one other package, consistent with its role as a subordinate component of the AME-requisition integration layer.

Because the package writes to PO_ACTION_HISTORY and reads Workflow and HR tables, its behavior depends on valid AME setup, approver assignments, and active approval workflow configuration. Customizations that require AME approval behavior for requisitions should use the supported AME and Purchasing workflow configuration surfaces rather than modifying this private package.