eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_ACC_GROUP_PVT SQL Statements

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

Line: 81


    okl_agc_pvt.insert_row(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      => p_agcv_rec
                          ,x_agcv_rec      => x_agcv_rec
                          );

Line: 173


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) := OKC_API.G_RET_STS_SUCCESS;

Line: 189


    update_acc_ccid(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      => p_agcv_rec
                   ,x_agcv_rec      => x_agcv_rec);

Line: 200


        update_acc_bal(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_agbv_tbl      => p_agbv_tbl
                      ,x_agbv_tbl      => x_agbv_tbl);

Line: 223


  END update_acc_group;

Line: 381


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)   := OKC_API.G_RET_STS_SUCCESS;

Line: 393


    okl_agc_pvt.update_row(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      => p_agcv_rec
                          ,x_agcv_rec      => x_agcv_rec);

Line: 419


  END update_acc_ccid;

Line: 422


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)   := OKC_API.G_RET_STS_SUCCESS;

Line: 441


        update_acc_ccid(p_api_version                  => p_api_version,
                        p_init_msg_list                => Okc_Api.G_FALSE,
                        x_return_status                => x_return_status,
                        x_msg_count                    => x_msg_count,
                        x_msg_data                     => x_msg_data,
                        p_agcv_rec                     => p_agcv_tbl(i),
                        x_agcv_rec                     => x_agcv_tbl(i));

Line: 475


  END update_acc_ccid;

Line: 478


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


 SELECT agb.id
 FROM OKL_ACC_GROUP_BAL agb
 WHERE agb.acc_group_id = p_agcv_rec.id;

Line: 502


    delete_acc_bal( 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_agbv_tbl      => l_agbv_tbl);

Line: 511


      okl_agc_pvt.delete_row(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      => p_agcv_rec);

Line: 532


  END delete_acc_ccid;

Line: 535


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


        delete_acc_ccid( 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      => p_agcv_tbl(i));

Line: 585


END delete_acc_ccid;

Line: 695


    okl_agb_pvt.insert_row(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_agbv_rec      => p_agbv_rec
                          ,x_agbv_rec      => x_agbv_rec);

Line: 873


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)   := OKC_API.G_RET_STS_SUCCESS;

Line: 884


    okl_agb_pvt.update_row(
                           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_agbv_rec      => p_agbv_rec
                          ,x_agbv_rec      => x_agbv_rec
                          );

Line: 911


  END update_acc_bal;

Line: 913


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)   := OKC_API.G_RET_STS_SUCCESS;

Line: 933


        update_acc_bal(
          p_api_version                  => p_api_version,
          p_init_msg_list                => OKC_API.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_agbv_rec                     => p_agbv_tbl(i),
          x_agbv_rec                     => x_agbv_tbl(i));

Line: 969


  END update_acc_bal;

Line: 971


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


    okl_agb_pvt.delete_row(
                           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_agbv_rec      => p_agbv_rec);

Line: 1006


  END delete_acc_bal;

Line: 1008


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


        delete_acc_bal(
                                  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_agbv_rec      => p_agbv_tbl(i));

Line: 1058


  END delete_acc_bal;