DBA Data[Home] [Help]

APPS.OKL_PDT_QUALITYS_PUB SQL Statements

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

Line: 402

  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) := FND_API.G_RET_STS_SUCCESS;
Line: 424

    l_api_name              CONSTANT VARCHAR2(30)  := 'update_pdt_qualitys';
Line: 434

    SAVEPOINT update_pdt_qualitys;
Line: 457

    okl_pdt_qualitys_pvt.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      => l_pqyv_rec

                        ,p_qvev_tbl      => l_qvev_tbl

                        ,x_pqyv_rec      => x_pqyv_rec

                        ,x_qvev_tbl      => x_qvev_tbl

                        );
Line: 505

      ROLLBACK TO update_pdt_qualitys;
Line: 513

      ROLLBACK TO update_pdt_qualitys;
Line: 520

      FND_MSG_PUB.ADD_EXC_MSG('OKL_PDT_QUALITYS_PUB','update_pdt_qualitys');
Line: 528

  END update_pdt_qualitys;
Line: 840

  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)   := FND_API.G_RET_STS_SUCCESS;
Line: 858

    l_api_name                    CONSTANT VARCHAR2(30)  := 'update_pdt_qualitys';
Line: 864

    SAVEPOINT update_pdt_qualitys;
Line: 885

    okl_pdt_qualitys_pvt.update_pdt_qualitys(

                           p_api_version   => p_api_version

                          ,p_init_msg_list => p_init_msg_list

                          ,x_return_status => l_return_status

                          ,x_msg_count     => x_msg_count

                          ,x_msg_data      => x_msg_data

                          ,p_pqyv_rec      => l_pqyv_rec

                          ,x_pqyv_rec      => x_pqyv_rec

                          );
Line: 928

      ROLLBACK TO update_pdt_qualitys;
Line: 936

      ROLLBACK TO update_pdt_qualitys;
Line: 943

      FND_MSG_PUB.ADD_EXC_MSG('OKL_PDT_QUALITYS_PUB','update_pdt_qualitys');
Line: 951

  END update_pdt_qualitys;
Line: 955

  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)   := FND_API.G_RET_STS_SUCCESS;
Line: 973

    l_api_name                    CONSTANT VARCHAR2(30)  := 'update_pdt_qualitys';
Line: 986

	SAVEPOINT update_pdt_qualitys;
Line: 1008

        update_pdt_qualitys(

                           p_api_version   => p_api_version

                          ,p_init_msg_list => p_init_msg_list

                          ,x_return_status => l_return_status

                          ,x_msg_count     => x_msg_count

                          ,x_msg_data      => x_msg_data

                          ,p_pqyv_rec      => l_pqyv_tbl(i)

                          ,x_pqyv_rec      => x_pqyv_tbl(i)

                          );
Line: 1068

      ROLLBACK TO update_pdt_qualitys;
Line: 1076

      ROLLBACK TO update_pdt_qualitys;
Line: 1083

      FND_MSG_PUB.ADD_EXC_MSG('OKL_PDT_QUALITYS_PUB','update_pdt_qualitys');
Line: 1093

  END update_pdt_qualitys;
Line: 1099

  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: 1117

    l_api_name               CONSTANT VARCHAR2(30)  := 'delete_pdt_qualitys';
Line: 1125

    SAVEPOINT delete_pdt_qualitys;
Line: 1146

    okl_pdt_qualitys_pvt.delete_pdt_qualitys(

                           p_api_version   => p_api_version

                          ,p_init_msg_list => p_init_msg_list

                          ,x_return_status => l_return_status

                          ,x_msg_count     => x_msg_count

                          ,x_msg_data      => x_msg_data

                          ,p_pqyv_rec      => l_pqyv_rec

                          );
Line: 1189

      ROLLBACK TO delete_pdt_qualitys;
Line: 1197

      ROLLBACK TO delete_pdt_qualitys;
Line: 1204

      FND_MSG_PUB.ADD_EXC_MSG('OKL_PDT_QUALITYS_PUB','delete_pdt_qualitys');
Line: 1212

  END delete_pdt_qualitys;
Line: 1216

  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: 1234

    l_api_name               CONSTANT VARCHAR2(30)  := 'delete_pdt_qualitys';
Line: 1245

	SAVEPOINT delete_pdt_qualitys;
Line: 1267

        delete_pdt_qualitys(

                             p_api_version   => p_api_version

                            ,p_init_msg_list => p_init_msg_list

                            ,x_return_status => l_return_status

                            ,x_msg_count     => x_msg_count

                            ,x_msg_data      => x_msg_data

                            ,p_pqyv_rec      => l_pqyv_tbl(i)

                            );
Line: 1325

      ROLLBACK TO delete_pdt_qualitys;
Line: 1333

      ROLLBACK TO delete_pdt_qualitys;
Line: 1340

      FND_MSG_PUB.ADD_EXC_MSG('OKL_PDT_QUALITYS_PUB','delete_pdt_qualitys');
Line: 1350

  END delete_pdt_qualitys;
Line: 2044

  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)   := FND_API.G_RET_STS_SUCCESS;
Line: 2062

    l_api_name                        CONSTANT VARCHAR2(30)  := 'update_pdt_quality_vals';
Line: 2068

    SAVEPOINT update_pdt_quality_vals;
Line: 2089

    okl_pdt_qualitys_pvt.update_pdt_quality_vals(

                           p_api_version   => p_api_version

                          ,p_init_msg_list => p_init_msg_list

                          ,x_return_status => l_return_status

                          ,x_msg_count     => x_msg_count

                          ,x_msg_data      => x_msg_data

                          ,p_qvev_rec      => l_qvev_rec

                          ,x_qvev_rec      => x_qvev_rec

                          );
Line: 2132

      ROLLBACK TO update_pdt_quality_vals;
Line: 2140

      ROLLBACK TO update_pdt_quality_vals;
Line: 2147

      FND_MSG_PUB.ADD_EXC_MSG('OKL_PDT_QUALITYS_PUB','update_pdt_quality_vals');
Line: 2155

  END update_pdt_quality_vals;
Line: 2159

  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)   := FND_API.G_RET_STS_SUCCESS;
Line: 2177

    l_api_name                        CONSTANT VARCHAR2(30)  := 'update_pdt_quality_vals';
Line: 2188

    SAVEPOINT update_pdt_quality_vals;
Line: 2213

        update_pdt_quality_vals(

                           p_api_version   => p_api_version

                          ,p_init_msg_list => p_init_msg_list

                          ,x_return_status => l_return_status

                          ,x_msg_count     => x_msg_count

                          ,x_msg_data      => x_msg_data

                          ,p_qvev_rec      => l_qvev_tbl(i)

                          ,x_qvev_rec      => x_qvev_tbl(i)

                          );
Line: 2272

      ROLLBACK TO update_pdt_quality_vals;
Line: 2280

      ROLLBACK TO update_pdt_quality_vals;
Line: 2287

      FND_MSG_PUB.ADD_EXC_MSG('OKL_PDT_QUALITYS_PUB','update_pdt_quality_vals');
Line: 2297

  END update_pdt_quality_vals;
Line: 2303

  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: 2321

    l_api_name                        CONSTANT VARCHAR2(30)  := 'delete_pdt_quality_vals';
Line: 2327

    SAVEPOINT delete_pdt_quality_vals;
Line: 2350

    okl_pdt_qualitys_pvt.delete_pdt_quality_vals(

                           p_api_version   => p_api_version

                          ,p_init_msg_list => p_init_msg_list

                          ,x_return_status => l_return_status

                          ,x_msg_count     => x_msg_count

                          ,x_msg_data      => x_msg_data

                          ,p_qvev_rec      => l_qvev_rec);
Line: 2389

      ROLLBACK TO delete_pdt_quality_vals;
Line: 2397

      ROLLBACK TO delete_pdt_quality_vals;
Line: 2404

      FND_MSG_PUB.ADD_EXC_MSG('OKL_PDT_QUALITYS_PUB','delete_pdt_quality_vals');
Line: 2412

  END delete_pdt_quality_vals;
Line: 2416

  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: 2436

    l_api_name                        CONSTANT VARCHAR2(30)  := 'delete_pdt_quality_vals';
Line: 2445

    SAVEPOINT delete_pdt_quality_vals;
Line: 2470

        delete_pdt_quality_vals(

                                  p_api_version   => p_api_version

                                 ,p_init_msg_list => p_init_msg_list

                                 ,x_return_status => l_return_status

                                 ,x_msg_count     => x_msg_count

                                 ,x_msg_data      => x_msg_data

                                 ,p_qvev_rec      => l_qvev_tbl(i));
Line: 2525

      ROLLBACK TO delete_pdt_quality_vals;
Line: 2533

      ROLLBACK TO delete_pdt_quality_vals;
Line: 2540

      FND_MSG_PUB.ADD_EXC_MSG('OKL_PDT_QUALITYS_PUB','delete_pdt_quality_vals');
Line: 2548

  END delete_pdt_quality_vals;