Search Results ams_listaction_pvt




Overview
Explore in AI Chat

Overview

APPS.AMS_LISTACTION_PVT is a private (PVT-classified) PL/SQL package body that forms part of the Oracle Marketing (AMS) module's list management infrastructure in Oracle E-Business Suite 12.1.1 and 12.2.2. Its principal business function is to manage the lifecycle of "list actions" — the discrete, record-level operations that are associated with a marketing list selection and applied to the members of that list. A list action represents an outcome decision for a party or record within a list, such as an inclusion, exclusion, or assignment action generated during list processing.

As a private API, the package is not intended for direct invocation by external consumers. It exposes the DML and validation logic that the public-facing list management APIs and the marketing candidate/list selection workflow rely upon internally. The package follows the standard EBS private API conventions, leveraging FND_API for the common error and return-status framework, FND_MSG_PUB and FND_MESSAGE for message stack handling, FND_GLOBAL for session context, and JTF_PLSQL_API for the shared PL/SQL utility interface.

Key Procedures and Functions

The package documents seven procedures and functions, organized around the standard CRUD-plus-validation pattern used throughout the AMS list APIs:

  • CREATE_LISTACTION — Inserts a new list action record, populating the base and translated tables with the supplied action attributes.
  • UPDATE_LISTACTION — Modifies the attributes of an existing list action record.
  • DELETE_LISTACTION — Removes a list action record from the underlying tables.
  • LOCK_LISTACTION — Acquires a row-level lock on the specified list action to serialize concurrent modifications.
  • VALIDATE_LISTACTION — Performs business-rule validation on the list action attributes prior to persistence, returning API-style status and messages.
  • INIT_ACTION_REC — Initializes the record structure used internally to carry list action data between procedures.
  • COMPLETE_ACTION_REC — Finalizes or completes the internal action record, typically resolving derived or defaulted values before the record is written.

Tables Accessed

The package operates against the following documented tables through APPS synonyms:

  • AMS_LIST_SELECT_ACTIONS — The base table storing list action definitions and their attributes; the primary target of create, update, delete, and lock operations.
  • AMS_LIST_SELECT_ACTIONS_S — The translation (TL) shadow table holding language-specific or seeded values for the list action records, maintained in parallel with the base table.
  • DUAL — Used for single-row utility queries such as sequence value retrieval or expression evaluation.

In addition, the package depends on AMS_DM_MODEL_PVT, AMS_DM_SCORE_PVT, AMS_LISTHEADER_PVT, and AMS_UTILITY_PVT for related list-header and data-mining functionality, and on the standard FND and JTF foundation packages. It is referenced by ten other database objects, confirming its role as an internal dependency rather than an entry point.

Usage Notes

APPS.AMS_LISTACTION_PVT is invoked indirectly through the AMS list management stack rather than being called directly by forms, concurrent programs, or custom code. Its procedures execute when list actions are created, updated, deleted, or locked as part of list selection and list processing flows. Because the package is classified PVT, Oracle does not guarantee API stability for direct callers; integrators should route list action maintenance through the supported public list APIs or the Marketing user interface. Direct calls are appropriate only for diagnostics or read-only inspection, and any use should account for the package's internal calls to LOCK_LISTACTION to manage concurrency.