Search Results ams_imp_source_line

Overview

APPS.AMS_LISTDEDUPE_PVT is a private PL/SQL package within the Oracle Marketing (AMS) schema responsible for managing list deduplication information. Deduplication is the process by which Oracle Marketing identifies and eliminates duplicate entries from marketing lists before those lists are used for campaign execution, telemarketing, direct mail, or other outbound activities. Duplicate suppression protects an organization from contacting the same party multiple times, which reduces cost, preserves brand reputation, and satisfies internal contact-policy rules.

The package operates as a Private (PVT) API, meaning it is not intended for direct invocation by external consumers. It is instead called by other AMS components that orchestrate list processing. The package header declares AUTHID CURRENT_USER, so it executes with the privileges of the calling user rather than the definer. Originally created in June 1999, the package was renamed and revised over the following months, and in November 1999 the Generate_Key routine was relocated here from AMS_PartyImport_PVT, consolidating key-generation logic within the deduplication component.

Key Procedures and Functions

• FILTER_WORD — A function that replaces noise words within the relevant fields of AMS_LIST_ENTRIES. It accepts a word, a substring length from the list rule, and the field table and column names that identify which list-rule field is being processed, returning the filtered string result.
• DEDUPE_LIST — The core deduplication routine. It drives the comparison and elimination of duplicate list entries based on the configured list rules.
• GENERATE_KEY — Produces the deduplication key used to match records against one another. This routing was migrated from AMS_PartyImport_PVT to centralize key building with the dedupe logic.
• REPLACE_WORD — Supports word-level replacement, working in conjunction with HZ_WORD_REPLACEMENTS to normalize text during filtering so that variant spellings or abbreviations match correctly.

Tables Accessed

The package reads and writes a set of AMS list configuration and data tables, accessed through APPS synonyms:

• AMS_LIST_HEADERS_ALL — The parent header record identifying the marketing list being processed.
• AMS_LIST_ENTRIES — The individual list members that are filtered and deduplicated.
• AMS_LIST_RULES_ALL, AMS_LIST_RULE_FIELDS, and AMS_LIST_RULE_USAGES — Define how deduplication is performed, which fields participate, substring lengths, and rule application scope.
• AMS_LIST_WORD_FIELDS — Identifies which list fields are subject to word-level filtering.
• AMS_LIST_SELECT_ACTIONS — Governs selection behavior tied to list processing.
• HZ_WORD_REPLACEMENTS — Supplies noise-word and replacement definitions.
• DBMS_SQL and PLITBLM — Oracle-supplied utilities used for dynamic SQL construction and PL/SQL table (index-by) management respectively.

Usage Notes

Because this is a private API, it is invoked indirectly. Within Oracle EBS 12.1.1 and 12.2.2 it is referenced by three other packages, which supply the driving logic for list import and list processing. Typical entry points include the list import routines that stage records through AMS_IMP_SOURCE_LINE and the marketing list management flows exposed through the Oracle Marketing forms and concurrent programs. Administrators should not call this package directly; customization or extension should occur through the public AMS list APIs or by wrapping the private routines with appropriately privileged code. As with any AUTHID CURRENT_USER package, callers must possess the necessary object privileges on the referenced AMS and HZ tables, and any schema changes to the underlying list rule configuration will directly alter deduplication behavior.