[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT 'x'
FROM OKL_VALIDATION_SETS_V
WHERE validation_set_name = p_vlsv_rec.validation_set_name
AND org_id = mo_global.get_current_org_id();
okl_vls_pvt.insert_row(p_api_version
,okl_api.g_false
,l_return_status
,x_msg_count
,x_msg_data
,lp_vlsv_rec
,lx_vlsv_rec); -- write to log
,'okl_vls_pvt.insert_row returned with status ' ||
l_return_status ||
' x_msg_data ' ||
x_msg_data);
okl_vld_pvt.insert_row(p_api_version
,okl_api.g_false
,l_return_status
,x_msg_count
,x_msg_data
,lp_vldv_tbl
,lx_vldv_tbl); -- write to log
,'okl_vld_pvt.insert_row returned with status ' ||
l_return_status ||
' x_msg_data ' ||
x_msg_data);
PROCEDURE update_vls(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_vlsv_rec IN vlsv_rec_type
,x_vlsv_rec OUT NOCOPY vlsv_rec_type
,p_vldv_tbl IN vldv_tbl_type
,x_vldv_tbl OUT NOCOPY vldv_tbl_type) IS
lp_vlsv_rec vlsv_rec_type;
l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VALIDATION_SET_PVT.update_vls';
l_api_name CONSTANT varchar2(30) := 'update_vls';
,'begin debug OKL_VALIDATION_SET_PVT.pls call update_vls');
okl_vls_pvt.update_row(p_api_version
,okl_api.g_false
,l_return_status
,x_msg_count
,x_msg_data
,lp_vlsv_rec
,lx_vlsv_rec); -- write to log
,'okl_vls_pvt.update_row returned with status ' ||
l_return_status ||
' x_msg_data ' ||
x_msg_data);
okl_vld_pvt.insert_row(p_api_version
,okl_api.g_false
,l_return_status
,x_msg_count
,x_msg_data
,lp_vldv_crt_tbl
,lx_vldv_crt_tbl); -- write to log
,'okl_vld_pvt.insert_row returned with status ' ||
l_return_status ||
' x_msg_data ' ||
x_msg_data);
okl_vld_pvt.update_row(p_api_version
,okl_api.g_false
,l_return_status
,x_msg_count
,x_msg_data
,lp_vldv_rmv_tbl
,lx_vldv_rmv_tbl); -- write to log
,'okl_vld_pvt.delete_row returned with status ' ||
l_return_status ||
' x_msg_data ' ||
x_msg_data);
,'end debug OKLRvlsB.pls call update_vls');
END update_vls;
PROCEDURE delete_vls(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_vlsv_rec IN vlsv_rec_type) IS
CURSOR l_vldv_csr(p_validation_set_id number) IS
SELECT id
,object_version_number
,attribute_category
,attribute1
,attribute2
,attribute3
,attribute4
,attribute5
,attribute6
,attribute7
,attribute8
,attribute9
,attribute10
,attribute11
,attribute12
,attribute13
,attribute14
,attribute15
,validation_set_id
,function_id
,failure_severity
,short_description
,description
,comments
FROM OKL_VALIDATIONS_V
WHERE validation_set_id=p_validation_set_id;
l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VALIDATION_SET_PVT.delete_vls';
l_api_name CONSTANT varchar2(30) := 'delete_vls';
,'begin debug OKL_VALIDATION_SET_PVT.pls call delete_vls');
okl_vld_pvt.delete_row(p_api_version
,okl_api.g_false
,l_return_status
,x_msg_count
,x_msg_data
,lx_vldv_tbl); -- write to log
,'okl_vls_pvt.delete_row returned with status ' ||
l_return_status ||
' x_msg_data ' ||
x_msg_data);
okl_vls_pvt.delete_row(p_api_version
,okl_api.g_false
,l_return_status
,x_msg_count
,x_msg_data
,lp_vlsv_rec); -- write to log
,'okl_vls_pvt.delete_row returned with status ' ||
l_return_status ||
' x_msg_data ' ||
x_msg_data);
,'end debug OKL_VALIDATION_SET_PVT.pls call delete_vls');
END delete_vls;
PROCEDURE delete_vld(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_vldv_rec IN vldv_rec_type) IS
lp_vldv_rec vldv_rec_type;
l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VALIDATION_SET_PVT.delete_vld';
l_api_name CONSTANT varchar2(30) := 'delete_vld';
,'begin debug OKL_VALIDATION_SET_PVT.pls call delete_vls');
okl_vld_pvt.delete_row(p_api_version
,okl_api.g_false
,l_return_status
,x_msg_count
,x_msg_data
,lp_vldv_rec); -- write to log
,'okl_vls_pvt.delete_row returned with status ' ||
l_return_status ||
' x_msg_data ' ||
x_msg_data);
END delete_vld;