APPS.OKL_AM_REPURCHASE_ASSET_PUB SQL Statements

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

Line: 36

	-- call the insert of pvt

	OKL_AM_REPURCHASE_ASSET_PVT.create_repurchase_quote(
                                                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_qtev_rec               => p_qtev_rec,
											    p_tqlv_tbl               => p_tqlv_tbl,
											    x_qtev_rec               => x_qtev_rec,
											    x_tqlv_tbl               => x_tqlv_tbl);

Line: 97

  PROCEDURE update_repurchase_quote(
    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_qtev_rec                      IN qtev_rec_type,
    p_tqlv_tbl					   	IN tqlv_tbl_type,
    x_qtev_rec                      OUT NOCOPY qtev_rec_type,
    x_tqlv_tbl					   	OUT NOCOPY tqlv_tbl_type) IS


    l_api_version NUMBER ;

Line: 117

    SAVEPOINT update_repurchase_quote;

Line: 128

	-- call the insert of pvt

	OKL_AM_REPURCHASE_ASSET_PVT.update_repurchase_quote(
                                                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_qtev_rec               => p_qtev_rec,
											    p_tqlv_tbl               => p_tqlv_tbl,
											    x_qtev_rec               => x_qtev_rec,
											    x_tqlv_tbl               => x_tqlv_tbl);

Line: 161

	      ROLLBACK TO update_repurchase_quote;

Line: 169

	      ROLLBACK TO update_repurchase_quote;

Line: 177

	      ROLLBACK TO update_repurchase_quote;

Line: 181

	      FND_MSG_PUB.ADD_EXC_MSG('OKL_AM_REPURCHASE_ASSET_PUB','update_repurchase_quote');

Line: 186

  END update_repurchase_quote;