DBA Data[Home] [Help]

APPS.OKL_SYS_ACCT_OPTS_PUB SQL Statements

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

Line: 11

  PROCEDURE insert_sys_acct_opts(
                         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_saov_rec                     IN  saov_rec_type
                        ,x_saov_rec                     OUT NOCOPY saov_rec_type
                        ) IS
    l_saov_rec                        saov_rec_type;
Line: 22

    l_api_name                        CONSTANT VARCHAR2(30)  := 'insert_sys_acct_opts';
Line: 27

    SAVEPOINT insert_sys_acct_opts;
Line: 40

    okl_sao_pvt.insert_row(
                               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_saov_rec      => l_saov_rec
                              ,x_saov_rec      => x_saov_rec
                              );
Line: 64

      ROLLBACK TO insert_sys_acct_opts;
Line: 72

      ROLLBACK TO insert_sys_acct_opts;
Line: 79

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SYS_ACCT_OPTS_PUB','insert_sys_acct_opts');
Line: 86

  END insert_sys_acct_opts;
Line: 89

  PROCEDURE insert_sys_acct_opts(
                         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_saov_tbl                     IN  saov_tbl_type
                        ,x_saov_tbl                     OUT NOCOPY saov_tbl_type
                        ) IS
    l_saov_tbl                        saov_tbl_type;
Line: 101

    l_api_name                        CONSTANT VARCHAR2(30)  := 'insert_sys_acct_opts';
Line: 108

    SAVEPOINT insert_sys_acct_opts;
Line: 117

        insert_sys_acct_opts (
                           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_saov_rec      => p_saov_tbl(i)
                          ,x_saov_rec      => x_saov_tbl(i)
                          );
Line: 158

      ROLLBACK TO insert_sys_acct_opts;
Line: 166

      ROLLBACK TO insert_sys_acct_opts;
Line: 173

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SYS_ACCT_OPTS_PUB','insert_sys_acct_opts');
Line: 180

  END insert_sys_acct_opts;
Line: 320

  PROCEDURE update_sys_acct_opts(
                         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_saov_rec                     IN  saov_rec_type
                        ,x_saov_rec                     OUT NOCOPY saov_rec_type
                        ) IS
    l_saov_rec                        saov_rec_type;
Line: 332

    l_api_name                        CONSTANT VARCHAR2(30)  := 'update_sys_acct_opts';
Line: 336

    SAVEPOINT update_sys_acct_opts;
Line: 341

    okl_sao_pvt.update_row(
                               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_saov_rec      => l_saov_rec
                              ,x_saov_rec      => x_saov_rec
                              );
Line: 364

      ROLLBACK TO update_sys_acct_opts;
Line: 372

      ROLLBACK TO update_sys_acct_opts;
Line: 379

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SYS_ACCT_OPTS_PUB','update_sys_acct_opts');
Line: 386

  END update_sys_acct_opts;
Line: 389

  PROCEDURE update_sys_acct_opts(
                         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_saov_tbl                     IN  saov_tbl_type
                        ,x_saov_tbl                     OUT NOCOPY saov_tbl_type
                        ) IS
    l_saov_tbl                        saov_tbl_type;
Line: 401

    l_api_name                        CONSTANT VARCHAR2(30)  := 'update_sys_acct_opts';
Line: 408

    SAVEPOINT update_sys_acct_opts;
Line: 417

        update_sys_acct_opts (
                           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_saov_rec      => p_saov_tbl(i)
                          ,x_saov_rec      => x_saov_tbl(i)
                          );
Line: 458

      ROLLBACK TO update_sys_acct_opts;
Line: 466

      ROLLBACK TO update_sys_acct_opts;
Line: 473

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SYS_ACCT_OPTS_PUB','update_sys_acct_opts');
Line: 480

  END update_sys_acct_opts;
Line: 482

  PROCEDURE delete_sys_acct_opts(
                         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_saov_rec                     IN  saov_rec_type
                        ) IS
    l_saov_rec                        saov_rec_type;
Line: 493

    l_api_name                        CONSTANT VARCHAR2(30)  := 'delete_sys_acct_opts';
Line: 497

    SAVEPOINT delete_sys_acct_opts;
Line: 502

    okl_sao_pvt.delete_row(
                               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_saov_rec      => l_saov_rec
                              );
Line: 521

      ROLLBACK TO delete_sys_acct_opts;
Line: 529

      ROLLBACK TO delete_sys_acct_opts;
Line: 536

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SYS_ACCT_OPTS_PUB','delete_sys_acct_opts');
Line: 543

  END delete_sys_acct_opts;
Line: 546

  PROCEDURE delete_sys_acct_opts(
                         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_saov_tbl                     IN  saov_tbl_type
                        ) IS
    l_saov_tbl                        saov_tbl_type;
Line: 557

    l_api_name                        CONSTANT VARCHAR2(30)  := 'delete_sys_acct_opts';
Line: 564

    SAVEPOINT delete_sys_acct_opts;
Line: 573

        delete_sys_acct_opts (
                           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_saov_rec      => p_saov_tbl(i)
                          );
Line: 610

      ROLLBACK TO delete_sys_acct_opts;
Line: 618

      ROLLBACK TO delete_sys_acct_opts;
Line: 625

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SYS_ACCT_OPTS_PUB','delete_sys_acct_opts');
Line: 632

  END delete_sys_acct_opts;