DBA Data[Home] [Help]

APPS.OKL_TMPT_SET_PUB SQL Statements

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

Line: 412

  PROCEDURE update_tmpt_set(

    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_aesv_rec              IN  aesv_rec_type,

    p_avlv_tbl              IN  avlv_tbl_type,

	p_atlv_tbl				IN	atlv_tbl_type,

    x_aesv_rec              OUT NOCOPY aesv_rec_type,

    x_avlv_tbl              OUT NOCOPY avlv_tbl_type,

	x_atlv_tbl				OUT NOCOPY atlv_tbl_type) IS

    l_return_status         VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
Line: 438

    l_api_name              CONSTANT VARCHAR2(30)  := 'update_tmpt_set';
Line: 450

    SAVEPOINT update_tmpt_set;
Line: 472

    okl_tmpt_set_pvt.update_tmpt_set(

                         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_aesv_rec      => l_aesv_rec

                        ,p_avlv_tbl      => l_avlv_tbl

                        ,p_atlv_tbl => l_atlv_tbl

                        ,x_aesv_rec      => x_aesv_rec

                        ,x_avlv_tbl      => x_avlv_tbl

						,x_atlv_tbl       => x_atlv_tbl

                        );
Line: 525

      ROLLBACK TO update_tmpt_set;
Line: 533

      ROLLBACK TO update_tmpt_set;
Line: 540

      FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','update_tmpt_set');
Line: 548

  END update_tmpt_set;
Line: 866

  PROCEDURE update_tmpt_set(

     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_aesv_rec                   IN  aesv_rec_type

    ,x_aesv_rec                   OUT NOCOPY aesv_rec_type) IS

    l_return_status               VARCHAR2(1)   := OKC_API.G_RET_STS_SUCCESS;
Line: 884

    l_api_name                    CONSTANT VARCHAR2(30)  := 'update_tmpt_set';
Line: 892

    SAVEPOINT update_tmpt_set;
Line: 913

    okl_tmpt_set_pvt.update_tmpt_set(

                           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_aesv_rec      => l_aesv_rec

                          ,x_aesv_rec      => x_aesv_rec

                          );
Line: 958

      ROLLBACK TO update_tmpt_set;
Line: 966

      ROLLBACK TO update_tmpt_set;
Line: 973

      FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','update_tmpt_set');
Line: 981

  END update_tmpt_set;
Line: 985

  PROCEDURE update_tmpt_set(

     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_aesv_tbl                   IN  aesv_tbl_type

    ,x_aesv_tbl                   OUT NOCOPY aesv_tbl_type) IS

    l_return_status               VARCHAR2(1)   := OKC_API.G_RET_STS_SUCCESS;
Line: 1004

    l_api_name                    CONSTANT VARCHAR2(30)  := 'update_tmpt_set';
Line: 1014

    SAVEPOINT update_tmpt_set;
Line: 1038

        update_tmpt_set(

                           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_aesv_rec      => l_aesv_tbl(i)

                          ,x_aesv_rec      => x_aesv_tbl(i)

                          );
Line: 1097

      ROLLBACK TO update_tmpt_set;
Line: 1105

      ROLLBACK TO update_tmpt_set;
Line: 1112

      FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','update_tmpt_set');
Line: 1120

  END update_tmpt_set;
Line: 1126

  PROCEDURE delete_tmpt_set(

     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_aesv_rec              IN  aesv_rec_type) IS

    i                        NUMBER :=0;
Line: 1144

    l_api_name               CONSTANT VARCHAR2(30)  := 'delete_tmpt_set';
Line: 1154

    SAVEPOINT delete_tmpt_set;
Line: 1175

    okl_tmpt_set_pvt.delete_tmpt_set(

                           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_aesv_rec      => l_aesv_rec

                          );
Line: 1219

      ROLLBACK TO delete_tmpt_set;
Line: 1227

      ROLLBACK TO delete_tmpt_set;
Line: 1234

      FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','delete_tmpt_set');
Line: 1242

  END delete_tmpt_set;
Line: 1246

  PROCEDURE delete_tmpt_set(

     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_aesv_tbl              IN  aesv_tbl_type) IS

    i                        NUMBER :=0;
Line: 1265

    l_api_name               CONSTANT VARCHAR2(30)  := 'delete_tmpt_set';
Line: 1273

     SAVEPOINT delete_tmpt_set;
Line: 1298

        delete_tmpt_set(

                             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_aesv_rec      => l_aesv_tbl(i)

                            );
Line: 1354

      ROLLBACK TO delete_tmpt_set;
Line: 1362

      ROLLBACK TO delete_tmpt_set;
Line: 1369

      FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','delete_tmpt_set');
Line: 1377

  END delete_tmpt_set;
Line: 2077

  PROCEDURE update_template(

     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_avlv_rec                       IN  avlv_rec_type

    ,x_avlv_rec                       OUT NOCOPY avlv_rec_type) IS

    l_return_status                   VARCHAR2(1)   := OKC_API.G_RET_STS_SUCCESS;
Line: 2095

    l_api_name                        CONSTANT VARCHAR2(30)  := 'update_template';
Line: 2101

    SAVEPOINT update_template;
Line: 2123

    okl_tmpt_set_pvt.update_template(

                           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_avlv_rec      => l_avlv_rec

                          ,x_avlv_rec      => x_avlv_rec

                          );
Line: 2167

      ROLLBACK TO update_template;
Line: 2175

      ROLLBACK TO update_template;
Line: 2182

      FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','update_template');
Line: 2190

  END update_template;
Line: 2194

  PROCEDURE update_template(

     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_avlv_tbl                       IN  avlv_tbl_type

    ,x_avlv_tbl                       OUT NOCOPY avlv_tbl_type) IS

    l_return_status                   VARCHAR2(1)   := OKC_API.G_RET_STS_SUCCESS;
Line: 2213

    l_api_name                        CONSTANT VARCHAR2(30)  := 'update_template';
Line: 2223

     SAVEPOINT update_template;
Line: 2247

        update_template(

                           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_avlv_rec      => l_avlv_tbl(i)

                          ,x_avlv_rec      => x_avlv_tbl(i)

                          );
Line: 2307

      ROLLBACK TO update_template;
Line: 2315

      ROLLBACK TO update_template;
Line: 2322

      FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','update_template');
Line: 2330

  END update_template;
Line: 2336

  PROCEDURE delete_template(

     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_avlv_rec                       IN  avlv_rec_type) IS

    i                                 NUMBER :=0;
Line: 2354

    l_api_name                        CONSTANT VARCHAR2(30)  := 'delete_template';
Line: 2360

    SAVEPOINT delete_template;
Line: 2383

    okl_tmpt_set_pvt.delete_template(

                           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_avlv_rec      => l_avlv_rec);
Line: 2423

      ROLLBACK TO delete_template;
Line: 2431

      ROLLBACK TO delete_template;
Line: 2438

      FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','delete_template');
Line: 2446

  END delete_template;
Line: 2450

  PROCEDURE delete_template(

     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_avlv_tbl                       IN  avlv_tbl_type) IS



    i                                 NUMBER :=0;
Line: 2471

    l_api_name                        CONSTANT VARCHAR2(30)  := 'delete_template';
Line: 2480

   SAVEPOINT delete_template;
Line: 2504

        delete_template(

                                  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_avlv_rec      => l_avlv_tbl(i));
Line: 2561

      ROLLBACK TO delete_template;
Line: 2569

      ROLLBACK TO delete_template;
Line: 2576

      FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','delete_template');
Line: 2585

  END delete_template;
Line: 3284

  PROCEDURE update_tmpt_lines(

     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_atlv_rec                       IN  atlv_rec_type

    ,x_atlv_rec                       OUT NOCOPY atlv_rec_type) IS

    l_return_status                   VARCHAR2(1)   := OKC_API.G_RET_STS_SUCCESS;
Line: 3302

    l_api_name                        CONSTANT VARCHAR2(30)  := 'update_tmpt_lines';
Line: 3308

    SAVEPOINT update_tmpt_lines;
Line: 3329

    okl_tmpt_set_pvt.update_tmpt_lines(

                           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_atlv_rec      => l_atlv_rec

                          ,x_atlv_rec      => x_atlv_rec

                          );
Line: 3373

      ROLLBACK TO update_tmpt_lines;
Line: 3381

      ROLLBACK TO update_tmpt_lines;
Line: 3388

      FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','update_tmpt_lines');
Line: 3395

  END update_tmpt_lines;
Line: 3399

  PROCEDURE update_tmpt_lines(

     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_atlv_tbl                       IN  atlv_tbl_type

    ,x_atlv_tbl                       OUT NOCOPY atlv_tbl_type) IS

    l_return_status                   VARCHAR2(1)   := OKC_API.G_RET_STS_SUCCESS;
Line: 3418

    l_api_name                        CONSTANT VARCHAR2(30)  := 'update_tmpt_lines';
Line: 3428

    SAVEPOINT update_tmpt_lines;
Line: 3451

        update_tmpt_lines(

                           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_atlv_rec      => l_atlv_tbl(i)

                          ,x_atlv_rec      => x_atlv_tbl(i)

                          );
Line: 3513

      ROLLBACK TO update_tmpt_lines;
Line: 3521

      ROLLBACK TO update_tmpt_lines;
Line: 3528

      FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','update_tmpt_lines');
Line: 3536

  END update_tmpt_lines;
Line: 3542

  PROCEDURE delete_tmpt_lines(

     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_atlv_rec                       IN  atlv_rec_type) IS

    i                                 NUMBER :=0;
Line: 3560

    l_api_name                        CONSTANT VARCHAR2(30)  := 'delete_tmpt_lines';
Line: 3566

    SAVEPOINT delete_tmpt_lines;
Line: 3589

    okl_tmpt_set_pvt.delete_tmpt_lines(

                           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_atlv_rec      => l_atlv_rec);
Line: 3628

      ROLLBACK TO delete_tmpt_lines;
Line: 3636

      ROLLBACK TO delete_tmpt_lines;
Line: 3643

      FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','delete_tmpt_lines');
Line: 3651

  END delete_tmpt_lines;
Line: 3655

  PROCEDURE delete_tmpt_lines(

     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_atlv_tbl                       IN  atlv_tbl_type) IS



    i                                 NUMBER :=0;
Line: 3676

    l_api_name                        CONSTANT VARCHAR2(30)  := 'delete_tmpt_lines';
Line: 3684

    SAVEPOINT delete_tmpt_lines;
Line: 3710

        delete_tmpt_lines(

                                  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_atlv_rec      => l_atlv_tbl(i));
Line: 3766

      ROLLBACK TO delete_tmpt_lines;
Line: 3774

      ROLLBACK TO delete_tmpt_lines;
Line: 3781

      FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','delete_tmpt_lines');
Line: 3789

  END delete_tmpt_lines;