The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE insert_answers(
p_api_version IN NUMBER
,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
,p_awrv_rec IN awrv_rec_type
,x_awrv_rec OUT NOCOPY awrv_rec_type) IS
l_api_version NUMBER ;
SAVEPOINT answers_insert;
okl_awr_pvt.insert_row(
l_api_version
,l_init_msg_list
,l_return_status
,l_msg_count
,l_msg_data
,lp_awrv_rec
,lx_awrv_rec);
ROLLBACK TO answers_insert;
ROLLBACK TO answers_insert;
ROLLBACK TO answers_insert;
FND_MSG_PUB.ADD_EXC_MSG('OKL_ANSWERS_PUB','insert_answers');
END insert_answers;
PROCEDURE insert_answers(
p_api_version IN NUMBER
,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
,p_awrv_tbl IN awrv_tbl_type
,x_awrv_tbl OUT NOCOPY awrv_tbl_type) IS
l_api_version NUMBER;
SAVEPOINT answers_insert;
okl_awr_pvt.insert_row(
l_api_version
,l_init_msg_list
,l_return_status
,l_msg_count
,l_msg_data
,lp_awrv_tbl
,lx_awrv_tbl);
ROLLBACK TO answers_insert;
ROLLBACK TO answers_insert;
ROLLBACK TO answers_insert;
FND_MSG_PUB.ADD_EXC_MSG('OKL_ANSWERS_PUB','insert_answers');
END insert_answers;
PROCEDURE update_answers(
p_api_version IN NUMBER
,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
,p_awrv_rec IN awrv_rec_type
,x_awrv_rec OUT NOCOPY awrv_rec_type) IS
l_api_version NUMBER ;
SAVEPOINT answers_update;
okl_awr_pvt.update_row(
l_api_version
,l_init_msg_list
,l_return_status
,l_msg_count
,l_msg_data
,lp_awrv_rec
,lx_awrv_rec);
ROLLBACK TO answers_update;
ROLLBACK TO answers_update;
ROLLBACK TO answers_update;
FND_MSG_PUB.ADD_EXC_MSG('OKL_ANSWERS_PUB','update_answers');
END update_answers;
PROCEDURE update_answers(
p_api_version IN NUMBER
,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
,p_awrv_tbl IN awrv_tbl_type
,x_awrv_tbl OUT NOCOPY awrv_tbl_type) IS
l_api_version NUMBER;
SAVEPOINT answers_update;
okl_awr_pvt.update_row(
l_api_version
,l_init_msg_list
,l_return_status
,l_msg_count
,l_msg_data
,lp_awrv_tbl
,lx_awrv_tbl);
ROLLBACK TO answers_update;
ROLLBACK TO answers_update;
ROLLBACK TO answers_update;
FND_MSG_PUB.ADD_EXC_MSG('OKL_ANSWERS_PUB','update_answers');
END update_answers;
PROCEDURE delete_answers(
p_api_version IN NUMBER
,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
,p_awrv_rec IN awrv_rec_type) IS
i NUMBER :=0;
SAVEPOINT answers_delete_rec;
okl_awr_pvt.delete_row(
l_api_version
,l_init_msg_list
,l_return_status
,l_msg_count
,l_msg_data
,lp_awrv_rec);
ROLLBACK TO answers_delete_rec;
ROLLBACK TO answers_delete_rec;
ROLLBACK TO answers_delete_rec;
FND_MSG_PUB.ADD_EXC_MSG('OKL_ANSWERS_PUB','delete_answers');
END delete_answers;
PROCEDURE delete_answers(
p_api_version IN NUMBER
,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
,p_awrv_tbl IN awrv_tbl_type) IS
i NUMBER := 0;
SAVEPOINT answers_delete_tbl;
delete_answers(
l_api_version
,l_init_msg_list
,l_return_status
,l_msg_count
,l_msg_data
,lp_awrv_tbl(i));
ROLLBACK TO answers_delete_tbl;
ROLLBACK TO answers_delete_tbl;
ROLLBACK TO answers_delete_tbl;
FND_MSG_PUB.ADD_EXC_MSG('OKL_ANSWERS_PUB','delete_answers');
END delete_answers;