Results for “ams_bom_pvt_w”

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

Overview

AMS_BOM_PVT_W is a private PL/SQL package body in the APPS schema that belongs to the Oracle Marketing (AMS) module. It serves as the "worker" implementation layer for Bill of Materials (BOM) processing within the Marketing suite. In Oracle EBS, the "_PVT" suffix designates a private API whose logic is exposed to callers only through a corresponding public package; here the public counterpart is AMS_BOM_PVT. The "_W" suffix identifies this body as the worker or wrapper that handles the actual procedural processing, delegating error handling and message propagation to the standard FND_API utility package.

The business context is marketing campaign and promotion management: BOM records in Oracle Marketing represent collections or bundles of marketing objects (offers, products, and related entities) that are assembled and processed as a unit. AMS_BOM_PVT_W encapsulates the server-side logic that validates, transforms, and persists these BOM definitions on behalf of the public API.

Key Procedures and Functions

The documented package metadata lists a single program unit:

• AMS_PROCESS_BOM — the central processing routine of this package body. It is the entry point through which the marketing application drives BOM processing logic. Based on its name and the package's role, AMS_PROCESS_BOM accepts the caller's BOM payload or identifier, performs the business validation and transformation rules required by the Marketing module, and orchestrates the resulting database operations. It also handles the standard API error stack behavior inherited from FND_API, allowing callers to inspect success or failure status after invocation. Only this one procedure/function is documented in the ETRM metadata for this package body; no additional public entry points are attributed to it.

Tables Accessed

The ETRM documentation for AMS_BOM_PVT_W does not itemize the base tables it touches, and the excerpt records no direct table references through APPS synonyms. As a private worker package, its DML activity is typically indirect: the documented dependency list shows that AMS_BOM_PVT_W references AMS_BOM_PVT, FND_API, the SYS-owned STANDARD package, and itself. Dependencies on AMS_BOM_PVT and FND_API indicate that the actual inserts, updates, and deletes against Marketing BOM tables are most likely performed by AMS_BOM_PVT, with AMS_BOM_PVT_W supplying processing orchestration and error handling. Any persistent writes performed here would target the BOM-related entities owned by the Oracle Marketing schema.

Usage Notes

Because this is a private ("_PVT") package body, it is not intended to be called directly by customer extensions. Oracle EBS development standards direct integrators and form developers to invoke the public API AMS_BOM_PVT, which in turn calls AMS_BOM_PVT_W. Typical invocation paths include Oracle Marketing forms and concurrent programs that create or modify BOM structures, as well as any internal Oracle code that assembles marketing objects into a processed BOM. Custom code that bypasses the public layer and calls AMS_BOM_PVT_W directly risks violating the supported API contract and may break across patch levels or upgrades (for example, between 12.1.1 and 12.2.2). The package status is VALID, meaning it is compiled and active in the APPS schema. Notably, the metadata records that AMS_BOM_PVT_W is not referenced by any other database object, confirming its role as a leaf-level implementation unit that depends on AMS_BOM_PVT and FND_API but is itself called only at runtime.