The following lines contain the word 'select', 'insert', 'update' or 'delete':
okl_tqd_pvt.insert_row(l_api_version
,l_init_msg_list
,l_return_status
,l_msg_count
,l_msg_data
,lp_tqdv_rec
,lx_tqdv_rec);
okl_tqd_pvt.insert_row(l_api_version
,l_init_msg_list
,l_return_status
,l_msg_count
,l_msg_data
,lp_tqdv_tbl
,lx_tqdv_tbl);
PROCEDURE update_txd_qte_ln_dtls(
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_tqdv_rec IN tqdv_rec_type
,x_tqdv_rec OUT NOCOPY tqdv_rec_type) IS
l_api_version NUMBER;
SAVEPOINT update_txd_qte_ln_dtls;
okl_tqd_pvt.update_row(l_api_version
,l_init_msg_list
,l_return_status
,l_msg_count
,l_msg_data
,lp_tqdv_rec
,lx_tqdv_rec);
ROLLBACK TO update_txd_qte_ln_dtls;
ROLLBACK TO update_txd_qte_ln_dtls;
ROLLBACK TO update_txd_qte_ln_dtls;
FND_MSG_PUB.ADD_EXC_MSG('OKL_TXD_QTE_LN_DTLS_PUB','update_txd_qte_ln_dtls');
END update_txd_qte_ln_dtls;
PROCEDURE update_txd_qte_ln_dtls(
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_tqdv_tbl IN tqdv_tbl_type
,x_tqdv_tbl OUT NOCOPY tqdv_tbl_type) IS
l_api_version NUMBER;
SAVEPOINT update_txd_qte_ln_dtls_tbl;
okl_tqd_pvt.update_row(l_api_version
,l_init_msg_list
,l_return_status
,l_msg_count
,l_msg_data
,lp_tqdv_tbl
,lx_tqdv_tbl);
ROLLBACK TO update_txd_qte_ln_dtls_tbl;
ROLLBACK TO update_txd_qte_ln_dtls_tbl;
ROLLBACK TO update_txd_qte_ln_dtls_tbl;
FND_MSG_PUB.ADD_EXC_MSG('OKL_TXD_QTE_LN_DTLS_PUB','update_txd_qte_ln_dtls_tbl');
END update_txd_qte_ln_dtls;
PROCEDURE delete_txd_qte_ln_dtls(
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_tqdv_rec IN tqdv_rec_type) IS
l_return_status VARCHAR2(3) := FND_API.G_RET_STS_SUCCESS;
SAVEPOINT delete_txd_qte_ln_dtls;
okl_tqd_pvt.delete_row(l_api_version
,l_init_msg_list
,l_return_status
,l_msg_count
,l_msg_data
,lp_tqdv_rec);
ROLLBACK TO delete_txd_qte_ln_dtls;
ROLLBACK TO delete_txd_qte_ln_dtls;
ROLLBACK TO delete_txd_qte_ln_dtls;
FND_MSG_PUB.ADD_EXC_MSG('OKL_TXD_QTE_LN_DTLS_PUB','delete_txd_qte_ln_dtls');
END delete_txd_qte_ln_dtls;
PROCEDURE delete_txd_qte_ln_dtls(
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_tqdv_tbl IN tqdv_tbl_type) IS
l_api_version NUMBER ;
SAVEPOINT delete_txd_qte_ln_dtls_tbl;
okl_tqd_pvt.delete_row(
l_api_version,
l_init_msg_list,
l_return_status,
l_msg_count,
l_msg_data,
lp_tqdv_tbl);
ROLLBACK TO delete_txd_qte_ln_dtls_tbl;
ROLLBACK TO delete_txd_qte_ln_dtls_tbl;
ROLLBACK TO delete_txd_qte_ln_dtls_tbl;
FND_MSG_PUB.ADD_EXC_MSG('OKL_TXD_QTE_LN_DTLS_PUB','delete_txd_qte_ln_dtls_tbl');
END delete_txd_qte_ln_dtls;