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

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

Line: 91


    okl_pqy_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_pqyv_rec      => p_pqyv_rec
                          ,x_pqyv_rec      => x_pqyv_rec
                          );

Line: 135


    okl_pqy_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_pqyv_tbl      => p_pqyv_tbl
                          ,x_pqyv_tbl      => x_pqyv_tbl
                          );

Line: 169


  PROCEDURE update_pdt_qualitys(
    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_pqyv_rec              IN  pqyv_rec_type,
    p_qvev_tbl              IN  qvev_tbl_type,
    x_pqyv_rec              OUT NOCOPY pqyv_rec_type,
    x_qvev_tbl              OUT NOCOPY qvev_tbl_type) IS
    l_return_status         VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line: 182


    update_pdt_qualitys(
                         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_pqyv_rec      => p_pqyv_rec
                        ,x_pqyv_rec      => x_pqyv_rec
                        );

Line: 200


    update_pdt_quality_vals(
                              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_qvev_tbl      => p_qvev_tbl
                             ,x_qvev_tbl      => x_qvev_tbl
                             );

Line: 231


  END update_pdt_qualitys;

Line: 372


  PROCEDURE update_pdt_qualitys(
     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_pqyv_rec                   IN  pqyv_rec_type
    ,x_pqyv_rec                   OUT NOCOPY pqyv_rec_type) IS
    l_return_status               VARCHAR2(1)   := OKC_API.G_RET_STS_SUCCESS;

Line: 383


    okl_pqy_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_pqyv_rec      => p_pqyv_rec
                          ,x_pqyv_rec      => x_pqyv_rec
                          );

Line: 410


  END update_pdt_qualitys;

Line: 412


  PROCEDURE update_pdt_qualitys(
     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_pqyv_tbl                   IN  pqyv_tbl_type
    ,x_pqyv_tbl                   OUT NOCOPY pqyv_tbl_type) IS
    l_return_status               VARCHAR2(1)   := OKC_API.G_RET_STS_SUCCESS;

Line: 422


    okl_pqy_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_pqyv_tbl      => p_pqyv_tbl
                          ,x_pqyv_tbl      => x_pqyv_tbl
                          );

Line: 449


  END update_pdt_qualitys;

Line: 452


  PROCEDURE delete_pdt_qualitys(
     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_pqyv_rec              IN  pqyv_rec_type) IS
    i                        NUMBER :=0;

Line: 464


      SELECT qve.id
        FROM OKL_PQY_VALUES qve
       WHERE qve.pqy_id = p_pqyv_rec.id;

Line: 474


      delete_pdt_quality_vals(
                                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_qvev_tbl      => l_qvev_tbl
                               );

Line: 492


    okl_pqy_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_pqyv_rec      => p_pqyv_rec
                          );

Line: 520


  END delete_pdt_qualitys;

Line: 522


  PROCEDURE delete_pdt_qualitys(
     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_pqyv_tbl              IN  pqyv_tbl_type) IS
    i                        NUMBER :=0;

Line: 538


        delete_pdt_qualitys(
                             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_pqyv_rec      => p_pqyv_tbl(i)
                            );

Line: 576


  END delete_pdt_qualitys;

Line: 664


    okl_qve_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_qvev_rec      => p_qvev_rec
                          ,x_qvev_rec      => x_qvev_rec
                          );

Line: 704


    okl_qve_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_qvev_tbl      => p_qvev_tbl
                          ,x_qvev_tbl      => x_qvev_tbl
                          );

Line: 809


  PROCEDURE update_pdt_quality_vals(
     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_qvev_rec                       IN  qvev_rec_type
    ,x_qvev_rec                       OUT NOCOPY qvev_rec_type) IS
    l_return_status                   VARCHAR2(1)   := OKC_API.G_RET_STS_SUCCESS;

Line: 820


    okl_qve_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_qvev_rec      => p_qvev_rec
                          ,x_qvev_rec      => x_qvev_rec
                          );

Line: 847


  END update_pdt_quality_vals;

Line: 849


  PROCEDURE update_pdt_quality_vals(
     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_qvev_tbl                       IN  qvev_tbl_type
    ,x_qvev_tbl                       OUT NOCOPY qvev_tbl_type) IS
    l_return_status                   VARCHAR2(1)   := OKC_API.G_RET_STS_SUCCESS;

Line: 860


    okl_qve_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_qvev_tbl      => p_qvev_tbl
                          ,x_qvev_tbl      => x_qvev_tbl
                          );

Line: 887


  END update_pdt_quality_vals;

Line: 890


  PROCEDURE delete_pdt_quality_vals(
     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_qvev_rec                       IN  qvev_rec_type) IS
    i                                 NUMBER :=0;

Line: 900


    okl_qve_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_qvev_rec      => p_qvev_rec);

Line: 925


  END delete_pdt_quality_vals;

Line: 927


  PROCEDURE delete_pdt_quality_vals(
     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_qvev_tbl                       IN  qvev_tbl_type) IS

    i                                 NUMBER :=0;

Line: 944


        delete_pdt_quality_vals(
                                  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_qvev_rec      => p_qvev_tbl(i));

Line: 981


  END delete_pdt_quality_vals;