Results for “amv_item_id”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

AMV_WFAPPROVAL_PVT is a private PL/SQL package body in the APPS schema that provides the internal workflow approval engine for Oracle E-Business Suite's AMV (Approval Management) module, which governs the publication and subscription lifecycle of items managed through the JTF/AMV framework. Its central responsibility is to initiate Oracle Workflow processes for requisitions, items, and subscriptions that require approval, and to evaluate the outcome of those workflow activities. The package bridges the AMV channel and item data model with the Oracle Workflow runtime, generating item keys and user keys, resolving approvers, and returning notification results back to the calling application.

The package is classified as PVT (private), meaning it is not a public API surface; it is invoked by other AMV packages and workflow callbacks rather than by external customizations. The header revision identifier ($Header: amvvwfab.pls 120.1 2005/06/21) confirms the file dates to the 11i/12.0-era code line and remains shipped unmodified through 12.1.1 and 12.2.2.

Key Procedures and Functions

The documented procedures cover the full approval lifecycle:

• STARTPROCESS — Initiates the workflow for a requisition. Per the source excerpt, it accepts a requestor identifier (item owner or subscriber), an item identifier, a channel identifier, an optional timeout, a process owner, the workflow process name, and an item type that defaults to AMV_APPR. It resolves channel, item, and requestor names, obtains a sequence value from AMV_WF_REQUESTS_S to build an item key (for example, a 'PUB' prefix for the public approval process), and launches the workflow.
• IS_CHANNELAPPROVER — Determines whether a given user acts as an approver for a channel.
• CAN_PUBLISH — Evaluates whether the requestor holds the privileges required to publish an item.
• CAN_SUBSCRIBE — Evaluates whether the requestor may subscribe to an item or channel.
• GETAPPROVER — Retrieves the approver associated with a given item or channel.
• SELECT_APPROVER — Selects and assigns the appropriate approver for a workflow instance.
• NOTIFICATION_RESULTS — Processes the result of a workflow notification, typically invoked as a workflow callback.
• APPROVE_ITEM — Records approval of a published item and advances its workflow state.
• APPROVE_SUBSCRIPTION — Records approval of a subscription request.
• REJECT_ITEM — Records rejection of an item, terminating or rerouting its workflow.

Tables Accessed

The package operates against the following tables through APPS synonyms:

• AMV_C_CHANNELS_B — channel definition, used to resolve the channel name for display and key construction via AMV_C_CHANNELS_VL.
• AMV_U_ACCESS — access and privilege records used by CAN_PUBLISH, CAN_SUBSCRIBE, and approver checks.
• AMV_WF_REQUESTS_S — the sequence driving unique workflow item keys generated in STARTPROCESS.
• JTF_AMV_ITEMS_VL — item name lookup used when the public approval process runs; although not in the synonym list, it appears directly in the source excerpt.
• FND_USER and JTF_RS_RESOURCE_EXTNS — joined to resolve the requestor's username from the resource identifier.
• WF_ACTIVITIES, WF_ITEMS, and WF_PROCESS_ACTIVITIES — Oracle Workflow runtime tables used to start processes, inspect activity status, and post notification results.
• DUAL — used for sequence selection.

Usage Notes

Because this package is classified PVT, it should not be called directly from custom code. It is invoked internally by the AMV approval framework: AMV forms and the AMV_UTILITY_PVT public utility package route approval requests into STARTPROCESS, while Oracle Workflow invokes NOTIFICATION_RESULTS, APPROVE_ITEM, APPROVE_SUBSCRIPTION, and REJECT_ITEM as callback activities when an approver responds to a notification. Two other packages reference it, confirming its role as an internal service layer.

In 12.1.1 and 12.2.2 the package is unchanged from its 11i lineage. When troubleshooting, the identifier named in the user's search — amv_item_id — is the workflow item key generated from AMV_WF_REQUESTS_S; queries against WF_ITEMS using this key (with the AMV_APPR item type) locate the corresponding approval workflow instance and its current activity.