DBA Data[Home] [Help]

APPS.OKL_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_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_ACC_GROUP_PUB','update_acc_ccid');
Line: 427

  END update_acc_group;
Line: 685

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

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

    SAVEPOINT update_acc_ccid;
Line: 718

    okl_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: 749

      ROLLBACK TO update_acc_ccid;
Line: 757

      ROLLBACK TO update_acc_ccid;
Line: 764

      FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','update_acc_ccid');
Line: 772

  END update_acc_ccid;
Line: 776

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

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

	SAVEPOINT update_acc_ccid;
Line: 818

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

      ROLLBACK TO update_acc_ccid;
Line: 886

      ROLLBACK TO update_acc_ccid;
Line: 893

      FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','update_acc_ccid');
Line: 903

  END update_acc_ccid;
Line: 909

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

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

    SAVEPOINT delete_acc_ccid;
Line: 956

    okl_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: 999

      ROLLBACK TO delete_acc_ccid;
Line: 1007

      ROLLBACK TO delete_acc_ccid;
Line: 1014

      FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','delete_acc_ccid');
Line: 1022

  END delete_acc_ccid;
Line: 1026

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

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

	SAVEPOINT delete_acc_ccid;
Line: 1077

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

      ROLLBACK TO delete_acc_ccid;
Line: 1143

      ROLLBACK TO delete_acc_ccid;
Line: 1150

      FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','delete_acc_ccid');
Line: 1160

  END delete_acc_ccid;
Line: 1854

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

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

    SAVEPOINT update_acc_bal;
Line: 1899

    okl_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: 1942

      ROLLBACK TO update_acc_bal;
Line: 1950

      ROLLBACK TO update_acc_bal;
Line: 1957

      FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','update_acc_bal');
Line: 1965

  END update_acc_bal;
Line: 1969

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

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

    SAVEPOINT update_acc_bal;
Line: 2023

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

      ROLLBACK TO update_acc_bal;
Line: 2090

      ROLLBACK TO update_acc_bal;
Line: 2097

      FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','update_acc_bal');
Line: 2107

  END update_acc_bal;
Line: 2113

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

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

    SAVEPOINT delete_acc_bal;
Line: 2160

    okl_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: 2199

      ROLLBACK TO delete_acc_bal;
Line: 2207

      ROLLBACK TO delete_acc_bal;
Line: 2214

      FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','delete_acc_bal');
Line: 2222

  END delete_acc_bal;
Line: 2226

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

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

    SAVEPOINT delete_acc_bal;
Line: 2280

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

      ROLLBACK TO delete_acc_bal;
Line: 2343

      ROLLBACK TO delete_acc_bal;
Line: 2350

      FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','delete_acc_bal');
Line: 2358

  END delete_acc_bal;