Search Results copy_deliverables

Overview

APPS.AMS_COPYACTIVITIES_PVT_W is a private PL/SQL package in the Oracle E-Business Suite Marketing (AMS) module that provides the programmatic copy engine for marketing campaigns and their related objects. Its central purpose is to let users duplicate an existing campaign, event header, event offer, deliverable, or schedule attribute set into a new record, optionally re-parented under a different campaign or event and optionally rebranded with a new name and new start and end dates. The package is declared AUTHID CURRENT_USER, meaning it executes with the privileges of the calling schema, and the trailing "_W" suffix indicates it is a wrapper package that mediates between the public API layer and a private implementation package.

The header comment shows a source control revision of 120.0 dated 2005, indicating the package is long-standing, stable code that has been carried forward through the 12.1.1 and 12.2.2 releases essentially unchanged. It is the workhorse behind the "Copy" action on the Marketing campaign and event forms, where the descriptive flexfield context is transferred to the target record through the generic p10_a0 through p10_a12 parameters.

Key Procedures and Functions

ETRM documents ten callable routines. The two copy_campaign overloads are the primary entry points: both accept the source campaign identifier, a new campaign name, a parent campaign identifier, a source code, the attribute containers, and start and end dates, and both return the newly created campaign identifier; the second overload additionally returns a transaction identifier for downstream tracking. The remaining procedures follow the same calling convention for their respective object types:

• COPY_CAMPAIGN — duplicates a campaign record and its flexfield attribute values into a new campaign, returning the new campaign identifier.
• COPY_CAMPAIGN_NEW — an alternate campaign copy path used when creating a campaign from another, typically with a different name and re-parenting target.
• COPY_EVENT_HEADER — copies an event header row, returning the new event header identifier and accepting nine attribute placeholders (p9_a0 through p9_a7 in the excerpt).
• COPY_EVENT_OFFER — duplicates an offer associated with an event.
• COPY_DELIVERABLES — copies the deliverable (fulfillment) definitions and their associated detail lines attached to a campaign, event, or offer, which is the routine most commonly searched for by name.
• COPY_SCHEDULE_ATTRIBUTES — replicates scheduling attributes, such as recurrence and timing data, for the new activity.

All routines share the standard EBS API signature elements: p_api_version, p_init_msg_list, and the output parameters x_return_status, x_msg_count, and x_msg_data for message stack handling.

Tables Accessed

ETRM lists no explicit table references for this package, because access is performed through APPS synonyms resolved at runtime inside the private implementation body. Functionally, the package reads and writes the AMS campaign, event header, event offer, deliverable, and schedule attribute tables, together with the associated descriptive flexfield tables that hold the values passed in through the p10_* and p9_* parameter arrays. The copy operations insert new rows into the destination tables and carry forward the source rows' flexfield context.

Usage Notes

Because the package is classified as OTHER and is not referenced by any other documented package, it is intended for internal use rather than as a public integration surface. In practice it is invoked from the Marketing campaign and event forms when a user performs a copy action, and it may also be called from custom concurrent programs or extension code that needs to clone marketing activities in bulk. Callers must supply p_api_version for compatibility checking, initialize the message list as required, and inspect x_return_status, x_msg_count, and x_msg_data after every call to detect errors and retrieve messages from the FND message stack.