Search Results ams_wftrig_pvt




Overview
Explore in AI Chat

Overview

AMS_WFTRIG_PVT is an Oracle Applications private PL/SQL package owned by the APPS schema, classified under the ETRM (E-Business Suite Technical Reference Manual) as a PVT (private) API. It belongs to the Oracle Marketing (AMS) product family and provides the internal runtime engine that evaluates and executes campaign trigger logic integrated with Oracle Workflow. The package orchestrates the lifecycle of a marketing trigger: checking whether a trigger condition has been satisfied, recording the evaluation result, deciding whether the trigger should repeat, and then invoking the associated action (notification or executable program) through the Workflow infrastructure. Because it is a private package, it is not intended for direct invocation by external or customer code; it is called by other AMS components, such as the trigger monitoring concurrent programs and internal scheduling logic. The _PVT suffix signals restricted scope, and the ETRM records the package as VALID with 23 documented procedures and functions.

Key Procedures and Functions

The documented subprograms cover trigger initialization, evaluation, scheduling, and action dispatch:

Tables Accessed

The package reads and writes the core AMS trigger schema through APPS synonyms:

Usage Notes

AMS_WFTRIG_PVT is invoked internally by the Marketing trigger engine, typically from concurrent programs that poll trigger conditions and from scheduling logic. It is not exposed to end users through forms and is referenced by no other packages per ETRM metadata. Custom code should not call it directly; instead, use supported public AMS trigger APIs or Workflow configuration. Because it is private, its signature and behavior are subject to change across releases, and the ETRM entry should be treated as the authoritative reference for its internal interface.