The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE insert_tax_trx_details(
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_ttdv_rec IN ttdv_rec_type,
x_ttdv_rec OUT NOCOPY ttdv_rec_type) IS
l_api_version NUMBER ;
SAVEPOINT ttd_insert ;
okl_ttd_pvt.insert_row(
l_api_version
,l_init_msg_list
,l_return_status
,l_msg_count
,l_msg_data
,lp_ttdv_rec
,lx_ttdv_rec);
ROLLBACK TO ttd_insert;
ROLLBACK TO ttd_insert;
ROLLBACK TO ttd_insert;
FND_MSG_PUB.ADD_EXC_MSG('OKL_TAX_TRX_DETAILS_PUB','insert_tax_trx_details');
END insert_tax_trx_details;
PROCEDURE insert_tax_trx_details(
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_ttdv_tbl IN ttdv_tbl_type,
x_ttdv_tbl OUT NOCOPY ttdv_tbl_type) IS
l_api_version NUMBER;
SAVEPOINT ttd_insert;
okl_ttd_pvt.insert_row(
l_api_version
,l_init_msg_list
,l_return_status
,l_msg_count
,l_msg_data
,lp_ttdv_tbl
,lx_ttdv_tbl);
ROLLBACK TO ttd_insert;
ROLLBACK TO ttd_insert;
ROLLBACK TO ttd_insert;
FND_MSG_PUB.ADD_EXC_MSG('OKL_TAX_TRX_DETAILS_PUB','insert_tax_trx_details');
END insert_tax_trx_details;
PROCEDURE update_tax_trx_details(
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_ttdv_rec IN ttdv_rec_type
,x_ttdv_rec OUT NOCOPY ttdv_rec_type) IS
l_api_version NUMBER ;
SAVEPOINT ttd_update;
okl_ttd_pvt.update_row(
l_api_version
,l_init_msg_list
,l_return_status
,l_msg_count
,l_msg_data
,lp_ttdv_rec
,lx_ttdv_rec);
ROLLBACK TO ttd_update;
ROLLBACK TO ttd_update;
ROLLBACK TO ttd_update;
FND_MSG_PUB.ADD_EXC_MSG('OKL_TAX_TRX_DETAILS_PUB','update_tax_trx_details');
END update_tax_trx_details;
PROCEDURE update_tax_trx_details(
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_ttdv_tbl IN ttdv_tbl_type,
x_ttdv_tbl OUT NOCOPY ttdv_tbl_type) IS
l_api_version NUMBER;
SAVEPOINT ttd_update;
okl_ttd_pvt.update_row(
l_api_version
,l_init_msg_list
,l_return_status
,l_msg_count
,l_msg_data
,lp_ttdv_tbl
,lx_ttdv_tbl);
ROLLBACK TO ttd_update;
ROLLBACK TO ttd_update;
ROLLBACK TO ttd_update;
FND_MSG_PUB.ADD_EXC_MSG('OKL_TAX_TRX_DETAILS_PUB','update_tax_trx_details');
END update_tax_trx_details;
PROCEDURE delete_tax_trx_details(
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_ttdv_rec IN ttdv_rec_type) IS
i NUMBER :=0;
SAVEPOINT ttd_delete;
okl_ttd_pvt.delete_row(
l_api_version
,l_init_msg_list
,l_return_status
,l_msg_count
,l_msg_data
,lp_ttdv_rec);
ROLLBACK TO ttd_delete;
ROLLBACK TO ttd_delete;
ROLLBACK TO ttd_delete;
FND_MSG_PUB.ADD_EXC_MSG('OKL_TAX_TRX_DETAILS_PUB','delete_tax_trx_details');
END delete_tax_trx_details;
PROCEDURE delete_tax_trx_details(
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_ttdv_tbl IN ttdv_tbl_type) IS
i NUMBER := 0;
SAVEPOINT ttd_delete;
okl_ttd_pvt.delete_row(
l_api_version
,l_init_msg_list
,l_return_status
,l_msg_count
,l_msg_data
,lp_ttdv_tbl);
ROLLBACK TO ttd_delete;
ROLLBACK TO ttd_delete;
ROLLBACK TO ttd_delete;
FND_MSG_PUB.ADD_EXC_MSG('OKL_TAX_TRX_DETAILS_PUB','delete_tax_trx_details');
END delete_tax_trx_details;