Search Results ams_list_src_fields_pkg




Overview
Explore in AI Chat

Overview

AMS_LIST_SRC_FIELDS_PKG is an Oracle Application Object Library (APPS) schema package within the Oracle Marketing (AMS) module of Oracle E-Business Suite. Its purpose is to provide the low-level data access and maintenance layer for the AMS_LIST_SRC_FIELDS entity, which defines the individual source fields available to marketing list generation and list source definitions. In ETRM terms the package is classified as an OTHER API, meaning it is not a formally published business API but an internal, table-oriented access package. It sits beneath the public package AMS_LIST_SRC_FIELD_PVT (the "private" or implementation package) and exposes row-level operations on the underlying tables. The package status is VALID in the documented 12.2.2 environment, and the same object exists in 12.1.1. Its SQL-level dependencies are limited to SYS.STANDARD, indicating that the package body is largely procedural DML against the AMS tables rather than a deep dependency tree. Versioning, the preservation of owner and status metadata, and relationship to the marketing list infrastructure make it a supporting component in the list source configuration subsystem.

Key Procedures and Functions

The package documents seven procedures/functions:

  • INSERT_ROW — Inserts a new list source field row into the base table.
  • UPDATE_ROW — Modifies an existing list source field row.
  • DELETE_ROW — Removes a list source field row.
  • LOCK_ROW — Acquires a pessimistic lock on the target row, typically used to serialize concurrent updates in a multi-user forms environment.
  • LOAD_ROW — Performs the canonical create-or-update operation, loading a complete row into the table without raising the "row already exists" condition.
  • ADD_LANGUAGE — Creates translated (TL) rows for all enabled languages, populating the translatable columns of AMS_LIST_SRC_FIELDS_TL.
  • TRANSLATE_ROW — Updates a single translation row for a specific language, used for language-specific maintenance.

Parameter lists are not published in the ETRM metadata and should be verified against the package specification in the target instance.

Tables Accessed

The package operates on the following documented tables through APPS synonyms:

  • AMS_LIST_SRC_FIELDS — the base (non-translatable) table holding list source field definitions.
  • AMS_LIST_SRC_FIELDS_S — the sequence/identifier table used to generate primary keys.
  • AMS_LIST_SRC_FIELDS_TL — the translation table holding language-specific descriptive text.
  • FND_LANGUAGES — the installed-language reference table, consulted by ADD_LANGUAGE to determine which languages require translation rows.
  • DUAL — used for single-row operations, sequence value retrieval, and similar lookups.

Collectively these tables support the definition, identification, and multilingual presentation of marketing list source fields.

Usage Notes

AMS_LIST_SRC_FIELDS_PKG is an internal layer that is normally invoked indirectly. The primary consumer is AMS_LIST_SRC_FIELD_PVT, which encapsulates this package; the ETRM metadata records exactly one referenced-by package. In practice the package is exercised through Oracle Forms-based list source setup and through concurrent programs that seed or migrate list source field metadata. LOAD_ROW and ADD_LANGUAGE are the entry points most often used in setup and translation-loading scripts, since they are idempotent and language-aware. Direct calls from custom code are possible but discouraged; developers should prefer the corresponding private package (AMS_LIST_SRC_FIELD_PVT) or the public marketing list APIs, which enforce validation and business rules that this package does not. When invoking the package directly, standard APPS initialization (FND_GLOBAL.APPS_INITIALIZE) must be performed so that the correct organization and language context is established, and the caller should respect the lock-before-update pattern established by LOCK_ROW.