Search Results copy_act_offers

Overview

The AMS_EVENT_OBJECTS_COPY_PVT package is a private PL/SQL API within the Oracle Marketing (AMS) module of Oracle E-Business Suite. It belongs to the Applications (APPS) schema and is classified as a private (PVT) API, meaning it is intended for internal consumption by other AMS packages rather than for direct invocation by end users or external customizations. Its primary business function is to support the duplication of marketing event structures, including event headers, agendas, offers, and delivery methods, when a user copies an existing marketing event or event schedule. This copy capability is essential in marketing operations where campaigns and events are frequently cloned to reuse proven configurations without recreating each element manually. The package operates as part of a broader copy framework, delegating reusable low-level operations to AMS_CPYUTILITY_PVT and conforming to the standard Oracle API error-handling conventions via FND_API. The ETRM documentation classifies this package as VALID under both Oracle EBS 12.1.1 and 12.2.2 release levels.

Key Procedures and Functions

The ETRM metadata documents six procedures and functions within this package. Their purposes are as follows:

• COPY_EVENT_HEADER — Copies the top-level marketing event header record, establishing the parent entity for subsequent dependent object copies.
• COPY_EVENT_HEADER_AGENDA — Copies agenda entries associated with the event header, preserving the sequenced agenda structure of the source event.
• COPY_ACT_OFFERS — Copies offers linked to activities within the event, ensuring promotional or product offer associations are replicated.
• COPY_ACT_DELIVERY_METHOD — Copies delivery method assignments for activities, retaining the communication channel configuration of the source event.
• GET_AGENDA_NAME — Retrieves the agenda name, typically used to derive or validate a name during the copy operation.
• GET_OFFER_NAME — Retrieves the offer name, likewise supporting naming and validation logic during copy.

As a private package, these programs are not exposed as public APIs; their signatures are callable only by trusted sibling packages within the AMS copy framework.

Tables Accessed

The package operates against several AMS base and translation tables through APPS synonyms:

• AMS_CATEGORIES_TL — Stores translated category names, used to resolve category descriptions during copy.
• AMS_DELIVERABLES_ALL_B and AMS_DELIVERABLES_ALL_TL — Hold deliverable definitions and their translations, supporting copy of delivery-related objects.
• AMS_EVENT_OFFERS_ALL_B — Contains event-to-offer associations, accessed by COPY_ACT_OFFERS.
• AMS_OBJECT_ASSOCIATIONS — Maintains generic relationships between marketing objects, critical for preserving linkage integrity across copied entities.
• PLITBLM — A standard PL/SQL table (index-by table) type used for in-memory collections, not a physical application table.

Usage Notes

AMS_EVENT_OBJECTS_COPY_PVT is never invoked directly by end users. It is called by AMS_EVENTSCHEDULE_COPY_PVT and by the public wrapper AMS_EVENT_OBJECTS_COPY_PVT_W, which exposes a controlled entry point for the copy logic. The package also references itself recursively, reflecting internal helper reuse. In practice, invocation occurs when a user selects a "Copy" action on a marketing event or event schedule within the Oracle Marketing responsibility, or when a concurrent program or custom extension calls the public wrapper. Developers extending AMS copy behavior should call the _W wrapper rather than this private package, and must respect the FND_API savepoint and message conventions that the package adheres to. Because the package is private and version-specific, direct custom calls to its procedures are unsupported and may break across patches.