Search Results delete_list_entries




Overview
Explore in AI Chat

Overview

AMS_LISTGENERATION_UTIL_PKG is a PL/SQL utility package belonging to the Oracle Advanced Marketing (AMS) application, which forms part of the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 marketing modules. The package body encapsulates the supporting logic required to manage the lifecycle of list generation, a core marketing operation in which target lists are built from source queries and stored as list entries. Its documented classification is "OTHER," indicating that it is an internal helper package rather than a public API contract. As the source header comment states, the package is primarily driven by a single entry point, cancel_list_gen, which in turn orchestrates the remaining procedures and functions. The package also exposes getWFItemStatus, noted explicitly as being callable from elsewhere, which links list generation to the Oracle Workflow engine. Together these routines support cancellation, deletion, header maintenance, concurrent processing control, and status interrogation for list generation runs, including those executed against remote data sources via database links.

Key Procedures and Functions

  • CANCEL_LIST_GEN — The principal public procedure and the only routine documented as being called directly to drive the package. It accepts a list header identifier along with remote-generation flags and a database link name, and returns standard API messaging outputs. It resolves the current status of the list, writes status information to the activity log, and raises the internal cancelexcep exception when cancellation cannot proceed.
  • DELETE_LIST_ENTRIES — Removes list entry records, typically invoked as part of the cancellation or regeneration flow to purge stale membership rows.
  • UPDATE_LIST_HEADER — Maintains the list header record, updating status and related control columns to reflect the outcome of processing.
  • GETWFITEMSTATUS — Retrieves the Oracle Workflow item status for a list generation process, enabling the package to determine whether an asynchronous generation has completed or failed. This function is documented as being called from outside the package.
  • ISLISTCANCELLING — A predicate used to determine whether a given list is currently in the process of being cancelled, which prevents conflicting concurrent operations.
  • START_CTRL_GRP_PROCESS — Initiates processing for a control group, used to coordinate batch list generation across related lists.
  • CANCEL_CTRL_GRP_PROCESS — The counterpart routine that terminates control group processing, including cleanup of associated list state.
  • GET_SPLIT_PREVIEW_COUNT — Returns a count used to preview how a list would be split, supporting the list segmentation features of Advanced Marketing.

Tables Accessed

  • AMS_LIST_HEADERS_ALL — The master list definition table; read to obtain status and updated to reflect cancellation or completion.
  • AMS_LIST_ENTRIES — Stores the generated membership rows; queried for counts and purged during cancellation.
  • AMS_LIST_SRC_TYPES — Defines the available list source types, used to resolve generation behavior.
  • AMS_LIST_SRC_TYPE_USAGES — Records which source types are in use, informing validation and processing paths.
  • PLITBLM — The standard EBS PL/SQL integer table type used for passing collections of identifiers between routines.

Usage Notes

The package is invoked from the Advanced Marketing list generation forms and from concurrent programs that build or refresh target lists. Its cancellation routines are typically called when a user aborts a long-running generation, and GETWFITEMSTATUS is used by wrapper code polling Workflow for completion. The remote-generation flags and database link parameter indicate support for distributed list generation across EBS instances. The package is referenced by two other packages, so customizations should call the documented public routines rather than altering private helpers. As an internal utility with an "OTHER" classification, it is not a supported integration API and may change between point releases.