DBA Data[Home] [Help]

APPS.OKL_TRNS_ACC_DSTRS_PUB SQL Statements

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

Line: 191

  PROCEDURE insert_trns_acc_dstrs(
                         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_tabv_rec                     IN  tabv_rec_type
                        ,x_tabv_rec                     OUT NOCOPY tabv_rec_type
                        ) IS
    l_tabv_rec                        tabv_rec_type;
Line: 202

    l_api_name                        CONSTANT VARCHAR2(30)  := 'insert_trns_acc_dstrs';
Line: 209

    SELECT NAME
    FROM okl_ae_templates
    WHERE id = template_id;
Line: 214

    SAVEPOINT insert_trns_acc_dstrs;
Line: 241

    okl_tab_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_tabv_rec      => l_tabv_rec
                              ,x_tabv_rec      => x_tabv_rec
                              );
Line: 265

      ROLLBACK TO insert_trns_acc_dstrs;
Line: 273

      ROLLBACK TO insert_trns_acc_dstrs;
Line: 280

      FND_MSG_PUB.ADD_EXC_MSG('OKL_TRNS_ACC_DSTRS_PUB','insert_trns_acc_dstrs');
Line: 287

  END insert_trns_acc_dstrs;
Line: 290

  PROCEDURE insert_trns_acc_dstrs(
                         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_tabv_tbl                     IN  tabv_tbl_type
                        ,x_tabv_tbl                     OUT NOCOPY tabv_tbl_type
                        ) IS
    l_tabv_tbl                        tabv_tbl_type;
Line: 302

    l_api_name                        CONSTANT VARCHAR2(30)  := 'insert_trns_acc_dstrs';
Line: 309

    SAVEPOINT insert_trns_acc_dstrs;
Line: 318

        insert_trns_acc_dstrs (
                           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_tabv_rec      => p_tabv_tbl(i)
                          ,x_tabv_rec      => x_tabv_tbl(i)
                          );
Line: 359

      ROLLBACK TO insert_trns_acc_dstrs;
Line: 367

      ROLLBACK TO insert_trns_acc_dstrs;
Line: 374

      FND_MSG_PUB.ADD_EXC_MSG('OKL_TRNS_ACC_DSTRS_PUB','insert_trns_acc_dstrs');
Line: 381

  END insert_trns_acc_dstrs;
Line: 521

  PROCEDURE update_trns_acc_dstrs(
                         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_tabv_rec                     IN  tabv_rec_type
                        ,x_tabv_rec                     OUT NOCOPY tabv_rec_type
                        ) IS
    l_tabv_rec                        tabv_rec_type;
Line: 533

    l_api_name                        CONSTANT VARCHAR2(30)  := 'update_trns_acc_dstrs';
Line: 537

    SAVEPOINT update_trns_acc_dstrs;
Line: 542

    okl_tab_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_tabv_rec      => l_tabv_rec
                              ,x_tabv_rec      => x_tabv_rec
                              );
Line: 565

      ROLLBACK TO update_trns_acc_dstrs;
Line: 573

      ROLLBACK TO update_trns_acc_dstrs;
Line: 580

      FND_MSG_PUB.ADD_EXC_MSG('OKL_TRNS_ACC_DSTRS_PUB','update_trns_acc_dstrs');
Line: 587

  END update_trns_acc_dstrs;
Line: 590

  PROCEDURE update_trns_acc_dstrs(
                         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_tabv_tbl                     IN  tabv_tbl_type
                        ,x_tabv_tbl                     OUT NOCOPY tabv_tbl_type
                        ) IS
    l_tabv_tbl                        tabv_tbl_type;
Line: 602

    l_api_name                        CONSTANT VARCHAR2(30)  := 'update_trns_acc_dstrs';
Line: 609

    SAVEPOINT update_trns_acc_dstrs;
Line: 618

        update_trns_acc_dstrs (
                           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_tabv_rec      => p_tabv_tbl(i)
                          ,x_tabv_rec      => x_tabv_tbl(i)
                          );
Line: 659

      ROLLBACK TO update_trns_acc_dstrs;
Line: 667

      ROLLBACK TO update_trns_acc_dstrs;
Line: 674

      FND_MSG_PUB.ADD_EXC_MSG('OKL_TRNS_ACC_DSTRS_PUB','update_trns_acc_dstrs');
Line: 681

  END update_trns_acc_dstrs;
Line: 683

  PROCEDURE delete_trns_acc_dstrs(
                         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_tabv_rec                     IN  tabv_rec_type
                        ) IS
    l_tabv_rec                        tabv_rec_type;
Line: 694

    l_api_name                        CONSTANT VARCHAR2(30)  := 'delete_trns_acc_dstrs';
Line: 704

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

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

    SAVEPOINT delete_trns_acc_dstrs;
Line: 740

    okl_tab_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_tabv_rec      => l_tabv_rec
                              );
Line: 759

      ROLLBACK TO delete_trns_acc_dstrs;
Line: 767

      ROLLBACK TO delete_trns_acc_dstrs;
Line: 774

      FND_MSG_PUB.ADD_EXC_MSG('OKL_TRNS_ACC_DSTRS_PUB','delete_trns_acc_dstrs');
Line: 781

  END delete_trns_acc_dstrs;
Line: 784

  PROCEDURE delete_trns_acc_dstrs(
                         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_tabv_tbl                     IN  tabv_tbl_type
                        ) IS
    l_tabv_tbl                        tabv_tbl_type;
Line: 795

    l_api_name                        CONSTANT VARCHAR2(30)  := 'delete_trns_acc_dstrs';
Line: 802

    SAVEPOINT delete_trns_acc_dstrs;
Line: 811

        delete_trns_acc_dstrs (
                           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_tabv_rec      => p_tabv_tbl(i)
                          );
Line: 848

      ROLLBACK TO delete_trns_acc_dstrs;
Line: 856

      ROLLBACK TO delete_trns_acc_dstrs;
Line: 863

      FND_MSG_PUB.ADD_EXC_MSG('OKL_TRNS_ACC_DSTRS_PUB','delete_trns_acc_dstrs');
Line: 870

  END delete_trns_acc_dstrs;