Search Results delete_act_list

Overview

AMS_ACT_LIST_PVT is a private PL/SQL package in the APPS schema that implements the core business logic supporting Oracle Marketing's campaign activity list infrastructure. Within Oracle E-Business Suite 12.1.1 and 12.2.2, this package functions as the internal engine backing the activity list generation process, providing the procedural foundation that public worklist APIs and concurrent programs invoke when managing marketing activity lists. An activity list in Oracle Marketing represents a grouping of campaign activities or target groups that must be processed, scheduled, or evaluated as a single unit.

The "PVT" classification indicates this is a private API package, not intended for direct customer invocation. It encapsulates validation, locking, record initialization, and target group generation logic that higher-level public packages and workflow components consume. This architectural pattern separates stable public interfaces from the volatility of internal processing logic, which is significant because the package depends on FND_API for standard error-handling and messaging conventions and on WF_EVENT_T for integration with the Oracle Workflow event system.

Key Procedures and Functions

The package documents 18 procedures and functions spanning the lifecycle of an activity list record. The primary CRUD and control procedures are CREATE_ACT_LIST, UPDATE_ACT_LIST, DELETE_ACT_LIST, and LOCK_ACT_LIST, which respectively insert, modify, remove, and acquire a concurrency lock on activity list records. VALIDATE_ACT_LIST and VALIDATE_ACT_LIST_REC perform validation of activity list data prior to persistence. CHECK_ACT_LIST_ITEMS and CHECK_SUPP verify integrity of the list contents and supplementary conditions.

Record initialization and completion are handled by INIT_ACT_LIST_REC and COMPLETE_ACT_LIST_REC, which set up and finalize the activity list record structure used throughout processing. The target group generation functions — GENERATE_TARGET_GROUP_LIST, GENERATE_TARGET_GROUP_LIST_OLD, CREATE_TARGET_GROUP_LIST, and COPY_TARGET_GROUP — construct the actual target groups associated with a list, with the _OLD variant retained for backward compatibility. Auxiliary procedures including PROCESS_CELL, INVOKE_TARGET_GROUP_LOCK, and CONTROL_GROUP_GENERATION manage cell-level processing, concurrency locking of target groups, and orchestration of the generation run.

Tables Accessed

Through APPS synonyms, the package reads and writes the central activity list tables AMS_ACT_LISTS, AMS_ACT_LISTS_S (the audit/shadow table), and AMS_ACT_LIST_GROUPS, which link activity lists to their groups. Logging and transactional audit are handled via AMS_ACT_LOGS, AMS_ACT_LOGS_S, and AMS_ACT_LOGS_TRANSACTION_ID_S. Target group and list content data is drawn from AMS_LIST_ENTRIES, AMS_LIST_HEADERS_ALL, AMS_LIST_QUERIES_ALL, and AMS_LIST_QUERIES_PARAM_S, while restriction and rule definitions come from AMS_LIST_CONT_RESTRICTIONS, AMS_LIST_RULE_FIELDS, and AMS_LIST_RULE_USAGES. Campaign scheduling context is sourced from AMS_CAMPAIGN_SCHEDULES_B, and WF_EVENT_T is used to raise workflow events.

Usage Notes

AMS_ACT_LIST_PVT is not invoked directly by end users. It is referenced by the public wrapper AMS_ACT_LIST_PVT_W, by workflow-enabled components such as AMS_LIST_WF and AMS_WFTRIG_PVT, and by processing packages including AMS_LISTGENERATION_PKG, AMS_SCHEDULERULES_PVT, AMS_SCHEDULER_PVT, AMS_COPYELEMENTS_PVT, and AMS_EVHRULES_PVT. Practically, invocation occurs through Oracle Marketing forms, the list generation concurrent programs, and the Scheduler when activity lists are created, copied, or regenerated. Customizations should target the public "_W" API rather than this private package, since private APIs are subject to change between releases and are unsupported for direct extension.