Search Results ams_dm_source_s

Overview

APPS.AMS_DMSELECTION_PVT is a private (PVT-classified) PL/SQL package body in the Oracle Marketing (AMS) module of Oracle E-Business Suite. It provides the internal processing engine that drives Oracle Marketing's Direct Marketing selection and aggregation framework. In the context of search terms such as ams_dm_source_s, this package is the component that resolves data sources, evaluates targeting criteria, and executes the extract logic that determines which customers, prospects, or organizations are eligible for a given marketing campaign, list, or direct mail effort.

The package belongs to the Oracle Marketing Direct Marketing (DM) sub-module superset. It operates against the AMS_DM_SOURCE, AMS_DM_SOURCE_S, AMS_DM_TARGETS_B, AMS_DM_TARGET_SOURCES, and AMS_DM_SCORES tables, and it orchestrates calls into companion packages such as AMS_DMEXTRACT_PVT, AMS_DISCOVERERSQL_PVT, AMS_ADV_FILTER_PVT, AMS_LISTACTION_PVT, and AMS_WFMOD_PVT. Because it is a private package, its procedures are not part of the public API surface and are invoked indirectly by these higher-level packages and by Oracle Marketing concurrent programs.

Key Procedures and Functions

• PREVIEW_SELECTIONS — Generates a preview of the records that would be selected by a given direct marketing source or target definition, allowing marketers to validate criteria before committing to a full extraction.
• AGGREGATE_SELECTIONS — Executes the full selection and aggregation run, consolidating qualifying records into staging and score tables for downstream campaign execution.
• SCHEDULE_PREVIEW — Schedules a preview run as a background process, typically for large data sources where interactive preview is impractical.
• SCHEDULE_AGGREGATION — Schedules the aggregation process as a concurrent request, supporting recurring or high-volume direct marketing selections.
• GET_TARGET_POSITIVE_VALUES — Retrieves the positive target values (the matching criteria set) for a target definition, used to drive the selection SQL.
• IS_B2B_DATA_SOURCE — Determines whether a given data source is business-to-business oriented, influencing the tables and joins used during selection.
• GET_WF_URL — Returns the Workflow URL associated with a selection or target, used for workflow notification and monitoring integration.
• GET_RELATED_DS_CONDITION — Builds the conditional clause for related data sources, supporting multi-source or dependent source selection logic.
• IS_ORG_PROD_AFFN — Tests whether an organization/affinity relationship exists, used to qualify organizational product affinity selections.

Tables Accessed

The package is documented as referencing a broad set of AMS and related application tables through APPS synonyms. Core direct marketing tables include AMS_DM_SOURCE and AMS_DM_SOURCE_S (source definitions), AMS_DM_TARGETS_B and AMS_DM_TARGET_VALUES_B (target definitions and their values), AMS_DM_TARGET_SOURCES (source-target mappings), AMS_DM_MODELS_ALL_B (models), AMS_DM_SCORES_ALL_B (scores), and AMS_DM_ORG_CONTACTS. Staging and temporary structures used during execution include AMS_DM_INT_SRC_STG_GT and AMS_DM_TARGET_STG_GT. Campaign and list metadata is read from AMS_CAMPAIGN_SCHEDULES_B, AMS_LIST_SELECT_ACTIONS, AMS_LIST_SRC_FIELDS, AMS_LIST_SRC_TYPES, and AMS_LIST_SRC_TYPE_ASSOCS. Customer and party data is sourced from HZ_CUST_ACCOUNTS, HZ_CUST_ACCOUNT_ROLES, HZ_PARTIES, and HZ_RELATIONSHIPS. Product data is read from MTL_SYSTEM_ITEMS_KFV, MTL_ITEM_CATEGORIES, and MTL_ITEM_CATEGORIES_V. Order and interaction data is drawn from OE_ORDER_HEADERS_ALL, OE_ORDER_LINES_ALL, JTF_IH_INTERACTIONS, and JTF_IH_RESULTS_B.

Usage Notes

As a private package, AMS_DMSELECTION_PVT is not called directly from Oracle Forms or from custom code; it is invoked by its public counterparts within the Oracle Marketing direct marketing stack, and the documented metadata notes that it is referenced by five other packages. Its procedures are typically triggered from the Oracle Marketing HTML user interface when a marketer previews, schedules, or executes a direct marketing selection, and from concurrent programs that process scheduled aggregations. Because it depends on FND_API, FND_GLOBAL, FND_MSG_PUB, and WF_CORE, it participates fully in the standard EBS API error-handling and workflow notification framework. Customizations that need to extend direct marketing selection logic should generally be implemented through the corresponding public APIs or by wrapping the documented procedures rather than by modifying this package directly, since it is a VALID, seeded APPS object subject to patching.