The following lines contain the word 'select', 'insert', 'update' or 'delete':
SAVEPOINT insert_buckets;
ROLLBACK TO insert_buckets;
ROLLBACK TO insert_buckets;
SAVEPOINT insert_buckets;
ROLLBACK TO insert_buckets;
ROLLBACK TO insert_buckets;
PROCEDURE update_buckets(
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_bktv_rec IN bktv_rec_type,
x_bktv_rec OUT NOCOPY bktv_rec_type)
IS
l_api_version CONSTANT NUMBER := 1.0;
l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_BUCKETS';
SAVEPOINT update_buckets;
OKL_PROCESS_BUCKETS_PVT.UPDATE_BUCKETS(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_bktv_rec => p_bktv_rec,
x_bktv_rec => x_bktv_rec);
ROLLBACK TO update_buckets;
ROLLBACK TO update_buckets;
END update_buckets;
PROCEDURE update_buckets(
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_bktv_tbl IN bktv_tbl_type,
x_bktv_tbl OUT NOCOPY bktv_tbl_type)
IS
l_api_version CONSTANT NUMBER := 1.0;
l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_BUCKETS';
SAVEPOINT update_buckets;
OKL_PROCESS_BUCKETS_PVT.UPDATE_BUCKETS(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_bktv_rec => l_bktv_tbl(i),
x_bktv_rec => x_bktv_tbl(i));
ROLLBACK TO update_buckets;
ROLLBACK TO update_buckets;
END update_buckets;
PROCEDURE delete_buckets(
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_bktv_rec IN bktv_rec_type)
IS
l_api_version CONSTANT NUMBER := 1.0;
l_api_name CONSTANT VARCHAR2(30) := 'DELETE_BUCKETS';
SAVEPOINT delete_buckets;
OKL_PROCESS_BUCKETS_PVT.DELETE_BUCKETS(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_bktv_rec => p_bktv_rec);
ROLLBACK TO delete_buckets;
ROLLBACK TO delete_buckets;
END delete_buckets;
PROCEDURE delete_buckets(
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_bktv_tbl IN bktv_tbl_type)
IS
l_api_version CONSTANT NUMBER := 1.0;
l_api_name CONSTANT VARCHAR2(30) := 'DELETE_BUCKETS';
SAVEPOINT delete_buckets;
OKL_PROCESS_BUCKETS_PVT.DELETE_BUCKETS(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_bktv_rec => l_bktv_tbl(i));
ROLLBACK TO delete_buckets;
ROLLBACK TO delete_buckets;
END delete_buckets;