Search Results ams_act_lists_pkg




Overview
Explore in AI Chat

Overview

AMS_ACT_LISTS_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the Oracle Marketing (AMS) product family. Its name derives from "Activity Lists," indicating that it manages the persistence of activity list header records used within Marketing and Trade Management (formerly CRM) functionality. Activity lists define groupings of activities that are associated with marketing campaigns, telemarketing efforts, or list-based processing operations, allowing users to organize and target sets of contacts or actions.

The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking user rather than the definer, consistent with Oracle EBS multi-schema security conventions. The header comment block ($Header: amstalss.pls) is largely empty in the available metadata, so the authoritative record of behavior is the declared procedure set and the referenced table. Functionally, the package serves as a CRUD (Create, Read, Update, Delete) API layer over the AMS_ACT_LISTS table, supplemented by an optimistic-locking routine.

Key Procedures and Functions

The ETRM metadata documents four procedures in this package:

  • INSERT_ROW — Inserts a new activity list header record into AMS_ACT_LISTS. It accepts the full set of header attributes, including the primary key act_list_header_id (returned as an IN OUT parameter), audit columns (last_update_date, last_updated_by, creation_date, created_by, last_update_login), and business attributes such as list_header_id, group_code, list_used_by_id, list_used_by, list_act_type, list_action_type, and order_number. The object_version_number is also passed IN OUT to support the EBS versioning scheme.
  • UPDATE_ROW — Modifies an existing activity list header identified by act_list_header_id. It carries the same attribute set as INSERT_ROW, including the object version number used to detect concurrent updates.
  • DELETE_ROW — Removes the activity list header identified solely by p_ACT_LIST_HEADER_ID.
  • LOCK_ROW — Performs an optimistic locking check on the row before modification, comparing the supplied column values and object version against the current database state. This is the standard EBS pattern used to prevent lost updates in multi-user editing scenarios.

Tables Accessed

The package operates on a single documented table, AMS_ACT_LISTS, accessed via its APPS synonym. This table stores activity list header information, with the act_list_header_id as the primary key and the object_version_number supporting optimistic concurrency. The audit columns (creation_date, created_by, last_update_date, last_updated_by, last_update_login) follow the standard EBS WHO column convention, and the API expects the caller to populate them, typically through the OAF/Forms framework or a calling program.

Usage Notes

AMS_ACT_LISTS_PKG is a low-level table-handler package and is not intended for direct ad-hoc invocation by end users. It is normally called from Oracle Forms-based marketing screens, OAF-based pages, or from higher-level marketing APIs. The metadata notes that the package is referenced by one other package, indicating it forms part of a layered API stack where dependent PL/SQL units call these routines rather than issuing DML directly against AMS_ACT_LISTS. Custom code integrating with Marketing activity lists should invoke INSERT_ROW, UPDATE_ROW, DELETE_ROW, and LOCK_ROW in the documented order—performing LOCK_ROW before UPDATE_ROW to respect version numbering—and should always supply the WHO audit columns and object version consistently to avoid corrupting the versioning model. Because the package uses AUTHID CURRENT_USER, callers require appropriate grants on the underlying table and package.