[Home] [Help]
34: -- Cursor to get associated conditions related to that counter group id
35: CURSOR ctr_cnh_cur(b_tmp_ctr_grp_id IN NUMBER
36: ,b_inv_item_id IN NUMBER) IS
37: SELECT id
38: FROM okc_condition_headers_v
39: WHERE counter_group_id = b_tmp_ctr_grp_id
40: AND object_id = b_inv_item_id
41: AND jtot_object_code = 'OKX_SYSITEM'
42: AND template_yn = 'Y';
77: ,attribute12
78: ,attribute13
79: ,attribute14
80: ,attribute15
81: FROM okc_condition_headers_v
82: WHERE id = b_cnh_id
83: AND template_yn = 'Y';
84:
85:
119: ,cnl.attribute12
120: ,cnl.attribute13
121: ,cnl.attribute14
122: ,cnl.attribute15
123: FROM okc_condition_headers_v cnh,okc_condition_lines_v cnl
124: WHERE cnh.id = cnl.cnh_id
125: AND cnh.id = b_cnh_id;
126:
127: -- Cursor for Counter Group related information
154: ,fep.pdp_id
155: ,fep.aae_id
156: ,fep.dnz_chr_id
157: ,fep.value
158: FROM okc_function_expr_params_v fep,okc_condition_headers_v cnh,
159: okc_condition_lines_v cnl
160: WHERE fep.cnl_id = cnl.id
161: AND cnl.cnh_id = cnh.id
162: AND cnh.id = b_cnh_id;
186: ,oce.attribute12
187: ,oce.attribute13
188: ,oce.attribute14
189: ,oce.attribute15
190: FROM okc_outcomes_v oce,okc_condition_headers_v cnh
191: WHERE oce.cnh_id = cnh.id
192: AND cnh.id = b_cnh_id;
193:
194: -- Cursor for Outcome parameters and related information
199: ,oat.aae_id
200: ,oat.dnz_chr_id
201: ,oat.value
202: FROM okc_outcome_arguments_v oat,okc_outcomes_v oce,
203: okc_condition_headers_v cnh
204: WHERE oat.oce_id = oce.id
205: AND oce.cnh_id = cnh.id
206: AND cnh.id = b_cnh_id;
207:
299: ,l_cnhv_rec.attribute12
300: ,l_cnhv_rec.attribute13
301: ,l_cnhv_rec.attribute14
302: ,l_cnhv_rec.attribute15
303: FROM okc_condition_headers_v
304: WHERE id = ctr_cnh_cur_rec.id
305: AND template_yn = 'Y';
306:
307: l_cnhv_rec.counter_group_id := p_instcnd_inp_rec.ins_ctr_grp_id;