DBA Data[Home] [Help]

APPS.OKL_CONTRACT_BALANCES_PVT SQL Statements

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

Line: 53

    OKL_CBL_PVT.insert_row(p_api_version    => l_api_version,
                           p_init_msg_list  => p_init_msg_list,
                           x_return_status  => x_return_status,
                           x_msg_count      => x_msg_count,
                           x_msg_data       => x_msg_data,
                           p_cblv_rec       => p_cblv_rec,
                           x_cblv_rec       => x_cblv_rec);
Line: 65

                              'okl_cbl_pvt.insert_row(rec) returned with status '||x_return_status||' id '||x_cblv_rec.id
                              );
Line: 108

  END create_contract_balance; -- end of record insert api - REC
Line: 158

    OKL_CBL_PVT.insert_row(p_api_version    => l_api_version,
                           p_init_msg_list  => p_init_msg_list,
                           x_return_status  => x_return_status,
                           x_msg_count      => x_msg_count,
                           x_msg_data       => x_msg_data,
                           p_cblv_tbl       => p_cblv_tbl,
                           x_cblv_tbl       => x_cblv_tbl);
Line: 170

                              'okl_cbl_pvt.insert_row (tbl) returned with status '||x_return_status
                              );
Line: 213

  END create_contract_balance; -- end of table insert api - TBL
Line: 224

  PROCEDURE update_contract_balance(
                         p_api_version      IN         NUMBER
                       , p_init_msg_list    IN         VARCHAR2 DEFAULT OKL_API.G_FALSE
                       , x_return_status    OUT NOCOPY VARCHAR2
                       , x_msg_count        OUT NOCOPY NUMBER
                       , x_msg_data         OUT NOCOPY VARCHAR2
                       , p_cblv_rec         IN         okl_cblv_rec
                       , x_cblv_rec         OUT NOCOPY okl_cblv_rec) AS
    l_api_version CONSTANT NUMBER DEFAULT 1.0;
Line: 233

    l_api_name CONSTANT VARCHAR2(30) DEFAULT 'UPDATE_CONTRACT_BAL_REC';
Line: 235

    l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_CONTRACT_BALANCES_PVT.UPDATE_CONTRACT_BALANCE';
Line: 244

      okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRCBLB.pls call update_contract_balance(REC)');
Line: 263

    OKL_CBL_PVT.update_row(p_api_version    => l_api_version,
                           p_init_msg_list  => p_init_msg_list,
                           x_return_status  => x_return_status,
                           x_msg_count      => x_msg_count,
                           x_msg_data       => x_msg_data,
                           p_cblv_rec       => p_cblv_rec,
                           x_cblv_rec       => x_cblv_rec);
Line: 275

                              'okl_cbl_pvt.update_row(rec) returned with status '||x_return_status||'id '||x_cblv_rec.id
                              );
Line: 289

      okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRCBLB.pls call update_contract_balance(REC)');
Line: 318

  END update_contract_balance; -- end of record update api - REC
Line: 329

  PROCEDURE update_contract_balance(
                         p_api_version      IN         NUMBER
                       , p_init_msg_list    IN         VARCHAR2 DEFAULT OKL_API.G_FALSE
                       , x_return_status    OUT NOCOPY VARCHAR2
                       , x_msg_count        OUT NOCOPY NUMBER
                       , x_msg_data         OUT NOCOPY VARCHAR2
                       , p_cblv_tbl         IN         okl_cblv_tbl
                       , x_cblv_tbl         OUT NOCOPY okl_cblv_tbl) AS
    l_api_version CONSTANT NUMBER DEFAULT 1.0;
Line: 338

    l_api_name CONSTANT VARCHAR2(30) DEFAULT 'UPDATE_CONTRACT_BAL_TBL';
Line: 349

      okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRCBLB.pls call update_contract_balance(TBL)');
Line: 368

    OKL_CBL_PVT.update_row(p_api_version    => l_api_version,
                           p_init_msg_list  => p_init_msg_list,
                           x_return_status  => x_return_status,
                           x_msg_count      => x_msg_count,
                           x_msg_data       => x_msg_data,
                           p_cblv_tbl       => p_cblv_tbl,
                           x_cblv_tbl       => x_cblv_tbl);
Line: 380

                              'okl_cbl_pvt.update_row (tbl) returned with status '||x_return_status
                              );
Line: 394

      okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRCBLB.pls call update_contract_balance(TBL)');
Line: 423

  END update_contract_balance; -- end of table update api - TBL
Line: 434

  PROCEDURE delete_contract_balances(
                         p_api_version      IN         NUMBER
                       , p_init_msg_list    IN         VARCHAR2 DEFAULT OKL_API.G_FALSE
                       , x_return_status    OUT NOCOPY VARCHAR2
                       , x_msg_count        OUT NOCOPY NUMBER
                       , x_msg_data         OUT NOCOPY VARCHAR2
                       , p_cblv_tbl         IN         okl_cblv_tbl) AS
    l_api_version CONSTANT NUMBER DEFAULT 1.0;
Line: 442

    l_api_name CONSTANT VARCHAR2(30) DEFAULT 'DELETE_CONTRACT_BAL_TBL';
Line: 444

    l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_CONTRACT_BALANCES_PVT.DELETE_CONTRACT_BALANCE';
Line: 453

      okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRCBLB.pls call delete_contract_balance(TBL)');
Line: 472

    OKL_CBL_PVT.delete_row(p_api_version    => l_api_version,
                           p_init_msg_list  => p_init_msg_list,
                           x_return_status  => x_return_status,
                           x_msg_count      => x_msg_count,
                           x_msg_data       => x_msg_data,
                           p_cblv_tbl       => p_cblv_tbl);
Line: 483

                              'okl_cbl_pvt.delete_row (tbl) returned with status '||x_return_status
                              );
Line: 497

      okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRCBLB.pls call delete_contract_balance(TBL)');
Line: 526

  END delete_contract_balances; -- end of table update api - TBL