Search Results csi_systems_h_pkg




Overview
Explore in AI Chat

Overview

The APPS.CSI_SYSTEMS_H_PKG package is a low-level database maintenance package within the Oracle E-Business Suite Install Base (CSI) module. Install Base maintains the master repository of customer assets, instances, and system configurations that drive service, depot repair, and field service operations. The _H suffix conventionally identifies a table-maintenance helper package that manages the history table associated with the base entity. In this case, the package supports the system hierarchy entity, providing the primitive DML operations used to persist and update records in the CSI_SYSTEMS_H history table and its corresponding CSI_SYSTEMS_H_S secondary (locale/translation) table.

The package is classified as OTHER in the ETRM API classification scheme, indicating that it is an internal implementation package rather than a published, customer-facing PL/SQL API. It is not intended to be invoked directly by external or custom code, but rather functions as a building block consumed by the higher-level public API package CSI_SYSTEMS_PVT.

Key Procedures and Functions

The documented metadata identifies two procedures in this package:

  • INSERT_ROW — Inserts a new row into the systems history table. This procedure is invoked when a new system configuration record must be created in the history store, typically as a result of a system assembly or system-definition transaction.
  • UPDATE_ROW — Updates an existing row in the systems history table. This procedure handles modifications to previously recorded system history entries, such as changes to system attributes or effective dating.

Both procedures are declared in the package Specification and implemented in the package Body. The metadata indicates that both the specification and the body are present and that the object is VALID in the APPS schema. No parameter lists are documented; consumers must consult the live source (via FND_API and STANDARD dependencies) to determine exact signatures.

Tables Accessed

The package reads and writes the following documented tables through APPS synonyms:

  • CSI_SYSTEMS_H — the primary system history entity table. This is the main target of the INSERT_ROW and UPDATE_ROW operations.
  • CSI_SYSTEMS_H_S — the secondary table, typically used to store translated or descriptive attribute values that are not stored in the primary history table. It is maintained in parallel with the primary table so that language-specific content remains consistent.

Because the package touches the underlying history tables directly, it bypasses the validation and business-rule layers that the public CSI_SYSTEMS_PVT API enforces. Direct use therefore carries data-integrity risk.

Usage Notes

CSI_SYSTEMS_H_PKG is an internal package. Per the documented dependencies, it is referenced by CSI_SYSTEMS_PVT (the public systems API) and by itself. It is not referenced by any Oracle Forms or concurrent program in the metadata provided; instead, it is typically invoked indirectly whenever CSI_SYSTEMS_PVT processes a system transaction.

From a technical standpoint, the package relies on FND_API (for the standard API error-handling and message conventions) and on SYS.STANDARD. Its behavior in EBS 12.1.1 and 12.2.2 is functionally consistent, as the ETRM metadata records the object as VALID in both release lines. Customizations should call CSI_SYSTEMS_PVT rather than this package, since the private package does not expose the API-level validation, concurrency, or who-column population that the public layer provides.