Search Results tbl_rowid_type

Overview

AMS_DEL_DISABLED_LIST_PVT is a private PL/SQL package body in the Oracle E-Business Suite 12.1.1 / 12.2.2 Marketing (AMS) module. Its business purpose is to provide the executable logic behind an AMS concurrent program that deletes disabled list entries. The package header comments identify the concurrent program as "AMS : Delete Disabled List Entries," with the short name AMSDDLEPRG, the executable AMSDDLEEX, and the valueset AMS_LIST. The package was created by ANNSRINI on 07-OCT-2010 and later modified by SARIFF on 02-DEC-2010, as recorded in the file header of amsvdleb.pls. The package is classified as PVT (private) under the APPS schema, meaning it is intended for internal invocation and is not a published public API.

The body declares several package-level constants and globals, including G_PKG_NAME, G_FILE_NAME, G_CURSOR_LIMIT (100000), and G_NUM_REC (100000), together with boolean debug and error flags driven by FND_MSG_PUB.CHECK_MSG_LEVEL. These conventions are standard across AMS private packages and provide instrumentation for FND debug logging.

Key Procedures and Functions

The package body documents a single procedure, DEL_DISABLED_LIST_ENTRIES. Per the documented comments, this is a private API requiring no pre-requisites. Its purpose is to serve as the executable for the concurrent program AMSDDLEPRG, and it accepts an IN parameter, p_list_name, of type VARCHAR2, which scopes the deletion to a specific list. The procedure also returns the standard concurrent program OUT parameters errbuf and retcode.

Within the procedure, the body declares a cursor c_list_entries_deleted that selects LIST_ENTRY_ROW_ID, LIST_HEADER_ID, and ROWID (aliased PURGE_ROWID) from AMS_LIST_ENTRIES_PURGE. It also defines the collection types TBL_ROWID_TYPE, LIST_NUM_TYPE, and the record type LIST_REC_TYPE, which combines a table of row identifiers, a table of list header numbers, and a table of purge row identifiers into l_list_rec. This is the point at which the user's search term "tbl_rowid_type" originates: TBL_ROWID_TYPE is a package-local PL/SQL associative-array type used to bulk-collect and process row identifiers efficiently. The record structure allows the procedure to process list header IDs and their associated rowids in bulk rather than row by row.

Tables Accessed

The package references three tables via APPS synonyms. AMS_LIST_ENTRIES_PURGE is the primary source table, read through the c_list_entries_deleted cursor to obtain the rows eligible for permanent removal together with their physical ROWID values. AMS_LIST_ENTRIES is the target marketing list entries table, referenced for the actual deletion of disabled list entries. PLITBLM is an Oracle interMedia (text) support table that is typically touched when text indexes or interMedia-managed columns on the affected rows require maintenance during deletion. The combination ensures that purged list entries and their associated indexed content are handled consistently.

Usage Notes

AMS_DEL_DISABLED_LIST_ENTRIES is invoked exclusively through the AMS concurrent program "AMS : Delete Disabled List Entries" (AMSDDLEPRG), whose executable is AMSDDLEEX and whose parameter is driven by the AMS_LIST valueset. Administrators schedule this program to remove disabled list entries in bulk, typically during housekeeping or data-cleanup windows. Because the package is classified PVT and is referenced by zero other packages, it is not designed to be called directly from forms or custom code; any custom integration should instead submit the concurrent program through the standard FND_REQUEST.SUBMIT_REQUEST mechanism, honoring the p_list_name parameter. Debug output can be enabled through the standard FND message-level settings, given the package's AMS_DEBUG_HIGH_ON, AMS_DEBUG_LOW_ON, AMS_DEBUG_MEDIUM_ON, and AMS_ERROR_ON flags.