APPS.OKL_AM_CONSOLIDATED_QTE_PUB SQL Statements

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

Line: 111

  PROCEDURE update_consolidate_quote (
           p_api_version                 IN  NUMBER,
           p_init_msg_list               IN  VARCHAR2,
           x_return_status               OUT NOCOPY VARCHAR2,
           x_msg_count                   OUT NOCOPY NUMBER,
           x_msg_data                    OUT NOCOPY VARCHAR2,
           p_cons_rec                    IN  qtev_rec_type,
           x_cons_rec                    OUT NOCOPY qtev_rec_type,
           x_qtev_tbl                    OUT NOCOPY qtev_tbl_type) IS

     l_api_version NUMBER ;

Line: 132

     SAVEPOINT trx_update_consolidate_quote;

Line: 147

     OKL_AM_CONSOLIDATED_QTE_PVT.update_consolidate_quote(
                                           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_cons_rec      => lp_cons_rec,
	                                         x_cons_rec      => lx_cons_rec,
                                           x_qtev_tbl      => lx_qtev_tbl);

Line: 178

      ROLLBACK TO trx_update_consolidate_quote;

Line: 187

      ROLLBACK TO trx_update_consolidate_quote;

Line: 196

      ROLLBACK TO trx_update_consolidate_quote;

Line: 200

      FND_MSG_PUB.ADD_EXC_MSG('OKL_AM_CONSOLIDATED_QTE_PUB','update_consolidate_quote');

Line: 205

  END update_consolidate_quote;