DBA Data[Home] [Help]

APPS.OKL_ACCT_SOURCES_PVT SQL Statements

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

Line: 5

  PROCEDURE insert_acct_sources(
                         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_asev_rec                     IN  asev_rec_type
                        ,x_asev_rec                     OUT NOCOPY asev_rec_type
                        ) IS
    l_asev_rec                        asev_rec_type;
Line: 16

    l_api_name                        CONSTANT VARCHAR2(30)  := 'insert_acct_sources';
Line: 21

    SAVEPOINT insert_acct_sources;
Line: 24

    Okl_Ase_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_asev_rec      => l_asev_rec
                              ,x_asev_rec      => x_asev_rec
                              );
Line: 46

      ROLLBACK TO insert_acct_sources;
Line: 54

      ROLLBACK TO insert_acct_sources;
Line: 61

      Fnd_Msg_Pub.ADD_EXC_MSG('OKL_acct_sources_Pvt','insert_acct_sources');
Line: 68

  END insert_acct_sources;
Line: 71

  PROCEDURE insert_acct_sources(
                         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_asev_tbl                     IN  asev_tbl_type
                        ,x_asev_tbl                     OUT NOCOPY asev_tbl_type
                        ) IS
    l_asev_tbl                        asev_tbl_type;
Line: 83

    l_api_name                        CONSTANT VARCHAR2(30)  := 'insert_acct_sources';
Line: 90

    SAVEPOINT insert_acct_sources;
Line: 101

          insert_acct_sources (
                           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_asev_rec      => p_asev_tbl(i)
                          ,x_asev_rec      => x_asev_tbl(i)
                          );
Line: 144

      ROLLBACK TO insert_acct_sources;
Line: 152

      ROLLBACK TO insert_acct_sources;
Line: 159

      Fnd_Msg_Pub.ADD_EXC_MSG('OKL_acct_sources_Pvt','insert_acct_sources');
Line: 166

  END insert_acct_sources;
Line: 172

     PROCEDURE insert_acct_sources_bulk(
                            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_asev_tbl                     IN  asev_tbl_type
                           ,x_asev_tbl                     OUT NOCOPY asev_tbl_type
                           ) IS
       l_asev_tbl                        asev_tbl_type;
Line: 184

       l_api_name                        CONSTANT VARCHAR2(30)  := 'insert_acct_sources_bulk';
Line: 191

       SAVEPOINT insert_acct_sources;
Line: 198

           Okl_Ase_Pvt.insert_row_bulk (
                              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_asev_tbl      => p_asev_tbl
                             ,x_asev_tbl      => x_asev_tbl
                             );
Line: 218

         ROLLBACK TO insert_acct_sources;
Line: 226

         ROLLBACK TO insert_acct_sources;
Line: 233

         Fnd_Msg_Pub.ADD_EXC_MSG('OKL_acct_sources_Pvt','insert_acct_sources_bulk');
Line: 240

     END insert_acct_sources_bulk;
Line: 381

  PROCEDURE update_acct_sources(
                         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_asev_rec                     IN  asev_rec_type
                        ,x_asev_rec                     OUT NOCOPY asev_rec_type
                        ) IS
    l_asev_rec                        asev_rec_type;
Line: 393

    l_api_name                        CONSTANT VARCHAR2(30)  := 'update_acct_sources';
Line: 397

    SAVEPOINT update_acct_sources;
Line: 404

    Okl_Ase_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_asev_rec      => l_asev_rec
                              ,x_asev_rec      => x_asev_rec
                              );
Line: 429

      ROLLBACK TO update_acct_sources;
Line: 437

      ROLLBACK TO update_acct_sources;
Line: 444

      Fnd_Msg_Pub.ADD_EXC_MSG('OKL_acct_sources_Pvt','update_acct_sources');
Line: 451

  END update_acct_sources;
Line: 454

  PROCEDURE update_acct_sources(
                         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_asev_tbl                     IN  asev_tbl_type
                        ,x_asev_tbl                     OUT NOCOPY asev_tbl_type
                        ) IS
    l_asev_tbl                        asev_tbl_type;
Line: 466

    l_api_name                        CONSTANT VARCHAR2(30)  := 'update_acct_sources';
Line: 473

    SAVEPOINT update_acct_sources;
Line: 484

        update_acct_sources (
                           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_asev_rec      => p_asev_tbl(i)
                          ,x_asev_rec      => x_asev_tbl(i)
                          );
Line: 527

      ROLLBACK TO update_acct_sources;
Line: 535

      ROLLBACK TO update_acct_sources;
Line: 542

      Fnd_Msg_Pub.ADD_EXC_MSG('OKL_acct_sources_Pvt','update_acct_sources');
Line: 549

  END update_acct_sources;
Line: 551

  PROCEDURE delete_acct_sources(
                         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_asev_rec                     IN  asev_rec_type
                        ) IS
    l_asev_rec                        asev_rec_type;
Line: 562

    l_api_name                        CONSTANT VARCHAR2(30)  := 'delete_acct_sources';
Line: 572

  SELECT tcn_id
  FROM OKL_TXL_CNTRCT_LNS
  WHERE ID = v_source_id;
Line: 577

  SELECT tsu_code
  FROM OKL_TRX_CONTRACTS
  WHERE ID = v_tcn_id;
Line: 583

    SAVEPOINT delete_acct_sources;
Line: 610

    Okl_Ase_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_asev_rec      => l_asev_rec
                              );
Line: 631

      ROLLBACK TO delete_acct_sources;
Line: 639

      ROLLBACK TO delete_acct_sources;
Line: 646

      Fnd_Msg_Pub.ADD_EXC_MSG('OKL_acct_sources_Pvt','delete_acct_sources');
Line: 653

  END delete_acct_sources;
Line: 656

  PROCEDURE delete_acct_sources(
                         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_asev_tbl                     IN  asev_tbl_type
                        ) IS
    l_asev_tbl                        asev_tbl_type;
Line: 667

    l_api_name                        CONSTANT VARCHAR2(30)  := 'delete_acct_sources';
Line: 674

    SAVEPOINT delete_acct_sources;
Line: 685

        delete_acct_sources (
                           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_asev_rec      => p_asev_tbl(i)
                          );
Line: 724

      ROLLBACK TO delete_acct_sources;
Line: 732

      ROLLBACK TO delete_acct_sources;
Line: 739

      Fnd_Msg_Pub.ADD_EXC_MSG('OKL_acct_sources_Pvt','delete_acct_sources');
Line: 746

  END delete_acct_sources;
Line: 909

  PROCEDURE update_acct_src_custom_status(
    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_asev_rec                     IN  asev_rec_type,
    x_asev_rec                     OUT NOCOPY asev_rec_type) IS

    l_asev_rec                        asev_rec_type;
Line: 921

    l_api_name                        CONSTANT VARCHAR2(30)  := 'update_acct_src_custom_status';
Line: 925

    SAVEPOINT update_acct_src_custom_status;
Line: 932

    Okl_Ase_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_asev_rec      => l_asev_rec
                              ,x_asev_rec      => x_asev_rec
                              );
Line: 957

      ROLLBACK TO update_acct_src_custom_status;
Line: 965

      ROLLBACK TO update_acct_src_custom_status;
Line: 972

      Fnd_Msg_Pub.ADD_EXC_MSG('OKL_acct_sources_Pvt','update_acct_sources');
Line: 980

  END   update_acct_src_custom_status;