Search Results check_header

Overview

AMS_BOM_PVT is a private (PVT-classified) PL/SQL package in the Oracle E-Business Suite Applications (APPS) schema that functions as a wrapper around the Oracle Bills of Material (BOM) application programming interface. The package belongs to the Oracle Advanced Marketing (AMS) product family and is deployed in Oracle EBS releases 12.1.1 and 12.2.2. Its stated purpose, taken directly from the package header comment, is to provide a controlled interface layer between AMS marketing components and the underlying BOM API, allowing AMS to create, query, and process bill of material structures without directly coupling application logic to the BOM schema objects.

The package resides in a source file named amsvbomb.pls and carries the constant G_FILE_NAME set to that value, with the package name defined as the constant G_PKG_NAME. The private classification indicates that it is not intended as a public, supported integration point; it is invoked internally by other AMS packages. The ETRM metadata confirms that AMS_BOM_PVT is referenced by one other package.

Key Procedures and Functions

The documented ETRM metadata lists a single procedure for this package: AMS_PROCESS_BOM. This procedure is the principal entry point through which AMS requests BOM processing and serves as the wrapper that delegates the actual bill-of-material manipulation to the underlying BOM API.

The package body additionally declares supporting program units, including a get_transaction_type procedure and a bill_details_rec_type record type. The record type defines the fields used to carry bill details into and out of the processing logic, such as Assembly_Item_Id, Component_Item_Id, Assembly_Item_Name, Component_Item_Name, Header_Trans_Type, Component_Trans_Type, Header_org_id, Header_org_code, Effectivity_date, Component_Item_Num, Object_Id, and Transaction_Type. Each field is initialized to the corresponding FND_API.G_MISS_VALUE sentinel, and the global record G_MISS_BILL_DETAILS_REC provides the standard missing-value row used for API parameter checking. These elements support the documented AMS_PROCESS_BOM procedure but are not separately classified as documented functional interfaces in the metadata.

The package also declares debug control flags using FND_MSG_PUB.CHECK_MSG_LEVEL at package initialization for high, low, and medium debug levels, enabling FND logging throughout execution.

Tables Accessed

According to the ETRM metadata, AMS_BOM_PVT references the MTL_PARAMETERS table through the APPS synonym. MTL_PARAMETERS stores organization-level inventory parameters and is typically consulted to validate or retrieve the operating context, such as the organization identifier used when invoking BOM processing. No other base tables are documented against this package; all remaining bill-of-material access is performed indirectly through the wrapped BOM API rather than through direct SQL in this unit.

Usage Notes

Because AMS_BOM_PVT is classified as a private API, it is not exposed for direct customer calls and is not a supported public interface. It is invoked internally by AMS application code, most likely from concurrent programs, workflow activities, or other AMS packages that need to create or process bills of material while preserving the integrity of the BOM API contract. The comment history indicates the package was created in September 2000 and maintained through 2004, including fixes relating to effectivity date handling (Bug 2993951 and Bug 3857716) where truncation of the effectivity date was removed so that the BOM API could correctly locate components.

Custom code that must invoke this logic should call the corresponding public AMS APIs rather than AMS_BOM_PVT directly, to remain upgrade-safe. When troubleshooting the search term "check_header," note that header validation logic is understood to reside in the wider BOM API wrapper pattern; the documented public artifact for this package remains AMS_PROCESS_BOM.