Search Results p_item_id

Overview

INV_ATTRIBUTE_CONTROL_PVT is a private PL/SQL package in the APPS schema of Oracle E-Business Suite 12.1.1 and 12.2.2. Its responsibility is to validate and enforce item-level attribute controls that govern how an item may be reserved, transacted, shipped, or adjusted within Oracle Inventory and its downstream fulfillment flows. The package acts as a central gatekeeper: before an item can participate in a given inventory or order-management operation, the relevant private function is called to confirm that the item's definition permits that operation and that no conflicting conditions (such as pending adjustments or unprocessed interface records) exist.

The p_item_id parameter referenced by the user appears throughout the package's signatures as the primary key of the item master record (MTL_SYSTEM_ITEMS_B) being evaluated. Every validation function in the package is scoped by this identifier, frequently paired with p_org_id to localize the check to a specific inventory organization. The package is classified as PVT (private), meaning it is not a supported public API for customer extensions and is intended for internal consumption by Oracle's own application modules.

Key Procedures and Functions

• GET_ATTRIBUTE_CONTROL — Returns a numeric control value derived from a source item, used to determine the default attribute control setting applicable to the item.
• CHECK_PENDING_ADJUSTMENTS — Determines whether unresolved adjustment records exist for the item in the specified organization, preventing conflicting attribute changes.
• RESERVABLE_CHECK / RESERVABLE_UNCHECK — Validate whether an item may be reserved, and reverse or clear that reservation eligibility respectively.
• TRANSACTABLE_CHECK / TRANSACTABLE_UNCHECK — Confirm whether an item is permitted to participate in inventory transactions, and clear that permission on request.
• CHECK_PENDING_INTERFACE — Verifies that no open transaction interface rows remain for the item, ensuring interface tables are clean before an attribute control change proceeds.
• SERIAL_CHECK — Confirms serial-number control compatibility for the item.
• ATO_UNCHECK — Clears the Assemble-to-Order designation for the item.
• SHIPPABLE_CHECK — Validates whether the item is eligible to be shipped.

Tables Accessed

The package references ten documented tables through APPS synonyms. MTL_ITEM_ATTRIBUTES and MTL_PARAMETERS supply the item attribute and organization control definitions that form the basis of each validation. MTL_TRANSACTIONS_INTERFACE, MTL_PHYSICAL_ADJUSTMENTS, and MTL_CYCLE_COUNT_ENTRIES are queried to detect pending transactional or adjustment activity. MTL_SUPPLY supports reservation and supply-demand checks. WSH_DELIVERY_DETAILS and OE_ORDER_LINES_ALL are consulted to confirm that the item is not already committed to an order or delivery in a way that would block the requested attribute change. For process-manufacturing items, GME_BATCH_HEADER and GME_MATERIAL_DETAILS are examined.

Usage Notes

Because INV_ATTRIBUTE_CONTROL_PVT is a private package, it is not documented as a public API and is not intended for direct invocation by customer code. It is invoked internally by Oracle Inventory forms and by the three dependent packages identified in the metadata, which call these validation functions before allowing attribute transitions on an item. Typical triggers include item attribute updates through the Item Master and Organization Items forms, reservation and shipping workflows, and concurrent processes that must confirm an item is free of pending adjustments or interface rows. The heavy dependence on p_item_id reflects the item-centric nature of the checks: each function validates the state of one specific item within one inventory organization. Customers should treat this package as read-only reference material and route any required customization through supported public APIs.