Search Results ams_bom_pvt




Overview
Explore in AI Chat

Overview

APPS.AMS_BOM_PVT is an internal, private PL/SQL package within the Oracle E-Business Suite Application Management System (AMS) module, which governs marketing, campaign, and lead management activity. The PVT designation indicates that this is a private API package, not intended for direct invocation by external or customer code. Such packages typically encapsulate the low-level implementation logic behind a corresponding public API or a Workflow-enabled wrapper. In the case of AMS_BOM_PVT, the package is the implementation layer that supports bill-of-material style processing within AMS. The status of the package is VALID in the APPS schema under the 12.1.1 and 12.2.2 releases. Its dependency on FND_API confirms that it conforms to the Oracle Application Framework development standards, using the standard API error-handling and message stack conventions. The package is referenced by both AMS_BOM_PVT_W (a Workflow-instantiable wrapper) and by itself, indicating internal recursive or self-referential calls, as well as exposure to the Workflow business event infrastructure.

Key Procedures and Functions

The ETRM 12.2.2 metadata documents a single procedure/function within the package:

  • AMS_PROCESS_BOM — The solitary documented entry point, whose purpose is to process the business object model (BOM) within the AMS context. Consistent with the private-API pattern of Oracle EBS, this procedure centralizes the validation, processing, and persistence logic invoked by higher-level AMS routines. The "_W" wrapper package (AMS_BOM_PVT_W) exposes this procedure to Oracle Workflow, confirming that AMS_PROCESS_BOM is designed to be called within a Workflow or business event subscription context rather than directly from a form. Because the metadata does not document a parameter list, the exact arguments are not reproduced here; the procedure name itself conveys its role as a processor of BOM data within the AMS schema.

Tables Accessed

The documented table access for this package is limited to a single referenced table:

  • MTL_PARAMETERS — Accessed via the APPS synonym. MTL_PARAMETERS stores organization-level Inventory parameters, including the default organization, costing information, and various supply-chain control settings. The reference from AMS_BOM_PVT indicates that the package reads organizational or inventory configuration data before processing BOM records, ensuring that the AMS processing operates within the correct inventory organization context. This is a read (rather than write) dependency in most AMS processing flows, as AMS logic generally does not modify inventory setup parameters.

Usage Notes

APPS.AMS_BOM_PVT is a private package and should not be invoked directly by custom applications. Its intended invocation path is through the public wrapper AMS_BOM_PVT_W, which in turn is typically triggered by Oracle Workflow processes or by higher-level AMS APIs. Developers extending AMS should call the public API or the Workflow-enabled wrapper rather than this package, to preserve compatibility and leverage the FND_API error handling it inherits. In the 12.1.1 and 12.2.2 releases, the package remains VALID in the APPS schema, indicating it is actively used in the standard AMS installation. Because only one procedure and one table dependency are documented, the package should be treated as a focused utility rather than a broad business-logic container. Any customization that requires modification of AMS BOM processing must be carefully coordinated, since changes to private APIs like AMS_BOM_PVT risk breaking the wrapper and Workflow chain. Database administrators and technical consultants tracing an AMS BOM error should examine the AMS_BOM_PVT_W wrapper first, then follow the call into AMS_BOM_PVT and confirm that the required MTL_PARAMETERS organization context is correctly configured.