Search Results ams_schedulerules_pvt




Overview
Explore in AI Chat

Overview

APPS.AMS_SCHEDULERULES_PVT is a private PL/SQL package within the Oracle Marketing (AMS) module of Oracle E-Business Suite, released under the APPS schema and classified as a PVT (private) API. Its primary business function is to encapsulate the scheduling rule validation, initiation, and execution logic that governs marketing campaign schedules. Because it is a private package, it is not intended for direct invocation by external consumers; rather, it serves as an internal engine consumed by higher-level marketing packages such as AMS_CAMP_SCHEDULE_PVT, AMS_APPROVAL_PVT, AMS_EVENTOFFER_PVT, AMS_EVHRULES_PVT, AMS_SCHEDULER_PVT, and AMS_ADI_CAMP_SCHED_PVT. The package depends on FND_API for the standard Oracle Application Object Library API error-handling and messaging constructs, on WF_EVENT_T for workflow event payloads, and on AMS_CAMP_SCHEDULE_PVT for related campaign scheduling operations. Its scope centers on validating schedule dates, managing schedule activity and status transitions, creating access lists and target groups, and executing direct marketing and sales activities tied to a campaign schedule.

Key Procedures and Functions

The ETRM 12.2.2 metadata documents 36 procedures and functions. The named public surface includes the following groups of logic:

Tables Accessed

The package reads and writes through APPS synonyms against several marketing tables, including WF_EVENT_T for workflow events; AMS_ACT_ACCESS, AMS_ACT_LISTS, and AMS_ACT_PRODUCTS for activity list, access, and product associations; AMS_CAMPAIGNS_ALL_B and AMS_CAMPAIGN_SCHEDULES_B for campaign and schedule master data; AMS_CTDS and AMS_MEDIA_B / AMS_MEDIA_CHANNELS for media and channel configuration; AMS_EVENT_OFFERS_ALL_B for event offer definitions; AMS_GENERATED_CODES for generated code values; AMS_LIST_ENTRIES and AMS_LIST_HEADERS_ALL for list header and entry data; and AMS_CUSTOM_SETUPS_B and AMS_CUSTOM_SETUP_ATTR for custom setup attributes. These accesses support validation of campaign context, maintenance of list membership, and persistence of schedule-driven interactions.

Usage Notes

As a PVT-classified package, AMS_SCHEDULERULES_PVT is not exposed to end users through standard Oracle Forms menus or concurrent program parameters. It is invoked internally by the six dependent marketing packages listed in the ETRM dependency information, which in turn are called from the Oracle Marketing Campaign Scheduling and approval flows. Typical invocation occurs during campaign schedule creation, update, activation, and execution processing, where validation procedures are called before DML and execution procedures perform downstream direct marketing and sales actions. Customizations should not call this package directly; instead, developers should target the corresponding public APIs such as AMS_CAMP_SCHEDULE_PVT, since the private package may change without notice between 12.1.1 and 12.2.2 and its error-handling conventions rely on FND_API.