Search Results csi_item_instance_vld_pvt




Overview
Explore in AI Chat

Overview

CSI_ITEM_INSTANCE_VLD_PVT is a private PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified as a PVT (private) API within the Complex Maintenance, Repair, and Overhaul (CSI) product family. Its primary business function is to centralize the validation logic applied to item instances — the deployed, serialized, or lot-controlled units tracked in Oracle Installed Base. Rather than permitting every calling module to implement its own checks, this package encapsulates reusable validation routines covering identifiers, revisions, serial and lot numbers, units of measure, quantities, organization-dependent parameters, conditions, and instance status. Because it is a private package, it is not intended to be called directly by external integrations or customer extensions; it exists as an internal validation service consumed by the public CSI APIs and the various grouping and transaction-handling packages that manage the installed base lifecycle.

Key Procedures and Functions

The package exposes 63 documented procedures and functions, consistent with its role as a shared validation utility.

Tables Accessed

The package reads and writes the core Installed Base tables through APPS synonyms. CSI_ITEM_INSTANCES, along with its _H, _H_S, and _S history and security variants, hold the instance records being validated. CSI_INSTANCE_STATUSES and CSI_TXN_ERRORS support status evaluation and error logging. CSI_I_ASSETS, CSI_I_PARTIES, CSI_I_EXTENDED_ATTRIBS, and CSI_I_VERSION_LABELS supply asset, party-relationship, descriptive-flexfield, and version-label data used during validation. CSI_TRANSACTIONS and CSI_T_TRANSACTION_LINES provide transaction context, while CSI_II_RELATIONSHIPS, CSI_INSTANCE_INTERFACE, and CSI_II_FORWARD_SYNC_TEMP participate in interface and relationship processing.

Usage Notes

CSI_ITEM_INSTANCE_VLD_PVT is referenced by 15 packages, including CSI_ITEM_INSTANCE_PUB, CSI_ITEM_INSTANCE_PVT, CSI_INTERFACE_PKG, CSI_INV_TXN_HOOK_PKG, CSI_ORDER_FULFILL_PUB, CSI_ORDER_SHIP_PUB, CSI_ONT_TXN_PUB, CSI_FA_INSTANCE_GRP, and CSI_DIAGNOSTICS_PKG. It is invoked indirectly during Installed Base instance creation and update, inventory transaction hooks, order fulfillment and shipping, and interface imports. It depends on FND_API and CSI_DATASTRUCTURES_PUB for the standard API error and data-structure conventions. Because the package is private, custom code should call the corresponding public APIs, such as CSI_ITEM_INSTANCE_PUB, rather than this package directly; the naming convention and documentation confirm the same pattern applies across both 12.1.1 and 12.2.2.