Search Results ams_del_disabled_list_pvt

Overview

AMS_DEL_DISABLED_LIST_PVT is a private PL/SQL package owned by the APPS schema in Oracle E-Business Suite. It belongs to the Oracle Marketing (AMS) product family and, more specifically, to the list management infrastructure that supports campaign and marketing list processing. The package is classified as PVT, meaning it is an internal, private API rather than a public, supported interface. It is not intended to be called directly by customer extensions or third-party integrations; instead it is invoked by other components of the Oracle Marketing application, typically through a concurrent program or an internal calling layer.

The package name describes its purpose precisely: deletion of disabled list entries. In Oracle Marketing, a marketing list consists of list entries — individuals, accounts, contacts, or other entities targeted by a campaign. Over time, entries within a list may become disabled, for example because a customer has opted out, a record has been marked inactive, or a suppression rule has been applied. The package provides the mechanism to purge those disabled entries from the active list and move or stage them accordingly, keeping the active list clean and consistent for downstream campaign execution.

Originally created on 07-OCT-2010 by the developer identified as ANNSRINI, the package carries the source file header amsvdles.pls and was last modified in January 2011. The package is declared with AUTHID CURRENT_USER, so it executes with the privileges of the calling user rather than the definer, which is a common pattern in EBS private utility packages that operate on session-owned data.

Key Procedures and Functions

The package exposes a single documented procedure:

• DEL_DISABLED_LIST_ENTRIES — The sole public procedure in the package. Based on its name and the package context, it deletes disabled entries belonging to a specified marketing list. It accepts a list name to identify the target list and returns the standard concurrent program OUT parameters errbuf and retcode, which report error messages and completion status to the concurrent manager. This signature pattern confirms that the procedure is designed to run as, or be driven by, a concurrent program rather than being called interactively from a form.

No functions or additional overloaded procedures are documented in the package specification. The internal private types and helper routines, if any, are not part of the documented interface.

Tables Accessed

Three tables are referenced through APPS synonyms:

• AMS_LIST_ENTRIES — The primary marketing list entry table. The procedure reads this table to identify entries that are disabled and removes them from the active list.
• AMS_LIST_ENTRIES_PURGE — A purge or staging table that retains list entries removed from the active list. Deleted or disabled entries are likely moved here to preserve an audit trail or to support cleanup processing before permanent removal.
• PLITBLM — A PL/SQL internal table type used by Oracle Forms and EBS utilities for array processing and bulk operations. Its presence indicates that the procedure performs set-based or bulk DML against the list entry tables rather than row-by-row processing.

Usage Notes

Because AMS_DEL_DISABLED_LIST_PVT is a private package, it should not be invoked directly from custom code. It is invoked internally by the Oracle Marketing module, most commonly through a concurrent program that passes the target list name and receives the standard errbuf and retcode outputs. Administrators and developers encountering this package while troubleshooting a marketing list cleanup, a purge job, or a concurrent request that removes disabled list entries should treat it as a supporting internal routine. Referenced by no other documented packages, it sits at the leaf of the calling hierarchy, invoked only by the concurrent program or form that owns the delete operation. Modifying or calling it outside its intended caller context risks data inconsistency between AMS_LIST_ENTRIES and AMS_LIST_ENTRIES_PURGE.