Search Results copy_campaign_schedules

Overview

APPS.AMS_COPYACTIVITIES_PVT is a private PL/SQL package within the Oracle Marketing (AMS) module of Oracle E-Business Suite. Its principal business function is to support the duplication of marketing activities and their related child entities. In the Oracle Marketing data model, a campaign or event is rarely a single record; it is composed of headers, offers, deliverables, schedules, and element-level attributes. AMS_COPYACTIVITIES_PVT provides the internal copy logic that clones these structures, allowing marketing users to reproduce an existing campaign or event as the basis for a new one without manually re-entering every associated record.

The package is classified as a private (PVT) API. It is not intended for direct invocation by external consumers; instead, it exposes the procedural building blocks consumed by public marketing APIs such as AMS_CAMP_SCHEDULE_PVT, AMS_COPYELEMENTS_PVT, and AMS_EVENTOFFER_PVT, as well as by its own public wrapper. This layered design keeps the copy mechanics centralized while allowing higher-level APIs to orchestrate the overall duplication workflow.

Key Procedures and Functions

The documented package exposes eleven procedures and functions. The primary copy operations are named COPY_CAMPAIGN and COPY_CAMPAIGN_NEW, which handle duplication of campaign-level records, including the creation of a new campaign entity derived from an existing one. COPY_EVENT_HEADER performs the equivalent operation for event header data stored in the translatable event header tables. COPY_EVENT_OFFER duplicates the offers associated with an event. COPY_DELIVERABLES copies the deliverable definitions attached to a campaign or event. COPY_SCHEDULE_ATTRIBUTES replicates schedule-level attribute records, and WRITE_TO_ACT_LOG records activity against the marketing activity log for audit and traceability purposes. Exact parameter signatures are not enumerated in the ETRM metadata; the procedures are described by purpose only.

Tables Accessed

The package accesses several core Oracle Marketing tables through APPS synonyms. AMS_CAMPAIGN_SCHEDULES_B stores the base schedule records for campaigns and is central to the schedule copy logic. AMS_EVENT_HEADERS_ALL_TL and AMS_EVENT_OFFERS_ALL_TL hold the translatable event header and event offer descriptions, which the EVENT_HEADER and EVENT_OFFER procedures clone. AMS_OBJECT_ATTRIBUTES supplies extensible attribute values associated with marketing objects during duplication. AMS_USER_STATUSES_B contributes user-defined status information applied to copied records. JTF_TASKS_B, from the shared JTF (CRM Foundation) schema, supports task-related data referenced during activity copying.

Usage Notes

AMS_COPYACTIVITIES_PVT is invoked indirectly. According to dependency metadata, it is referenced by AMS_CAMP_SCHEDULE_PVT, AMS_COPYELEMENTS_PVT, AMS_EVENTOFFER_PVT, and by its own public companion package AMS_COPYACTIVITIES_PVT_W. This indicates that the private package functions as an internal engine called during campaign and event copy operations initiated from the Oracle Marketing user interface or through higher-level public APIs. Custom code should not call the PVT package directly; developers should instead invoke the public (non-PVT) wrapper, which enforces the standard API error-handling and validation conventions via FND_API and the shared utility package AMS_CPYUTILITY_PVT. It depends on AMS_CPYUTILITY_PVT for common copy utilities and on FND_API for messaging and return-status handling, consistent with the standard Oracle EBS PL/SQL API architecture.