Search Results item_updated

Overview

IBE_SEARCH_PVT is a private PL/SQL package owned by the APPS schema in Oracle E-Business Suite releases 12.1.1 and 12.2.2. It belongs to the iStore (IBE) product family and supports the search and indexing infrastructure that allows customers to locate inventory items through the Oracle iStore storefront. The package encapsulates the event-handling logic required to keep the iStore search index synchronized with changes made to inventory items and their category assignments in Oracle Inventory. The "PVT" classification indicates this is an internal implementation package; it is not a public API intended for direct invocation by external callers, and its procedures are designed to be fired by database triggers or internal iStore processing logic in response to DML against the underlying item and category tables.

Key Procedures and Functions

The package exposes eight documented procedures, all of which follow an event-driven naming convention that identifies both the triggering event and the affected entity:

• ITEM_CATEGORY_INSERTED — Handles the creation of a new item-to-category association, accepting the new category, category set, inventory item, and organization identifiers.
• ITEM_CATEGORY_DELETED — Handles removal of an item-to-category association, accepting the old category, category set, inventory item, and organization identifiers.
• ITEM_CATEGORY_UPDATED — Handles modifications to an existing item-to-category association, accepting both old and new values for the category, category set, inventory item, and organization identifiers.
• ITEM_DELETED — Handles deletion of an inventory item from the searchable catalog.
• ITEM_UPDATED — Handles item changes, including transitions in the web status flag that governs whether an item is published to the storefront.
• ITEMTL_DELETED — Handles deletion of a translated (language-specific) item description row.
• ITEMTL_UPDATED — Handles changes to translated item descriptions, including language, description, and long description attributes.
• ITEMTL_INSERTED — Handles insertion of new translated item description rows.

Tables Accessed

The package interacts with the following documented tables through APPS synonyms:

• MTL_SYSTEM_ITEMS_B, MTL_SYSTEM_ITEMS_KFV, MTL_SYSTEM_ITEMS_TL — Oracle Inventory base, key flexfield view, and translation tables holding item definitions and language-specific descriptions that drive searchable content.
• MTL_ITEM_CATEGORIES — Stores the item-to-category assignments whose changes trigger the category event procedures.
• IBE_CT_IMEDIA_SEARCH and IBE_CT_IMEDIA_SEARCH_S1 — iStore media search staging/index tables that hold the searchable representation of catalog content.
• IBE_DSP_SECTION_ITEMS — iStore display section membership, linking items to storefront presentation structures.

These tables are read and written to reconcile the iStore search index with the current state of inventory items, their translations, and their category assignments.

Usage Notes

IBE_SEARCH_PVT is invoked indirectly rather than through direct application calls. It is referenced by at least one other package in the EBS codebase, and its procedures are typically fired by triggers attached to the MTL_SYSTEM_ITEMS_TL and MTL_ITEM_CATEGORIES tables, or by internal iStore indexing processes that detect changes to catalog-relevant data. Because the package is classified as PVT, it should not be invoked from custom code; developers seeking to modify item searchability should rely on the public iStore and Inventory APIs, which will in turn drive these private event procedures. The presence of both Item and ItemTL variants reflects the need to keep the searchable catalog synchronized across all installed languages, ensuring that translated descriptions are indexed alongside base item attributes.