Search Results get_relationships




Overview
Explore in AI Chat

Overview

APPS.CSI_II_RELATIONSHIPS_PUB is the public PL/SQL API for managing Instance-to-Instance Relationships within the Oracle E-Business Suite Item Instance (CSI) product family. The package exposes a controlled, supported interface for creating, maintaining, querying, and expiring the relationship records that describe how one item instance relates to another — for example, parent/child component hierarchies, containment relationships, or peer associations between tracked instances. Because it is classified as a PUB API and marked with an active lifecycle and "S" (supported) compatibility, it is the sanctioned integration point for external and internal consumers that must manipulate relationship data without writing directly to the underlying tables.

The package operates against the CSI_II_RELATIONSHIPS entity and supports the concept of time-based (historical) retrieval, allowing callers to reconstruct the state of a relationship structure as of a given point in time. This makes it relevant to installed-base and configuration-management scenarios where the relationship topology of an asset or configuration changes over its lifecycle and must be reported as of a past date.

Key Procedures and Functions

The ETRM documentation identifies four public procedures in this package:

  • GET_RELATIONSHIPS — Retrieves the list of relationships among item instances that satisfy the supplied query criteria. When a time stamp is provided, the relationship information is reconstructed from history; otherwise the current relationship is returned. Its parameters include a relationship query record, a depth indicator that controls how many levels the structure is exploded (with NULL meaning all levels), a time stamp for point-in-time configuration, and a flag controlling whether only active relationships are returned. Results are returned in an output relationship table structure, accompanied by the standard API return status, message count, and message data.
  • CREATE_RELATIONSHIP — Creates a new instance-to-instance relationship between item instances.
  • UPDATE_RELATIONSHIP — Modifies the attributes of an existing instance-to-instance relationship.
  • EXPIRE_RELATIONSHIP — Terminates an existing relationship so that it is no longer treated as current, while preserving its historical record.

All procedures follow the Oracle EBS API conventions, accepting API version, commit, and initialization/validation-level parameters and returning standard return status and message stack outputs.

Tables Accessed

The documented tables accessed by this package, through APPS synonyms, are:

  • CSI_II_RELATIONSHIPS — The primary relationship store; read and written by the create, update, expire, and get operations.
  • CSI_ITEM_INSTANCES — The item instance master, used to validate and resolve the instances participating in a relationship.
  • CSI_INSTALL_PARAMETERS — Installation-level setup and control parameters consulted during processing.
  • PLITBLM — The standard EBS message/translation table used to populate the API message stack.

Usage Notes

Because the package is a PUB API, it is intended for invocation from PL/SQL callers rather than direct DML against the CSI relationship tables. Typical consumers include Oracle Forms-based Item Instance and configuration screens, concurrent programs that build or report installed-base hierarchies, and custom extensions and interfaces that need to register or inspect relationships. Standard practice is to call the API, check x_return_status against fnd_api.g_ret_sts_success, and drain messages via fnd_msg_pub. The package is referenced by 23 other packages, confirming its role as a shared dependency in the CSI and installed-base stack in both 12.1.1 and 12.2.2.