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

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

Line: 91


    okl_ptq_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_ptqv_rec      => p_ptqv_rec
                          ,x_ptqv_rec      => x_ptqv_rec
                          );

Line: 135


    okl_ptq_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_ptqv_tbl      => p_ptqv_tbl
                          ,x_ptqv_tbl      => x_ptqv_tbl
                          );

Line: 169


  PROCEDURE update_ptl_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_ptqv_rec              IN  ptqv_rec_type,
    p_ptvv_tbl              IN  ptvv_tbl_type,
    x_ptqv_rec              OUT NOCOPY ptqv_rec_type,
    x_ptvv_tbl              OUT NOCOPY ptvv_tbl_type) IS
    l_return_status         VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line: 182


    update_ptl_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_ptqv_rec      => p_ptqv_rec
                        ,x_ptqv_rec      => x_ptqv_rec
                        );

Line: 200


    update_ptl_qlty_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_ptvv_tbl      => p_ptvv_tbl
                             ,x_ptvv_tbl      => x_ptvv_tbl
                             );

Line: 231


  END update_ptl_qualitys;

Line: 372


  PROCEDURE update_ptl_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_ptqv_rec                   IN  ptqv_rec_type
    ,x_ptqv_rec                   OUT NOCOPY ptqv_rec_type) IS
    l_return_status               VARCHAR2(1)   := OKC_API.G_RET_STS_SUCCESS;

Line: 383


    okl_ptq_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_ptqv_rec      => p_ptqv_rec
                          ,x_ptqv_rec      => x_ptqv_rec
                          );

Line: 410


  END update_ptl_qualitys;

Line: 412


  PROCEDURE update_ptl_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_ptqv_tbl                   IN  ptqv_tbl_type
    ,x_ptqv_tbl                   OUT NOCOPY ptqv_tbl_type) IS
    l_return_status               VARCHAR2(1)   := OKC_API.G_RET_STS_SUCCESS;

Line: 422


    okl_ptq_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_ptqv_tbl      => p_ptqv_tbl
                          ,x_ptqv_tbl      => x_ptqv_tbl
                          );

Line: 449


  END update_ptl_qualitys;

Line: 452


  PROCEDURE delete_ptl_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_ptqv_rec              IN  ptqv_rec_type) IS
    i                        NUMBER :=0;

Line: 464


      SELECT ptv.id
        FROM OKL_PTQ_VALUES ptv
       WHERE ptv.ptq_id = p_ptqv_rec.id;

Line: 474


      delete_ptl_qlty_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_ptvv_tbl      => l_ptvv_tbl
                               );

Line: 492


    okl_ptq_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_ptqv_rec      => p_ptqv_rec
                          );

Line: 520


  END delete_ptl_qualitys;

Line: 522


  PROCEDURE delete_ptl_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_ptqv_tbl              IN  ptqv_tbl_type) IS
    i                        NUMBER :=0;

Line: 538


        delete_ptl_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_ptqv_rec      => p_ptqv_tbl(i)
                            );

Line: 576


  END delete_ptl_qualitys;

Line: 664


    okl_ptv_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_ptvv_rec      => p_ptvv_rec
                          ,x_ptvv_rec      => x_ptvv_rec
                          );

Line: 704


    okl_ptv_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_ptvv_tbl      => p_ptvv_tbl
                          ,x_ptvv_tbl      => x_ptvv_tbl
                          );

Line: 809


  PROCEDURE update_ptl_qlty_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_ptvv_rec                       IN  ptvv_rec_type
    ,x_ptvv_rec                       OUT NOCOPY ptvv_rec_type) IS
    l_return_status                   VARCHAR2(1)   := OKC_API.G_RET_STS_SUCCESS;

Line: 820


    okl_ptv_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_ptvv_rec      => p_ptvv_rec
                          ,x_ptvv_rec      => x_ptvv_rec
                          );

Line: 847


  END update_ptl_qlty_values;

Line: 849


  PROCEDURE update_ptl_qlty_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_ptvv_tbl                       IN  ptvv_tbl_type
    ,x_ptvv_tbl                       OUT NOCOPY ptvv_tbl_type) IS
    l_return_status                   VARCHAR2(1)   := OKC_API.G_RET_STS_SUCCESS;

Line: 860


    okl_ptv_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_ptvv_tbl      => p_ptvv_tbl
                          ,x_ptvv_tbl      => x_ptvv_tbl
                          );

Line: 887


  END update_ptl_qlty_values;

Line: 890


  PROCEDURE delete_ptl_qlty_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_ptvv_rec                       IN  ptvv_rec_type) IS
    i                                 NUMBER :=0;

Line: 900


    okl_ptv_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_ptvv_rec      => p_ptvv_rec);

Line: 925


  END delete_ptl_qlty_values;

Line: 927


  PROCEDURE delete_ptl_qlty_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_ptvv_tbl                       IN  ptvv_tbl_type) IS
    i                                 NUMBER :=0;

Line: 943


        delete_ptl_qlty_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_ptvv_rec      => p_ptvv_tbl(i));

Line: 980


  END delete_ptl_qlty_values;