The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE update_asset_return(
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_artv_rec IN artv_rec_type,
x_artv_rec OUT NOCOPY artv_rec_type) AS
l_api_version NUMBER ;
SAVEPOINT trx_update_asset_return;
OKL_AM_ASSET_RETURN_PVT.update_asset_return( p_api_version => l_api_version
,p_init_msg_list => l_init_msg_list
,x_msg_data => l_msg_data
,x_msg_count => l_msg_count
,x_return_status => l_return_status
,p_artv_rec => lp_artv_rec
,x_artv_rec => lx_artv_rec) ;
ROLLBACK TO trx_update_asset_return;
ROLLBACK TO trx_update_asset_return;
ROLLBACK TO trx_update_asset_return;
FND_MSG_PUB.ADD_EXC_MSG('OKL_AM_ASSET_RETURN_PUB','update_asset_return');
END update_asset_return;
SAVEPOINT trx_update_asset_return;
ROLLBACK TO trx_update_asset_return;
ROLLBACK TO trx_update_asset_return;
ROLLBACK TO trx_update_asset_return;
PROCEDURE update_asset_return(
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_artv_tbl IN artv_tbl_type,
x_artv_tbl OUT NOCOPY artv_tbl_type) IS
l_api_version NUMBER ;
SAVEPOINT trx_update_asset_return;
OKL_AM_ASSET_RETURN_PVT.update_asset_return( p_api_version => l_api_version
,p_init_msg_list => l_init_msg_list
,x_msg_data => l_msg_data
,x_msg_count => l_msg_count
,x_return_status => l_return_status
,p_artv_tbl => lp_artv_tbl
,x_artv_tbl => lx_artv_tbl) ;
ROLLBACK TO trx_update_asset_return;
ROLLBACK TO trx_update_asset_return;
ROLLBACK TO trx_update_asset_return;
FND_MSG_PUB.ADD_EXC_MSG('OKL_AM_ASSET_RETURN_PUB','update_asset_return');
END update_asset_return;