Search Results validate_event_offer

Overview

APPS.AMS_EVENTOFFER_PVT is a private PL/SQL API package within the Oracle Marketing (AMS) application, classified under the PVT (private) API tier. It encapsulates the business logic governing the creation, maintenance, and fulfillment of event offers — the promotional offerings that are associated with events and campaigns managed within Oracle Marketing. The package acts as the internal execution layer that supports the corresponding public API, AMS_EVENTOFFER_PUB, and is consumed extensively across the AMS scheduling, approval, copy, and campaign-management subsystems.

As a PVT-tier package, AMS_EVENTOFFER_PVT is not intended for direct invocation by external or customer code. Instead, it provides the procedural core — validation, record initialization, locking, persistence, and fulfillment — that higher-level public APIs and workflow handlers orchestrate. It depends on the FND_API and JTF_PLSQL_API foundation packages, which supply standard API error-handling and messaging conventions (such as the FND_API.G_RET_STS_SUCCESS / ERROR return status idiom), and on the SYS.STANDARD package.

Key Procedures and Functions

The package exposes eleven documented procedures and functions, reflecting a complete Create-Read-Update-Delete (CRUD) surface augmented by validation, fulfillment, and test utilities:

• INIT_EVO_REC — Initializes the event offer record structure, populating default values prior to an insert or update operation.
• CHECK_EVO_RECORD — Performs pre-processing checks on the event offer record to confirm required elements are present.
• CHECK_EVO_ITEMS — Validates the line-level or item-level components associated with an event offer.
• VALIDATE_EVENT_OFFER — Executes the full business-rule validation for an event offer.
• LOCK_EVENT_OFFER — Acquires a lock on the event offer record to support concurrency control during updates.
• CREATE_EVENT_OFFER — Creates a new event offer record.
• UPDATE_EVENT_OFFER — Modifies an existing event offer record.
• DELETE_EVENT_OFFER — Removes an event offer record.
• COMPLETE_EVO_REC — Finalizes the event offer record, likely setting completion or status flags.
• FULFILL_EVENT_OFFER — Drives the fulfillment processing of an event offer, advancing it through its delivery lifecycle.
• UNIT_TEST_INSERT — A test utility for inserting event offer data during unit testing.

Tables Accessed

The package reads and writes a broad set of AMS tables via APPS synonyms. Central to its operation is AMS_EVENT_OFFERS_ALL_B together with its translation and sequence counterparts (AMS_EVENT_OFFERS_ALL_TL and AMS_EVENT_OFFERS_ALL_B_S), which hold the primary event offer records. It also touches AMS_EVENT_HEADERS_ALL_B and AMS_CAMPAIGNS_ALL_B for the parent event and campaign context, AMS_ACT_DELIVERY_METHODS and AMS_ACT_RESOURCES for activity delivery and resource assignment, AMS_AGENDAS_B for agenda linkage, AMS_OBJECT_ATTRIBUTES and AMS_CUSTOM_SETUP_ATTR for configurable attributes, AMS_SOURCE_CODES for source categorization, AMS_USER_STATUSES_B for status resolution, and OZF_ACT_BUDGETS for budget associations. Reference and localization data are drawn from FND_LANGUAGES and HZ_LOCATIONS.

Usage Notes

AMS_EVENTOFFER_PVT is invoked indirectly through AMS_EVENTOFFER_PUB and the wrapper packages AMS_EVENTOFFER_PUB_W and AMS_EVENTOFFER_PVT_W. It is referenced by fifteen other packages, including approval submission (AMS_APPROVAL_SUBMIT_PVT), campaign scheduling (AMS_CAMP_SCHEDULE_PVT), activity and element copying (AMS_COPYACTIVITIES_PVT, AMS_COPYELEMENTS_PVT, AMS_EVENT_OBJECTS_COPY_PVT), event schedule activation and copy processes, scheduler rules, and workflow-based campaign approval (AMS_WFCMPAPR_PVT). Oracle Forms built on the AMS_EVENTOFFER block rely on the associated CUHK and VUHK handlers, which in turn call this package. Custom code should use AMS_EVENTOFFER_PUB; direct calls to the PVT layer are unsupported and may break across 12.1.1 to 12.2.2 upgrades.