Search Results csi_counter_template_cuhk

Overview

APPS.CSI_COUNTER_TEMPLATE_CUHK is a PL/SQL package in the Oracle E-Business Suite Applications schema (APPS) that belongs to the Enterprise Asset Management / Installed Base product family delivered by the CSI (Customer Support Installed Base) module. The suffix "CUHK" identifies it as a customization hook package generated and maintained by the Oracle Applications metadata layer: it exists to expose business-event entry points that customer extensions can override without modifying Oracle-owned code. In the Oracle EBS 12.1.1 and 12.2.2 releases this package sits between the public API CSI_COUNTER_TEMPLATE_PUB and the internal data-structure utilities provided by CSI_CTR_DATASTRUCTURES_PUB.

The functional area it supports is the definition and maintenance of meter counter templates, counter groups, counter properties, item associations and derived filters used by Installed Base meter (counter) tracking. These templates drive how counters are created against an asset, how their properties behave, and how relationships between counters are established. Because the package is registered as an "OTHER" API classification rather than a documented public API, it functions as a pre- and post-processing layer rather than a callable business API in its own right.

Key Procedures and Functions

The package exposes 34 documented procedures and functions, organised as matching PRE and POST hooks around the public API operations. Each PRE procedure executes before the corresponding public API logic and is intended for validation, defaulting or data enrichment; each POST procedure executes after the public API completes and is used for downstream propagation, auditing or integration. Representative operations include:

• Counter group operations — CREATE_COUNTER_GROUP_PRE / _POST and UPDATE_COUNTER_GROUP_PRE / _POST, invoked when counter groups are defined or modified.
• Item association operations — CREATE_ITEM_ASSOCIATION_PRE / _POST and UPDATE_ITEM_ASSOCIATION_PRE / _POST, invoked when counters are associated with inventory items.
• Counter template operations — CREATE_COUNTER_TEMPLATE_PRE / _POST and UPDATE_COUNTER_TEMPLATE_PRE / _POST, the primary template lifecycle hooks.
• Counter property template operations — CREATE_CTR_PROP_TEMPLATE_PRE / _POST and UPDATE_CTR_PROP_TEMPLATE_PRE / _POST, covering meter property definitions.
• Counter relationship operations — CREATE_CTR_RELATIONSHIP_PRE / _POST, governing relationships between counters.
• Derived filter operations — CREATE_DERIVED_FILTERS_PRE / _POST, supporting derived counter filter generation.

Tables Accessed

The ETRM dependency record for this package lists no direct table references through APPS synonyms. All persistence is performed indirectly through the dependent packages. CSI_COUNTER_TEMPLATE_PUB provides the public API surface that performs the actual DML against the CSI counter template, counter group, item association and counter property tables, while CSI_CTR_DATASTRUCTURES_PUB supplies the PL/SQL record and table type definitions used to pass parameter data between the API and its callers. This design keeps CSIHK packages free of direct SQL and preserves the integrity of the underlying data model.

Usage Notes

CSI_COUNTER_TEMPLATE_CUHK is not intended to be called directly by forms, concurrent programs or custom code. It is referenced by exactly one other package — CSI_COUNTER_TEMPLATE_PUB — which invokes the PRE and POST hooks as part of its execution path. In Oracle EBS 12.1.1 and 12.2.2 the same design pattern is applied by the Oracle Applications customization-hook framework, which automatically generates the empty hook bodies and wires them into the owning public API.

Customers who need to add validation, defaulting or integration logic to counter template processing should implement their logic inside the appropriate PRE or POST procedure of this package using the standard customization-hook registration mechanism, rather than modifying the public API. Any change must be re-applied after patching, since the package is regenerated by AD utilities. The related data structure package, CSI_CTR_DATASTRUCTURES_PUB, is the object most commonly searched alongside this package, as it defines the parameter types the hooks receive.