DBA Data[Home] [Help]

APPS.OKL_AM_TERMNT_QUOTE_PUB SQL Statements

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

Line: 648

	       OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qld_tbl(' || i || ').select_yn: ' || p_qld_tbl(i).select_yn);
Line: 1060

  PROCEDURE update_quote_line(
               p_api_version    IN NUMBER,
               p_init_msg_list  IN VARCHAR2 DEFAULT G_FALSE,
               x_return_status  OUT NOCOPY VARCHAR2,
               x_msg_count      OUT NOCOPY NUMBER,
               x_msg_data       OUT NOCOPY VARCHAR2,
               p_tqlv_rec       IN tqlv_rec_type,
               x_tqlv_rec       OUT NOCOPY tqlv_rec_type) IS


    l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
Line: 1073

    l_api_name VARCHAR2(30) := 'update_quote_line';
Line: 1078

    l_module_name VARCHAR2(500) := G_MODULE_NAME || 'update_quote_line';
Line: 1088

     SAVEPOINT trx_update_quote_line;
Line: 1130

       OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_TERMNT_QUOTE_PVT.update_quote_line');
Line: 1133

     OKL_AM_TERMNT_QUOTE_PVT.update_quote_line(
               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_tqlv_rec      => lp_tqlv_rec,
               x_tqlv_rec      => lx_tqlv_rec);
Line: 1142

       OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_TERMNT_QUOTE_PVT.update_quote_line , return status: ' || l_return_status);
Line: 1167

      ROLLBACK TO trx_update_quote_line;
Line: 1180

      ROLLBACK TO trx_update_quote_line;
Line: 1193

      ROLLBACK TO trx_update_quote_line;
Line: 1207

  END update_quote_line;
Line: 1220

  PROCEDURE update_quote_line(
               p_api_version    IN NUMBER,
               p_init_msg_list  IN VARCHAR2 DEFAULT G_FALSE,
               x_return_status  OUT NOCOPY VARCHAR2,
               x_msg_count      OUT NOCOPY NUMBER,
               x_msg_data       OUT NOCOPY VARCHAR2,
               p_tqlv_tbl       IN tqlv_tbl_type,
               x_tqlv_tbl       OUT NOCOPY tqlv_tbl_type) IS


    l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
Line: 1233

    l_api_name VARCHAR2(30) := 'update_quote_line';
Line: 1239

    l_module_name VARCHAR2(500) := G_MODULE_NAME || 'update_quote_line';
Line: 1248

     SAVEPOINT trx_update_quote_line;
Line: 1294

       OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_TERMNT_QUOTE_PVT.update_quote_line');
Line: 1297

     OKL_AM_TERMNT_QUOTE_PVT.update_quote_line(
               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_tqlv_tbl      => lp_tqlv_tbl,
               x_tqlv_tbl      => lx_tqlv_tbl);
Line: 1306

       OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_TERMNT_QUOTE_PVT.update_quote_line , return status: ' || l_return_status);
Line: 1331

      ROLLBACK TO trx_update_quote_line;
Line: 1344

      ROLLBACK TO trx_update_quote_line;
Line: 1357

      ROLLBACK TO trx_update_quote_line;
Line: 1370

  END update_quote_line;
Line: 1383

  PROCEDURE delete_quote_line(
               p_api_version    IN NUMBER,
               p_init_msg_list  IN VARCHAR2 DEFAULT G_FALSE,
               x_return_status  OUT NOCOPY VARCHAR2,
               x_msg_count      OUT NOCOPY NUMBER,
               x_msg_data       OUT NOCOPY VARCHAR2,
               p_tqlv_rec       IN tqlv_rec_type) IS


    l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
Line: 1394

    l_api_name VARCHAR2(30) := 'update_quote_line';
Line: 1400

    l_module_name VARCHAR2(500) := G_MODULE_NAME || 'delete_quote_line';
Line: 1409

     SAVEPOINT trx_delete_quote_line;
Line: 1424

       OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_TERMNT_QUOTE_PVT.delete_quote_line');
Line: 1427

     OKL_AM_TERMNT_QUOTE_PVT.delete_quote_line(
               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_tqlv_rec      => lp_tqlv_rec);
Line: 1435

       OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_TERMNT_QUOTE_PVT.delete_quote_line , return status: ' || l_return_status);
Line: 1459

      ROLLBACK TO trx_delete_quote_line;
Line: 1472

      ROLLBACK TO trx_delete_quote_line;
Line: 1485

      ROLLBACK TO trx_delete_quote_line;
Line: 1499

  END delete_quote_line;
Line: 1511

  PROCEDURE delete_quote_line(
               p_api_version    IN NUMBER,
               p_init_msg_list  IN VARCHAR2 DEFAULT G_FALSE,
               x_return_status  OUT NOCOPY VARCHAR2,
               x_msg_count      OUT NOCOPY NUMBER,
               x_msg_data       OUT NOCOPY VARCHAR2,
               p_tqlv_tbl       IN tqlv_tbl_type) IS


    l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
Line: 1522

    l_api_name VARCHAR2(30) := 'delete_quote_line';
Line: 1528

    l_module_name VARCHAR2(500) := G_MODULE_NAME || 'delete_quote_line';
Line: 1537

     SAVEPOINT trx_delete_quote_line;
Line: 1557

       OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_TERMNT_QUOTE_PVT.delete_quote_line');
Line: 1560

     OKL_AM_TERMNT_QUOTE_PVT.delete_quote_line(
               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_tqlv_tbl      => lp_tqlv_tbl);
Line: 1568

       OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_TERMNT_QUOTE_PVT.delete_quote_line , return status: ' || l_return_status);
Line: 1591

      ROLLBACK TO trx_delete_quote_line;
Line: 1604

      ROLLBACK TO trx_delete_quote_line;
Line: 1617

      ROLLBACK TO trx_delete_quote_line;
Line: 1630

  END delete_quote_line;