Search Results write_interaction

Overview

APPS.AMS_EVTREGS_PVT is a private PL/SQL API within the Oracle E-Business Suite Oracle Marketing (AMS) module that manages the lifecycle of event registrations. Unlike public APIs, a PVT-classified package is intended for internal use by Oracle's own forms, concurrent programs, and sibling packages rather than for direct customer extension. In Oracle EBS 12.1.1 and 12.2.2, this package encapsulates the business rules governing registration creation, validation, waitlisting, cancellation, substitution, transfer, and prioritization, ensuring that registration data captured through the Event Management forms is persisted consistently across the underlying ETRM tables.

The package header carries a header comment dated 2002, reflecting its origin in the earlier Oracle Marketing code line, with subsequent enhancements for invite list validation, automatic registration on capacity changes, and support for the public API AMS_Registrants_PUB. Its declared AUTHID CURRENT_USER attribute means it executes with the privileges of the calling schema rather than the definer, requiring careful grant management in multi-schema deployments.

Key Procedures and Functions

ETRM documents 23 procedures and functions. The core data manipulation routines are CREATE_EVTREGS, UPDATE_EVTREGS, UPDATE_EVTREGS_WRAPPER, CANCEL_EVTREGS, and DELETE_EVTREGS, which respectively insert, modify, cancel, and remove event registration records. LOCK_EVTREGS provides record-level concurrency control, while VALIDATE_EVTREGS and CHECK_EVTREGS_RECORD enforce the overall integrity of a registration record prior to commit.

Capacity and waitlist logic is handled by CHECK_REG_AVAILABILITY, CHECK_NUMBER_REGISTERED, CHECK_NUMBER_WAITLISTED, and PRIORITIZE_WAITLIST, which together determine whether an offer has space, how many registrants are confirmed or waitlisted, and in what order waitlisted registrants should be promoted. The routines SUBSTITUTE_AND_VALIDATE and TRANSFER_AND_VALIDATE manage changes of attendee and movement of registration between offers while re-running validation.

A family of item-level validation routines supports the broader registration validation framework: CHECK_EVTREGS_ITEMS, CHECK_EVTREGS_REQ_ITEMS, CHECK_EVTREGS_UK_ITEMS, CHECK_EVTREGS_FK_ITEMS, CHECK_EVTREGS_LOOKUP_ITEMS, and CHECK_EVTREGS_FLAG_ITEMS, covering required fields, unique key constraints, foreign key relationships, lookup code validity, and Yes/No flag columns.

Tables Accessed

The package reads and writes AMS_EVENT_REGISTRATIONS and its _S (sequence) companion, the primary operational tables for registration data. Cancellation and confirmation history are recorded in AMS_EVENT_REG_CANCELLATION_S and AMS_EVENT_REG_CONFIRMATION_S. Offer and event definitions come from AMS_EVENT_OFFERS_ALL_B and _TL, while AMS_CAMPAIGN_SCHEDULES_B and AMS_ACT_LISTS support scheduling and list processing.

Waitlist ordering draws on AMS_REG_WAITLIST_PRIORITY_S and AMS_USER_STATUSES_B, and AMS_LIST_ENTRIES links registrants to campaign lists. Interaction history records are written to JTF_IH_ACTIVITIES_S1, JTF_IH_INTERACTIONS_S1, and JTF_IH_MEDIA_ITEMS_S1, capturing registration-related interactions. DUAL is used only for scalar evaluation.

Usage Notes

Because this is a PVT API, it is normally invoked indirectly: the Event Management registration forms and the public wrapper AMS_Registrants_PUB call into AMS_EVTREGS_PVT, and seven other packages reference it. Custom code should generally use the public API unless Oracle-driven behavior must be replicated exactly. In 12.2.2 the package resides in the APPS schema with synonyms for the referenced base tables; custom callers must ensure they invoke it in the correct language and security context.