DBA Data[Home] [Help]

APPS.OKL_AM_RESTRUCTURE_QUOTE_PUB SQL Statements

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

Line: 185

PROCEDURE update_restructure_quote(
     p_api_version                  IN   NUMBER
    ,p_init_msg_list                IN   VARCHAR2 DEFAULT FND_API.G_FALSE
    ,x_return_status                OUT  NOCOPY VARCHAR2
    ,x_msg_count                    OUT  NOCOPY NUMBER
    ,x_msg_data                     OUT  NOCOPY VARCHAR2
    ,p_quot_rec                     IN   quot_rec_type
    ,x_quot_rec                     OUT  NOCOPY quot_rec_type) IS

l_api_version NUMBER ;
Line: 204

SAVEPOINT restructure_quote_update;
Line: 219

okl_am_restructure_quote_pvt.update_restructure_quote(
                              l_api_version
                             ,l_init_msg_list
                             ,l_return_status
                             ,l_msg_count
                             ,l_msg_data
                             ,lp_quot_rec
                             ,lx_quot_rec);
Line: 250

      ROLLBACK TO restructure_quote_update;
Line: 258

      ROLLBACK TO restructure_quote_update;
Line: 266

      ROLLBACK TO restructure_quote_update;
Line: 270

      FND_MSG_PUB.ADD_EXC_MSG('OKL_AM_RESTRUCTURE_QUOTE_PUB','update_restructure_quote');
Line: 274

END update_restructure_quote;
Line: 276

PROCEDURE update_restructure_quote(
     p_api_version                  IN   NUMBER
    ,p_init_msg_list                IN   VARCHAR2 DEFAULT FND_API.G_FALSE
    ,x_return_status                OUT  NOCOPY VARCHAR2
    ,x_msg_count                    OUT  NOCOPY NUMBER
    ,x_msg_data                     OUT  NOCOPY VARCHAR2
    ,p_quot_tbl                     IN   quot_tbl_type
    ,x_quot_tbl                     OUT  NOCOPY quot_tbl_type) IS

l_api_version NUMBER;
Line: 295

SAVEPOINT restructure_quote_update;
Line: 309

okl_am_restructure_quote_pvt.update_restructure_quote(
                              l_api_version
                             ,l_init_msg_list
                             ,l_return_status
                             ,l_msg_count
                             ,l_msg_data
                             ,lp_quot_tbl
                             ,lx_quot_tbl);
Line: 339

      ROLLBACK TO restructure_quote_update;
Line: 347

      ROLLBACK TO restructure_quote_update;
Line: 355

      ROLLBACK TO restructure_quote_update;
Line: 359

      FND_MSG_PUB.ADD_EXC_MSG('OKL_AM_RESTRUCTURE_QUOTE_PUB','update_restructure_quote');
Line: 363

END update_restructure_quote;