Search Results ams_act_list_pvt_w




Overview
Explore in AI Chat

Overview

The APPS.AMS_ACT_LIST_PVT_W package body is the private implementation wrapper for the Activity List (ACT_LIST) business logic within the Oracle Advanced Marketing (AMS) module of Oracle E-Business Suite. Activity Lists define groupings of activities that support campaign, event, and marketing effort planning. The _PVT_W suffix indicates a private package body that provides a lightweight, wrapper-oriented layer around the primary private package AMS_ACT_LIST_PVT. Its principal role is to expose the Activity List DML and validation operations to the Oracle Forms user interface and to the Rosetta table-copy integration pattern used for passing multi-row data structures between client and server.

The package is documented as VALID and classified under API type OTHER. It depends on AMS_ACT_LIST_PVT, FND_API, the JTF collection types JTF_DATE_TABLE, JTF_NUMBER_TABLE, and JTF_VARCHAR2_TABLE_100, as well as the Oracle-supplied STANDARD and PLITBLM packages. It is not referenced by any other database object, confirming its position as a terminal, UI-facing wrapper.

Key Procedures and Functions

The package exposes eleven documented procedures and functions organized around two functional groups.

  • ROSETTA_TABLE_COPY_IN_P1, ROSETTA_TABLE_COPY_OUT_P1, ROSETTA_TABLE_COPY_IN_P4, and ROSETTA_TABLE_COPY_OUT_P4 — the Rosetta-style table transfer routines. The _IN variants copy PL/SQL table structures from the caller into the package's internal state; the _OUT variants copy the package's results back to the caller. The _P1 and _P4 designators distinguish separate parameter sets or directional transfer groups, enabling multi-row activity list data to be marshalled between the Forms tier and the database.
  • CREATE_ACT_LIST — performs the insert of a new activity list entity through the underlying AMS_ACT_LIST_PVT logic.
  • UPDATE_ACT_LIST — applies modifications to an existing activity list record.
  • VALIDATE_ACT_LIST — performs the top-level validation of an activity list prior to persistence.
  • CHECK_ACT_LIST_ITEMS — validates the individual items (member activities) associated with an activity list.
  • VALIDATE_ACT_LIST_REC — validates a single activity list record, typically invoked for row-level checks.
  • INIT_ACT_LIST_REC — initializes the activity list record structure with default values before DML processing.
  • COMPLETE_ACT_LIST_REC — finalizes the activity list record after DML, populating post-save attributes such as identifiers or derived columns.

No parameter lists are documented; consumers should treat the signatures as internal implementation details layered over AMS_ACT_LIST_PVT.

Tables Accessed

The only documented table reference is PLITBLM, an Oracle-supplied package rather than an application table. The package relies on the underlying AMS_ACT_LIST_PVT package to execute the actual DML against the AMS activity list base tables. Activity list content is therefore inserted, updated, and validated through the private package's table access, while AMS_ACT_LIST_PVT_W orchestrates the transfer of row collections and invokes validation and record lifecycle routines.

Usage Notes

Because the package is a private wrapper (_PVT_W) with no inbound object dependencies, it is principally invoked from the Oracle Forms-based Activity List maintenance windows in the AMS marketing workbench, and from any custom code that emulates those Forms calls. The Rosetta COPY_IN/COPY_OUT routines are typically called in pairs to pass ordered row collections between the client and the package before invoking CREATE_ACT_LIST or UPDATE_ACT_LIST. Validation should follow the sequence INIT_ACT_LIST_REC, VALIDATE_ACT_LIST_REC (or CHECK_ACT_LIST_ITEMS), CREATE_ACT_LIST/UPDATE_ACT_LIST, and finally COMPLETE_ACT_LIST_REC. Direct invocation from concurrent programs is not documented, and the object is not referenced elsewhere in the database; custom integrations should prefer the public Application Programming Interface surfaces where available rather than calling this private wrapper directly.