The following lines contain the word 'select', 'insert', 'update' or 'delete':
OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qld_tbl(' || i || ').select_yn: ' || p_qld_tbl(i).select_yn);
PROCEDURE update_quote_line(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_tqlv_rec IN tqlv_rec_type,
x_tqlv_rec OUT NOCOPY tqlv_rec_type) IS
l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
l_api_name VARCHAR2(30) := 'update_quote_line';
l_module_name VARCHAR2(500) := G_MODULE_NAME || 'update_quote_line';
SAVEPOINT trx_update_quote_line;
OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_TERMNT_QUOTE_PVT.update_quote_line');
OKL_AM_TERMNT_QUOTE_PVT.update_quote_line(
p_api_version => l_api_version,
p_init_msg_list => l_init_msg_list,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_tqlv_rec => lp_tqlv_rec,
x_tqlv_rec => lx_tqlv_rec);
OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_TERMNT_QUOTE_PVT.update_quote_line , return status: ' || l_return_status);
ROLLBACK TO trx_update_quote_line;
ROLLBACK TO trx_update_quote_line;
ROLLBACK TO trx_update_quote_line;
END update_quote_line;
PROCEDURE update_quote_line(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_tqlv_tbl IN tqlv_tbl_type,
x_tqlv_tbl OUT NOCOPY tqlv_tbl_type) IS
l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
l_api_name VARCHAR2(30) := 'update_quote_line';
l_module_name VARCHAR2(500) := G_MODULE_NAME || 'update_quote_line';
SAVEPOINT trx_update_quote_line;
OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_TERMNT_QUOTE_PVT.update_quote_line');
OKL_AM_TERMNT_QUOTE_PVT.update_quote_line(
p_api_version => l_api_version,
p_init_msg_list => l_init_msg_list,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_tqlv_tbl => lp_tqlv_tbl,
x_tqlv_tbl => lx_tqlv_tbl);
OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_TERMNT_QUOTE_PVT.update_quote_line , return status: ' || l_return_status);
ROLLBACK TO trx_update_quote_line;
ROLLBACK TO trx_update_quote_line;
ROLLBACK TO trx_update_quote_line;
END update_quote_line;
PROCEDURE delete_quote_line(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_tqlv_rec IN tqlv_rec_type) IS
l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
l_api_name VARCHAR2(30) := 'update_quote_line';
l_module_name VARCHAR2(500) := G_MODULE_NAME || 'delete_quote_line';
SAVEPOINT trx_delete_quote_line;
OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_TERMNT_QUOTE_PVT.delete_quote_line');
OKL_AM_TERMNT_QUOTE_PVT.delete_quote_line(
p_api_version => l_api_version,
p_init_msg_list => l_init_msg_list,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_tqlv_rec => lp_tqlv_rec);
OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_TERMNT_QUOTE_PVT.delete_quote_line , return status: ' || l_return_status);
ROLLBACK TO trx_delete_quote_line;
ROLLBACK TO trx_delete_quote_line;
ROLLBACK TO trx_delete_quote_line;
END delete_quote_line;
PROCEDURE delete_quote_line(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_tqlv_tbl IN tqlv_tbl_type) IS
l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
l_api_name VARCHAR2(30) := 'delete_quote_line';
l_module_name VARCHAR2(500) := G_MODULE_NAME || 'delete_quote_line';
SAVEPOINT trx_delete_quote_line;
OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_TERMNT_QUOTE_PVT.delete_quote_line');
OKL_AM_TERMNT_QUOTE_PVT.delete_quote_line(
p_api_version => l_api_version,
p_init_msg_list => l_init_msg_list,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_tqlv_tbl => lp_tqlv_tbl);
OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_TERMNT_QUOTE_PVT.delete_quote_line , return status: ' || l_return_status);
ROLLBACK TO trx_delete_quote_line;
ROLLBACK TO trx_delete_quote_line;
ROLLBACK TO trx_delete_quote_line;
END delete_quote_line;