The following lines contain the word 'select', 'insert', 'update' or 'delete':
OKL_VIR_PVT.insert_row(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_virv_rec => l_virv_rec
,x_virv_rec => x_virv_rec);
'okl_vir_pvt.insert_row returned with status '||x_return_status||' id '||x_virv_rec.id
);
OKL_VIR_PVT.insert_row(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_virv_tbl => l_virv_tbl
,x_virv_tbl => x_virv_tbl);
'okl_vir_pvt.insert_row returned with status '||x_return_status
);
PROCEDURE update_var_int_params(p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_virv_rec IN virv_rec_type,
x_virv_rec OUT NOCOPY virv_rec_type) IS
-- Variables Declarations
l_api_version CONSTANT NUMBER DEFAULT 1.0;
l_api_name CONSTANT VARCHAR2(30) DEFAULT 'update_var_int_params';
l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VAR_INT_PARAMS_PVT.update_var_int_params';
okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'start debug OKLRVISB.pls call update_var_int_params for record');
OKL_VIR_PVT.update_row(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_virv_rec => l_virv_rec
,x_virv_rec => x_virv_rec);
l_module,'okl_vir_pvt.update_row returned with status '||x_return_status||' id '||x_virv_rec.id
);
okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'ends debug OKLRVISB.pls call update_var_int_params for record');
END update_var_int_params;
PROCEDURE update_var_int_params(p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_virv_tbl IN virv_tbl_type,
x_virv_tbl OUT NOCOPY virv_tbl_type) IS
-- Variables Declarations
l_api_version CONSTANT NUMBER DEFAULT 1.0;
l_api_name CONSTANT VARCHAR2(30) DEFAULT 'update_var_int_params';
l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VAR_INT_PARAMS_PVT.update_var_int_params';
okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'start debug OKLRVISB.pls call update_var_int_params for table');
OKL_VIR_PVT.update_row(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_virv_tbl => l_virv_tbl
,x_virv_tbl => x_virv_tbl);
l_module,'okl_vir_pvt.update_row returned with status '||x_return_status
);
okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'ends debug OKLRVISB.pls call update_var_int_params for table');
END update_var_int_params;
PROCEDURE delete_var_int_params(p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_virv_tbl IN virv_tbl_type ) IS
-- Variables Declarations
l_api_version CONSTANT NUMBER DEFAULT 1.0;
l_api_name CONSTANT VARCHAR2(30) DEFAULT 'delete_var_int_params';
l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VAR_INT_PARAMS_PVT.delete_var_int_params';
okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'start debug OKLRVISB.pls call delete_var_int_params for table');
OKL_VIR_PVT.delete_row(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_virv_tbl => l_virv_tbl
);
l_module,'okl_vir_pvt.delete_row returned with status '||x_return_status
);
okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'ends debug OKLRVISB.pls call delete_var_int_params for a table');
END delete_var_int_params;