Search Results update_counter_reading_post




Overview

CSI_COUNTER_READINGS_VUHK is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite, deployed identically on 12.1.1 and 12.2.2. It belongs to the Enterprise Asset Management (eAM) / Complex Maintenance Repair and Overhaul (cMRO) product family and serves the counter reading capture and update business function. Counters represent cumulative or replenishment meters associated with maintainable assets — such as odometer, hours-run, or cycle meters. The "_VUHK" suffix indicates that this is a generated validation hook (VUHK) stub package, whose header comments carry the revision marker $Header: csivhcrb.pls 120.0 2005/06/10 08:58 srramakr noship $. Notably, the source excerpt shows that every procedure body simply sets x_return_status := FND_API.G_RET_STS_SUCCESS and returns, confirming that the package is a placeholder hook with no substantive business logic of its own.

Key Procedures and Functions

The ETRM metadata documents four procedures. Each follows the Oracle Applications API convention, taking a standard API version, commit flag, initialization message list flag, and validation level, and returning the standard x_return_status, x_msg_count, and x_msg_data OUT parameters. Their names indicate they act as pre/post validation hooks surrounding the corresponding base API operations in the CSI Counter Readings public package.

  • CAPTURE_COUNTER_READING_PRE — Pre-processing validation hook invoked before counter readings are captured. It receives the transaction table and counter reading/property reading tables as IN parameters and performs no default logic beyond signaling success.
  • CAPTURE_COUNTER_READING_POST — Post-processing hook invoked after counter readings are captured. It is identical in signature to the Pre variant and likewise returns success without further processing.
  • UPDATE_COUNTER_READING_PRE — Pre-processing validation hook invoked before an existing counter reading is updated. This is the procedure surfaced by the user's search term "update_counter_reading_post".
  • UPDATE_COUNTER_READING_POST — Post-processing hook invoked after a counter reading is updated, providing an extension point where customer-specific validation or side effects may be added.

Tables Accessed

The ETRM metadata for this object lists no tables referenced through APPS synonyms. This is consistent with the source excerpt: none of the documented procedure bodies issue DML or queries. Data is instead passed in by the caller via PL/SQL record collections defined in CSI_DATASTRUCTURES_PUB (transaction table) and CSI_CTR_DATASTRUCTURES_PUB (counter readings and counter property readings tables). Any persistence of counter readings occurs in the base CSI Counter Readings API, not in this hook package.

Usage Notes

Because this is a generated validation hook stub, it is not called directly by end users. It is referenced by two other packages and is invoked by the framework as part of the counter reading capture and update flow — typically when a technician enters meter readings through an eAM/cMRO form or when readings are loaded through a concurrent program or public API. The "_VUHK" naming convention allows Oracle to regenerate the stub while preserving customer extensions placed in it. Implementers seeking to add custom validation around counter reading capture or update, including the update_counter_reading_post event, should add logic inside the appropriate Pre or Post procedure while respecting the standard API contract and returning FND_API.G_RET_STS_SUCCESS or an error status as appropriate.