Search Results validate_listheader

Overview

APPS.AMS_LISTHEADER_PUB is the public application programming interface for Oracle Marketing list headers within Oracle E-Business Suite release 12.1.1 and 12.2.2. Marketing lists are the foundational containers used to group customers, prospects, and contacts for campaign targeting, list segmentation, and outbound marketing execution. A list header represents the top-level definition of such a list — its name, type, ownership, and status — and the detail lines that hold individual list members hang beneath it.

The package is classified as a PUB (public) API, meaning it is an officially supported entry point intended for external invocation rather than private internal use. It wraps the underlying private package AMS_LISTHEADER_PVT, which performs the actual table maintenance and business validation, and exposes a stable, FND_API-conformant interface so that callers do not need to manipulate the base marketing tables directly. Because it is AUTHID CURRENT_USER, it executes under the privileges of the calling schema. The version banner ($Header: amsplshs.pls 115.14) confirms this is a mature, long-lived component of the Advanced Marketing (AMS) product family.

Key Procedures and Functions

The package documents six procedures, all following the standard Oracle EBS API pattern (API version, initialization flag, commit flag, validation level, and return status / message count / message data out parameters):

• CREATE_LISTHEADER — Creates a new list header. Accepts a list header record structure from AMS_LISTHEADER_PVT and returns the primary key of the newly inserted record via x_listheader_id.
• UPDATE_LISTHEADER — Updates an existing list header. Raises an exception if the object_version_number does not match, providing optimistic locking; attributes passed as FND_API.g_miss_char/num/date are not updated.
• DELETE_LISTHEADER — Removes an existing list header.
• LOCK_LISTHEADER — Acquires a lock on the list header, typically used to serialize concurrent modification attempts.
• VALIDATE_LISTHEADER — Performs business-rule validation on a list header record without necessarily persisting it.
• COPY_LIST — Copies an existing marketing list, allowing users to replicate a list definition and its associated structure as the basis for a new list. This is the procedure most commonly associated with the "copy_list" search term.

Tables Accessed

The ETRM metadata does not enumerate specific base tables reached by this package; the documented table access is performed through APPS synonyms. Functionally, the package operates on the AMS list header entity and its supporting structures — a header table holding the list definition and a detail/association table holding list members — together with the standard marketing validation and lookup tables consulted by the private package during create and update processing. The copy_list procedure reads the source header and detail rows and writes corresponding new rows, remapping identifiers.

Usage Notes

APPS.AMS_LISTHEADER_PUB is typically invoked from Oracle Marketing Forms, from concurrent programs that build or refresh lists, and from custom PL/SQL integrations that need to create, maintain, duplicate, or delete marketing lists in a supported manner. Callers should always supply p_api_version, inspect x_return_status for FND_API.G_RET_STS_SUCCESS, and drain x_msg_count / x_msg_data on error. Commit behavior should be controlled explicitly through p_commit, and callers performing updates must populate object_version_number to satisfy the locking check. The package is referenced by three other packages, reflecting its role as a shared service within the AMS module.