The following lines contain the word 'select', 'insert', 'update' or 'delete':
SAVEPOINT insert_provisions;
ROLLBACK TO insert_provisions;
ROLLBACK TO insert_provisions;
SAVEPOINT insert_provisions;
ROLLBACK TO insert_provisions;
ROLLBACK TO insert_provisions;
PROCEDURE update_provisions(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_pvnv_rec IN pvnv_rec_type,
x_pvnv_rec OUT NOCOPY pvnv_rec_type)
IS
l_api_version CONSTANT NUMBER := 1.0;
l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_PROVISIONS';
SAVEPOINT update_provisions;
OKL_PROCESS_PROVISIONS_PVT.UPDATE_PROVISIONS(p_api_version => l_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_pvnv_rec => p_pvnv_rec,
x_pvnv_rec => x_pvnv_rec);
ROLLBACK TO update_provisions;
ROLLBACK TO update_provisions;
END update_provisions;
PROCEDURE update_provisions(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_pvnv_tbl IN pvnv_tbl_type,
x_pvnv_tbl OUT NOCOPY pvnv_tbl_type)
IS
l_api_version CONSTANT NUMBER := 1.0;
l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_PROVISIONS';
SAVEPOINT update_provisions;
OKL_PROCESS_PROVISIONS_PVT.UPDATE_PROVISIONS(p_api_version => l_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_pvnv_tbl => p_pvnv_tbl,
x_pvnv_tbl => x_pvnv_tbl);
ROLLBACK TO update_provisions;
ROLLBACK TO update_provisions;
END update_provisions;
PROCEDURE delete_provisions(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_pvnv_rec IN pvnv_rec_type)
IS
l_api_version CONSTANT NUMBER := 1.0;
l_api_name CONSTANT VARCHAR2(30) := 'DELETE_PROVISIONS';
SAVEPOINT delete_provisions;
OKL_PROCESS_PROVISIONS_PVT.DELETE_PROVISIONS(p_api_version => l_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_pvnv_rec => p_pvnv_rec);
ROLLBACK TO delete_provisions;
ROLLBACK TO delete_provisions;
END delete_provisions;
PROCEDURE delete_provisions(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_pvnv_tbl IN pvnv_tbl_type)
IS
l_api_version CONSTANT NUMBER := 1.0;
l_api_name CONSTANT VARCHAR2(30) := 'DELETE_PROVISIONS';
SAVEPOINT delete_provisions;
OKL_PROCESS_PROVISIONS_PVT.DELETE_PROVISIONS(p_api_version => l_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_pvnv_tbl => p_pvnv_tbl);
ROLLBACK TO delete_provisions;
ROLLBACK TO delete_provisions;
END delete_provisions;