DBA Data[Home] [Help]

APPS.OKL_PROCESS_TMPT_SET_PUB SQL Statements

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

Line: 248

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

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

    SAVEPOINT update_tmpt_set2;
Line: 278

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLPTMSB.pls call OKL_PROCESS_TMPT_SET_PVT.update_tmpt_set ');
Line: 281

    OKL_PROCESS_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: 296

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLPTMSB.pls call OKL_PROCESS_TMPT_SET_PVT.update_tmpt_set ');
Line: 312

      ROLLBACK TO update_tmpt_set2;
Line: 318

      ROLLBACK TO update_tmpt_set2;
Line: 324

      ROLLBACK TO update_tmpt_set2;
Line: 325

      FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','update_tmpt_set');
Line: 332

  END update_tmpt_set;
Line: 334

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

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

    SAVEPOINT update_tmpt_set2;
Line: 358

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLPTMSB.pls call OKL_PROCESS_TMPT_SET_PVT.update_tmpt_set ');
Line: 361

    OKL_PROCESS_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: 372

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLPTMSB.pls call OKL_PROCESS_TMPT_SET_PVT.update_tmpt_set ');
Line: 386

      ROLLBACK TO update_tmpt_set2;
Line: 392

      ROLLBACK TO update_tmpt_set2;
Line: 398

      ROLLBACK TO update_tmpt_set2;
Line: 399

      FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','update_tmpt_set');
Line: 406

  END update_tmpt_set;
Line: 409

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

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

    SAVEPOINT update_tmpt_set2;
Line: 431

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

      ROLLBACK TO update_tmpt_set2;
Line: 466

      ROLLBACK TO update_tmpt_set2;
Line: 472

      ROLLBACK TO update_tmpt_set2;
Line: 473

      FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','update_tmpt_set');
Line: 480

  END update_tmpt_set;
Line: 483

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

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

    SAVEPOINT delete_tmpt_set2;
Line: 507

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLPTMSB.pls call OKL_PROCESS_TMPT_SET_PVT.delete_tmpt_set ');
Line: 510

    OKL_PROCESS_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: 520

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLPTMSB.pls call OKL_PROCESS_TMPT_SET_PVT.delete_tmpt_set ');
Line: 533

      ROLLBACK TO delete_tmpt_set2;
Line: 539

      ROLLBACK TO delete_tmpt_set2;
Line: 545

      ROLLBACK TO delete_tmpt_set2;
Line: 546

      FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','delete_tmpt_set');
Line: 553

  END delete_tmpt_set;
Line: 555

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

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

     SAVEPOINT delete_tmpt_set2;
Line: 576

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

      ROLLBACK TO delete_tmpt_set2;
Line: 609

      ROLLBACK TO delete_tmpt_set2;
Line: 615

      ROLLBACK TO delete_tmpt_set2;
Line: 616

      FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','delete_tmpt_set');
Line: 623

  END delete_tmpt_set;
Line: 767

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

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

    SAVEPOINT update_template2;
Line: 791

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLPTMSB.pls call OKL_PROCESS_TMPT_SET_PVT.update_template ');
Line: 794

    OKL_PROCESS_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: 805

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLPTMSB.pls call OKL_PROCESS_TMPT_SET_PVT.update_template ');
Line: 819

      ROLLBACK TO update_template2;
Line: 825

      ROLLBACK TO update_template2;
Line: 831

      ROLLBACK TO update_template2;
Line: 832

      FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','update_template');
Line: 839

  END update_template;
Line: 841

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

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

     SAVEPOINT update_template2;
Line: 863

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

      ROLLBACK TO update_template2;
Line: 898

      ROLLBACK TO update_template2;
Line: 904

      ROLLBACK TO update_template2;
Line: 905

      FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','update_template');
Line: 912

  END update_template;
Line: 915

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

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

    SAVEPOINT delete_template2;
Line: 939

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLPTMSB.pls call OKL_PROCESS_TMPT_SET_PVT.delete_template ');
Line: 942

    OKL_PROCESS_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: 951

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLPTMSB.pls call OKL_PROCESS_TMPT_SET_PVT.delete_template ');
Line: 964

      ROLLBACK TO delete_template2;
Line: 970

      ROLLBACK TO delete_template2;
Line: 976

      ROLLBACK TO delete_template2;
Line: 977

      FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','delete_template');
Line: 984

  END delete_template;
Line: 986

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

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

   SAVEPOINT delete_template2;
Line: 1007

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

      ROLLBACK TO delete_template2;
Line: 1039

      ROLLBACK TO delete_template2;
Line: 1045

      ROLLBACK TO delete_template2;
Line: 1046

      FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','delete_template');
Line: 1053

  END delete_template;
Line: 1201

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

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

    SAVEPOINT update_tmpt_lines2;
Line: 1225

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLPTMSB.pls call OKL_PROCESS_TMPT_SET_PVT.update_tmpt_lines ');
Line: 1228

    OKL_PROCESS_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: 1239

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLPTMSB.pls call OKL_PROCESS_TMPT_SET_PVT.update_tmpt_lines ');
Line: 1253

      ROLLBACK TO update_tmpt_lines2;
Line: 1259

      ROLLBACK TO update_tmpt_lines2;
Line: 1265

      ROLLBACK TO update_tmpt_lines2;
Line: 1266

      FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','update_tmpt_lines');
Line: 1273

  END update_tmpt_lines;
Line: 1275

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

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

    SAVEPOINT update_tmpt_lines2;
Line: 1297

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

      ROLLBACK TO update_tmpt_lines2;
Line: 1332

      ROLLBACK TO update_tmpt_lines2;
Line: 1338

      ROLLBACK TO update_tmpt_lines2;
Line: 1339

      FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','update_tmpt_lines');
Line: 1346

  END update_tmpt_lines;
Line: 1349

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

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

    SAVEPOINT delete_tmpt_lines2;
Line: 1373

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLPTMSB.pls call OKL_PROCESS_TMPT_SET_PVT.delete_tmpt_lines ');
Line: 1376

    OKL_PROCESS_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: 1385

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLPTMSB.pls call OKL_PROCESS_TMPT_SET_PVT.delete_tmpt_lines ');
Line: 1398

      ROLLBACK TO delete_tmpt_lines2;
Line: 1404

      ROLLBACK TO delete_tmpt_lines2;
Line: 1410

      ROLLBACK TO delete_tmpt_lines2;
Line: 1411

      FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','delete_tmpt_lines');
Line: 1418

  END delete_tmpt_lines;
Line: 1420

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

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

    SAVEPOINT delete_tmpt_lines2;
Line: 1441

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

      ROLLBACK TO delete_tmpt_lines2;
Line: 1473

      ROLLBACK TO delete_tmpt_lines2;
Line: 1479

      ROLLBACK TO delete_tmpt_lines2;
Line: 1480

      FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','delete_tmpt_lines');
Line: 1487

  END delete_tmpt_lines;