Search Results create_ctr_prop_template_post

Overview

CSI_COUNTER_TEMPLATE_VUHK is an Oracle E-Business Suite PL/SQL package body owned by the APPS schema, classified under API type OTHER within the ETRM repository. The package is part of the Counter Template and Installed Base (CSI) module family and functions as a user hook (VUHK) layer that exposes pre- and post-event entry points around the core counter template business operations. Its header footprint (csivhctb.pls, version 120.3, dated 2005/09/19) indicates that it has been a stable artifact since the early 11i lineage and was carried forward into EBS 12.1.1 and 12.2.2 without structural change.

The business purpose of the package is to provide extensibility hooks that Oracle Development and customers can leverage to inject custom validation, defaulting, or side-effect logic at well-defined points in the counter management lifecycle. Each public procedure mirrors a corresponding stage of the counter, counter group, item association, counter template, counter property template, counter relationship, and derived filter creation and update flows.

Key Procedures and Functions

The package exposes thirty-four documented procedures, organized in pre/post pairs around the following business entities:

• CREATE_COUNTER_GROUP_PRE / _POST — entry points surrounding the creation of a counter group.
• CREATE_ITEM_ASSOCIATION_PRE / _POST — hooks around creation of counter item associations.
• CREATE_COUNTER_TEMPLATE_PRE / _POST — hooks around creation of a counter template.
• CREATE_CTR_PROP_TEMPLATE_PRE / _POST — the specific hook the user searched for; invoked before and after creation of a counter property template.
• CREATE_CTR_RELATIONSHIP_PRE / _POST — hooks around creation of counter relationships.
• CREATE_DERIVED_FILTERS_PRE / _POST — hooks around creation of derived filters.
• UPDATE_COUNTER_GROUP_PRE / _POST, UPDATE_ITEM_ASSOCIATION_PRE / _POST, UPDATE_COUNTER_TEMPLATE_PRE / _POST, UPDATE_CTR_PROP_TEMPLATE_PRE / _POST — the corresponding update-stage hooks for each entity.

Each procedure accepts an API version, commit flag, initialization flag, validation level, entity record(s), and returns x_return_status, x_msg_count, and x_msg_data following the standard FND_API error handling convention. In the shipped body, the pre/post procedures are stubs that simply set x_return_status to FND_API.G_RET_STS_SUCCESS, confirming their role as extension points rather than business logic implementations.

Tables Accessed

The ETRM metadata does not document explicit table references via APPS synonyms for this package. Because the procedures operate exclusively on data structures passed in through parameters (such as counter_groups_rec and ctr_item_associations_tbl from CSI_CTR_DATASTRUCTURES_PUB) and because the shipped bodies are no-op stubs, no direct DML against CSI base tables is performed. Any table access occurs in the calling core API packages that invoke these hooks. Referenced by one other package in the ETRM inventory.

Usage Notes

CSI_COUNTER_TEMPLATE_VUHK is not directly user-facing. It is invoked by the Oracle core counter template APIs at the designated pre and post stages of each business operation. Customers and partners who require custom behavior — for example, additional validation of counter property template attributes, defaulting logic, or downstream notifications — modify these procedure bodies rather than the core APIs, preserving upgrade safety. Typical calling contexts include the Counter Template setup forms in the Oracle Installed Base HTML/Forms UI, concurrent programs that mass-create or update counter configurations, and custom PL/SQL programs that drive the counter APIs programmatically.