DBA Data[Home] [Help]

APPS.OKL_AM_ASSET_RETURN_PUB SQL Statements

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

Line: 103

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

SAVEPOINT trx_update_asset_return;
Line: 133

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

      ROLLBACK TO trx_update_asset_return;
Line: 169

      ROLLBACK TO trx_update_asset_return;
Line: 177

      ROLLBACK TO trx_update_asset_return;
Line: 181

      FND_MSG_PUB.ADD_EXC_MSG('OKL_AM_ASSET_RETURN_PUB','update_asset_return');
Line: 186

END update_asset_return;
Line: 218

SAVEPOINT trx_update_asset_return;
Line: 260

      ROLLBACK TO trx_update_asset_return;
Line: 268

      ROLLBACK TO trx_update_asset_return;
Line: 276

      ROLLBACK TO trx_update_asset_return;
Line: 287

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

SAVEPOINT trx_update_asset_return;
Line: 320

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

      ROLLBACK TO trx_update_asset_return;
Line: 356

      ROLLBACK TO trx_update_asset_return;
Line: 364

      ROLLBACK TO trx_update_asset_return;
Line: 368

      FND_MSG_PUB.ADD_EXC_MSG('OKL_AM_ASSET_RETURN_PUB','update_asset_return');
Line: 373

  END update_asset_return;