[Home] [Help]
2761: /* A source counter cannot be a target counter */
2762: BEGIN
2763: SELECT 'N'
2764: INTO l_valid_flag
2765: FROM csi_counter_relationships
2766: WHERE relationship_type_code = 'CONFIGURATION'
2767: AND source_counter_id = l_object_counter_id;
2768:
2769: CSI_CTR_GEN_UTILITY_PVT.ExitWithErrMsg('CSI_API_TARGET_CTR_EXIST');
4096:
4097:
4098: CURSOR formula_ref_cur(p_counter_id number) IS
4099: SELECT relationship_id
4100: FROM csi_counter_relationships
4101: WHERE object_counter_id = p_counter_id
4102: AND relationship_type_code = 'FORMULA';
4103:
4104: CURSOR derived_filters_cur(p_counter_id NUMBER) IS
4107: WHERE counter_id = p_counter_id;
4108:
4109: CURSOR target_counter_cur(p_counter_id NUMBER) IS
4110: SELECT relationship_id
4111: FROM csi_counter_relationships
4112: WHERE source_counter_id = p_counter_id
4113: AND relationship_type_code = 'CONFIGURATION';
4114:
4115: CURSOR counter_readings_cur(p_counter_id NUMBER) IS
5571: /* A source counter cannot be a target counter */
5572: BEGIN
5573: SELECT 'N'
5574: INTO l_valid_flag
5575: FROM csi_counter_relationships
5576: WHERE relationship_type_code = 'CONFIGURATION'
5577: AND source_counter_id = l_ctr_relationships_rec.object_counter_id;
5578:
5579: CSI_CTR_GEN_UTILITY_PVT.ExitWithErrMsg('CSI_API_TARGET_CTR_EXIST');
7062: attribute14,
7063: attribute15,
7064: attribute_category,
7065: security_group_id
7066: FROM csi_counter_relationships
7067: -- WHERE source_counter_id = p_counter_id;
7068: WHERE object_counter_id = p_counter_id;
7069:
7070: CURSOR ctr_der_filter_cur(p_counter_id NUMBER) IS
7974: attribute14,
7975: attribute15,
7976: attribute_category,
7977: security_group_id
7978: FROM csi_counter_relationships
7979: -- WHERE source_counter_id = p_counter_id;
7980: WHERE object_counter_id = p_counter_id;
7981:
7982: CURSOR ctr_der_filter_cur(p_counter_id NUMBER) IS