Search Results inv_item_grp




Overview
Explore in AI Chat

Overview

INV_ITEM_GRP is a group-type PL/SQL package in the APPS schema that provides the core business logic for creating, maintaining, and retrieving Oracle Inventory item definitions across Oracle E-Business Suite releases 12.1.1 and 12.2.2. Its primary role is to centralize item master manipulation so that callers — Forms, concurrent programs, open interfaces, and custom code — operate through a single validated entry point rather than writing directly to the item tables. The package is tightly integrated with the Enterprise Object Library (EGO) framework, as evidenced by its dependencies on EGO_ITEM_OPEN_INTERFACE_PVT, EGO_ITEM_USER_ATTRS_CP_PUB, EGO_IMPORT_UTIL_PVT, and the EGO user-attribute data objects and tables. This integration allows INV_ITEM_GRP to populate both the base item attributes and the flexfield-based descriptive and user-defined attribute structures in one coordinated operation.

The package also bundles interface handling responsibilities, orchestrating the movement of item records between the open interface tables and the production item master, and recording failures into the interface error table. It is referenced by 21 other database objects, confirming its position as a foundational dependency for downstream item-related processing.

Key Procedures and Functions

  • CREATE_ITEM — Creates a new item definition, applying validation and defaulting rules before persisting the item and its associated attributes.
  • UPDATE_ITEM — Modifies an existing item definition, including attribute changes routed through the EGO user-attribute framework.
  • LOCK_ITEM — Acquires a lock on an item record to prevent concurrent modification during an update transaction.
  • GET_ITEM — Retrieves a full item definition, including attribute data, for a specified item.
  • INTERFACE_HANDLER — Processes records staged in the open interface tables, transferring valid items into the item master and logging errors for rejected rows.
  • GET_ITEM_NUMBER — Returns the item number associated with a given item identifier.
  • CHECK_ITEM_NUMBER — Validates whether an item number exists or is available, supporting duplicate and uniqueness checks.
  • GET_ITEM_ID — Returns the internal system item identifier for a supplied item number.

The documented procedure list totals ten entries; the remaining routines support internal helper and attribute-processing activity.

Tables Accessed

The package reads and writes the core item master tables MTL_SYSTEM_ITEMS_VL, MTL_SYSTEM_ITEMS_INTERFACE, and MTL_SYSTEM_ITEMS_INTF_SETS_S, the latter two supporting open interface processing. Item template information is drawn from MTL_ITEM_TEMPLATES_B and MTL_ITEM_TEMPLATES_TL, while revision data flows through MTL_ITEM_REVISIONS_INTERFACE. Interface failures are recorded in MTL_INTERFACE_ERRORS. Organization-level defaults and controls come from MTL_PARAMETERS, and EGO_DATA_LEVEL_B plus EGO_ITM_USR_ATTR_INTRFC supply the user-attribute and data-level definitions applied to items. DUAL and PLITBLM are used for standard PL/SQL utility operations.

Usage Notes

INV_ITEM_GRP is typically invoked indirectly. The Inventory item definition Forms call it during item creation and maintenance, and concurrent programs that process the item open interface rely on INTERFACE_HANDLER to migrate and validate staged records. Custom integrations extending the item master should call CREATE_ITEM, UPDATE_ITEM, and the GET_* functions rather than inserting into the underlying tables, ensuring that EGO attribute processing, revision validation, and error logging occur consistently. Because the package is referenced by 21 objects, changes to its behavior can propagate widely, and callers should adopt the standard FND_API error-handling conventions when invoking it.