eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_OPTIONS_PVT SQL Statements

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

Line: 91


    okl_opt_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_optv_rec      => p_optv_rec
                          ,x_optv_rec      => x_optv_rec
                          );

Line: 135


    okl_opt_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_optv_tbl      => p_optv_tbl
                          ,x_optv_tbl      => x_optv_tbl
                          );

Line: 169


  PROCEDURE update_options(
    p_api_version           IN  NUMBER,
    p_init_msg_list         IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status         OUT NOCOPY VARCHAR2,
    x_msg_count             OUT NOCOPY NUMBER,
    x_msg_data              OUT NOCOPY VARCHAR2,
    p_optv_rec              IN  optv_rec_type,
    p_ovev_tbl              IN  ovev_tbl_type,
    x_optv_rec              OUT NOCOPY optv_rec_type,
    x_ovev_tbl              OUT NOCOPY ovev_tbl_type) IS
    l_return_status         VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line: 182


    update_options(
                         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_optv_rec      => p_optv_rec
                        ,x_optv_rec      => x_optv_rec
                        );

Line: 200


    update_option_values(
                              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_ovev_tbl      => p_ovev_tbl
                             ,x_ovev_tbl      => x_ovev_tbl
                             );

Line: 231


  END update_options;

Line: 372


  PROCEDURE update_options(
     p_api_version                IN  NUMBER
    ,p_init_msg_list              IN  VARCHAR2 DEFAULT OKC_API.G_FALSE
    ,x_return_status              OUT NOCOPY VARCHAR2
    ,x_msg_count                  OUT NOCOPY NUMBER
    ,x_msg_data                   OUT NOCOPY VARCHAR2
    ,p_optv_rec                   IN  optv_rec_type
    ,x_optv_rec                   OUT NOCOPY optv_rec_type) IS
    l_return_status               VARCHAR2(1)   := OKC_API.G_RET_STS_SUCCESS;

Line: 383


    okl_opt_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_optv_rec      => p_optv_rec
                          ,x_optv_rec      => x_optv_rec
                          );

Line: 410


  END update_options;

Line: 412


  PROCEDURE update_options(
     p_api_version                IN  NUMBER
    ,p_init_msg_list              IN  VARCHAR2 DEFAULT OKC_API.G_FALSE
    ,x_return_status              OUT NOCOPY VARCHAR2
    ,x_msg_count                  OUT NOCOPY NUMBER
    ,x_msg_data                   OUT NOCOPY VARCHAR2
    ,p_optv_tbl                   IN  optv_tbl_type
    ,x_optv_tbl                   OUT NOCOPY optv_tbl_type) IS
    l_return_status               VARCHAR2(1)   := OKC_API.G_RET_STS_SUCCESS;

Line: 422


    okl_opt_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_optv_tbl      => p_optv_tbl
                          ,x_optv_tbl      => x_optv_tbl
                          );

Line: 449


  END update_options;

Line: 452


  PROCEDURE delete_options(
     p_api_version           IN  NUMBER
    ,p_init_msg_list         IN  VARCHAR2 DEFAULT OKC_API.G_FALSE
    ,x_return_status         OUT NOCOPY VARCHAR2
    ,x_msg_count             OUT NOCOPY NUMBER
    ,x_msg_data              OUT NOCOPY VARCHAR2
    ,p_optv_rec              IN  optv_rec_type) IS
    i                        NUMBER :=0;

Line: 464


      SELECT ove.id
        FROM OKL_OPT_VALUES_V ove
       WHERE ove.opt_id = p_optv_rec.id;

Line: 474


      delete_option_values(
                                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_ovev_tbl      => l_ovev_tbl
                               );

Line: 492


    okl_opt_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_optv_rec      => p_optv_rec
                          );

Line: 520


  END delete_options;

Line: 522


  PROCEDURE delete_options(
     p_api_version           IN  NUMBER
    ,p_init_msg_list         IN  VARCHAR2 DEFAULT OKC_API.G_FALSE
    ,x_return_status         OUT NOCOPY VARCHAR2
    ,x_msg_count             OUT NOCOPY NUMBER
    ,x_msg_data              OUT NOCOPY VARCHAR2
    ,p_optv_tbl              IN  optv_tbl_type) IS
    i                        NUMBER :=0;

Line: 539


        delete_options(
                             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_optv_rec      => p_optv_tbl(i)
                            );

Line: 577


  END delete_options;

Line: 665


    okl_ove_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_ovev_rec      => p_ovev_rec
                          ,x_ovev_rec      => x_ovev_rec
                          );

Line: 705


    okl_ove_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_ovev_tbl      => p_ovev_tbl
                          ,x_ovev_tbl      => x_ovev_tbl
                          );

Line: 810


  PROCEDURE update_option_values(
     p_api_version                    IN  NUMBER
    ,p_init_msg_list                  IN  VARCHAR2 DEFAULT OKC_API.G_FALSE
    ,x_return_status                  OUT NOCOPY VARCHAR2
    ,x_msg_count                      OUT NOCOPY NUMBER
    ,x_msg_data                       OUT NOCOPY VARCHAR2
    ,p_ovev_rec                       IN  ovev_rec_type
    ,x_ovev_rec                       OUT NOCOPY ovev_rec_type) IS
    l_return_status                   VARCHAR2(1)   := OKC_API.G_RET_STS_SUCCESS;

Line: 821


    okl_ove_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_ovev_rec      => p_ovev_rec
                          ,x_ovev_rec      => x_ovev_rec
                          );

Line: 848


  END update_option_values;

Line: 850


  PROCEDURE update_option_values(
     p_api_version                    IN  NUMBER
    ,p_init_msg_list                  IN  VARCHAR2 DEFAULT OKC_API.G_FALSE
    ,x_return_status                  OUT NOCOPY VARCHAR2
    ,x_msg_count                      OUT NOCOPY NUMBER
    ,x_msg_data                       OUT NOCOPY VARCHAR2
    ,p_ovev_tbl                       IN  ovev_tbl_type
    ,x_ovev_tbl                       OUT NOCOPY ovev_tbl_type) IS
    l_return_status                   VARCHAR2(1)   := OKC_API.G_RET_STS_SUCCESS;

Line: 861


    okl_ove_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_ovev_tbl      => p_ovev_tbl
                          ,x_ovev_tbl      => x_ovev_tbl
                          );

Line: 888


  END update_option_values;

Line: 891


  PROCEDURE delete_option_values(
     p_api_version                    IN  NUMBER
    ,p_init_msg_list                  IN  VARCHAR2 DEFAULT OKC_API.G_FALSE
    ,x_return_status                  OUT NOCOPY VARCHAR2
    ,x_msg_count                      OUT NOCOPY NUMBER
    ,x_msg_data                       OUT NOCOPY VARCHAR2
    ,p_ovev_rec                       IN  ovev_rec_type) IS
    i                                 NUMBER :=0;

Line: 901


    okl_ove_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_ovev_rec      => p_ovev_rec);

Line: 926


  END delete_option_values;

Line: 928


  PROCEDURE delete_option_values(
     p_api_version                    IN  NUMBER
    ,p_init_msg_list                  IN  VARCHAR2 DEFAULT OKC_API.G_FALSE
    ,x_return_status                  OUT NOCOPY VARCHAR2
    ,x_msg_count                      OUT NOCOPY NUMBER
    ,x_msg_data                       OUT NOCOPY VARCHAR2
    ,p_ovev_tbl                       IN  ovev_tbl_type) IS
    i                                 NUMBER :=0;

Line: 945


        delete_option_values(
                                  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_ovev_rec      => p_ovev_tbl(i));

Line: 982


  END delete_option_values;