DBA Data[Home] [Help]

APPS.OKL_PROCESS_ACC_GROUP_PUB SQL Statements

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

Line: 328

  PROCEDURE update_acc_group(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_agcv_rec              IN  agcv_rec_type,
    p_agbv_tbl              IN  agbv_tbl_type,
    x_agcv_rec              OUT NOCOPY agcv_rec_type,
    x_agbv_tbl              OUT NOCOPY agbv_tbl_type) IS

    l_return_status         VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
Line: 339

    l_api_name              CONSTANT VARCHAR2(30)  := 'update_acc_ccid';
Line: 347

    SAVEPOINT update_acc_group;
Line: 369

    okl_process_acc_group_pvt.update_acc_group(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_agcv_rec      => l_agcv_rec
                        ,p_agbv_tbl      => l_agbv_tbl
                        ,x_agcv_rec      => x_agcv_rec
                        ,x_agbv_tbl      => x_agbv_tbl);
Line: 404

      ROLLBACK TO update_acc_group;
Line: 412

      ROLLBACK TO update_acc_group;
Line: 419

      FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_ACC_GROUP_PUB','update_acc_ccid');
Line: 427

  END update_acc_group;
Line: 433

  PROCEDURE update_acc_ccid(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_agcv_rec                   IN  agcv_rec_type
                           ,x_agcv_rec                   OUT NOCOPY agcv_rec_type) IS

    l_return_status               VARCHAR2(1)   := FND_API.G_RET_STS_SUCCESS;
Line: 442

    l_api_name                    CONSTANT VARCHAR2(30)  := 'update_acc_ccid';
Line: 447

    SAVEPOINT update_acc_ccid;
Line: 466

    okl_process_acc_group_pvt.update_acc_ccid(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_agcv_rec      => l_agcv_rec
                          ,x_agcv_rec      => x_agcv_rec
                          );
Line: 497

      ROLLBACK TO update_acc_ccid;
Line: 505

      ROLLBACK TO update_acc_ccid;
Line: 512

      FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_ACC_GROUP_PUB','update_acc_ccid');
Line: 520

  END update_acc_ccid;
Line: 524

  PROCEDURE update_acc_ccid(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_agcv_tbl                 IN  agcv_tbl_type
                           ,x_agcv_tbl                 OUT NOCOPY agcv_tbl_type) IS

    l_return_status          VARCHAR2(1)   := FND_API.G_RET_STS_SUCCESS;
Line: 533

    l_api_name               CONSTANT VARCHAR2(30)  := 'update_acc_ccid';
Line: 544

	SAVEPOINT update_acc_ccid;
Line: 566

        update_acc_ccid(

                           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_agcv_rec      => l_agcv_tbl(i)

                          ,x_agcv_rec      => x_agcv_tbl(i)

                          );
Line: 626

      ROLLBACK TO update_acc_ccid;
Line: 634

      ROLLBACK TO update_acc_ccid;
Line: 641

      FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_ACC_GROUP_PUB','update_acc_ccid');
Line: 651

  END update_acc_ccid;
Line: 657

  PROCEDURE delete_acc_ccid(

     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_agcv_rec              IN  agcv_rec_type) IS

    i                        NUMBER :=0;
Line: 675

    l_api_name               CONSTANT VARCHAR2(30)  := 'delete_acc_ccid';
Line: 683

    SAVEPOINT delete_acc_ccid;
Line: 704

    okl_process_acc_group_pvt.delete_acc_ccid(

                           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_agcv_rec      => l_agcv_rec

                          );
Line: 747

      ROLLBACK TO delete_acc_ccid;
Line: 755

      ROLLBACK TO delete_acc_ccid;
Line: 762

      FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_ACC_GROUP_PUB','delete_acc_ccid');
Line: 770

  END delete_acc_ccid;
Line: 774

  PROCEDURE delete_acc_ccid(

     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_agcv_tbl              IN  agcv_tbl_type) IS

    i                        NUMBER :=0;
Line: 792

    l_api_name               CONSTANT VARCHAR2(30)  := 'delete_acc_ccid';
Line: 803

	SAVEPOINT delete_acc_ccid;
Line: 825

        delete_acc_ccid(

                             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_agcv_rec      => l_agcv_tbl(i)

                            );
Line: 883

      ROLLBACK TO delete_acc_ccid;
Line: 891

      ROLLBACK TO delete_acc_ccid;
Line: 898

      FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_ACC_GROUP_PUB','delete_acc_ccid');
Line: 908

  END delete_acc_ccid;
Line: 1176

  PROCEDURE update_acc_bal(

     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_agbv_rec                       IN  agbv_rec_type

    ,x_agbv_rec                       OUT NOCOPY agbv_rec_type) IS

    l_return_status                   VARCHAR2(1)   := FND_API.G_RET_STS_SUCCESS;
Line: 1194

    l_api_name                        CONSTANT VARCHAR2(30)  := 'update_acc_bal';
Line: 1200

    SAVEPOINT update_acc_bal;
Line: 1221

    okl_process_acc_group_pvt.update_acc_bal(

                           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_agbv_rec      => l_agbv_rec

                          ,x_agbv_rec      => x_agbv_rec

                          );
Line: 1264

      ROLLBACK TO update_acc_bal;
Line: 1272

      ROLLBACK TO update_acc_bal;
Line: 1279

      FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_ACC_GROUP_PUB','update_acc_bal');
Line: 1287

  END update_acc_bal;
Line: 1291

  PROCEDURE update_acc_bal(

     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_agbv_tbl                       IN  agbv_tbl_type

    ,x_agbv_tbl                       OUT NOCOPY agbv_tbl_type) IS

    l_return_status                   VARCHAR2(1)   := FND_API.G_RET_STS_SUCCESS;
Line: 1309

    l_api_name                        CONSTANT VARCHAR2(30)  := 'update_acc_bal';
Line: 1320

    SAVEPOINT update_acc_bal;
Line: 1345

        update_acc_bal(

                           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_agbv_rec      => l_agbv_tbl(i)

                          ,x_agbv_rec      => x_agbv_tbl(i)

                          );
Line: 1404

      ROLLBACK TO update_acc_bal;
Line: 1412

      ROLLBACK TO update_acc_bal;
Line: 1419

      FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_ACC_GROUP_PUB','update_acc_bal');
Line: 1429

  END update_acc_bal;
Line: 1435

  PROCEDURE delete_acc_bal(

     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_agbv_rec                       IN  agbv_rec_type) IS

    i                                 NUMBER :=0;
Line: 1453

    l_api_name                        CONSTANT VARCHAR2(30)  := 'delete_acc_bal';
Line: 1459

    SAVEPOINT delete_acc_bal;
Line: 1482

    okl_process_acc_group_pvt.delete_acc_bal(

                           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_agbv_rec      => l_agbv_rec);
Line: 1521

      ROLLBACK TO delete_acc_bal;
Line: 1529

      ROLLBACK TO delete_acc_bal;
Line: 1536

      FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_ACC_GROUP_PUB','delete_acc_bal');
Line: 1544

  END delete_acc_bal;
Line: 1548

  PROCEDURE delete_acc_bal(

     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_agbv_tbl                       IN  agbv_tbl_type) IS



    i                                 NUMBER :=0;
Line: 1568

    l_api_name                        CONSTANT VARCHAR2(30)  := 'delete_acc_bal';
Line: 1577

    SAVEPOINT delete_acc_bal;
Line: 1602

        delete_acc_bal(

                                  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_agbv_rec      => l_agbv_tbl(i));
Line: 1657

      ROLLBACK TO delete_acc_bal;
Line: 1665

      ROLLBACK TO delete_acc_bal;
Line: 1672

      FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_ACC_GROUP_PUB','delete_acc_bal');
Line: 1680

  END delete_acc_bal;