The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT instr(lp_sql, ' ID,')
INTO i
FROM dual;
SELECT instr(lp_sql, ' NAME ')
INTO i
FROM dual;
SELECT 'x'
FROM okl_fe_crit_cat_def_v
WHERE crit_cat_name = p_eccv_rec.crit_cat_name
AND ecc_ac_flag = p_eccv_rec.ecc_ac_flag;
RAISE okl_api.g_exception_error; --sql statement should contain ID and NAME as alias in Select clause
okl_ecc_pvt.insert_row(p_api_version
,okl_api.g_false
,l_return_status
,x_msg_count
,x_msg_data
,lp_eccv_rec
,lx_eccv_rec); -- write to log
,'okl_ecc_pvt.insert_row returned with status ' ||
l_return_status ||
' x_msg_data ' ||
x_msg_data);
okl_eco_pvt.insert_row(p_api_version
,okl_api.g_false
,l_return_status
,x_msg_count
,x_msg_data
,lp_eco_tbl
,lx_eco_tbl); -- write to log
,'okl_eco_pvt.insert_row returned with status ' ||
l_return_status ||
' x_msg_data ' ||
x_msg_data);
PROCEDURE update_ecc(p_api_version IN number
,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false
,x_return_status OUT NOCOPY varchar2
,x_msg_count OUT NOCOPY number
,x_msg_data OUT NOCOPY varchar2
,p_eccv_rec IN okl_eccv_rec
,x_eccv_rec OUT NOCOPY okl_eccv_rec
,p_eco_tbl IN okl_eco_tbl
,x_eco_tbl OUT NOCOPY okl_eco_tbl) IS
lp_eccv_rec okl_eccv_rec;
l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_ECC_DEF_PVT.UPDATE_ECC';
l_api_name CONSTANT varchar2(30) := 'update_ecc';
,'begin debug OKLRECCB.pls call update_ecc');
okl_ecc_pvt.update_row(p_api_version
,okl_api.g_false
,l_return_status
,x_msg_count
,x_msg_data
,lp_eccv_rec
,lx_eccv_rec); -- write to log
,'okl_ecc_pvt.update_row returned with status ' ||
l_return_status ||
' x_msg_data ' ||
x_msg_data);
okl_eco_pvt.insert_row(p_api_version
,okl_api.g_false
,l_return_status
,x_msg_count
,x_msg_data
,lp_eco_crt_tbl
,lx_eco_crt_tbl); -- write to log
,'okl_eco_pvt.insert_row returned with status ' ||
l_return_status ||
' x_msg_data ' ||
x_msg_data);
okl_eco_pvt.delete_row(p_api_version
,okl_api.g_false
,l_return_status
,x_msg_count
,x_msg_data
,lp_eco_rmv_tbl); -- write to log
,'okl_eco_pvt.delete_row returned with status ' ||
l_return_status ||
' x_msg_data ' ||
x_msg_data);
,'end debug OKLRECCB.pls call update_ecc');
END update_ecc;