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_PROCESS_ACC_GROUP_PVT SQL Statements

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

Line: 116


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


  BEGIN


    okl_acc_group_pub.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      => p_agcv_rec
                                      ,p_agbv_tbl      => p_agbv_tbl
                                      ,x_agcv_rec      => x_agcv_rec
                                      ,x_agbv_tbl      => x_agbv_tbl);

Line: 141


END update_acc_group;

Line: 145


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


BEGIN

   -- call complex entity API

    okl_acc_group_pub.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: 167


END update_acc_ccid;

Line: 172


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


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

Line: 195


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


  END update_acc_ccid;

Line: 225


  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


  BEGIN


    okl_acc_group_pub.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_rec);

Line: 245


 END delete_acc_ccid;

Line: 249


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


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

Line: 270


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


  END delete_acc_ccid;

Line: 378


  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

  BEGIN

    okl_acc_group_pub.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_rec      => p_agbv_rec
                                    ,x_agbv_rec      => x_agbv_rec);

Line: 396


  END update_acc_bal;

Line: 401


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


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

Line: 423


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


  END update_acc_bal;

Line: 455


  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


  BEGIN


    okl_acc_group_pub.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_rec);

Line: 474


  END delete_acc_bal;

Line: 478


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


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

Line: 501


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


  END delete_acc_bal;