Search Results ams_imp_list_headers_all_s

Overview

AMS_IMPORT_LIST_PVT is an internal PL/SQL package body in the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 releases, owned by the APPS schema and classified as a private (PVT) API within the Oracle Marketing (AMS) module. Its principal responsibility is the import of marketing list headers — the container metadata for target lists, mailing lists, and campaign audience definitions — from staging and interface structures into the permanent marketing repository. List import is a foundational operation in Oracle Marketing because imported lists drive campaign assignment, telemarketing dialing, direct mail, and downstream analytics. The package body is the implementation unit behind the AMS_IMPORT_LIST public API family; it is not referenced by any database object, which is consistent with its role as a leaf-level implementation package invoked only by application code, concurrent programs, and the list import concurrent manager processes. Because it is a private package, it is not intended for direct customer invocation, and Oracle does not guarantee its signature across patch levels.

Key Procedures and Functions

The documented interface exposes nine procedures that cover the full import lifecycle:

• DO_RECURRING — Handles repeated or scheduled import executions, allowing a previously defined import list request to be re-processed on the recurrence defined for the import.
• DUPLICATE_IMPORT_LIST — Creates a copy of an existing import list definition, preserving selection criteria so that variants of a list can be imported without redefinition.
• CREATE_IMPORT_LIST — Inserts a new import list header record, establishing the parent row for subsequent detail and security processing.
• UPDATE_IMPORT_LIST — Modifies attributes of an existing import list header, including descriptive and status-related columns.
• DELETE_IMPORT_LIST — Removes an import list header and its associated import bookkeeping.
• LOCK_IMPORT_LIST — Acquires a logical lock on an import list header to serialize concurrent modification and prevent conflicting imports.
• VALIDATE_IMPORT_LIST — Performs business-rule validation of an import list definition before it is persisted or executed.
• CHECK_AMS_IMPORT_ITEMS — Verifies the constituent import items belonging to a list, typically confirming that referenced records exist and are eligible.
• VALIDATE_AMS_IMPORT_REC — Validates a single import record as it is staged for loading, applying column-level and reference integrity checks.

Supporting procedures invoke AMS_IMPORT_SECURITY_PVT for security enforcement, AMS_UTILITY_PVT for shared marketing utilities, and the FND_API, FND_GLOBAL, JTF_PLSQL_API, and FND_MSG_PUB APIs for API error handling, message stacking, and global context.

Tables Accessed

The package operates against the AMS_IMP_% interface tables through APPS synonyms. AMS_IMP_LIST_HEADERS_ALL is the primary store of import list header rows; AMS_IMP_LIST_HEADERS_ALL_S is the corresponding sequence or surrogate-key structure used during insert processing, and is directly relevant to the search term "ams_imp_list_headers_all_s" that surfaces this object. AMS_IMP_DOCUMENTS holds document/attachment linkages associated with imported lists. AMS_USER_STATUSES_B supplies the user-defined status codes that govern list lifecycle state. AS_IMPORT_INTERFACE_S provides the sequence for interface record identifiers, and DUAL is used for scalar lookups and sequence retrieval. AMS_IMP_LIST_HEADERS_PKG and AMS_IMP_LIST_HEADERS_VL provide the header entity's package logic and translated view access.

Usage Notes

AMS_IMPORT_LIST_PVT is normally invoked indirectly. The standard entry points are the Oracle Marketing List Import concurrent program, the Import Lists web-based forms in the Marketing responsibility, and the public wrapper packages in the AMS_IMPORT_LIST family. The package may also be called from customer-developed concurrent programs or PL/SQL that perform high-volume list loading, provided the calling code handles the FND_MSG_PUB message stack consistently with Oracle's API conventions. Two EBS packages reference AMS_IMPORT_LIST_PVT, confirming its internal dependency position. Because the package is private and possesses no documented public signature, customizations should call the public AMS_IMPORT_LIST API instead. The object's status is VALID in both 12.1.1 and 12.2.2, indicating no known invalidations introduced by the Online Patching (adop) cycle or by the 12.2 file system editioning model.