Search Results inv_material_status_pub




Overview
Explore in AI Chat

Overview

The APPS.INV_MATERIAL_STATUS_PUB package body is the public PL/SQL API for managing material status assignments on inventory entities within Oracle E-Business Suite Release 12.1.1 and 12.2.2. Material statuses in Oracle Inventory are user-defined codes that control the usability, reservation, and transaction eligibility of on-hand material — for example, statuses such as Available, Quarantine, or Rejected. The INV_MATERIAL_STATUS_PUB package provides the supported, documented entry point through which Oracle Forms, concurrent programs, and customer extensions can apply or change a material status against an inventory entity without directly manipulating the underlying Inventory tables.

The package is classified as a public (PUB) API, meaning it forms part of the stable interface that Oracle supports for external invocation. It follows the standard Oracle Application Object Library (AOL) API design pattern, delegating message handling to FND_MSG_PUB and conforming to the shared error-handling and savepoint conventions provided by FND_API. The package body is validated in the APPS schema and is fully resolved against its dependencies at the documented release level.

Key Procedures and Functions

The documented public interface exposes a single procedure:

  • UPDATE_STATUS — This procedure applies a material status update against an inventory entity. It is the sole documented entry point in the package and represents the supported mechanism for programmatically changing the status associated with on-hand items and their related inventory attributes. The procedure internally orchestrates the update through the lower-level group and private API layers.

Because only one procedure is documented, callers requiring additional material status functionality must rely on this single API rather than private or internal procedures, which are not part of the supported public contract.

Tables Accessed

The package body references several Inventory base tables through APPS synonyms, reflecting the scope of a material status update:

Read and write access is determined by the update logic, with status values propagated to the on-hand and control-level tables that govern downstream material eligibility.

Usage Notes

INV_MATERIAL_STATUS_PUB.UPDATE_STATUS is typically invoked from the Oracle Inventory material status forms and from concurrent programs that perform bulk status changes. It is also the recommended API for custom PL/SQL extensions that need to change material status while preserving the standard validation, message-stack, and error-handling behavior of the EBS application framework. According to the dependency metadata, the package is referenced by fifteen other database objects, indicating that it is a foundational API within the Inventory module rather than a leaf utility. Callers should observe standard EBS API conventions — initializing the message stack via FND_MSG_PUB before invocation and checking the returned status — to ensure consistent error propagation and transactional integrity.