Search Results p_order_number

Overview

AMS_ACT_LISTS_PKG is a PL/SQL package belonging to the Oracle Marketing (AMS) schema in Oracle E-Business Suite. It provides the programmatic interface for maintaining the AMS_ACT_LISTS table, which stores the association between marketing activity list headers and their corresponding order or list definitions. The "ACT" prefix identifies the record as an activity list, a construct used by Oracle Marketing to link a marketing campaign or event to the transactional lists that drive its execution. The package encapsulates the standard EBS table-handling API pattern: insert, update, delete, and lock operations, each of which is responsible for maintaining audit columns, object version numbers, and concurrency control on behalf of the calling application.

Key Procedures and Functions

• INSERT_ROW — Creates a new activity list record in AMS_ACT_LISTS. It assigns the object version number to 1 on creation, populates the WHO columns (creation date, created by, last update date, last updated by, last update login), and returns the generated primary key and version number to the caller through IN OUT parameters. The insertion includes the order_number column, which is the attribute most commonly sought when this package is searched. This confirms that order_number is a stored column on AMS_ACT_LISTS and is supplied to the package through the insert call parameter list.
• UPDATE_ROW — Modifies an existing activity list row identified by its primary key. It refreshes the audit columns, increments the object version number to support optimistic locking, and updates the business attributes including order_number, list header reference, group code, and the list usage attributes.
• DELETE_ROW — Removes an activity list record from AMS_ACT_LISTS. Because this is a child table in several marketing relationships, callers are expected to respect any foreign key dependencies before invoking the delete.
• LOCK_ROW — Acquires a row-level lock using SELECT ... FOR UPDATE on the specified primary key, allowing the calling transaction to serialize concurrent modifications and read the current object version number before performing its own update.

Tables Accessed

The package operates against a single documented table, AMS_ACT_LISTS, referenced through the APPS synonym. This table holds the activity list records, including the act_list_header_id primary key, the object_version_number used for concurrency control, the standard EBS audit columns, the list_header_id, group_code, list_used_by and list_used_by_id, list_act_type, list_action_type, and order_number. No other tables are documented as accessed by this package.

Usage Notes

AMS_ACT_LISTS_PKG is an internal EBS table-handling package and is normally invoked indirectly rather than by end users. It is called by Oracle Marketing forms and by the higher-level activity management APIs that create and maintain activity lists, including the single documented dependent package identified in the ETRM repository. In the 12.1.1 and 12.2.2 environments the package behaves identically from a functional standpoint. When a search is driven by the term "p_order_number", the relevant entry point is INSERT_ROW (and the corresponding UPDATE_ROW call), where p_order_number is the parameter carrying the order number into the AMS_ACT_LISTS.ORDER_NUMBER column. Custom code that must populate this column should call INSERT_ROW rather than issuing a direct INSERT, so that the object version number, WHO columns, and DECODE-based defaults (which translate FND_API.g_miss_num into NULL) are applied consistently. Because the package was last shipped in the 11.5.x source line, customers should treat it as a stable, low-change component when planning upgrades or extensions.