287: ) IS
288: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_CTR_GRP_TEMPLATE';
289: l_api_version CONSTANT NUMBER := 1.0;
290:
291: l_ctr_groups_rec CSI_CTR_DATASTRUCTURES_PUB.counter_groups_rec;
292: l_ctr_item_associations_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_tbl;
293: l_validation_level NUMBER;
294:
295: BEGIN
288: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_CTR_GRP_TEMPLATE';
289: l_api_version CONSTANT NUMBER := 1.0;
290:
291: l_ctr_groups_rec CSI_CTR_DATASTRUCTURES_PUB.counter_groups_rec;
292: l_ctr_item_associations_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_tbl;
293: l_validation_level NUMBER;
294:
295: BEGIN
296:
509: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_COUNTER';
510: l_api_version CONSTANT NUMBER := 1.0;
511:
512: l_template_flag VARCHAR2(1);
513: l_counter_template_rec CSI_CTR_DATASTRUCTURES_PUB.counter_template_rec;
514: l_ctr_item_associations_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_tbl;
515: l_ctr_property_template_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_property_template_tbl;
516: l_counter_relationships_tbl CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_tbl;
517: l_ctr_derived_filters_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_tbl;
510: l_api_version CONSTANT NUMBER := 1.0;
511:
512: l_template_flag VARCHAR2(1);
513: l_counter_template_rec CSI_CTR_DATASTRUCTURES_PUB.counter_template_rec;
514: l_ctr_item_associations_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_tbl;
515: l_ctr_property_template_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_property_template_tbl;
516: l_counter_relationships_tbl CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_tbl;
517: l_ctr_derived_filters_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_tbl;
518: l_validation_level NUMBER;
511:
512: l_template_flag VARCHAR2(1);
513: l_counter_template_rec CSI_CTR_DATASTRUCTURES_PUB.counter_template_rec;
514: l_ctr_item_associations_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_tbl;
515: l_ctr_property_template_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_property_template_tbl;
516: l_counter_relationships_tbl CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_tbl;
517: l_ctr_derived_filters_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_tbl;
518: l_validation_level NUMBER;
519: BEGIN
512: l_template_flag VARCHAR2(1);
513: l_counter_template_rec CSI_CTR_DATASTRUCTURES_PUB.counter_template_rec;
514: l_ctr_item_associations_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_tbl;
515: l_ctr_property_template_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_property_template_tbl;
516: l_counter_relationships_tbl CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_tbl;
517: l_ctr_derived_filters_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_tbl;
518: l_validation_level NUMBER;
519: BEGIN
520:
513: l_counter_template_rec CSI_CTR_DATASTRUCTURES_PUB.counter_template_rec;
514: l_ctr_item_associations_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_tbl;
515: l_ctr_property_template_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_property_template_tbl;
516: l_counter_relationships_tbl CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_tbl;
517: l_ctr_derived_filters_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_tbl;
518: l_validation_level NUMBER;
519: BEGIN
520:
521: SAVEPOINT Create_Counter_PUB;
738: ) is
739: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_CTR_PROP';
740: l_api_version CONSTANT NUMBER := 1.0;
741:
742: l_ctr_property_template_rec CSI_CTR_DATASTRUCTURES_PUB.ctr_property_template_rec;
743: l_validation_level NUMBER;
744:
745: BEGIN
746:
948: ) is
949: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_FORMULA_REF';
950: l_api_version CONSTANT NUMBER := 1.0;
951:
952: l_counter_relationships_rec CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_rec;
953: l_validation_level NUMBER;
954:
955: cursor ctr_associations IS
956: SELECT ctr_association_id, inventory_item_id
1197: ) is
1198: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_GRPOP_FILTER';
1199: l_api_version CONSTANT NUMBER := 1.0;
1200:
1201: l_ctr_derived_filters_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_tbl;
1202: l_validation_level NUMBER;
1203:
1204: BEGIN
1205:
1428: ) is
1429: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_CTR_ASSOCIATION';
1430: l_api_version CONSTANT NUMBER := 1.0;
1431: l_association_type VARCHAR2(30);
1432: l_ctr_item_associations_rec CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_rec;
1433: l_validation_level NUMBER;
1434: BEGIN
1435: SAVEPOINT Create_Ctr_Association_PUB;
1436:
2024: ) is
2025: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_CTR_GRP';
2026: l_api_version CONSTANT NUMBER := 1.0;
2027:
2028: l_ctr_groups_rec CSI_CTR_DATASTRUCTURES_PUB.counter_groups_rec;
2029: l_ctr_item_associations_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_tbl;
2030: l_validation_level NUMBER;
2031:
2032: BEGIN
2025: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_CTR_GRP';
2026: l_api_version CONSTANT NUMBER := 1.0;
2027:
2028: l_ctr_groups_rec CSI_CTR_DATASTRUCTURES_PUB.counter_groups_rec;
2029: l_ctr_item_associations_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_tbl;
2030: l_validation_level NUMBER;
2031:
2032: BEGIN
2033:
2235: ) is
2236: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_COUNTER';
2237: l_api_version CONSTANT NUMBER := 1.0;
2238:
2239: l_counter_template_rec CSI_CTR_DATASTRUCTURES_PUB.counter_template_rec;
2240: l_ctr_item_associations_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_tbl;
2241: l_ctr_property_template_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_property_template_tbl;
2242: l_counter_relationships_tbl CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_tbl;
2243: l_ctr_derived_filters_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_tbl;
2236: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_COUNTER';
2237: l_api_version CONSTANT NUMBER := 1.0;
2238:
2239: l_counter_template_rec CSI_CTR_DATASTRUCTURES_PUB.counter_template_rec;
2240: l_ctr_item_associations_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_tbl;
2241: l_ctr_property_template_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_property_template_tbl;
2242: l_counter_relationships_tbl CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_tbl;
2243: l_ctr_derived_filters_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_tbl;
2244: l_validation_level NUMBER;
2237: l_api_version CONSTANT NUMBER := 1.0;
2238:
2239: l_counter_template_rec CSI_CTR_DATASTRUCTURES_PUB.counter_template_rec;
2240: l_ctr_item_associations_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_tbl;
2241: l_ctr_property_template_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_property_template_tbl;
2242: l_counter_relationships_tbl CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_tbl;
2243: l_ctr_derived_filters_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_tbl;
2244: l_validation_level NUMBER;
2245:
2238:
2239: l_counter_template_rec CSI_CTR_DATASTRUCTURES_PUB.counter_template_rec;
2240: l_ctr_item_associations_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_tbl;
2241: l_ctr_property_template_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_property_template_tbl;
2242: l_counter_relationships_tbl CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_tbl;
2243: l_ctr_derived_filters_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_tbl;
2244: l_validation_level NUMBER;
2245:
2246: BEGIN
2239: l_counter_template_rec CSI_CTR_DATASTRUCTURES_PUB.counter_template_rec;
2240: l_ctr_item_associations_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_tbl;
2241: l_ctr_property_template_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_property_template_tbl;
2242: l_counter_relationships_tbl CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_tbl;
2243: l_ctr_derived_filters_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_tbl;
2244: l_validation_level NUMBER;
2245:
2246: BEGIN
2247:
2473: ) is
2474: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_CTR_PROP';
2475: l_api_version CONSTANT NUMBER := 1.0;
2476:
2477: l_ctr_property_template_rec CSI_CTR_DATASTRUCTURES_PUB.ctr_property_template_rec;
2478: l_validation_level NUMBER;
2479:
2480: BEGIN
2481:
2694: ) is
2695: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_FORMULA_REF';
2696: l_api_version CONSTANT NUMBER := 1.0;
2697:
2698: l_counter_relationships_rec CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_rec;
2699: l_validation_level NUMBER;
2700:
2701: BEGIN
2702:
2928: ) is
2929: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_GRPOP_FILTER';
2930: l_api_version CONSTANT NUMBER := 1.0;
2931:
2932: l_ctr_derived_filters_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_tbl;
2933: l_validation_level NUMBER;
2934:
2935: BEGIN
2936:
3169: ) is
3170: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_CTR_ASSOCIATION';
3171: l_api_version CONSTANT NUMBER := 1.0;
3172:
3173: l_ctr_item_associations_rec CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_rec;
3174: l_validation_level NUMBER;
3175:
3176: BEGIN
3177:
3684: ) IS
3685: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_ESTIMATION_METHOD';
3686: l_api_version CONSTANT NUMBER := 1.0;
3687:
3688: l_ctr_estimation_methods_rec CSI_CTR_DATASTRUCTURES_PUB.ctr_estimation_methods_rec;
3689: l_validation_level NUMBER;
3690:
3691: BEGIN
3692: SAVEPOINT Create_Ctr_Estimation_PUB;
3805: ) is
3806: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_ESTIMATION_METHOD';
3807: l_api_version CONSTANT NUMBER := 1.0;
3808:
3809: l_ctr_estimation_methods_rec CSI_CTR_DATASTRUCTURES_PUB.ctr_estimation_methods_rec;
3810: l_validation_level NUMBER;
3811: BEGIN
3812:
3813: SAVEPOINT Update_Estimation_Method_PUB;