Search Results csi_counter_readings_s




Overview
Explore in AI Chat

Overview

The APPS.CSI_COUNTER_READINGS_PKG package body is a stored PL/SQL program unit within the Oracle E-Business Suite (EBS) Applications schema. Its status is recorded as VALID in the ETRM registry and it belongs to the Enterprise Asset Management / Installed Base product family that owns the CSI_ table prefix (CSI denoting the Install Base / Counter Readings subsystem). The package provides the database-level implementation responsible for maintaining counter reading records — the periodic meter, gauge, and usage measurements captured against an asset or counter definition. Its classification is listed as OTHER, indicating it is not a public, certified integration API but rather an internal maintenance package used to persist and manipulate counter reading rows on behalf of other components.

Functionally, the package supplies the create, modify, lock, and remove operations needed to keep the CSI_COUNTER_READINGS table synchronized with its associated tables and business logic. It relies on Oracle's standard Application Object Library error handling and messaging infrastructure (FND_API, FND_MESSAGE, and APP_EXCEPTION) so that failures are raised through the same conventions used across EBS APIs, rather than raw Oracle exceptions.

Key Procedures and Functions

ETRM documents four callable units within the package body:

  • INSERT_ROW — Creates a new counter reading record. This routine is the entry point for persisting a freshly captured counter value (meter reading, gauge value, or usage quantity) against its parent counter definition.
  • UPDATE_ROW — Modifies an existing counter reading record, allowing correction or enrichment of previously stored readings.
  • LOCK_ROW — Acquires a row-level lock on a specified counter reading, providing concurrency control so that concurrent sessions cannot modify the same record simultaneously.
  • DELETE_ROW — Removes an existing counter reading record from the table, supporting purge, reversal, or correction scenarios.

The package follows the conventional EBS pattern in which insert, update, lock, and delete logic is encapsulated per row so that callers do not issue direct DML against the underlying table. Parameter lists are intentionally not documented in the ETRM excerpt and are not reproduced here.

Tables Accessed

The package references the following objects through APPS synonyms:

  • CSI_COUNTER_READINGS — The primary transactional table holding counter reading data. It is the target of the INSERT, UPDATE, and DELETE operations and the source for the LOCK operation.
  • CSI_COUNTER_READINGS_S — The sequence used to generate primary key values for new counter reading rows. Notably, this sequence is the object most closely matching the user's search term csi_counter_readings_s.
  • DUAL — The standard SYS single-row pseudo-table, typically used for sequence selection or lightweight value checks within PL/SQL.

The package also depends on the standard PL/SQL STANDARD package and on the EBS error-handling packages noted above.

Usage Notes

Because CSI_COUNTER_READINGS_PKG is documented as being referenced by two other database objects while itself referencing the counter readings tables, it is best understood as a lower-level service layer invoked by higher-level EBS code rather than called directly by end users. Typical invocation paths include Install Base / counter reading forms and concurrent programs that record or adjust counter values, as well as custom extensions or integrations that must load readings programmatically. Custom code should call the package's procedures instead of performing direct DML on CSI_COUNTER_READINGS, which ensures that sequence-based key generation, locking, and standardized error messaging remain consistent. Developers should confirm the exact parameter signatures in the source before use, since ETRM does not document them here.