Results for “inv_item_events_pvt”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

INV_ITEM_EVENTS_PVT is an Oracle Application Object Library (APPS) private package body that provides the event-propagation and integration-dispatch infrastructure for item master transactions in Oracle E-Business Suite release 12.1.1 and 12.2.2. The package belongs to the Oracle Inventory (INV) product family and is classified under the API convention as a PVT ("private") package, meaning it is intended for internal, controlled invocation rather than direct customer use. Its business purpose is to detect and broadcast item-related events generated during create, update, and interface-processing operations against the MTL_SYSTEM_ITEMS and MTL_SYSTEM_ITEMS_INTERFACE entity, and to relay those events to subscribing downstream consumers.

The package consolidates the sequencing of event raising with the invocation of supplemental integration APIs. Rather than allowing each calling program to decide which external hooks to fire, INV_ITEM_EVENTS_PVT centralises this logic so that item changes consistently trigger the same dependent processes — Intercompany (ICX), India localization (JAI), and China localization (JG_ZZ) integrations, along with synchronization of item index data.

Key Procedures and Functions

Six documented entry points exist within the package body:

• RAISE_EVENTS — The principal driver procedure. It assembles and emits item events for subsequent consumption, forming the core of the package's event broadcast responsibility.
• INVOKE_ICX_APIS — Invokes the Oracle Intercompany integration APIs so that item attribute changes propagate to intercompany transaction processing.
• INVOKE_ICX_WRAPPER — A wrapper routine that shields callers from the underlying ICX invocation details, delegating to EGO_WF_WRAPPER_PVT where workflow participation is required.
• SYNC_IP_IM_INDEX — Synchronises the item index structures used by Oracle Item Master, ensuring index consistency after item modifications.
• INVOKE_JAI_API — Triggers the India localisation (JAI) integration for item events, supporting statutory requirements for Indian operations.
• INVOKE_JG_ZZ_API — Triggers the corresponding localisation integration associated with JG/ZZ requirements.

All procedures share the package's dependency set and are not documented independently, reflecting their tightly coupled, internal orchestration role.

Tables Accessed

The package references several Inventory base and interface tables through APPS synonyms:

• MTL_SYSTEM_ITEMS and MTL_SYSTEM_ITEMS_KFV — the core item definition and its key-flexfield view, read to identify the item and its descriptive attributes at event time.
• MTL_SYSTEM_ITEMS_INTERFACE, MTL_ITEM_CATEGORIES_INTERFACE, and MTL_ITEM_REVISIONS_INTERFACE — staging tables whose processing drives item event generation during batch imports.
• MTL_CATEGORIES_KFV and MTL_ITEM_CATEGORIES_INTERFACE — used to resolve category assignments transmitted with item events.
• MTL_PARAMETERS — supplies organisation-level Inventory setup and control flags.
• HR_ORGANIZATION_INFORMATION and ORG_ORGANIZATION_DEFINITIONS — provide organisation classification and operating unit context.
• DUAL — used for scalar resolution of profile values and constants.

Usage Notes

INV_ITEM_EVENTS_PVT is not intended for direct customer invocation. It is called internally by the item master transaction flow, by interface concurrent programs that load MTL_SYSTEM_ITEMS_INTERFACE, and by dependent PL/SQL packages; the metadata records that it references INV_ITEM_PVT, INV_ITEM_UTIL, INVPUTLI, FND_API, and FND_PROFILE, and is itself referenced by twenty other database objects. Customisations should invoke the public INV_ITEM_PVT API rather than this private package, allowing INV_ITEM_EVENTS_PVT to perform event propagation transparently in both 12.1.1 and 12.2.2 environments.