Search Results g_miss_num

Overview

INV_ITEM_GRP is the public item-master API group within the Oracle EBS Inventory module, owned by APPS and classified as a GRP (grouped API) in the ETRM repository. It provides a programmatic, PL/SQL-based alternative to the Oracle Forms user interface for creating and maintaining inventory item definitions across organizations. The package header is declared with AUTHID CURRENT_USER, so all unqualified object references resolve against the schema of the calling session, while the actual data manipulation happens through APPS synonyms.

The package establishes the global constants g_MISS_CHAR, g_MISS_NUM, and g_MISS_DATE, each initialized from the corresponding fnd_api values. The item record type Item_rec_type uses these constants as default values, which is the standard Oracle "missing value" convention: a caller who does not intend to change or supply a given attribute leaves it defaulted to the sentinel, and the API treats that attribute as unspecified rather than as an explicit value. This is directly relevant to the search term g_miss_num, the sentinel used for all numeric attributes in the record type, including ORGANIZATION_ID and INVENTORY_ITEM_ID.

Key Procedures and Functions

The documented API surface comprises ten procedures and functions, of which eight are named in the metadata:

• CREATE_ITEM — Creates a new item definition using the caller-supplied Item_rec_type record and applicable attribute values.
• UPDATE_ITEM — Modifies attributes of an existing item; unchanged attributes are typically passed as the g_MISS_* sentinels so they are preserved.
• LOCK_ITEM — Acquires a logical lock on an item record so concurrent update attempts are serialized.
• GET_ITEM — Retrieves the current attribute values of an item into the item record type.
• INTERFACE_HANDLER — Manages the interface record lifecycle, moving item data through the standard interface tables and recording outcomes.
• GET_ITEM_NUMBER — Returns the concatenated item number (SEGMENT1) for a given item.
• CHECK_ITEM_NUMBER — Validates whether an item number already exists, supporting duplicate detection.
• GET_ITEM_ID — Resolves an inventory item identifier from supplied item-number criteria.

Tables Accessed

The package operates primarily against the inventory item interface and item master tables. MTL_SYSTEM_ITEMS_INTERFACE and MTL_SYSTEM_ITEMS_INTF_SETS_S hold item data staged for validation and import; MTL_INTERFACE_ERRORS captures row-level validation failures; MTL_ITEM_REVISIONS_INTERFACE carries revision data; and EGO_ITM_USR_ATTR_INTRFC stores user-defined attribute values for the extensible item attributes framework. MTL_ITEM_TEMPLATES_B and MTL_ITEM_TEMPLATES_TL supply item template definitions, EGO_DATA_LEVEL_B provides the data-level (attribute group) definitions, MTL_PARAMETERS provides installation-level inventory parameters such as the default item master organization, DUAL is used for single-value lookups, and PLITBLM is the PL/SQL table-to-database interface utility. All are referenced through APPS synonyms.

Usage Notes

INV_ITEM_GRP is typically invoked from custom concurrent programs, interface loaders, and back-end extensions that must bulk-load or maintain item master data without the Items form. Because g_MISS_NUM and the other sentinels drive API behavior, callers must populate the item record carefully, leaving attributes at their default sentinel when no change is intended. The package is referenced by twenty-one other packages in the ETRM repository. Its use is limited to server-side PL/SQL and concurrent processing; the standard Item Master form continues to use its own internal logic.