Search Results check_list_src_field_items

Overview

APPS.AMS_LIST_SRC_FIELD_PVT_W is a private PL/SQL API wrapper within the Oracle EBS Marketing (AMS) module. It governs the metadata that describes the individual source fields belonging to a marketing list source. In the AMS data model, a list source represents an origin of customer or prospect records (for example, a campaign, a query, or an imported file), and each list source exposes one or more selectable fields. AMS_LIST_SRC_FIELD_PVT_W provides the programmatic substrate that the public AMS List Source Field APIs and the corresponding Oracle Forms screens use to create, maintain, validate, and enumerate those field definitions.

The package name carries the _PVT_W suffix, identifying it as a private wrapper generated for the PL/SQL-to-Java (JTF) interoperability layer. That layer relies on the rosetta table-copy routines to marshal data between EBS database types and Java-side collection types. The header revision ($Header: amswlsfs.pls 115.13) indicates the file is a long-standing component last modified in 2004, consistent with the maturity of the Marketing foundation schema in releases 12.1.1 and 12.2.2, where 12.2.x is the online-patching release train and 12.1.1 the earlier 11g-based platform.

Key Procedures and Functions

• ROSETTA_TABLE_COPY_IN_P3 — Bulk-loads a PL/SQL collection of list source field records from a parallel set of JTF typed tables (JTF_NUMBER_TABLE, JTF_DATE_TABLE, JTF_VARCHAR2_TABLE_100/200) into the internal list_src_field_tbl_type. The many a0–a28 arguments correspond to the individual attributes of a source field row.
• ROSETTA_TABLE_COPY_OUT_P3 — Performs the inverse operation, decomposing an internal list_src_field_tbl_type collection into the JTF typed tables expected by the Java wrapper.
• CREATE_LIST_SRC_FIELD — Inserts a new source field definition, associating the field with its parent list source and recording its descriptive metadata.
• UPDATE_LIST_SRC_FIELD — Modifies the editable attributes of an existing source field record.
• VALIDATE_LIST_SRC_FIELD — Performs row-level validation for a single field definition before persistence.
• CHECK_LIST_SRC_FIELD_ITEMS — The procedure most commonly sought by the search term "check_list_src_field_items." It verifies the field items associated with a list source, typically to confirm that item or value assignments exist and are consistent before the list source is used.
• VALIDATE_LIST_SRC_FIELD_REC — Applies validation logic across a complete record or collection rather than a single row.

Tables Accessed

The documented table reference for this package is PLITBLM (accessed through an APPS synonym). PLITBLM is the Marketing "list table" structure that stores the tabular data generated for a marketing list source, including the columns that correspond to the source fields defined through this package. The validation and check routines read from this structure, while the create and update routines indirectly support the field definitions that determine how PLITBLM content is interpreted. No additional base tables are documented in the ETRM metadata.

Usage Notes

AMS_LIST_SRC_FIELD_PVT_W is not intended for direct invocation by end users or customer code. It is called by the public AMS list source field APIs and by the Marketing list source Oracle Forms, which supply field values, trigger validation, and persist changes. Because the package references APPS synonyms and is a private wrapper, customizations should target the corresponding public API rather than this package. Developers troubleshooting list source field creation or validation should inspect the CHECK_LIST_SRC_FIELD_ITEMS and VALIDATE_LIST_SRC_FIELD_REC routines, as these carry the logic most often implicated in field-item errors. ETRM records zero dependent packages, confirming its role as a leaf-level implementation unit beneath the public AMS interfaces.