DBA Data[Home] [Help]

APPS.OKL_AM_AMORTIZE_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 199

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 ;
Line: 216

SAVEPOINT trx_update_offlease_asset_trx;
Line: 231

	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) ;
Line: 258

      ROLLBACK TO trx_update_offlease_asset_trx;
Line: 266

      ROLLBACK TO trx_update_offlease_asset_trx;
Line: 274

      ROLLBACK TO trx_update_offlease_asset_trx;
Line: 278

      FND_MSG_PUB.ADD_EXC_MSG('OKL_AM_AMORTIZE_PUB','update_offlease_asset_trx');
Line: 282

END update_offlease_asset_trx;
Line: 286

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 ;
Line: 306

SAVEPOINT trx_update_offlease_asset_trx;
Line: 322

	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) ;
Line: 355

      ROLLBACK TO trx_update_offlease_asset_trx;
Line: 363

      ROLLBACK TO trx_update_offlease_asset_trx;
Line: 371

      ROLLBACK TO trx_update_offlease_asset_trx;
Line: 375

      FND_MSG_PUB.ADD_EXC_MSG('OKL_AM_AMORTIZE_PUB','update_offlease_asset_trx');
Line: 379

END update_offlease_asset_trx;
Line: 392

  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 ;
Line: 411

     SAVEPOINT trx_update_deprn;
Line: 421

     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);
Line: 442

      ROLLBACK TO trx_update_deprn;
Line: 450

      ROLLBACK TO trx_update_deprn;
Line: 458

      ROLLBACK TO trx_update_deprn;
Line: 462

      FND_MSG_PUB.ADD_EXC_MSG('OKL_AM_AMORTIZE_PUB','update_depreciation');
Line: 467

  END  update_depreciation;