DBA Data[Home] [Help]

APPS.OKL_TRX_CSH_BATCH_PUB SQL Statements

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

Line: 4

PROCEDURE insert_trx_csh_batch(
     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_btcv_rec              IN  btcv_rec_type
    ,x_btcv_rec              OUT  NOCOPY btcv_rec_type) IS


l_api_version NUMBER ;
Line: 24

SAVEPOINT trx_csh_batch_insert;
Line: 41

okl_btc_pvt.insert_row(
                          l_api_version
                         ,l_init_msg_list
                         ,l_return_status
                         ,l_msg_count
                         ,l_msg_data
                         ,lp_btcv_rec
                         ,lx_btcv_rec);
Line: 66

      ROLLBACK TO trx_csh_batch_insert;
Line: 74

      ROLLBACK TO trx_csh_batch_insert;
Line: 82

      ROLLBACK TO trx_csh_batch_insert;
Line: 86

      FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_CSH_BATCH_PUB','insert_trx_csh_batch');
Line: 90

END insert_trx_csh_batch;
Line: 92

PROCEDURE insert_trx_csh_batch(
     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_btcv_tbl              IN  btcv_tbl_type
    ,x_btcv_tbl              OUT  NOCOPY btcv_tbl_type) IS

l_api_version NUMBER;
Line: 111

SAVEPOINT trx_csh_batch_insert;
Line: 132

okl_btc_pvt.insert_row(
                          l_api_version
                         ,l_init_msg_list
                         ,l_return_status
                         ,l_msg_count
                         ,l_msg_data
                         ,lp_btcv_tbl
                         ,lx_btcv_tbl);
Line: 158

      ROLLBACK TO trx_csh_batch_insert;
Line: 166

      ROLLBACK TO trx_csh_batch_insert;
Line: 174

      ROLLBACK TO trx_csh_batch_insert;
Line: 178

      FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_CSH_BATCH_PUB','insert_trx_csh_batch');
Line: 182

END insert_trx_csh_batch;
Line: 268

PROCEDURE update_trx_csh_batch(
     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_btcv_rec              IN  btcv_rec_type
    ,x_btcv_rec              OUT  NOCOPY btcv_rec_type) IS

l_api_version NUMBER ;
Line: 287

SAVEPOINT trx_csh_batch_update;
Line: 298

    okl_btc_pvt.update_row(
                              l_api_version
                             ,l_init_msg_list
                             ,l_return_status
                             ,l_msg_count
                             ,l_msg_data
                             ,lp_btcv_rec
                             ,lx_btcv_rec);
Line: 324

      ROLLBACK TO trx_csh_batch_update;
Line: 332

      ROLLBACK TO trx_csh_batch_update;
Line: 340

      ROLLBACK TO trx_csh_batch_update;
Line: 344

      FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_CSH_BATCH_PUB','update_trx_csh_batch');
Line: 348

END update_trx_csh_batch;
Line: 350

PROCEDURE update_trx_csh_batch(
     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_btcv_tbl              IN  btcv_tbl_type
    ,x_btcv_tbl              OUT  NOCOPY btcv_tbl_type) IS

l_api_version NUMBER;
Line: 369

SAVEPOINT trx_csh_batch_update;
Line: 380

    okl_btc_pvt.update_row(
                              l_api_version
                             ,l_init_msg_list
                             ,l_return_status
                             ,l_msg_count
                             ,l_msg_data
                             ,lp_btcv_tbl
                             ,lx_btcv_tbl);
Line: 406

      ROLLBACK TO trx_csh_batch_update;
Line: 414

      ROLLBACK TO trx_csh_batch_update;
Line: 422

      ROLLBACK TO trx_csh_batch_update;
Line: 426

      FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_CSH_BATCH_PUB','update_trx_csh_batch');
Line: 430

END update_trx_csh_batch;
Line: 432

PROCEDURE delete_trx_csh_batch(
     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_btcv_rec              IN btcv_rec_type) IS

i	                    NUMBER :=0;
Line: 451

SAVEPOINT trx_csh_batch_delete_rec;
Line: 461

okl_btc_pvt.delete_row(
                          l_api_version
                         ,l_init_msg_list
                         ,l_return_status
                         ,l_msg_count
                         ,l_msg_data
                         ,lp_btcv_rec);
Line: 483

      ROLLBACK TO trx_csh_batch_delete_rec;
Line: 491

      ROLLBACK TO trx_csh_batch_delete_rec;
Line: 499

      ROLLBACK TO trx_csh_batch_delete_rec;
Line: 503

      FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_CSH_BATCH_PUB','delete_trx_csh_batch');
Line: 507

END delete_trx_csh_batch;
Line: 509

PROCEDURE delete_trx_csh_batch(
     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_btcv_tbl           IN btcv_tbl_type) IS

i NUMBER := 0;
Line: 528

SAVEPOINT trx_csh_batch_delete_tbl;
Line: 544

          delete_trx_csh_batch(
                               l_api_version
                              ,l_init_msg_list
                              ,l_return_status
                              ,l_msg_count
                              ,l_msg_data
                              ,lp_btcv_tbl(i));
Line: 571

      ROLLBACK TO trx_csh_batch_delete_tbl;
Line: 579

      ROLLBACK TO trx_csh_batch_delete_tbl;
Line: 587

      ROLLBACK TO trx_csh_batch_delete_tbl;
Line: 591

      FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_CSH_BATCH_PUB','delete_trx_csh_batch');
Line: 595

END delete_trx_csh_batch;
Line: 776

    insert_trx_csh_batch(p_api_version           => p_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_btcv_rec              => p_btcv_rec
                        ,x_btcv_rec              => x_btcv_rec);
Line: 784

    update_trx_csh_batch(p_api_version           => p_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_btcv_rec              => p_btcv_rec
                        ,x_btcv_rec              => x_btcv_rec);