Search Results create_source_view

Overview

APPS.AMS_LIST_MAINT_PVT is a private (PVT-classified) PL/SQL package body within the Oracle Advanced Marketing (AMS) module of Oracle E-Business Suite. It provides the core maintenance and lifecycle logic for marketing lists — the named collections of customers, prospects, or other entities that drive campaign targeting and list generation. The package encapsulates the procedural logic used when a user creates, copies, schedules, or submits a marketing list for generation, as well as when the system must validate whether a list is already associated with other objects.

The specification header identifies the source file as amsvlmgb.pls (version 115.38, last shipped 2002/11/20). Because the package is classified as PVT, it is intended to be called by other AMS packages and by the Oracle Forms-based list maintenance UI rather than directly by external or customer-written code.

Key Procedures and Functions

The documented interface exposes six procedures, each addressing a discrete stage of the marketing list lifecycle:

• CREATE_SOURCE_VIEW — Builds the source view that materializes the records selected for a marketing list, drawing from the configured source types and source fields.
• COPY_LIST — Duplicates an existing list header and its associated entries, enabling users to derive a new list from a template or prior list definition.
• CHECK_LIST_ASSOCIATION — Validates whether a given list is already associated with other objects (for example, campaigns or selections), returning a status that callers use to prevent conflicting operations.
• SCHEDULE_LIST — Applies scheduling metadata so that a list can be processed or refreshed according to a defined schedule.
• SUBMIT_LIST_FOR_GENERATION — Submits the list for generation, typically driving the concurrent process that populates list entries.
• CREATE_DISCOVERER_URL — Constructs a URL that launches Oracle Web Discoverer for the list, allowing users to analyze list data interactively.

In addition to these procedures, the package body declares global package variables including g_sqlerrm and g_sqlcode — both VARCHAR2(500) — which are used to capture the Oracle error message and SQL return code during execution. This pattern is the reason the object surfaces in searches for g_sqlcode: the variable is the standard error-capture mechanism used throughout the package's exception handlers, allowing the caller to retrieve the most recent SQL error state. The body also declares g_listheader_rec and g_listaction_rec record variables, plus debug-level flags derived from FND_MSG_PUB.CHECK_MSG_LEVEL.

Tables Accessed

The package reads and writes the following tables through their APPS synonyms:

• AMS_LIST_HEADERS_ALL — Stores the header definition for each list (name, type, status, and descriptive attributes).
• AMS_LIST_ENTRIES — Holds the individual members selected into a list.
• AMS_LIST_SELECT_ACTIONS — Records the selection actions applied when building list membership.
• AMS_LIST_SRC_FIELDS — Defines the available fields from which list sources draw data.
• AMS_LIST_SRC_TYPES — Defines the source types (for example, tables or views) that can back a list.
• AMS_LIST_SRC_TYPE_ASSOCS — Establishes the association between source types and source fields.
• AD_DDL — The Applications DDL utility table used when the package creates the list source view dynamically.

Usage Notes

AMS_LIST_MAINT_PVT is invoked primarily from the Oracle Forms list maintenance interface and from other AMS packages; the ETRM metadata records zero external packages referencing it, confirming its internal, implementation-layer role. Developers should not call it directly from custom code without first confirming interface stability, since it is a private package. When troubleshooting failures, inspecting g_sqlcode and g_sqlerrm after a call provides the captured SQL error state, and the package's debug flags can be enabled through the standard FND message-level mechanism to trace execution.