[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT id
FROM okc_condition_headers_v
WHERE counter_group_id = b_tmp_ctr_grp_id
AND object_id = b_inv_item_id
AND jtot_object_code = 'OKX_SYSITEM'
AND template_yn = 'Y';
CURSOR cnh_cur(b_cnh_id IN NUMBER) IS SELECT
acn_id
,counter_group_id
,description
,short_description
,comments
,one_time_yn
,name
,condition_valid_yn
,before_after
,tracked_yn
,task_owner_id
,cnh_variance
,dnz_chr_id
,template_yn
,date_active
,object_id
,date_inactive
,jtot_object_code
,cnh_type
,attribute_category
,attribute1
,attribute2
,attribute3
,attribute4
,attribute5
,attribute6
,attribute7
,attribute8
,attribute9
,attribute10
,attribute11
,attribute12
,attribute13
,attribute14
,attribute15
FROM okc_condition_headers_v
WHERE id = b_cnh_id
AND template_yn = 'Y';
CURSOR cnl_cur(b_cnh_id IN NUMBER) IS SELECT
cnl.id cnl_id
,cnl.cnh_id
,cnl.pdf_id
,cnl.aae_id
,cnl.left_ctr_master_id
,cnl.right_ctr_master_id
,cnl.left_counter_id
,cnl.right_counter_id
,cnl.dnz_chr_id
,cnl.sortseq
,cnl.cnl_type
,cnl.description
,cnl.left_parenthesis
,cnl.relational_operator
,cnl.right_parenthesis
,cnl.logical_operator
,cnl.start_at
,cnl.tolerance
,cnl.right_operand
,cnl.attribute_category
,cnl.attribute1
,cnl.attribute2
,cnl.attribute3
,cnl.attribute4
,cnl.attribute5
,cnl.attribute6
,cnl.attribute7
,cnl.attribute8
,cnl.attribute9
,cnl.attribute10
,cnl.attribute11
,cnl.attribute12
,cnl.attribute13
,cnl.attribute14
,cnl.attribute15
FROM okc_condition_headers_v cnh,okc_condition_lines_v cnl
WHERE cnh.id = cnl.cnh_id
AND cnh.id = b_cnh_id;
CURSOR ctr_grp_cur(b_ctr_grp_id IN NUMBER) IS SELECT
counter_group_id
FROM okx_counter_groups_v
WHERE template_flag = 'N'
AND created_from_ctr_grp_tmpl_id = b_ctr_grp_id;
CURSOR ctr_cur(b_ctr_grp_id IN NUMBER) IS SELECT
counter_id
FROM okx_counters_v
WHERE counter_group_id = b_ctr_grp_id
AND created_from_counter_tmpl_id IS NULL
AND source_counter_id IS NULL;
CURSOR ctr_ins_cur(b_ctr_grp_id IN NUMBER,b_ctr_id IN NUMBER) IS SELECT
counter_id
FROM okx_counters_v
WHERE counter_group_id = b_ctr_grp_id
AND created_from_counter_tmpl_id = b_ctr_id;
CURSOR fep_cur(b_cnh_id IN NUMBER) IS SELECT
fep.id fep_id
,fep.cnl_id
,fep.pdp_id
,fep.aae_id
,fep.dnz_chr_id
,fep.value
FROM okc_function_expr_params_v fep,okc_condition_headers_v cnh,
okc_condition_lines_v cnl
WHERE fep.cnl_id = cnl.id
AND cnl.cnh_id = cnh.id
AND cnh.id = b_cnh_id;
CURSOR oce_cur(b_cnh_id IN NUMBER) IS SELECT
oce.id oce_id
,oce.pdf_id
,oce.cnh_id
,oce.dnz_chr_id
,oce.enabled_yn
,oce.comments
,oce.success_resource_id
,oce.failure_resource_id
,oce.attribute_category
,oce.attribute1
,oce.attribute2
,oce.attribute3
,oce.attribute4
,oce.attribute5
,oce.attribute6
,oce.attribute7
,oce.attribute8
,oce.attribute9
,oce.attribute10
,oce.attribute11
,oce.attribute12
,oce.attribute13
,oce.attribute14
,oce.attribute15
FROM okc_outcomes_v oce,okc_condition_headers_v cnh
WHERE oce.cnh_id = cnh.id
AND cnh.id = b_cnh_id;
CURSOR oat_cur(b_cnh_id IN NUMBER) IS SELECT
oat.id oat_id
,oat.pdp_id
,oat.oce_id
,oat.aae_id
,oat.dnz_chr_id
,oat.value
FROM okc_outcome_arguments_v oat,okc_outcomes_v oce,
okc_condition_headers_v cnh
WHERE oat.oce_id = oce.id
AND oce.cnh_id = cnh.id
AND cnh.id = b_cnh_id;
SELECT
id
,acn_id
,counter_group_id
,description
,short_description
,comments
,one_time_yn
,name
,condition_valid_yn
,before_after
,tracked_yn
,task_owner_id
,cnh_variance
,dnz_chr_id
,date_active
,object_id
,date_inactive
,template_yn
,jtot_object_code
,cnh_type
,attribute_category
,attribute1
,attribute2
,attribute3
,attribute4
,attribute5
,attribute6
,attribute7
,attribute8
,attribute9
,attribute10
,attribute11
,attribute12
,attribute13
,attribute14
,attribute15
INTO
l_cnhv_rec.id
,l_cnhv_rec.acn_id
,l_cnhv_rec.counter_group_id
,l_cnhv_rec.description
,l_cnhv_rec.short_description
,l_cnhv_rec.comments
,l_cnhv_rec.one_time_yn
,l_cnhv_rec.name
,l_cnhv_rec.condition_valid_yn
,l_cnhv_rec.before_after
,l_cnhv_rec.tracked_yn
,l_cnhv_rec.task_owner_id
,l_cnhv_rec.cnh_variance
,l_cnhv_rec.dnz_chr_id
,l_cnhv_rec.date_active
,l_cnhv_rec.object_id
,l_cnhv_rec.date_inactive
,l_cnhv_rec.template_yn
,l_cnhv_rec.jtot_object_code
,l_cnhv_rec.cnh_type
,l_cnhv_rec.attribute_category
,l_cnhv_rec.attribute1
,l_cnhv_rec.attribute2
,l_cnhv_rec.attribute3
,l_cnhv_rec.attribute4
,l_cnhv_rec.attribute5
,l_cnhv_rec.attribute6
,l_cnhv_rec.attribute7
,l_cnhv_rec.attribute8
,l_cnhv_rec.attribute9
,l_cnhv_rec.attribute10
,l_cnhv_rec.attribute11
,l_cnhv_rec.attribute12
,l_cnhv_rec.attribute13
,l_cnhv_rec.attribute14
,l_cnhv_rec.attribute15
FROM okc_condition_headers_v
WHERE id = ctr_cnh_cur_rec.id
AND template_yn = 'Y';
SELECT counter_id INTO l_cnlv_rec.left_counter_id
FROM okx_counters_v
WHERE counter_group_id = p_instcnd_inp_rec.ins_ctr_grp_id
AND created_from_counter_tmpl_id = cnl_cur_rec.left_ctr_master_id;
SELECT counter_id INTO l_cnlv_rec.right_counter_id
FROM okx_counters_v
WHERE counter_group_id = p_instcnd_inp_rec.ins_ctr_grp_id
AND created_from_counter_tmpl_id = cnl_cur_rec.right_ctr_master_id;
SELECT counter_id INTO l_cnlv_rec.left_counter_id
FROM okx_counters_v
WHERE counter_group_id = p_instcnd_inp_rec.ins_ctr_grp_id
AND created_from_counter_tmpl_id = cnl_cur_rec.left_counter_id;
SELECT counter_id INTO l_cnlv_rec.right_counter_id
FROM okx_counters_v
WHERE counter_group_id = p_instcnd_inp_rec.ins_ctr_grp_id
AND created_from_counter_tmpl_id = cnl_cur_rec.right_counter_id;