Results for “amv_wf_requests_s”

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

Overview

AMV_WFAPPROVAL_PVT is a private PL/SQL package owned by the APPS schema in Oracle E-Business Suite, delivered as part of the Oracle Marketing or Advanced Product Catalog (AMV) module. Its documented purpose is to manage the approval workflow lifecycle for published content and channel subscriptions. The package serves as the workflow back-end for the AMV "Inbox" approval channel, initiating Oracle Workflow processes for requisitions (publish requests), validating whether a given user holds approver privileges for a channel, and handling the approve, reject, subscribe, and notification result transactions that drive the workflow. In EBS 12.1.1 and 12.2.2 the package header remains at version 120.1, with the $Header comment dating to 2005, indicating a stable interface carried forward across releases.

Key Procedures and Functions

The ETRM metadata documents ten program units. The central entry point, STARTPROCESS, initiates the workflow for a requisition; its documented parameters include RequestorId (primary key of the item owner or subscriber), ItemId, ChannelId, Timeout, ProcessOwner (requisition process owner username supplied by the calling application), Workflowprocess (the workflow process to run), and optional Item_Type. Note that Workflowprocess and ProcessOwner are documented as varchar2 inputs, while the identification values are numeric.

The remaining units fall into three functional groups:

• Authorisation checks — IS_CHANNELAPPROVER (FUNCTION) returns TRUE when a user holds approver privilege for a channel; CAN_PUBLISH validates whether a user may publish a document into a channel (invoked as a workflow function activity with itemtype, itemkey, actid and funcmode, supporting Run/Cancel/Timeout modes); CAN_SUBSCRIBE validates subscription eligibility.
• Approver resolution — GETAPPROVER and SELECT_APPROVER determine the appropriate approver for an item or subscription.
• Workflow callbacks — NOTIFICATION_RESULTS, APPROVE_ITEM, APPROVE_SUBSCRIPTION and REJECT_ITEM process the outcomes returned from workflow notifications, updating the request and subscription state accordingly.

Tables Accessed

Through APPS synonyms the package reads and writes: AMV_C_CHANNELS_B (channel definition, used to resolve ChannelId and channel-level approver configuration); AMV_U_ACCESS (user access privileges underpinning IS_CHANNELAPPROVER and CAN_SUBSCRIBE); AMV_WF_REQUESTS_S (the workflow requisition/request store that records publish and subscription requests); FND_USER (user validation and ProcessOwner resolution); JTF_RS_RESOURCE_EXTNS (resource/party information for approver lookup); WF_ITEMS, WF_ACTIVITIES and WF_PROCESS_ACTIVITIES (Oracle Workflow runtime tables used in the CAN_PUBLISH function activity and process interrogation); and DUAL for PL/SQL-level constant selection.

Usage Notes

Because this is a PVT (private) package, Oracle does not expose it as a public API; it is invoked internally by the AMV forms and workflow definitions rather than called directly from customer extensions. Typical invocation paths are Oracle Workflow function activities configured on the AMV approval process (which call CAN_PUBLISH, CAN_SUBSCRIBE and the approve/reject callbacks) and the calling application layer that executes STARTPROCESS when a requisition or subscription is submitted. The ETRM metadata records that the package is referenced by two other packages, confirming it is consumed as an internal dependency. The channels it governs are the AMV collaboration channels surfaced in the application Inbox, and STARTUP parameters such as RequestorName, ItemName and ChannelName noted in the header comment were superseded in the final signature. Customisations should target the documented public alternatives rather than this package, since private interfaces are not guaranteed under Oracle's upgrade and support policy.