Search Results update_item_row

Overview

INV_ITEM_API is the public PL/SQL interface provided by Oracle Inventory for creating and maintaining item master definitions across organizations in Oracle E-Business Suite. The package encapsulates the business rules that govern item attributes, value-based attribute derivation, and the propagation of master-organization changes to child organizations, so that callers do not have to write directly against the underlying item tables. It is declared with AUTHID CURRENT_USER and is owned by APPS, which allows it to execute with the privileges of the invoking schema while still enforcing the Inventory application logic and validation rules.

Rather than exposing MTL_SYSTEM_ITEMS_B%ROWTYPE, the package defines its own Item_rec_type record. The source header notes two motivations for this design: record elements must be initialized to predefined constants that represent missing values, and the record must carry value-based attributes that are not columns of the base entity table. This makes the record the canonical payload for both insert and update operations and explains why the API is the supported entry point for item data rather than direct DML. The package is classified as an API in ETRM for 12.2.2 and remains valid for 12.1.1 usage patterns.

Key Procedures and Functions

• UPDATE_ITEM_ROW — The principal maintenance procedure for an existing item row. It applies changes to a populated Item_rec_type record for a specific inventory item and organization, validating the submitted attributes and updating the corresponding columns in the item entity tables. This is the procedure most commonly referenced when an integrator searches for update_item_row.
• UPDATE_ITEM_TL_ROW — Maintains the translated (TL) descriptive columns for an item, writing the language-specific description and related translatable text into the item translation table for the requested language.
• TO_BOOLCHAR — A small conversion helper that normalizes Boolean input into the single-character flag representation used throughout the item attribute model, allowing callers to pass Boolean-style values uniformly.

Tables Accessed

• MTL_SYSTEM_ITEMS_B — The core item entity table holding organization-specific item attributes; read for current values and written by the update procedures.
• MTL_SYSTEM_ITEMS_TL — Stores translated item descriptions; the target of the translation-row maintenance procedure.
• MTL_ITEM_ATTRIBUTES — Holds attribute-level values, including value-based attributes that are not physical columns of the item entity table; these are validated and persisted during item maintenance.
• MTL_PARAMETERS — The organization parameters table, consulted to determine organization defaults and the master/child relationships that drive item-level attribute derivation and validation.

Usage Notes

The package is most often invoked from Oracle Inventory forms, where the item definition UI calls the API rather than performing direct DML, and from concurrent programs and interfaces that load or refresh items in batch. Custom code should call it in the same manner: populate an Item_rec_type record, set the identifying keys, then call the appropriate update procedure and check the returned status before committing. Because six other packages reference it, INV_ITEM_API also functions as a building block for higher-level item APIs and extension routines. When the metadata is silent on a specific parameter, rely on the published ETRM/API documentation and the package specification rather than inferring signatures, and never bypass the API with direct updates to the item tables.