The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE update_offlease_asset_trx( 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_header_rec IN thpv_rec_type,
p_lines_rec IN tlpv_rec_type) AS
l_api_version NUMBER ;
SAVEPOINT trx_update_offlease_asset_trx;
OKL_AM_AMORTIZE_PVT.update_offlease_asset_trx( 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_header_rec => lp_header_rec,
p_lines_rec => lp_lines_rec) ;
ROLLBACK TO trx_update_offlease_asset_trx;
ROLLBACK TO trx_update_offlease_asset_trx;
ROLLBACK TO trx_update_offlease_asset_trx;
FND_MSG_PUB.ADD_EXC_MSG('OKL_AM_AMORTIZE_PUB','update_offlease_asset_trx');
END update_offlease_asset_trx;
PROCEDURE update_offlease_asset_trx( 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_header_tbl IN thpv_tbl_type,
p_lines_tbl IN tlpv_tbl_type,
x_record_status OUT NOCOPY VARCHAR2) AS
l_api_version NUMBER ;
SAVEPOINT trx_update_offlease_asset_trx;
OKL_AM_AMORTIZE_PVT.update_offlease_asset_trx( 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_header_tbl => lp_header_tbl,
p_lines_tbl => lp_lines_tbl,
x_record_status => lx_record_status) ;
ROLLBACK TO trx_update_offlease_asset_trx;
ROLLBACK TO trx_update_offlease_asset_trx;
ROLLBACK TO trx_update_offlease_asset_trx;
FND_MSG_PUB.ADD_EXC_MSG('OKL_AM_AMORTIZE_PUB','update_offlease_asset_trx');
END update_offlease_asset_trx;
PROCEDURE update_depreciation(
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_deprn_rec IN deprn_rec_type) IS
l_api_version NUMBER ;
SAVEPOINT trx_update_deprn;
OKL_AM_AMORTIZE_PVT.update_depreciation(
p_api_version => l_api_version,
p_init_msg_list => l_init_msg_list,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_deprn_rec => lp_deprn_rec);
ROLLBACK TO trx_update_deprn;
ROLLBACK TO trx_update_deprn;
ROLLBACK TO trx_update_deprn;
FND_MSG_PUB.ADD_EXC_MSG('OKL_AM_AMORTIZE_PUB','update_depreciation');
END update_depreciation;