Search Results ams_event_objects_copy_pvt_w




Overview
Explore in AI Chat

Overview

The APPS.AMS_EVENT_OBJECTS_COPY_PVT_W package is a private Oracle EBS API belonging to the Advanced Marketing (AMS) product family, which underpins the Oracle Marketing and Trade Management modules. Its declared purpose is to support the copying of marketing event objects — specifically event headers — within the AMS schema. In Oracle EBS 12.1.1 and 12.2.2, this package functions as the "W" (wrapper) layer of the AMS Event Objects Copy private API stack, exposing a single documented entry point that delegates to the underlying private implementation package.

The package header is defined with AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking user rather than the definer, which is consistent with Oracle's standard API security model. The header comment indicates this is a shipped, versioned object (version 115.6, dated 2003), reflecting its long-standing stability across release cycles. It is classified as OTHER in the ETRM documentation, signifying it is not a public, formally supported customer-callable API but rather an internal helper used by the AMS application itself.

Key Procedures and Functions

The package exposes one documented procedure:

  • COPY_EVENT_HEADER — Copies an AMS event header object. It accepts a comprehensive set of standard EBS API parameters, including p_api_version, p_init_msg_list, p_commit, and p_validation_level, together with the standard return parameters x_return_status, x_msg_count, and x_msg_data. Business-specific inputs include p_source_object_id (the identifier of the object being copied) and three attribute table parameters (p_attributes_table, p9_a0, and p9_a1) that carry configurable attribute values for the new object. The procedure returns x_new_object_id, identifying the newly created object, and x_custom_setup_id, referencing any associated custom setup record. This signature confirms the procedure is designed to duplicate an existing event header while capturing attribute-level customizations.

Tables Accessed

The ETRM metadata does not enumerate specific base tables referenced directly by this wrapper package. Because it is declared as a private "W" wrapper over an underlying implementation package, the actual table access is performed in the delegated private package body. Functionally, the procedure operates against the AMS event object store — reading the source event header identified by p_source_object_id and inserting a new header and associated attribute rows whose identifiers are returned through the output parameters. Developers requiring the exact table list should inspect the corresponding _PVT implementation package and its dependencies.

Usage Notes

As a private wrapper, this package is not intended for direct invocation by external or customer customizations. It is typically called internally by the AMS application layer — for example, from the Oracle Marketing forms or from AMS-owned concurrent programs — when a user copies an existing event or event template. The Referenced by 0 other packages annotation in the ETRM metadata confirms it is not consumed by other documented packages, reinforcing its role as a leaf-level internal utility.

When extending AMS event-copy behavior, developers should prefer the corresponding public API rather than calling AMS_EVENT_OBJECTS_COPY_PVT_W directly, since the private wrapper is subject to change without notice. If direct use is unavoidable, the caller must observe the standard EBS API conventions: initialize the message list when p_init_msg_list is set, respect the requested validation level, check x_return_status for FND_API.G_RET_STS_SUCCESS, and handle commit semantics through p_commit. Invocations should always be made as the APPS schema context to satisfy the AUTHID CURRENT_USER privilege model.