Search Results csi_ii_relationships_pkg




Overview
Explore in AI Chat

Overview

CSI_II_RELATIONSHIPS_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM metadata as an "OTHER" API type. It is deployed in both 12.1.1 and 12.2.2 and is part of the Oracle Installed Base (CSI) product family, specifically the module dealing with instance-instance relationships. Its business function is to provide the lowest-level Data Manipulation Language (DML) layer for the CSI_II_RELATIONSHIPS entity — the table that stores the many-to-many associations between two installed base instances, such as a parent-child, component-of, or connected-to relationship. Rather than exposing a public business API, this package encapsulates the primitive Create, Read, Update, and Delete operations on relationship rows so that higher-level packages (notably CSI_II_RELATIONSHIPS_PVT) can perform validation, workflow, and business-rule checks before committing the actual DML. The package is documented as VALID and has a defined dependency footprint, confirming it is a supported internal component of the Installed Base schema. The user-supplied search term "csi_ii_relationships_pkg" corresponds exactly to this object.

Key Procedures and Functions

The ETRM repository documents four procedures in this package. No parameter lists are recorded, so only their names and purpose are described here.

  • INSERT_ROW — Inserts a new instance-instance relationship record. It is the entry point for creating an association between two installed base instances and is normally invoked after the calling layer has confirmed that neither instance is duplicated and that the relationship type is permitted.
  • UPDATE_ROW — Modifies the mutable attributes of an existing relationship row. Typical columns affected include the relationship type, effective dates, and context/attribute columns on the CSI_II_RELATIONSHIPS table.
  • LOCK_ROW — Acquires a row-level lock (SELECT ... FOR UPDATE) on a relationship record to guarantee serialized access before an update or delete. It protects against concurrent modification by multiple users or concurrent managers.
  • DELETE_ROW — Physically removes a relationship row. Oracle Installed Base generally favors end-dating over physical deletion, so this is used selectively for genuinely invalid or mistakenly created relationships.

Tables Accessed

The package operates against two documented tables, referenced through APPS synonyms:

  • CSI_II_RELATIONSHIPS — The base transactional table holding the relationship records. All four procedures read from or write to this table.
  • CSI_II_RELATIONSHIPS_S — The corresponding sequence used to generate the primary key for new rows inserted by INSERT_ROW.

The dependent-object listing further shows that the package references the SYS.STANDARD package, which is the normal implicit dependency for compiled PL/SQL units.

Usage Notes

CSI_II_RELATIONSHIPS_PKG is not intended for direct call by end users or by external integration code. The metadata shows it is referenced by CSI_II_RELATIONSHIPS_PVT and by one other package, which is the standard Oracle design pattern in which the _PVT (private) package contains the business logic and this _PKG package contains the DML primitives. Consequently, the package is typically invoked indirectly: when a user maintains relationships through the Oracle Installed Base or Oracle Depot Repair forms, the form calls the _PVT layer, which in turn delegates insert, update, lock, and delete operations here. The same chain applies to concurrent programs and to any custom extensions that correctly call the public _PVT API rather than this package. Direct invocation by custom code is discouraged, because the _PVT layer performs the validation, security, and auditing checks that the DML layer omits. When reviewing dependency reports or troubleshooting Installed Base relationship errors in 12.1.1 or 12.2.2, this package should be treated as an internal implementation detail whose behaviour is governed by its calling private API.