133:
134: -- Cursor for Counter Template related information
135: CURSOR ctr_cur(b_ctr_grp_id IN NUMBER) IS SELECT
136: counter_id
137: FROM okx_counters_v
138: WHERE counter_group_id = b_ctr_grp_id
139: AND created_from_counter_tmpl_id IS NULL
140: AND source_counter_id IS NULL;
141:
141:
142: -- Cursor for Counter Instance related information
143: CURSOR ctr_ins_cur(b_ctr_grp_id IN NUMBER,b_ctr_id IN NUMBER) IS SELECT
144: counter_id
145: FROM okx_counters_v
146: WHERE counter_group_id = b_ctr_grp_id
147: AND created_from_counter_tmpl_id = b_ctr_id;
148:
149: -- Cursor for Function Expression Parameters and related information
359: IF cnl_cur_rec.cnl_type = 'CEX'
360: THEN
361: IF cnl_cur_rec.left_ctr_master_id IS NOT NULL THEN
362: SELECT counter_id INTO l_cnlv_rec.left_counter_id
363: FROM okx_counters_v
364: WHERE counter_group_id = p_instcnd_inp_rec.ins_ctr_grp_id
365: AND created_from_counter_tmpl_id = cnl_cur_rec.left_ctr_master_id;
366: END IF;
367: IF cnl_cur_rec.right_ctr_master_id IS NOT NULL THEN
365: AND created_from_counter_tmpl_id = cnl_cur_rec.left_ctr_master_id;
366: END IF;
367: IF cnl_cur_rec.right_ctr_master_id IS NOT NULL THEN
368: SELECT counter_id INTO l_cnlv_rec.right_counter_id
369: FROM okx_counters_v
370: WHERE counter_group_id = p_instcnd_inp_rec.ins_ctr_grp_id
371: AND created_from_counter_tmpl_id = cnl_cur_rec.right_ctr_master_id;
372: END IF;
373: IF cnl_cur_rec.left_counter_id IS NOT NULL THEN
371: AND created_from_counter_tmpl_id = cnl_cur_rec.right_ctr_master_id;
372: END IF;
373: IF cnl_cur_rec.left_counter_id IS NOT NULL THEN
374: SELECT counter_id INTO l_cnlv_rec.left_counter_id
375: FROM okx_counters_v
376: WHERE counter_group_id = p_instcnd_inp_rec.ins_ctr_grp_id
377: AND created_from_counter_tmpl_id = cnl_cur_rec.left_counter_id;
378: END IF;
379: IF cnl_cur_rec.right_counter_id IS NOT NULL THEN
377: AND created_from_counter_tmpl_id = cnl_cur_rec.left_counter_id;
378: END IF;
379: IF cnl_cur_rec.right_counter_id IS NOT NULL THEN
380: SELECT counter_id INTO l_cnlv_rec.right_counter_id
381: FROM okx_counters_v
382: WHERE counter_group_id = p_instcnd_inp_rec.ins_ctr_grp_id
383: AND created_from_counter_tmpl_id = cnl_cur_rec.right_counter_id;
384: END IF;
385: END IF;