Search Results ams_list_src_field_pvt_w




Overview
Explore in AI Chat

Overview

APPS.AMS_LIST_SRC_FIELD_PVT is a private PL/SQL package within the Oracle EBS Advanced Marketing (AMS) module. It serves as the internal implementation layer for managing list source fields — the configurable attribute columns that define which data elements can be captured, displayed, and processed for marketing list sources. List sources in AMS represent external or internal pools of prospects and customers, and the fields associated with each list source control how records are selected, filtered, and mapped during campaign list generation. The package is classified as PVT (private), meaning it is not intended for direct invocation by external consumers; instead, it is exposed through the public wrapper package AMS_LIST_SRC_FIELD_PUB, which enforces the standard Oracle EBS API contract for validation, error handling, and transaction control. The "_W" suffix referenced in the user search is a companion wrapper package (AMS_LIST_SRC_FIELD_PVT_W) that is generated to support the private package's public surface and dependency handling.

Key Procedures and Functions

The package exposes seven documented procedures, forming a standard CRUD-and-validation API pattern:

  • CREATE_LIST_SRC_FIELD — Inserts a new list source field definition, establishing the association between a field and its parent list source type.
  • UPDATE_LIST_SRC_FIELD — Modifies an existing list source field record, such as changing its display properties or association attributes.
  • DELETE_LIST_SRC_FIELD — Removes a list source field definition from the repository.
  • LOCK_LIST_SRC_FIELD — Acquires a row-level lock on the field record to ensure concurrency control during multi-step transactions.
  • VALIDATE_LIST_SRC_FIELD — Performs business-rule validation on field data prior to persistence, including attribute and reference checks.
  • CHECK_LIST_SRC_FIELD_ITEMS — Verifies whether dependent items exist for a given list source field, typically used before deletion to prevent orphaned references.
  • VALIDATE_LIST_SRC_FIELD_REC — Validates an entire field record structure, supporting bulk or record-level validation scenarios.

Tables Accessed

The package reads and writes the following tables via APPS synonyms:

  • AMS_LIST_SRC_FIELDS — The primary transactional table storing list source field definitions; the target of create, update, and delete operations.
  • AMS_LIST_SRC_FIELDS_S — The corresponding MLS (_S) table, holding translatable field attributes.
  • AMS_LIST_SRC_TYPES — The parent list source type definitions against which fields are validated.
  • AMS_LIST_SRC_TYPE_ASSOCS — Association records linking list source types to related entities, checked for referential integrity during validation.
  • DBA_TAB_COLUMNS — The data dictionary view queried to validate that referenced database columns exist for a given field mapping.
  • DUAL — Used for scalar and sequence expressions.
  • USER_SYNONYMS — Checked to confirm the presence of required synonyms for dynamically referenced objects.

Usage Notes

As a PVT package, AMS_LIST_SRC_FIELD_PVT should not be called directly by custom code. It is invoked by the AMS_LIST_SRC_FIELD_PUB public API, by the generated AMS_LIST_SRC_FIELD_PVT_W wrapper, by AMS_LISTSOURCETYPE_PVT, and recursively by itself. The public wrapper handles commit/rollback, savepoints, and FND_API-style error message stacking. Typical invocation originates from AMS setup forms where administrators define list source fields, from concurrent programs that configure list generation, and from the marketing list build process. Customizations should target the _PUB package, preserving the standard API contract and ensuring upward compatibility across EBS 12.1.1 and 12.2.2. Direct calls to the PVT layer risk bypassing validation and error-handling logic.