Search Results check_evh_record

Overview

APPS.AMS_EVENTHEADER_PVT is a private PL/SQL package within the Oracle E-Business Suite Oracle Marketing (AMS) module. It encapsulates the core business logic for creating, maintaining, validating, and deleting event header records stored in the AMS_EVENT_HEADERS tables. An event header represents a marketing or training event — such as a seminar, conference, or webcast — along with its scheduling, registration, capacity, financial, and status attributes. The package declares a comprehensive record type, evh_rec_type, which mirrors the structure of the event header entity, covering columns such as event_level, event_type_code, system_status_code, registration flags, agenda times, revenue and cost figures, and descriptive flexfield attributes (attribute1 through attributeN). Declared AUTHID CURRENT_USER, the package executes with the privileges of the invoking session and is classified as PVT, meaning it is intended to be called by other AMS packages and program units rather than directly by end users. In Oracle EBS 12.1.1 and 12.2.2, it forms a key layer beneath the event management user interface and public APIs.

Key Procedures and Functions

• CREATE_EVENT_HEADER — Inserts a new event header record into the underlying base and translation tables, applying defaulting and validations.
• UPDATE_EVENT_HEADER — Modifies an existing event header, typically following a lock operation to ensure record integrity.
• DELETE_EVENT_HEADER — Removes an event header record, subject to validation and dependency checks.
• LOCK_EVENT_HEADER — Obtains a row-level lock on the event header to prevent concurrent modification.
• VALIDATE_EVENT_HEADER — Performs business rule validation of the supplied event header record prior to insert or update.
• CHECK_EVH_RECORD — Verifies the existence and integrity of an event header row; this is the procedure associated with the user search term "check_evh_record."
• CHECK_EVH_ITEMS — Validates associated event line items or related child records.
• CHECK_EVH_INTER_ENTITY — Performs cross-entity consistency checks between the event header and related AMS entities.
• INIT_EVH_REC — Initializes the evh_rec_type record structure with default values before it is populated.
• COMPLETE_EVH_REC — Populates or completes the record structure, typically by fetching remaining columns from the database.

Tables Accessed

The package reads and writes AMS_EVENT_HEADERS_ALL_B (the base table storing event header rows) and its _S sequence and _TL translation tables, reflecting the multilingual, multi-org design. AMS_SOURCE_CODES and AMS_USER_STATUSES_B are referenced to validate source and status values against defined lookup data. FND_LANGUAGES supports language validation for the main_language_code and translation logic. OZF_ACT_BUDGETS is consulted in relation to event financial or budgeting data. DUAL is used for single-row computations and defaulting.

Usage Notes

As a PVT (private) package, AMS_EVENTHEADER_PVT is not intended for direct invocation by external custom code. It is instead called by public AMS APIs, event management forms, and other AMS packages — the metadata records that ten other packages reference it. Typical invocation occurs when an event is created or modified through the Oracle Marketing event management UI, when concurrent programs process event data, or when higher-level public APIs delegate low-level record validation and persistence to this package. Developers extending event functionality should prefer the corresponding public API rather than calling these private procedures directly, since the private interface may change between releases without notice.