Search Results csi_ii_relationships_pub




Overview
Explore in AI Chat

Overview

APPS.CSI_II_RELATIONSHIPS_PUB is a public PL/SQL package body in the Oracle E-Business Suite Install Base (CSI) module. It exposes the supported, published API for maintaining item instance relationships — the associative links between one installed asset and another. These relationships underpin Install Base configurations, service entitlement chains, and the hierarchies that service organizations rely on when tracing which component sits inside, supports, or depends upon a parent item instance. The _PUB classification indicates that the procedures carry the standard EBS API contract: a p_api_version argument, consistent p_init_msg_list/p_commit handling via FND_API, and error feedback through FND_MSG_PUB. The package body is documented as valid in both 12.1.1 and 12.2.2, and its internal logic delegates to a private implementation layer, CSI_II_RELATIONSHIPS_PVT.

Key Procedures and Functions

Four documented entry points are exposed:

  • GET_RELATIONSHIPS — Retrieves the relationship records associated with an item instance, returning the related instances and relationship attributes for display or downstream processing. It is the read-only inquiry entry point.
  • CREATE_RELATIONSHIP — Establishes a new relationship between two item instances. This procedure performs the validation and insert logic, including the Install Base business rules governing permissible relationship types.
  • UPDATE_RELATIONSHIP — Modifies the attributes of an existing relationship without creating a new record, supporting corrections and reclassification of the linkage.
  • EXPIRE_RELATIONSHIP — Terminates a relationship by dating its end, preserving history rather than deleting the row. This aligns with Install Base's date-tracked modeling of asset lifecycles.

The consistent CREATE/UPDATE/EXPIRE triad reflects the standard EBS pattern of maintaining dated entity versions, ensuring that relationship history remains auditable.

Tables Accessed

  • CSI_II_RELATIONSHIPS — The primary base table holding the relationship records; all four procedures ultimately read from or write to it.
  • CSI_ITEM_INSTANCES — Supplies and validates the item instances that participate in each relationship.
  • CSI_INSTALL_PARAMETERS — Provides Install Base system setup and control values consulted during processing.
  • PLITBLM — The standard EBS PL/SQL table/array buffer used for message and collection handling.

Usage Notes

The package is referenced by 23 other database objects, indicating broad internal reuse across Install Base and adjacent modules. Custom code and extensions should call CSI_II_RELATIONSHIPS_PUB rather than the private _PVT layer or direct DML, since only the public package guarantees API versioning and message-stack behavior. Dependencies include CSI_BUSINESS_EVENT_PVT, which suggests the procedures may raise business events on relationship changes; CSI_DATASTRUCTURES_PUB and CSI_GEN_UTILITY_PVT for shared data structure and utility logic; CSI_ITEM_INSTANCE_PVT for item instance validation; and the standard FND_API, FND_MSG_PUB, and FND_PROFILE services. Callers supply the API version, message-list initialization flag, and commit flag in the conventional manner, then inspect the returning status and message table for outcomes.