Search Results complete_action_rec

Overview

AMS_LISTACTION_PVT is a private (PVT classification) PL/SQL package owned by the APPS schema in Oracle E-Business Suite, first delivered in release 11i and carried forward into 12.1.1 and 12.2.2. It encapsulates the server-side business logic for list actions — the individual selection, ranking, and targeting steps that make up an Oracle Marketing list. List actions define how a marketing list chooses its membership: which source objects are included, how many rows are requested, how those rows are ranked or sampled, and what percentage distribution is applied. The package is the procedural layer beneath the AMS (Advanced Marketing) list-building feature set, providing insert, update, delete, lock, and validation operations against the underlying list-action entities.

The package spec is declared with AUTHID CURRENT_USER, so all SQL executes with the privileges of the calling session rather than the package owner. The header comment carries a ship date of 2002, reflecting the package's long-standing presence in the marketing module.

Key Procedures and Functions

The package exposes seven documented procedures. The first three implement the standard transactional operations against a list action record:

• CREATE_LISTACTION — Inserts a new list select action from a populated action record. The object version number is initialised to 1. If a caller supplies an action identifier, uniqueness is verified and a duplicate raises an exception; if not supplied, a unique identifier is generated from the sequence.
• UPDATE_LISTACTION — Applies modifications to an existing list action record, typically after validation has confirmed the change is permissible.
• DELETE_LISTACTION — Removes a list action record from the list definition.
• LOCK_LISTACTION — Places a logical lock on the action record, supporting concurrency control when multiple users or processes act on the same list.
• VALIDATE_LISTACTION — Performs the business validation that governs whether a list action may be saved or processed. This is the procedure most commonly sought by developers searching on "validate_listaction". It evaluates the action record for consistency and required-field completeness before the record is committed.
• INIT_ACTION_REC — Initialises the action record structure, defaulting attributes and preparing the record for population by the calling layer.
• COMPLETE_ACTION_REC — Finalises the action record, filling in derived or audit attributes before the record is persisted.

These procedures operate against the action_rec_type PL/SQL record, which carries the list action identifier, audit columns, object version number, order number, action type, included object descriptors, rank, row counts (available, requested, used, targeted), distribution percentage, result text, description, and usage attributes.

Tables Accessed

The package reads and writes two base tables, referenced through APPS synonyms:

• AMS_LIST_SELECT_ACTIONS — The primary transactional table storing list action definitions. Create, update, delete, and lock operations all target this table.
• AMS_LIST_SELECT_ACTIONS_S — The corresponding sequence used to generate unique list action identifiers when the caller does not supply one.
• DUAL — Used for sequence selection and single-row evaluation during record initialisation and validation.

Usage Notes

AMS_LISTACTION_PVT is a private package and is not intended for direct invocation by end users or external integrations. It is referenced by ten other packages within the marketing schema, which serve as the public entry points for list maintenance. These callers populate the action record, invoke validation, and then drive create, update, or delete operations. In the standard EBS forms flow, the list action setup form submits user edits through this layer; concurrent programs that build or refresh marketing lists also rely on the validation and record-completion routines to ensure each action is internally consistent before execution. Custom code should call the public wrapper packages rather than AMS_LISTACTION_PVT directly, since the private interface, the action record structure, and the validation rules may change between patch levels without notice.