The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT sts_code
,contract_number
FROM okc_k_headers_b
WHERE id = cp_chr_id;
okl_contract_status_pub.update_contract_status(p_api_version => p_api_version
,p_init_msg_list => p_init_msg_list
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
,p_khr_status => G_ACTIVE_STS_CODE
,p_chr_id => p_chr_id
);
'okl_contract_status_pub.update_contract_status G_ACTIVE_STS_CODE returned with status '||x_return_status||' x_msg_data '||x_msg_data
);
okl_contract_status_pub.update_contract_status(p_api_version => p_api_version
,p_init_msg_list => p_init_msg_list
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
,p_khr_status => G_PENDING_STS_CODE
,p_chr_id => p_chr_id
);
'okl_contract_status_pub.update_contract_status G_PENDING_STS_CODE returned with status '||x_return_status||' x_msg_data '||x_msg_data
);
SELECT sts_code
,contract_number
FROM okc_k_headers_b
WHERE id = cp_chr_id;
okl_contract_status_pub.update_contract_status(p_api_version => p_api_version
,p_init_msg_list => p_init_msg_list
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
,p_khr_status => G_ACTIVE_STS_CODE
,p_chr_id => p_chr_id
);
'okl_contract_status_pub.update_contract_status returned with status '||x_return_status||' x_msg_data '||x_msg_data
);
okl_contract_status_pub.update_contract_status(p_api_version => p_api_version
,p_init_msg_list => p_init_msg_list
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
,p_khr_status => G_PENDING_STS_CODE
,p_chr_id => p_chr_id
);
'okl_contract_status_pub.update_contract_status G_PENDING_STS_CODE returned with status '||x_return_status||' x_msg_data '||x_msg_data
);