Results for “ams_fulfill_pvt”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.AMS_FULFILL_PVT is a private PL/SQL package within the Oracle Marketing (AMS) module of Oracle E-Business Suite. It provides an internal API for managing fulfillment activities in AMS, notably the delivery of collaterals and cover letters associated with marketing campaigns. The package is classified as a Private (PVT) API, meaning it is intended for internal consumption by other AMS packages and concurrent programs rather than as a public integration point for external or customer code. The package was originally created in November 1999 and was subsequently modified to support user identification, scheduled eBlast execution, a profile_id parameter on the fulfillment routine, and removal of obsolete APIs following the migration to the newer eBlast architecture.

Key Procedures and Functions

The ETRM metadata documents four procedures and functions within the package:

• AMS_FULFILL — The core fulfillment routine. It fulfills collaterals and cover letters for a campaign, including the standard API parameters (API version, initialization of the message list, and commit flag) along with a user identifier and, as of the May 2002 revision, a profile_id parameter. This procedure represents the primary business action of the package.
• AMS_EXEC_SCHEDULE — Added in October 2000, this procedure is invoked from the schedule page to execute campaign scheduling logic, supporting the newer eBlast scheduling model.
• SEND_TEST_EMAIL — Used to dispatch a test email, supporting validation of campaign or eBlast content prior to full execution.
• ATTACH_QUERY — Supports attachment handling within the fulfillment flow, associating generated or retrieved content with the outbound communication.

The package references only these four documented routines; no public package specification is exposed for external callers.

Tables Accessed

The package operates against several AMS and shared application tables through APPS synonyms:

• AMS_CAMPAIGN_SCHEDULES_B — Stores campaign schedule definitions, supporting AMS_EXEC_SCHEDULE execution.
• AMS_LIST_ENTRIES — Holds the individual entries (recipients) belonging to a marketing list, used to determine fulfillment targets.
• AMS_LIST_HEADERS_ALL — Holds list header definitions that organize list entries.
• AMS_SOURCE_CODES — Provides marketing source code values associated with campaigns and lists.
• IBC_ASSOCIATIONS — Stores content association metadata used when attaching collateral or query content during fulfillment.

These tables indicate the package reads campaign scheduling, list membership, source code, and association data, and writes fulfillment outcomes as part of the campaign delivery cycle.

Usage Notes

AMS_FULFILL_PVT is invoked indirectly rather than directly. In typical EBS deployments it is called from AMS forms, concurrent programs, and other AMS packages that drive campaign execution and eBlast scheduling. The ETRM metadata records that the package is referenced by one other package, reinforcing its role as a subordinate internal API. Because it is a private package and any signature changes are not governed by public API compatibility rules, customers and integrators should not call it directly from custom code; instead, the supported public AMS APIs or the standard campaign scheduling UI should be used. The presence of the AMS_EXEC_SCHEDULE and SEND_TEST_EMAIL routines reflects the post-migration eBlast model in later 12.1.1 and 12.2.2 releases, where scheduled and test deliveries are handled within the same private fulfillment layer.