Search Results create_item_association

Overview

APPS.CSI_COUNTER_TEMPLATE_PUB is a public PL/SQL API package within the Oracle E-Business Suite Install Base (CSI) module. It provides the programmatic interface for defining, maintaining, and instantiating counter templates and counter groups, as well as for associating inventory items with counter groups or individual counters. Counters are the meter objects (for example, unit, copy, or click counters) tracked against installed items, and counter templates exist to standardize how those counters are created across large populations of items. The package is compiled with AUTHID CURRENT_USER, meaning execution privileges and schema resolution follow the calling user, and it exposes a set of global constants (G_PKG_NAME, G_FILE_NAME) plus two PL/SQL record and table types — ctr_template_autoinst_rec/tbl and counter_autoinstantiate_rec/tbl — that carry counter and group identifiers for bulk instantiation operations. In release 12.1.1 and 12.2.2 the package retains the same public surface, with the source header referencing csipctts.pls 120.3.12010000.1 (2008/07/25). The object is referenced by eight other packages, indicating it sits on a well-trodden integration path used by Install Base setup, service, and contract flows.

Key Procedures and Functions

The 18 documented entry points group naturally into creation, update, retrieval, instantiation, and deletion operations. All follow the standard EBS API convention of p_api_version, p_commit, p_init_msg_list, p_validation_level, and x_return_status / x_msg_count / x_msg_data parameters.

• CREATE_COUNTER_GROUP — creates a counter group and may simultaneously accept a table of counter-to-item associations. This is the procedure most often used alongside item association setup, since counters are organized into groups before items are attached.
• CREATE_ITEM_ASSOCIATION — the procedure matching the user search term. It creates an association between an inventory item and a counter group or an individual counter, accepting a ctr_item_associations record. This is the API that links MTL system items to CSI counter definitions.
• CREATE_COUNTER_TEMPLATE — defines a reusable counter template that can later be applied to multiple items.
• CREATE_CTR_PROPERTY_TEMPLATE — creates the property templates that describe the attributes (such as reading direction, rollover, or reset behaviour) of counters.
• CREATE_COUNTER_RELATIONSHIP — establishes relationships between counters, supporting derived or dependent counter configurations.
• CREATE_DERIVED_FILTERS — defines filters used when a counter value is derived from another counter or source.
• UPDATE_COUNTER_GROUP, UPDATE_ITEM_ASSOCIATION, UPDATE_COUNTER_TEMPLATE, UPDATE_CTR_PROPERTY_TEMPLATE, UPDATE_COUNTER_RELATIONSHIP, UPDATE_DERIVED_FILTERS — the corresponding maintenance procedures for each created entity.
• CREATE_ESTIMATION_METHOD / UPDATE_ESTIMATION_METHOD — maintain the estimation methods used to project counter readings when actual readings are unavailable.
• AUTOINSTANTIATE_COUNTERS, INSTANTIATE_GRP_COUNTERS, INSTANTIATE_COUNTERS — apply templates and group definitions, creating concrete counter instances against installed items; these operate on the autoinstantiate record/table types declared at package level.
• DELETE_ITEM_ASSOCIATION — removes an existing item-to-counter association.

Tables Accessed

The package reads and writes through APPS synonyms. CSI_COUNTER_TEMPLATE_B stores the base counter template definitions. CSI_CTR_ITEM_ASSOCIATIONS is the central intersection table holding item-to-counter and item-to-group associations, written by CREATE_ITEM_ASSOCIATION and UPDATE_ITEM_ASSOCIATION and cleared by DELETE_ITEM_ASSOCIATION. CS_CSI_COUNTER_GROUPS holds counter group headers used by CREATE_COUNTER_GROUP and the instantiation procedures. MTL_SYSTEM_ITEMS_B, MTL_SYSTEM_ITEMS_KFV, and MTL_PARAMETERS provide item validation and descriptive flexfield key information for the items being associated, ensuring that only valid, installed items in the current operating unit are linked. PLITBLM is the standard EBS PL/SQL message table used to accumulate API error messages returned through x_msg_count and x_msg_data.

Usage Notes

CSI_COUNTER_TEMPLATE_PUB is normally invoked from Install Base setup forms, from concurrent programs that bulk-instantiate counters across item populations, and from custom PL/SQL that automates counter provisioning during item onboarding or service contract activation. Callers should initialize the message list, pass a valid API version, and choose p_commit carefully: when several procedures are chained in one logical transaction, commit once at the end. Because the package is AUTHID CURRENT_USER and referenced by eight other packages, embedded calls typically resolve through the APPS schema. The presence of CREATE_ITEM_ASSOCIATION and DELETE_ITEM_ASSOCIATION makes this package the supported route for programmatic maintenance of counter-to-item links, rather than direct DML against CSI_CTR_ITEM_ASSOCIATIONS.