Search Results validate_filter_row_rec

Overview

AMS_ADV_FILTER_PVT is an Oracle Applications private PL/SQL package owned by the APPS schema that supports the Oracle Marketing (AMS) module's advanced filtering and list-selection infrastructure. It provides the underlying programmatic logic used to define, maintain, and validate the filter criteria that drive targeted marketing list generation and campaign audience selection. Advanced filters in Oracle Marketing allow marketers to build complex, multi-condition selection rules against customer and prospect data sources. This package encapsulates the private implementation logic that creates, modifies, deletes, and validates those filter definitions.

The package is classified as a PVT (private) API, meaning it is intended strictly for internal use by other Oracle Marketing packages rather than for direct invocation by customers or external integrations. Consistent with this classification, the ETRM metadata documents eight internal procedures and functions that form a closed set of operations governing the filter record lifecycle. The package is marked VALID in the APPS schema and conforms to the Oracle EBS standard that private APIs leverage shared services such as FND_API for error handling and message management.

Key Procedures and Functions

The eight documented entry points cover the full lifecycle of an advanced filter row:

• CREATE_FILTER_ROW — Inserts a new advanced filter record, establishing the base filter definition.
• UPDATE_FILTER_ROW — Modifies an existing filter record's attributes.
• DELETE_FILTER_ROW — Removes a filter record.
• VALIDATE_FILTER_ROW — Performs validation on a filter row against business rules before persistence.
• VALIDATE_FILTER_ROW_REC — A record-based variant of validation, accepting a structured record for bulk or set-based processing.
• CHECK_FILTER_ITEMS — Verifies the individual filter items (criteria components) attached to a filter.
• GET_FILTER_DATA — Retrieves filter data for downstream consumption.
• COPY_FILTER_DATA — Duplicates existing filter definitions, supporting reuse of filter templates.

Tables Accessed

The package operates against several AMS and JTF tables through APPS synonyms:

• AMS_LIST_SRC_FIELDS, AMS_LIST_SRC_TYPES, AMS_LIST_SRC_TYPE_ASSOCS — define the available list source fields and their associations, providing the metadata against which filters are constructed.
• JTF_PERZ_PROFILE, JTF_PERZ_QUERY, JTF_PERZ_QUERY_PARAM, JTF_PERZ_QUERY_PARAM_S — the personalization/query engine tables that store parameterized queries and their parameters, used to persist and resolve filter criteria.
• DUAL — used for standard single-row SQL operations.
• PLITBLM — the PL/SQL integer table type used for set-based ID handling.

Usage Notes

As a PVT-class API, AMS_ADV_FILTER_PVT is not called directly from forms or concurrent programs. Instead it is referenced by three documented packages — AMS_DMSELECTION_PVT, AMS_DM_MODEL_PVT, and AMS_DM_SCORE_PVT — which handle list selection, data-mining model management, and scoring respectively, along with a self reference. It depends on FND_API and the STANDARD package for standard EBS API error and exception handling. Custom code should invoke the public callers rather than this private package, and any direct dependency carries upgrade risk across releases.