Search Results g_list_header_id

Overview

APPS.AMS_LISTGENERATION_PKG is the core PL/SQL package responsible for the generation of all Oracle Marketing defined lists within Oracle E-Business Suite Release 12.1.1 and 12.2.2. Lists are the fundamental audience-construction mechanism in Oracle Marketing: they define which customers, prospects, or contacts qualify for a campaign, and the entries produced by this package drive downstream activities such as campaign scheduling, telemarketing call lists, and one-to-one marketing execution.

The package body carries a header revision of 120.33.12010000.2, reflecting a long maintenance history beginning in 1999. The header comments trace iterative fixes for SQL validation defects, deduplication behavior, bind-variable performance tuning, and list generation cancellation. The package is classified under ETRM as "OTHER" rather than a public API, indicating that it is primarily an internal engine invoked by Oracle Marketing forms and concurrent programs. The user search term g_list_header_id refers to the package-level global variable that holds the identifier of the list header currently being processed; this variable is central to the package's design because nearly every internal routine operates within the context of a single list header identified by this value.

Key Procedures and Functions

The package exposes 37 documented procedures and functions. The principal entry points and their roles are:

• GENERATE_LIST — Master driver that performs generation for a list header, coordinating source processing, selection, and entry insertion.
• PROCESS_LIST — Orchestrates processing logic for the list identified by the active list header context.
• PROCESS_STANDARD, PROCESS_SQL, PROCESS_MANUAL, PROCESS_CELL, PROCESS_DIWB — Source-specific processors: standard, SQL-query-based, manual, cell-based, and discoverer workbook sources respectively.
• PROCESS_IMPH — Handles import list headers, supporting externally supplied list definitions.
• CREATE_LIST, CREATE_IMPORT_LIST, CREATE_LIST_FROM_QUERY — Creation routines for defined lists, import lists, and query-derived lists.
• INSERT_LIST_MAPPING_USAGE — Records mapping usage for the list being generated.
• GET_LIST_ENTRY_DATA, UPDATE_LIST_DETS — Retrieves and persists list entry detail rows.
• VALIDATE_SQL_STRING — Validates user-supplied SQL used by SQL-based list sources.
• GET_MASTER_TYPES, GET_CHILD_TYPES — Retrieve source type hierarchies used to resolve list source configuration.
• GENERATE_TARGET_GROUP — Produces the target group associated with generated list output.
• EXECUTE_REMOTE_DEDUPE_LIST, MIGRATE_LISTS_FROM_REMOTE — Support distributed/remote list deduplication and list migration from remote instances, governed by the g_remote_list flag.

Tables Accessed

The package reads and writes several core Marketing tables through APPS synonyms:

• AMS_LIST_HEADERS_ALL — The list header record that anchors generation; g_list_header_id identifies the active row.
• AMS_LIST_ENTRIES — Stores the generated list entry rows produced by generation runs.
• AMS_LIST_SELECT_ACTIONS — Defines inclusion/exclusion selection actions applied when building entries.
• AMS_LIST_SRC_TYPES and AMS_LIST_SRC_TYPE_ASSOCS — Source type definitions and associations used to determine how each list is sourced.
• AMS_DISCOVERER_SQL, AMS_DS_TCA_ENTITY_COLS — Discoverer workbook SQL and TCA entity column metadata for DIWB/analytical sources.
• AMS_CELLS_ALL_B — Cell definitions referenced by cell-based list processing.
• AMS_ACT_LISTS, AMS_ACT_DISCOVERER_ALL — Activity-to-list and Discoverer activity associations.
• AMS_ACT_LOGS, AMS_ACT_LOGS_S, AMS_ACT_LOGS_TRANSACTION_ID_S — Logging and sequence tables used to record generation activity and support cancellation.
• AMS_CAMPAIGN_SCHEDULES_B — Campaign schedule information consulted during generation.
• AMS_IMP_LIST_HEADERS_ALL — Import list header definitions used by PROCESS_IMPH.

Usage Notes

AMS_LISTGENERATION_PKG is invoked primarily from Oracle Marketing list management forms and from concurrent programs that execute list generation in the background, including scheduled and cancellable runs. Because the package is designated as "OTHER" and is referenced by ten other packages, custom code should treat it as an internal engine rather than a formally guaranteed public API; direct invocation is possible but should be limited to controlled extensions that reproduce the calling conventions used by the standard concurrent programs.

When extending or debugging generation logic, note that the package relies on package-level globals such as g_list_header_id, g_remote_list, and the row-count variables to carry context between internal routines. Any custom wrapper must therefore establish the list header context before calling generation procedures, and should expect logging rows in AMS_ACT_LOGS and list output in AMS_LIST_ENTRIES.