[Home] [Help]
166:
167: BEGIN
168: SELECT direction, start_date_active, end_date_active
169: INTO x_direction, x_start_date, x_end_date
170: FROM csi_counters_b
171: WHERE counter_id = p_counter_id;
172:
173: EXCEPTION
174: WHEN no_data_found THEN
2951: BEGIN
2952: -- validate all counters
2953: SELECT nvl(type, 'REGULAR'), name
2954: into l_type, l_name
2955: FROM csi_counters_bc_v
2956: WHERE counter_id = l_ctr_derived_filters_rec.counter_id;
2957:
2958: EXCEPTION
2959: WHEN NO_DATA_FOUND THEN
3114: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3115: RAISE FND_API.G_EXC_ERROR;
3116: END IF;
3117:
3118: UPDATE csi_counters_b
3119: SET valid_flag = decode(l_valid_flag, 'Y', 'Y', 'N')
3120: WHERE counter_id = l_ctr_derived_filters_rec.COUNTER_ID;
3121:
3122: --l_ctr_derived_filters_rec.OBJECT_VERSION_NUMBER := 1;
5851: BEGIN
5852: -- validate all counters
5853: SELECT NVL(type, 'REGULAR'), name
5854: INTO l_type, l_name
5855: FROM csi_counters_bc_v
5856: WHERE counter_id = p_ctr_derived_filters_tbl(tab_row).counter_id;
5857: EXCEPTION WHEN NO_DATA_FOUND THEN
5858: csi_ctr_gen_utility_pvt.ExitWithErrMsg('CSI_API_CTR_INVALID');
5859: END;
6012: WHERE counter_id = p_ctr_derived_filters_tbl(tab_row).COUNTER_ID;
6013: csi_ctr_gen_utility_pvt.put_line('after updating csi_counters_vl');
6014: EXCEPTION
6015: WHEN NO_DATA_FOUND THEN
6016: UPDATE csi_counters_b
6017: SET valid_flag = decode(l_valid_flag, 'Y', 'Y', 'N')
6018: WHERE counter_id = p_ctr_derived_filters_tbl(tab_row).COUNTER_ID;
6019: csi_ctr_gen_utility_pvt.put_line('after updating csi_counters_vl');
6020: END;
7154: IF ctr_cur_rec.derive_counter_id IS NOT NULL THEN
7155: BEGIN
7156: SELECT max(counter_id)
7157: INTO l_new_derive_counter_id
7158: FROM csi_counters_b
7159: WHERE created_from_counter_tmpl_id = ctr_cur_rec.derive_counter_id;
7160: EXCEPTION
7161: WHEN NO_DATA_FOUND THEN
7162: csi_ctr_gen_utility_pvt.put_line( ' New counter id not found for deriver counte id '||to_char(ctr_cur_rec.derive_counter_id));
7556: FOR ctr_formula_bvars_cur_rec IN ctr_formula_bvars_cur(l_counter_id)
7557: LOOP
7558: SELECT max(counter_id)
7559: INTO l_new_mapped_ctr_id
7560: FROM csi_counters_b
7561: WHERE created_from_counter_tmpl_id = ctr_formula_bvars_cur_rec.source_counter_id;
7562: -- AND defaulted_group_id = l_new_ctr_grp_id;
7563:
7564: IF ctr_formula_bvars_cur_rec.source_counter_id IS NOT NULL THEN
8149: IF ctr_cur_rec.derive_counter_id IS NOT NULL THEN
8150: BEGIN
8151: SELECT max(counter_id)
8152: INTO l_new_derive_counter_id
8153: FROM csi_counters_b
8154: WHERE created_from_counter_tmpl_id = ctr_cur_rec.derive_counter_id;
8155: EXCEPTION
8156: WHEN NO_DATA_FOUND THEN
8157: csi_ctr_gen_utility_pvt.put_line( ' New counter id not found for deriver counte id '||to_char(ctr_cur_rec.derive_counter_id));
8418: csi_ctr_gen_utility_pvt.put_line('Created from ctr id = '||to_char(fmla_ctr_cur_rec.counter_id));
8419: BEGIN
8420: SELECT created_from_counter_tmpl_id
8421: INTO l_created_map_id
8422: FROM csi_counters_b
8423: WHERE counter_id = fmla_ctr_cur_rec.counter_id;
8424: EXCEPTION
8425: WHEN OTHERS THEN NULL;
8426: END;
8429: FOR ctr_formula_bvars_cur_rec IN ctr_formula_bvars_cur(l_created_map_id)
8430: LOOP
8431: SELECT max(counter_id)
8432: INTO l_new_mapped_ctr_id
8433: FROM csi_counters_b
8434: WHERE created_from_counter_tmpl_id = ctr_formula_bvars_cur_rec.source_counter_id;
8435: -- AND group_id = l_ctr_grp_rec.counter_group_id;
8436:
8437: IF ctr_formula_bvars_cur_rec.source_counter_id IS NOT NULL THEN
8630: AND group_id = p_group_id;
8631:
8632: CURSOR check_counters(p_counter_id NUMBER) IS
8633: SELECT counter_id instantiated_counter_id
8634: FROM csi_counters_b
8635: WHERE created_from_counter_tmpl_id = p_counter_id;
8636: BEGIN
8637: -- Standard Start of API savepoint
8638: SAVEPOINT delete_item_association_pvt;