Search Results update_status_na

Overview

AMS_WFCMPAPR_PVT is a private PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified as a PVT (private) API. It encapsulates the Oracle Workflow procedures used to drive Activity Approvals — also referred to as Campaign Approvals — within Oracle Marketing (AMS). The package orchestrates the approval lifecycle for marketing objects such as campaigns, events, event offers, and deliverables, moving them between user-defined statuses (for example, from "NEW" to "AVAILABLE") subject to configured approval rules. The header comment identifies the original creation date as 21-SEP-1999 and notes NOCOPY and debug-level performance changes introduced in December 2002. Because the package is designated private, it is not intended as a public integration surface; it is invoked internally by Oracle Marketing flows and workflow components.

Key Procedures and Functions

The documented procedures span the initiation, routing, evaluation, and termination of the approval flow:

• STARTPROCESS — Starts the workflow approval process for an object, accepting identifiers for the approval subject, the object version number, original and new user statuses, the requester, and optional workflow process and item type overrides.
• SELECTOR — Determines which process to run for a given workflow item, using the item type and item key.
• SET_ACTIVITY_DETAILS — Populates activity-level detail used by downstream workflow steps.
• APPR_REQUIRED_CHECK — Evaluates whether approval is required for the activity.
• THEME_APPR_REQ_CHECK, OWNER_APPR_CHECK, BA_OWNER_APPR_CHECK, and FUND_APPR_REQ_CHECK — Specialized rule checks that determine whether theme, owner, business-owner, or funding approvals are mandated before the status transition proceeds.
• CREATE_NOTIF_DOCUMENT and PREPARE_DOC — Build the notification content and documents delivered to approvers.
• UPDATE_STAT_APPRTA, UPDATE_STAT_APPRBA, and UPDATE_STATUS_NA — Apply the approved outcome, the business-approver outcome, or the not-applicable outcome respectively. The update_stat_apprba search term maps directly to UPDATE_STAT_APPRBA.
• UPDATE_STATUS_REJ — Applies the rejected status when an approver declines.
• REVERT_STATUS — Reverts the object to its prior status, typically on cancellation or failure.
• ABORTPROCESS — Terminates an in-flight approval process.

Tables Accessed

The package reads and writes through APPS synonyms across the marketing data model. AMS_CAMPAIGNS_ALL_B, AMS_EVENT_HEADERS_ALL_B, AMS_EVENT_OFFERS_ALL_B, and AMS_DELIVERABLES_ALL_B supply the transient base-table rows whose status is being advanced. AMS_STATUS_ORDER_RULES and AMS_APPROVAL_RULES define the permitted status transitions and the approval routing logic. AMS_ACT_WF_REQUESTS and AMS_ACT_WF_REQUESTS_S persist the workflow request and its translated/secure variant, while AMS_ACT_MARKET_SEGMENTS, AMS_ACT_MESSAGES, and AMS_OBJECT_ATTRIBUTES support activity context, notification messaging, and object attribute retrieval. FND_LANGUAGES and DUAL are consulted for language handling and singleton queries.

Usage Notes

AMS_WFCMPAPR_PVT is referenced by zero other packages, confirming its role as an internally consumed private component. It is normally triggered indirectly: when a user submits a marketing activity for approval from the Oracle Marketing forms, the calling flow delegates to STARTPROCESS, and Oracle Workflow subsequently re-enters the package through the selector and rule-check routines as approvers respond. Status-update routines such as UPDATE_STAT_APPRBA are executed by workflow activity nodes rather than by direct user action. Custom code should not call these procedures directly, because the parameter contracts are private and subject to change between releases; supported integration should instead use the public Oracle Marketing APIs. When troubleshooting approval behavior, DBAs and developers commonly trace the workflow item type and item key to correlate AMS_ACT_WF_REQUESTS rows with the status transitions applied by this package.