[Home] [Help]
2769: /* A source counter cannot be a target counter */
2770: BEGIN
2771: SELECT 'N'
2772: INTO l_valid_flag
2773: FROM csi_counter_relationships
2774: WHERE relationship_type_code = 'CONFIGURATION'
2775: AND source_counter_id = l_object_counter_id
2776: AND NVL(active_end_date, SYSDATE+1) > SYSDATE; --bug9160706
2777:
4109:
4110:
4111: CURSOR formula_ref_cur(p_counter_id number) IS
4112: SELECT relationship_id
4113: FROM csi_counter_relationships
4114: WHERE object_counter_id = p_counter_id
4115: AND relationship_type_code = 'FORMULA';
4116:
4117: CURSOR derived_filters_cur(p_counter_id NUMBER) IS
4120: WHERE counter_id = p_counter_id;
4121:
4122: CURSOR target_counter_cur(p_counter_id NUMBER) IS
4123: SELECT relationship_id
4124: FROM csi_counter_relationships
4125: WHERE source_counter_id = p_counter_id
4126: AND relationship_type_code = 'CONFIGURATION';
4127:
4128: CURSOR counter_readings_cur(p_counter_id NUMBER) IS
5592: /* A source counter cannot be a target counter */
5593: BEGIN
5594: SELECT 'N'
5595: INTO l_valid_flag
5596: FROM csi_counter_relationships
5597: WHERE relationship_type_code = 'CONFIGURATION'
5598: AND source_counter_id = l_ctr_relationships_rec.object_counter_id;
5599:
5600: CSI_CTR_GEN_UTILITY_PVT.ExitWithErrMsg('CSI_API_TARGET_CTR_EXIST');
7084: attribute14,
7085: attribute15,
7086: attribute_category,
7087: security_group_id
7088: FROM csi_counter_relationships
7089: -- WHERE source_counter_id = p_counter_id;
7090: WHERE object_counter_id = p_counter_id;
7091:
7092: CURSOR ctr_der_filter_cur(p_counter_id NUMBER) IS
8018: attribute14,
8019: attribute15,
8020: attribute_category,
8021: security_group_id
8022: FROM csi_counter_relationships
8023: -- WHERE source_counter_id = p_counter_id;
8024: WHERE object_counter_id = p_counter_id;
8025:
8026: CURSOR ctr_der_filter_cur(p_counter_id NUMBER) IS