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_INDICES_PVT SQL Statements

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

Line: 90


    okl_idx_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_idxv_rec      => p_idxv_rec
                          ,x_idxv_rec      => x_idxv_rec
                          );

Line: 134


    okl_idx_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_idxv_tbl      => p_idxv_tbl
                          ,x_idxv_tbl      => x_idxv_tbl
                          );

Line: 168


  PROCEDURE update_indices(
    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_idxv_rec              IN  idxv_rec_type,
    p_ivev_tbl              IN  ivev_tbl_type,
    x_idxv_rec              OUT NOCOPY idxv_rec_type,
    x_ivev_tbl              OUT NOCOPY ivev_tbl_type) IS
    l_return_status         VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line: 181


    update_indices(
                         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_idxv_rec      => p_idxv_rec
                        ,x_idxv_rec      => x_idxv_rec
                        );

Line: 199


    update_index_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_ivev_tbl      => p_ivev_tbl
                             ,x_ivev_tbl      => x_ivev_tbl
                             );

Line: 230


  END update_indices;

Line: 371


  PROCEDURE update_indices(
     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_idxv_rec                   IN  idxv_rec_type
    ,x_idxv_rec                   OUT NOCOPY idxv_rec_type) IS
    l_return_status               VARCHAR2(1)   := OKC_API.G_RET_STS_SUCCESS;

Line: 382


    okl_idx_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_idxv_rec      => p_idxv_rec
                          ,x_idxv_rec      => x_idxv_rec
                          );

Line: 409


  END update_indices;

Line: 411


  PROCEDURE update_indices(
     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_idxv_tbl                   IN  idxv_tbl_type
    ,x_idxv_tbl                   OUT NOCOPY idxv_tbl_type) IS
    l_return_status               VARCHAR2(1)   := OKC_API.G_RET_STS_SUCCESS;

Line: 421


    okl_idx_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_idxv_tbl      => p_idxv_tbl
                          ,x_idxv_tbl      => x_idxv_tbl
                          );

Line: 448


  END update_indices;

Line: 451


  PROCEDURE delete_indices(
     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_idxv_rec              IN  idxv_rec_type) IS
    i                        NUMBER :=0;

Line: 463


      SELECT ive.id
        FROM OKL_INDEX_VALUES ive
       WHERE ive.idx_id = p_idxv_rec.id;

Line: 473


      delete_index_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_ivev_tbl      => l_ivev_tbl
                               );

Line: 491


    okl_idx_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_idxv_rec      => p_idxv_rec
                          );

Line: 519


  END delete_indices;

Line: 521


  PROCEDURE delete_indices(
     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_idxv_tbl              IN  idxv_tbl_type) IS
    i                        NUMBER :=0;

Line: 536


        delete_indices(
                             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_idxv_rec      => p_idxv_tbl(i)
                            );

Line: 567


  END delete_indices;

Line: 655


    okl_ive_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_ivev_rec      => p_ivev_rec
                          ,x_ivev_rec      => x_ivev_rec
                          );

Line: 695


    okl_ive_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_ivev_tbl      => p_ivev_tbl
                          ,x_ivev_tbl      => x_ivev_tbl
                          );

Line: 800


  PROCEDURE update_index_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_ivev_rec                       IN  ivev_rec_type
    ,x_ivev_rec                       OUT NOCOPY ivev_rec_type) IS
    l_return_status                   VARCHAR2(1)   := OKC_API.G_RET_STS_SUCCESS;

Line: 811


    okl_ive_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_ivev_rec      => p_ivev_rec
                          ,x_ivev_rec      => x_ivev_rec
                          );

Line: 838


  END update_index_values;

Line: 840


  PROCEDURE update_index_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_ivev_tbl                       IN  ivev_tbl_type
    ,x_ivev_tbl                       OUT NOCOPY ivev_tbl_type) IS
    l_return_status                   VARCHAR2(1)   := OKC_API.G_RET_STS_SUCCESS;

Line: 851


    okl_ive_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_ivev_tbl      => p_ivev_tbl
                          ,x_ivev_tbl      => x_ivev_tbl
                          );

Line: 878


  END update_index_values;

Line: 881


  PROCEDURE delete_index_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_ivev_rec                       IN  ivev_rec_type) IS
    i                                 NUMBER :=0;

Line: 891


    okl_ive_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_ivev_rec      => p_ivev_rec);

Line: 916


  END delete_index_values;

Line: 918


  PROCEDURE delete_index_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_ivev_tbl                       IN  ivev_tbl_type) IS

    i                                 NUMBER :=0;

Line: 934


        delete_index_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_ivev_rec      => p_ivev_tbl(i));

Line: 963


  END delete_index_values;