Search Results g_attribute_geos




Overview
Explore in AI Chat

Overview

AMS_EVENTSCHEDULE_COPY_PVT is a private PL/SQL package body in the Oracle E-Business Suite Applications (APPS) schema that supports the "Copy Event Schedules" functionality available from the Oracle Marketing events overview and detail pages. The package encapsulates the server-side logic required to duplicate event schedules, associated agendas, and delivery method assignments, allowing users to replicate an existing event configuration rather than re-entering it manually. As a PVT (private) API, it is not intended for direct invocation by external integrations; it is called internally by the public event schedule copy APIs and by the Oracle Marketing user interface layer. The package declares package-level constants including G_PKG_NAME, G_FILE_NAME, G_OBJECT_TYPE_MODEL (set to 'EVEO'), and the attribute constants G_ATTRIBUTE_GEOS ('GEOS') and G_ATTRIBUTE_CELL ('CELL'), the last two being significant for search terms such as "g_attribute_geos" because they classify geography and cell attributes during schedule copying. Debug message levels are controlled through FND_MSG_PUB constants.

Key Procedures and Functions

The package exposes four documented program units:

  • COPY_EVENT_SCHEDULE — The primary routine that copies an event schedule, including its associated start and end date/time values. Historical comments indicate date/time copying was added in July 2002.
  • COPY_EVENT_SCHEDULE_AGENDA — Copies the agenda or agendas attached to the source event schedule so that the duplicated schedule retains its structured agenda content.
  • COPY_ACT_DELIVERY_METHOD — Duplicates activity delivery method assignments, ensuring the copied schedule preserves the original channel and fulfillment configuration.
  • GET_AGENDA_NAME — A helper function that retrieves the event offer name for a given agenda identifier from AMS_EVENT_OFFERS_VL, returning it as a quoted string. It returns a truncated quoted value on exception rather than propagating the error.

Parameter lists are not reproduced here; only documented purposes are described.

Tables Accessed

The package reads and writes through APPS synonyms across several Oracle Marketing tables. AMS_EVENT_OFFERS_ALL_B and AMS_EVENT_OFFERS_VL provide the base and translated event offer records. AMS_AGENDAS_B and AMS_AGENDAS_TL supply agenda headers and translations. AMS_ACT_DELIVERY_METHODS and AMS_ACT_CATEGORIES support activity delivery method and category configuration. AMS_DELIVERABLES_ALL_B and AMS_DELIVERABLES_ALL_TL hold deliverable definitions and translations. AMS_CATEGORIES_TL provides translated category names. AMS_OBJECT_ASSOCIATIONS links objects to their related entities, and PLITBLM is an Oracle Applications internal table type used for PL/SQL table storage during processing.

Usage Notes

AMS_EVENTSCHEDULE_COPY_PVT is referenced by three other packages within the Oracle Marketing module and is effectively invoked whenever a user selects the copy action on an event schedule in the Events Overview or Event Detail pages. It is also available to custom code that needs to replicate the standard copy behavior, though because it is a private package its signatures are not guaranteed across releases and direct calls should be avoided in favor of the public event APIs. The presence of the G_ATTRIBUTE_GEOS and G_ATTRIBUTE_CELL constants indicates the copy logic must distinguish geographic and cell-level attributes when duplicating schedules, particularly where schedules span multiple venues or hierarchical locations.