DBA Data[Home] [Help]

APPS.OKL_TRX_EXTENSION_PVT SQL Statements

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

Line: 105

  okl_teh_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_tehv_rec      => p_tehv_rec
                          ,x_tehv_rec      => x_tehv_rec
                          );
Line: 220

  PROCEDURE update_trx_extension(
    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_tehv_rec              IN  tehv_rec_type,
    p_telv_tbl              IN  telv_tbl_type,
    x_tehv_rec              OUT NOCOPY tehv_rec_type,
    x_telv_tbl              OUT NOCOPY telv_tbl_type) IS
    l_return_status         VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
Line: 233

    update_trx_extension(
                         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_tehv_rec      => p_tehv_rec
                        ,x_tehv_rec      => x_tehv_rec
                        );
Line: 246

    update_txl_extension(
                              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_telv_tbl      => p_telv_tbl
                             ,x_telv_tbl      => x_telv_tbl
                             );
Line: 272

  END update_trx_extension;
Line: 474

  PROCEDURE update_trx_extension(
     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_tehv_rec                   IN  tehv_rec_type
    ,x_tehv_rec                   OUT NOCOPY tehv_rec_type) IS
    l_return_status               VARCHAR2(1)   := OKC_API.G_RET_STS_SUCCESS;
Line: 484

    okl_teh_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_tehv_rec      => p_tehv_rec
                          ,x_tehv_rec      => x_tehv_rec
                          );
Line: 511

  END update_trx_extension;
Line: 524

  PROCEDURE update_trx_extension(
     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_tehv_tbl                   IN  tehv_tbl_type
    ,x_tehv_tbl                   OUT NOCOPY tehv_tbl_type) IS
    l_return_status               VARCHAR2(1)   := OKC_API.G_RET_STS_SUCCESS;
Line: 543

        update_trx_extension(
          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_tehv_rec                     => p_tehv_tbl(i),
          x_tehv_rec                     => x_tehv_tbl(i));
Line: 579

  END update_trx_extension;
Line: 592

  PROCEDURE delete_trx_extension(
     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_tehv_rec              IN  tehv_rec_type) IS
    i                        NUMBER :=0;
Line: 604

      SELECT tel.line_extension_id
        FROM OKL_TXL_EXTENSION_B tel
       WHERE tel.teh_id = p_tehv_rec.header_extension_id;
Line: 614

    delete_txl_extension(     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_telv_tbl      => l_telv_tbl);
Line: 623

      okl_teh_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_tehv_rec      => p_tehv_rec);
Line: 645

  END delete_trx_extension;
Line: 659

  PROCEDURE delete_trx_extension(
     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_tehv_tbl              IN  tehv_tbl_type) IS
    i                        NUMBER :=0;
Line: 676

        delete_trx_extension(
                             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_tehv_rec      => p_tehv_tbl(i)
                            );
Line: 710

  END delete_trx_extension;
Line: 847

    okl_tel_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_telv_rec      => p_telv_rec
                          ,x_telv_rec      => x_telv_rec
                          );
Line: 1072

  PROCEDURE update_txl_extension(
     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_telv_rec                       IN  telv_rec_type
    ,x_telv_rec                       OUT NOCOPY telv_rec_type) IS
    l_return_status                   VARCHAR2(1)   := OKC_API.G_RET_STS_SUCCESS;
Line: 1083

    okl_tel_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_telv_rec      => p_telv_rec
                          ,x_telv_rec      => x_telv_rec
                          );
Line: 1110

  END update_txl_extension;
Line: 1124

  PROCEDURE update_txl_extension(
     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_telv_tbl                       IN  telv_tbl_type
    ,x_telv_tbl                       OUT NOCOPY telv_tbl_type) IS

    l_return_status                   VARCHAR2(1)   := OKC_API.G_RET_STS_SUCCESS;
Line: 1144

        update_txl_extension(
          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_telv_rec                     => p_telv_tbl(i),
          x_telv_rec                     => x_telv_tbl(i));
Line: 1180

  END update_txl_extension;
Line: 1193

  PROCEDURE delete_txl_extension(
     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_telv_rec                       IN  telv_rec_type) IS
    i                                 NUMBER :=0;
Line: 1203

    okl_tel_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_telv_rec      => p_telv_rec);
Line: 1228

  END delete_txl_extension;
Line: 1241

  PROCEDURE delete_txl_extension(
     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_telv_tbl                       IN  telv_tbl_type) IS

    i                                 NUMBER :=0;
Line: 1259

        delete_txl_extension(
                                  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_telv_rec      => p_telv_tbl(i));
Line: 1292

  END delete_txl_extension;
Line: 1434

  okl_teh_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_teh_rec       => p_teh_rec
                          ,p_tehl_tbl      => p_tehl_tbl
                          ,x_teh_rec       => x_teh_rec
                          ,x_tehl_tbl      => x_tehl_tbl
                          );
Line: 1495

    okl_tel_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_tel_rec       => p_tel_rec
                          ,p_tell_tbl      => p_tell_tbl
                          ,x_tel_rec       => x_tel_rec
                          ,x_tell_tbl      => x_tell_tbl
                          );