DBA Data[Home] [Help]

APPS.OKL_VAR_INT_PARAMS_PVT SQL Statements

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

Line: 69

    OKL_VIR_PVT.insert_row(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_virv_rec          => l_virv_rec
                          ,x_virv_rec          => x_virv_rec);
Line: 81

                              'okl_vir_pvt.insert_row returned with status '||x_return_status||' id '||x_virv_rec.id
                              );
Line: 195

    OKL_VIR_PVT.insert_row(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_virv_tbl          => l_virv_tbl
                          ,x_virv_tbl          => x_virv_tbl);
Line: 207

                              'okl_vir_pvt.insert_row returned with status '||x_return_status
                              );
Line: 271

  PROCEDURE update_var_int_params(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_virv_rec      IN  virv_rec_type,
                                     x_virv_rec      OUT NOCOPY virv_rec_type) IS

    -- Variables Declarations
    l_api_version CONSTANT NUMBER DEFAULT 1.0;
Line: 281

    l_api_name CONSTANT VARCHAR2(30) DEFAULT 'update_var_int_params';
Line: 287

    l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VAR_INT_PARAMS_PVT.update_var_int_params';
Line: 297

       okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'start debug OKLRVISB.pls call update_var_int_params for record');
Line: 319

    OKL_VIR_PVT.update_row(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_virv_rec       => l_virv_rec
                          ,x_virv_rec       => x_virv_rec);
Line: 328

                             l_module,'okl_vir_pvt.update_row returned with status '||x_return_status||' id '||x_virv_rec.id
                             );
Line: 343

       okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'ends debug OKLRVISB.pls call update_var_int_params for record');
Line: 373

  END update_var_int_params;
Line: 392

  PROCEDURE update_var_int_params(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_virv_tbl      IN  virv_tbl_type,
                                  x_virv_tbl      OUT NOCOPY virv_tbl_type) IS
     -- Variables Declarations
    l_api_version CONSTANT NUMBER DEFAULT 1.0;
Line: 401

    l_api_name CONSTANT VARCHAR2(30) DEFAULT 'update_var_int_params';
Line: 407

    l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VAR_INT_PARAMS_PVT.update_var_int_params';
Line: 417

       okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'start debug OKLRVISB.pls call update_var_int_params for table');
Line: 439

    OKL_VIR_PVT.update_row(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_virv_tbl       => l_virv_tbl
                          ,x_virv_tbl       => x_virv_tbl);
Line: 448

                             l_module,'okl_vir_pvt.update_row returned with status '||x_return_status
                             );
Line: 461

      okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'ends debug OKLRVISB.pls call update_var_int_params for table');
Line: 491

  END update_var_int_params;
Line: 510

  PROCEDURE delete_var_int_params(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_virv_tbl      IN  virv_tbl_type ) IS

     -- Variables Declarations
    l_api_version CONSTANT NUMBER DEFAULT 1.0;
Line: 519

    l_api_name CONSTANT VARCHAR2(30) DEFAULT 'delete_var_int_params';
Line: 525

    l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VAR_INT_PARAMS_PVT.delete_var_int_params';
Line: 535

      okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'start debug OKLRVISB.pls call delete_var_int_params for table');
Line: 557

    OKL_VIR_PVT.delete_row(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_virv_tbl       => l_virv_tbl
                          );
Line: 566

                             l_module,'okl_vir_pvt.delete_row returned with status '||x_return_status
                             );
Line: 579

      okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'ends debug OKLRVISB.pls call delete_var_int_params for a table');
Line: 609

  END delete_var_int_params;