Search Results g_object_type_model

Overview

AMS_EVENT_OBJECTS_COPY_PVT is a private PL/SQL package body in the APPS schema that implements the cloning logic behind the "Copy" actions available on Oracle Marketing (AMS) event overview and detail pages. Its role is to duplicate an existing event header, together with its agenda lines and the associated activity offers and delivery methods, so that users can quickly create a new event seeded from a previously configured one rather than re-entering all setup data.

The package declares three package-level constants that drive its behaviour. The constant the user searched for, G_OBJECT_TYPE_MODEL, is defined as 'EVEH' (line 6), identifying the object type model as the event header — this is the key that AMS_OBJECT_ASSOCIATIONS uses to link related records such as offers and deliverables to the parent event. The companion constants G_ATTRIBUTE_GEOS ('GEOS') and G_ATTRIBUTE_CELL ('CELL') classify the geographic and cellular attributes of the copied offers. A further variable, g_commit, initialised to 'T', was introduced under bug fix 5213670 to control commit behaviour during the copy.

Per its header comment, the package supports the "Copy Event Headers" functionality from the events overview and detail pages, and its procedures were deliberately separated so that the individual copy steps could be invoked independently. It is classified as a PVT (private) API, meaning it is not intended for direct customer invocation.

Key Procedures and Functions

• COPY_EVENT_HEADER — the main entry point; duplicates an event header record and its dependent data to produce a new event.
• COPY_EVENT_HEADER_AGENDA — copies the agenda (child event headers) associated with the source event.
• COPY_ACT_OFFERS — copies the activity offers attached to the source event.
• COPY_ACT_DELIVERY_METHOD — copies the delivery methods configured for those offers.
• GET_AGENDA_NAME — a helper function that returns the quoted name of an agenda from AMS_EVENT_HEADERS_VL for a given agenda id, falling back to a quoted id value on exception.
• GET_OFFER_NAME — the equivalent helper for retrieving an offer name.

The two GET functions supply labels used while constructing the copied records.

Tables Accessed

• AMS_CATEGORIES_TL — supplies translated category names referenced during the copy.
• AMS_DELIVERABLES_ALL_B / AMS_DELIVERABLES_ALL_TL — the deliverable base and translation tables linked to copied offers.
• AMS_EVENT_OFFERS_ALL_B — the event offer base table, read and written as offers are cloned.
• AMS_OBJECT_ASSOCIATIONS — the association table keyed by the EVEH object type model, used to resolve the objects related to an event.
• PLITBLM — a PL/SQL index-by table used internally by the copy logic.

Usage Notes

Because this is a private package, it is not called directly from custom code. It is invoked indirectly by the AMS event pages when a user selects the copy action, and it is referenced by two other packages in the AMS schema. Any extensibility work involving event copying should be performed through the public AMS APIs rather than this private body.