Search Results create_list_src_field

Overview

The PL/SQL package body APPS.AMS_LIST_SRC_FIELD_PUB is a public API component within the Oracle Marketing (AMS) module of Oracle E-Business Suite. It manages list source field definitions, which govern the metadata structure used when importing or building marketing lists from external or internal data sources. Each list source field describes the columns that a source query or file must return so that marketing lists can be populated and mapped correctly. The package is classified as a PUB API, meaning its procedures form a supported, versioned interface intended for invocation by forms, concurrent programs, workflows, and custom extensions rather than ad hoc SQL.

The package header constants identify it as AMS_List_Src_Field_PUB, sourced from amsplsfb.pls. Because it follows the Oracle Application Object Library (AOL) API conventions, it is a thin public wrapper over a private package (AMS_List_Src_Field_PVT) and relies on FND_API, FND_MSG_PUB, and AMS_UTILITY_PVT for compatibility checking, message handling, and debugging.

Key Procedures and Functions

The package exposes four documented procedures:

• CREATE_LIST_SRC_FIELD — Creates a new list source field record. This is the procedure associated with the create_list_src_field call. The signature accepts a standard API version number, an init message list flag, a commit flag, an IN record of type list_src_field_rec_type, and returns a return status, message count, message data, and an OUT list source field identifier.
• UPDATE_LIST_SRC_FIELD — Modifies an existing list source field definition.
• DELETE_LIST_SRC_FIELD — Removes a list source field definition.
• LOCK_LIST_SRC_FIELD — Acquires a lock on a list source field record, supporting concurrency control when multiple sessions edit the same definition.

The public CREATE_LIST_SRC_FIELD begins by issuing a savepoint, calls FND_API.Compatible_API_Call to verify caller/API version compatibility, raises FND_API.G_EXC_UNEXPECTED_ERROR on mismatch, optionally initialises the message stack, and emits debug messages when AMS_DEBUG_HIGH_ON is enabled.

Tables Accessed

The supplied ETRM metadata does not list explicit table references through APPS synonyms. Based on the module's domain, the package operates against the marketing list source field tables — principally AMS_LIST_SRC_FIELDS — via the corresponding private package, which performs the actual DML. Reads and writes are packaged behind the public API so that validation and message handling remain consistent, and no direct DML should be issued against the underlying tables by callers.

Usage Notes

AMS_LIST_SRC_FIELD_PUB.CREATE_LIST_SRC_FIELD is typically invoked from the Marketing List Source setup forms, from concurrent programs that seed or import list source definitions, and from custom PL/SQL that integrates external data sources. Callers must pass p_api_version_number, honour the p_init_msg_list and p_commit flags, and inspect x_return_status (FND_API.G_RET_STS_SUCCESS, G_RET_STS_ERROR, or G_RET_STS_UNEXPECTED_ERROR) along with x_msg_count and x_msg_data. The ETRM metadata records that no other packages reference this one, so it is a top-level entry point. It is supported in both EBS 12.1.1 and 12.2.2, and its version constant remains 1.0.