Search Results require_approval

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:

• STARTPROCESS / ABORTPROCESS — Open and terminate a trigger processing cycle.
• SELECTOR — Selects the trigger or trigger set eligible for processing.
• CHECK_TRIGGER_STATUS / CHECK_ACTIVE_SCH / PERFORM_CHECK — Determine current trigger state, confirm an active schedule, and perform the core condition evaluation.
• RECORD_RESULT — Persists the outcome of a trigger evaluation.
• CHECK_REPEAT / GET_AVAL_REPEAT_SCH / GET_AVAL_SCH — Evaluate repeat behavior and resolve available (repeat) schedules.
• SCHEDULE_TRIG_RUN / EXECUTE_SCHEDULE — Register and execute a scheduled trigger run.
• REQUIRE_APPROVAL / NOTIFY_CHK_MET — Handle approval gating and notify when a trigger check is met.
• GET_USER_ROLE — Resolve the role context of the user for approval/notification routing.
• TRIG_TYPE_DATE — Handle date-type trigger classification.
• ACTION_NOTIFICATION / ACTION_EXECUTE / EVENT_CUSTOM_ACTION / EVENT_TRIG_NEXT — Dispatch the configured action, including notifications, executions, custom events, and chaining to the next trigger event.

Tables Accessed

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

• AMS_TRIGGERS, AMS_TRIGGER_CHECKS, AMS_TRIGGER_ACTIONS, AMS_TRIGGER_RESULTS — Define the trigger, its checks, its actions, and store evaluation results.
• AMS_CAMPAIGNS_ALL_B, AMS_CAMPAIGN_SCHEDULES_B — Provide campaign and schedule context.
• AMS_ACT_LISTS, AMS_ACT_METRICS_ALL, AMS_APPROVAL_RULES — Supply activity lists, metrics, and approval rules for gating.
• WF_PARAMETER_LIST_T and DBMS_UTILITY — Support Workflow parameter passing and utility operations.

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.