Search Results validate_list_record

Overview

AMS_LISTHEADER_PVT is the private PL/SQL API package for Oracle Marketing (AMS) list headers. It encapsulates the core business logic used to create, maintain, validate, and copy marketing list definitions stored in the AMS_LIST_HEADERS_ALL family of tables. The package is declared with AUTHID CURRENT_USER, meaning its unqualified references resolve under the privileges of the invoking session rather than the package owner, a design common to EBS private APIs that are called from within the AMS schema or from trusted public wrappers such as AMS_LISTHEADER_PUB.

The user search term "complete_listheader_rec" corresponds to the COMPLETE_LISTHEADER_REC procedure documented in the package header, which finalizes a fully populated list_header_rec_type record and persists it to the base tables. A companion routine, INIT_LISTHEADER_REC, initializes that record structure. The record type list_header_rec_type contains over seventy attributes covering identity columns, WHO audit columns, concurrent program context columns, list naming and classification, status, generation and de-duplication settings, workflow item key, and forecast, actual, and de-duplication dates. This record acts as the in-memory contract between the private API and its callers.

Key Procedures and Functions

The package exposes twelve documented procedures and functions. They are grouped by responsibility as follows.

• CREATE_LISTHEADER, UPDATE_LISTHEADER, DELETE_LISTHEADER, LOCK_LISTHEADER — the standard DML lifecycle for a list header, including the locking call used to obtain a row-level lock before updates in a multi-user environment.
• VALIDATE_LISTHEADER, VALIDATE_LIST_RECORD, VALIDATE_LIST_ITEMS — validation routines that check the header record and the associated list items and selection records against AMS setup and reference data before persistence.
• INIT_LISTHEADER_REC and COMPLETE_LISTHEADER_REC — initialize and finalize the list_header_rec_type record used throughout the package and by external callers constructing a list header programmatically.
• UPDATE_LIST_HEADER_COUNT and UPDATE_PREV_CONTACTED_COUNT — maintain cached counter columns on the list header, such as total entries and previously contacted contacts.
• COPY_LIST — duplicates an existing list header and its dependent entries for reuse.

No parameter signatures are invented here; callers should consult the package specification in the EBS instance for exact argument lists, as the ETRM excerpt documents only name and purpose.

Tables Accessed

The package reads and writes the AMS list header base, translation, and security tables, including AMS_LIST_HEADERS_ALL, AMS_LIST_HEADERS_ALL_TL, and AMS_LIST_HEADERS_ALL_S, which hold the header definition, its translatable name and description, and its security assignments respectively. It also touches AMS_LIST_ENTRIES and AMS_LIST_TMP_ENTRIES for list membership and staging, AMS_ACT_LISTS and AMS_CUSTOM_SETUPS_B for activity and setup validation, AMS_LIST_SELECT_ACTIONS, AMS_LIST_RULE_USAGES, AMS_LIST_SRC_TYPES, and AMS_LIST_SRC_TYPE_USAGES for generation and source-type configuration, and AMS_SOURCE_CODES for reference lookups. Date and language formatting rely on FND_LANGUAGES, while workflow-driven lists reference WF_ITEM_ACTIVITY_STATUSES. DUAL is used for scalar lookups and sequence-free derivations.

Usage Notes

AMS_LISTHEADER_PVT is a PVT-classified API and is not intended for direct invocation by customer forms or external integrations. It is referenced by sixteen other AMS packages, which cascade the private calls into public APIs, concurrent programs, and the Oracle Marketing forms. Typical invocation paths include list generation and de-duplication concurrent programs, the list administration forms, and custom code that calls the corresponding public wrapper. When extending or troubleshooting list header creation, the COMPLETE_LISTHEADER_REC and INIT_LISTHEADER_REC pair is the correct entry point for building a valid record, and callers must populate mandatory audit and classification columns before completion is attempted.