Search Results csi_systems_h_s

Overview

APPS.CSI_SYSTEMS_H_PKG is a PL/SQL package body in the Oracle E-Business Suite Install Base (CSI) schema, classified under ETRM as an OTHER API. It provides the low-level data manipulation logic for maintaining the history table associated with Install Base system records. In Oracle EBS, the CSI schema stores the configuration of installed customer assets, including systems, instances, and their relationships. The _H suffix denotes a history (audit) table that preserves prior versions of system header rows as they are created or changed, supporting auditability and date-effective inquiry of system configurations.

The package body is the implementation counterpart to the package specification CSI_SYSTEMS_H_PKG. It is reported as VALID and is not referenced by any other database object, indicating it is a leaf dependency used primarily by forms, concurrent processes, or the base Install Base APIs rather than being called from other packaged code.

Key Procedures and Functions

ETRM documents two entry points in this package body:

• INSERT_ROW — Inserts a row into the history table CSI_SYSTEMS_H. It is the mechanism by which a new historical image of a system header record is captured, typically at the point a new system row is created or a snapshot is taken.
• UPDATE_ROW — Updates an existing row in CSI_SYSTEMS_H. This supports correction or re-versioning of an existing historical record, ensuring the audit trail reflects the current state of the source row.

The metadata does not expose explicit parameter lists, so the exact signature should be confirmed from the package specification before direct invocation. The procedures rely on FND_API, indicating the Oracle Application Object Library API conventions are used for standard behaviors such as return status and message handling.

Tables Accessed

The package body operates against two documented objects:

• CSI_SYSTEMS_H — the history table for Install Base systems; INSERT_ROW and UPDATE_ROW write to this table to maintain historical versions of system header data.
• CSI_SYSTEMS_H_S — the sequence used to generate unique primary keys for new history rows inserted by INSERT_ROW.

Both are resolved through APPS synonyms, and DUAL is referenced for sequence or validation lookups, consistent with standard EBS PL/SQL patterns.

Usage Notes

This package is an internal maintenance component of the Install Base history framework. It is most commonly invoked indirectly: Install Base forms and the system header maintenance logic call it when a system record is created or amended so that the corresponding history image is persisted. Direct invocation from custom code is possible but not recommended, because the calling application is responsible for supplying a correctly populated record structure and for coordinating the sequence-based key. Any custom usage should mirror the existing call patterns, honor the FND_API conventions, and commit only within the appropriate transaction boundary to avoid orphaned history rows. Because the object is not referenced by other database objects, impact analysis for upgrades should focus on forms and concurrent program callers rather than on package dependencies.