[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT acn.correlation, acn.acn_type, cnh.name,cnh.id, cnh.dnz_chr_id,
cnh.cnh_variance, cnh.before_after,
nvl(cnh.last_rundate,sysdate-1) last_rundate,
acn.enabled_yn
FROM okc_condition_headers_v cnh, okc_actions_v acn
WHERE cnh.acn_id = acn.id
AND acn.acn_type = 'DBA'
AND condition_valid_yn = 'Y'
AND template_yn = 'N'
AND sysdate between date_active and nvl(date_inactive,sysdate)
ORDER BY cnh.name;
OKC_CONDITIONS_PUB.update_cond_hdrs(p_api_version => 1,
p_init_msg_list => okc_api.g_false,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_cnhv_rec => l_cnhv_rec,
x_cnhv_rec => i_cnhv_rec);
END IF; -- Update the Last Run date
OKC_CONDITIONS_PUB.update_cond_hdrs(p_api_version => 1,
p_init_msg_list => okc_api.g_false,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_cnhv_rec => l_cnhv_rec,
x_cnhv_rec => i_cnhv_rec);
END IF; -- Update the Last Run date