Search Results sync_im_index

Overview

INV_ITEM_PVT is a private (PVT-classified) PL/SQL package in the Oracle E-Business Suite Applications schema (APPS), distributed with the Inventory module. It supplies the internal implementation layer that underpins the master and organization item definition APIs exposed by INV_Item_API. Declared with AUTHID CURRENT_USER, the package executes under the privileges of the calling session rather than the definer, which means access to the underlying MTL and CST tables is governed by the caller's grants. Its responsibilities include item record retrieval and validation, item creation and update across master and child organizations, item number checking (the specific function behind the check_item_number search), multi-language description maintenance, index synchronization, and cost detail cleanup. Because it is a PVT package, it is not a published integration surface; it is intended for consumption by sibling public APIs and EBS internal code paths.

Key Procedures and Functions

The package exposes sixteen documented programs. The principal transactional entry points are CREATE_ITEM, UPDATE_ITEM, and UPDATE_ORG_ITEMS, which carry out insert and modify operations on item definitions, with UPDATE_ORG_ITEMS accepting an item record structure and controlling change-only updates and master validation. LOCK_ITEM and LOCK_ORG_ITEMS acquire row locks prior to modification; CHECK_MASTER_RECORD_LOCKED supports master-level lock checking. GET_ORG_ITEM and VALIDATE_ITEM retrieve an item's organization context and apply validation rules respectively. CHECK_ITEM_NUMBER — the program referenced by the user's search term — performs item number verification, typically confirming uniqueness or existence against the item master. Supporting utilities include UPDATE_NLS_TO_ORG and ADD_LANGUAGE for translated item attributes, SYNC_IM_INDEX for keeping the item index consistent, DELETE_ROW and DELETE_COST_DETAILS for removing item rows and associated cost records, and GET_IS_MASTER_ATTR_MODIFIED / SET_IS_MASTER_ATTR_MODIFIED for tracking whether master-level attributes have been altered. The package does not carry a public API commitment; signatures are private and subject to change.

Tables Accessed

Through APPS synonyms, the package reads and writes the core item master tables MTL_SYSTEM_ITEMS and MTL_SYSTEM_ITEMS_B, along with MTL_ITEM_ATTRIBUTES for attribute-level values and MTL_STATUS_ATTRIBUTE_VALUES for status control. Costing data is touched via CST_ITEM_COSTS, CST_ITEM_COST_DETAILS, CST_LAYER_COST_DETAILS, and CST_QUANTITY_LAYERS, which explains the DELETE_COST_DETAILS routine. Multi-language text is stored in EGO_ITEM_TEXT_TL, with FND_LANGUAGES supplying language definitions. Organization context is derived from MTL_PARAMETERS, HR_ORGANIZATION_INFORMATION, and FND_OBJECTS, while FND_USER and FND_GRANTS support authorization checks.

Usage Notes

INV_ITEM_PVT is referenced by nine other packages, indicating it is called internally by the public item APIs rather than invoked directly. Customizations should call the supported public counterpart (INV_Item_API / INV_Item_GRP-style interfaces) instead of this PVT package, since its procedures and signatures are not frozen across releases. In EBS 12.1.1 and 12.2.2 the package remains a private implementation helper; the check_item_number functionality is reached indirectly through public item validation APIs, online Item Master forms, and interfaces such as item import. Direct calls are unsupported and risk breakage on patching.