Search Results create_scheduler




Overview
Explore in AI Chat

Overview

AMS_SCHEDULER_PVT is a private PL/SQL package in the APPS schema that forms part of the Oracle Marketing (AMS) scheduling infrastructure within Oracle E-Business Suite 12.1.1 and 12.2.2. It is classified as a PVT package, indicating that it is intended for internal use by other marketing modules rather than as a public API for direct customer invocation.

The package encapsulates the core logic required to create, persist, and iterate marketing schedules — the definitions that determine when campaign activities, list activations, and related marketing operations are executed. It works in conjunction with sibling packages such as AMS_SCHEDULERULES_PVT, AMS_ADI_CAMP_SCHED_PVT, and AMS_WFTRIG_PVT, which delegate scheduling work to it. Its primary role is to translate a scheduling request into stored schedule records and to compute the next occurrence in a recurring schedule.

Key Procedures and Functions

The package exposes four documented procedures/functions:

  • WRITE_LOG — Provides internal diagnostic logging used throughout the package's execution path, recording activity and errors for debugging and audit purposes.
  • SCHEDULE_REPEAT — Handles the creation or regeneration of recurring schedule entries, giving effect to a schedule's repeat pattern so that future occurrences are generated from the base schedule definition.
  • CREATE_NEXT_SCHEDULE — Computes and inserts the next schedule instance derived from an existing schedule definition, supporting forward progression through a recurrence series.
  • CREATE_SCHEDULER — The principal entry point for constructing a scheduler record, establishing the base schedule entity used by the other procedures.

Parameter lists are intentionally private and not published; callers depend on the sibling PVT packages listed in the dependency metadata rather than invoking these directly.

Tables Accessed

The package reads from and writes to the following tables (accessed through APPS synonyms):

  • AMS_CAMPAIGN_SCHEDULES_B — The base table holding campaign schedule definitions; the primary target of schedule creation.
  • AMS_SCHEDULER_S — Sequence/identifier source used when allocating schedule keys.
  • AMS_ACT_LISTS — Activity lists linked to schedules, consulted to associate activities with the generated schedule occurrences.
  • AMS_LIST_ENTRIES — Individual entries within an activity list, read to determine what content a schedule should act upon.
  • AMS_MEDIA_CHANNELS — Media channel definitions referenced when a schedule targets a particular outbound channel.
  • AMS_USER_STATUSES_B — User-defined status values applied to schedule records.
  • IBC_ASSOCIATIONS — Association metadata used to resolve related marketing entities.
  • DUAL — Utility selection used for single-row computations.

Usage Notes

AMS_SCHEDULER_PVT is an internal (PVT) package and is not documented as a supported public API. It is referenced by three other packages — AMS_ADI_CAMP_SCHED_PVT, AMS_SCHEDULERULES_PVT, and AMS_WFTRIG_PVT — which serve as the practical invocation points during campaign scheduling, list scheduling, and workflow-triggered scheduling respectively.

Custom code should not call AMS_SCHEDULER_PVT directly. Instead, integrations should invoke the documented scheduling APIs or concurrent programs exposed by those dependent packages, allowing Oracle's internal schedule-generation lifecycle to manage record creation, recurrence, and logging consistently. Direct calls risk bypassing validation performed by the surrounding marketing framework.