Search Results g_attribute_cell

Overview

APPS.AMS_COPYELEMENTS_PVT is a private PL/SQL package in the Oracle Marketing (AMS) module of Oracle E-Business Suite. It provides the core copy engine that duplicates the subordinate elements of a marketing activity whenever that activity — a campaign, deliverable, event, or similar object — is copied. The package specification header documents its purpose explicitly: it is the specification for copying the different elements in Oracle Marketing, and its procedures are invoked by marketing activities while they are being copied.

The package is classified as PVT (private) and is intended strictly for internal use. The source comments state that it should be called from inside AMS only and not by any external source for copying campaigns, and that the principal caller is AMS_COPYACTIVITIES_PVT. The header history records creation on 15-May-1999, with subsequent revisions adding and removing copy procedures as the marketing data model evolved; a 2007 revision (120.2) is the last recorded in the excerpt. The reference to "g_attribute_cell" aligns with the package's copy_act_cells procedure, which duplicates marketing activity cells together with their attributes.

Key Procedures and Functions

The documented interface exposes 21 procedures and functions, each targeting a specific marketing element type:

• COPY_ACT_PROD, COPY_ACT_RESOURCES, COPY_ACT_CATEGORIES, COPY_ACT_MESSAGES, COPY_ACT_MARKET_SEGMENTS, COPY_ACT_GEO_AREAS, COPY_ACT_ACCESS — copy product, resource, category, message, market segment, geography, and access-list associations of an activity.
• COPY_ACT_ATTACHMENTS and COPY_ACT_CONTENT, COPY_ACT_COLLATERAL — duplicate attached documents, content records, and collateral material.
• COPY_DELIV_KITS and COPY_ACT_SCHEDULES, COPY_CAMPAIGN_SCHEDULES, COPY_SELECTED_SCHEDULE — copy deliverable kits and activity or campaign schedules.
• COPY_TASKS, COPY_PARTNERS, COPY_PARTNERS_GENERIC, COPY_TARGET_GROUP — copy tasks, partner assignments (including a generic variant), and target groups.
• COPY_OBJECT_ASSOCIATIONS and COPY_LIST_SELECT_ACTIONS — copy object associations and list selection actions.
• The header additionally lists copy_act_objectives, copy_act_offers, copy_act_offer_products, copy_act_scripts, copy_act_cells, copy_act_list_headers, and copy_act_offers/copy_act_offers entries, some of which were later removed per the history.

Parameter lists are not reproduced here; the procedures are named-and-purpose only.

Tables Accessed

The package reads and writes the AMS transactional tables that hold marketing activity detail, accessed through APPS synonyms. These include AMS_ACT_ACCESS, AMS_ACT_CATEGORIES, AMS_ACT_DELIVERY_METHODS, AMS_ACT_GEO_AREAS, AMS_ACT_MARKET_SEGMENTS, AMS_ACT_MESSAGES, AMS_ACT_PARTNERS, AMS_ACT_PRODUCTS, AMS_CAMPAIGNS_ALL_B, AMS_DELIV_KIT_ITEMS, AMS_EVENT_OFFERS_ALL_B, AMS_LIST_SELECT_ACTIONS, and AMS_OBJECT_ASSOCIATIONS. Attachment and content copying relies on FND_ATTACHED_DOCUMENTS and FND_DOCUMENTS. Because the package duplicates rows into these tables, it performs both reads (source activity) and writes (new activity).

Usage Notes

Invocation is expected from within the AMS application layer rather than from external custom code. The documented call path is AMS_COPYACTIVITIES_PVT, which orchestrates activity-level copying and delegates element-level duplication to this package. It is referenced by 12 other packages across Oracle Marketing. Customizations should not call AMS_COPYELEMENTS_PVT directly; doing so bypasses the validation and sequencing performed by the parent copy activity API and risks inconsistent activity data across the AMS_ACT_* tables.