Search Results ams_dmselection_pvt




Overview
Explore in AI Chat

Overview

AMS_DMSELECTION_PVT is a private PL/SQL package in the APPS schema belonging to the Oracle Advanced Marketing (AMS) module. Its name reflects its role in the "DM" (Direct Marketing or Data Mining/DM) subsystem, specifically handling the selection of targets from data sources against a defined model or set of conditions. The package provides the runtime engine that turns a stored data-mining or source definition into an actual, materialized set of selected target records — the population that downstream campaigns, lists, and scoring processes consume.

The package is classified as a PVT (private) API, meaning it is intended for internal use by other AMS packages rather than for direct invocation by external custom code. It is heavily integrated into the AMS data-mining and target-processing chain, as evidenced by its dependency graph. It references AMS_DM_SOURCE and AMS_DM_MODELS_ALL_B for its source and model definitions, and it is referenced by AMS_DMEXTRACT_PVT, AMS_DMSOURCE_PVT, AMS_DM_SCORE_PVT, AMS_SCORERESULT_PVT, AMS_WFMOD_PVT, and by itself, indicating recursive/internal orchestration.

Key Procedures and Functions

ETRM documents nine procedures and functions. Their purposes are:

  • PREVIEW_SELECTIONS — Produces a preview of the records that would be selected for a given data source/condition, enabling a user to validate selection criteria before committing.
  • AGGREGATE_SELECTIONS — Consolidates or aggregates the selection results, typically for summarizing selected counts or combining results.
  • SCHEDULE_PREVIEW — Registers or sets up a scheduled preview run, driving asynchronous preview execution.
  • SCHEDULE_AGGREGATION — Registers or sets up a scheduled aggregation run.
  • GET_TARGET_POSITIVE_VALUES — Returns the "positive" target values (the records satisfying the selection logic).
  • IS_B2B_DATA_SOURCE — Determines whether the data source in question is a B2B source, affecting how target selection is performed.
  • GET_WF_URL — Constructs the workflow URL used to link selection results to Oracle Workflow-driven processing.
  • GET_RELATED_DS_CONDITION — Retrieves the selection condition associated with a related data source.
  • IS_ORG_PROD_AFFN — Evaluates whether organization or product affinity applies to the selection, influencing target qualification.

Tables Accessed

The package reads and writes through APPS synonyms across the DM and campaign model. Key tables include AMS_DM_SOURCE and AMS_DM_SOURCE_S (source definitions and their translated/attribute rows), AMS_DM_TARGETS_B and AMS_DM_TARGET_SOURCES (target definitions and their source linkage), AMS_DM_TARGET_VALUES_B (target values), and AMS_DM_TARGET_STG_GT and AMS_DM_INT_SRC_STG_GT (global temporary staging tables used to hold intermediate selection/aggregation results). AMS_DM_MODELS_ALL_B and AMS_DM_SCORES_ALL_B support scoring integration, while AMS_DM_ORG_CONTACTS supplies contact-level selection data. AMS_CAMPAIGN_SCHEDULES_B and AMS_LIST_SELECT_ACTIONS and AMS_LIST_SRC_FIELDS connect selections to campaign schedules and list-building actions, and AMS_DISCOVERER_SQL and AMS_ACT_PRODUCTS support SQL-driven discovery and product associations.

Usage Notes

Because AMS_DMSELECTION_PVT is a private package, it is normally invoked indirectly by the public AMS data-mining packages (AMS_DMSOURCE_PVT, AMS_DMEXTRACT_PVT, AMS_DM_SCORE_PVT) rather than called directly from forms or concurrent programs. The presence of SCHEDULE_PREVIEW and SCHEDULE_AGGREGATION indicates it participates in concurrent-program-driven, asynchronous processing where selection previews and aggregations are queued. Customizations should avoid direct calls to this package; instead they should use the supported public AMS APIs, since Oracle may change this private package's interface without notice.