DBA Data[Home] [Help]

APPS.OKL_TRX_CONTRACTS_PVT SQL Statements

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

Line: 93

    SELECT name
    FROM okl_products
    WHERE id = pdt_id;
Line: 98

    SELECT quality_val, quality_name
    FROM okl_prod_qlty_val_uv
    WHERE pdt_id = p_id
    AND QUALITY_NAME IN ('LEASE', 'INVESTOR');
Line: 104

    SELECT quality_val
    FROM okl_prod_qlty_val_uv
    WHERE pdt_id = p_id
    AND QUALITY_NAME = 'TAXOWNER';
Line: 110

    SELECT name,
           short_name
    FROM gl_ledgers
    WHERE ledger_id = set_of_books_id;
Line: 116

    SELECT pdt_id
    FROM okl_k_headers
    WHERE id = p_khr_id;
Line: 220

    okl_tcn_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_tcnv_rec      => l_tcnv_rec
                          ,x_tcnv_rec      => x_tcnv_rec
                          );
Line: 313

  PROCEDURE update_trx_contracts(
    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_tcnv_rec              IN  tcnv_rec_type,
    p_tclv_tbl              IN  tclv_tbl_type,
    x_tcnv_rec              OUT NOCOPY tcnv_rec_type,
    x_tclv_tbl              OUT NOCOPY tclv_tbl_type) IS
    l_return_status         VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
Line: 326

    update_trx_contracts(
                         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_tcnv_rec      => p_tcnv_rec
                        ,x_tcnv_rec      => x_tcnv_rec
                        );
Line: 339

    update_trx_cntrct_lines(
                              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_tclv_tbl      => p_tclv_tbl
                             ,x_tclv_tbl      => x_tclv_tbl
                             );
Line: 365

  END update_trx_contracts;
Line: 522

  PROCEDURE update_trx_contracts(
     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_tcnv_rec                   IN  tcnv_rec_type
    ,x_tcnv_rec                   OUT NOCOPY tcnv_rec_type) IS
    l_return_status               VARCHAR2(1)   := OKC_API.G_RET_STS_SUCCESS;
Line: 539

    okl_tcn_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_tcnv_rec      => l_tcnv_rec -- Bug#5707866
                          ,x_tcnv_rec      => x_tcnv_rec
                          );
Line: 566

  END update_trx_contracts;
Line: 568

  PROCEDURE update_trx_contracts(
     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_tcnv_tbl                   IN  tcnv_tbl_type
    ,x_tcnv_tbl                   OUT NOCOPY tcnv_tbl_type) IS
    l_return_status               VARCHAR2(1)   := OKC_API.G_RET_STS_SUCCESS;
Line: 587

        update_trx_contracts(
          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_tcnv_rec                     => p_tcnv_tbl(i),
          x_tcnv_rec                     => x_tcnv_tbl(i));
Line: 623

  END update_trx_contracts;
Line: 626

  PROCEDURE delete_trx_contracts(
     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_tcnv_rec              IN  tcnv_rec_type) IS
    i                        NUMBER :=0;
Line: 638

      SELECT tcl.id
        FROM OKL_TXL_CNTRCT_LNS tcl
       WHERE tcl.tcn_id = p_tcnv_rec.id;
Line: 648

    delete_trx_cntrct_lines( 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_tclv_tbl      => l_tclv_tbl);
Line: 657

      okl_tcn_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_tcnv_rec      => p_tcnv_rec);
Line: 679

  END delete_trx_contracts;
Line: 682

  PROCEDURE delete_trx_contracts(
     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_tcnv_tbl              IN  tcnv_tbl_type) IS
    i                        NUMBER :=0;
Line: 699

        delete_trx_contracts(
                             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_tcnv_rec      => p_tcnv_tbl(i)
                            );
Line: 733

  END delete_trx_contracts;
Line: 839

    SELECT
     code,
     stream_type_purpose
    FROM
     OKL_STRM_TYPE_B
    WHERE
     id = sty_id;
Line: 869

    okl_tcl_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_tclv_rec      => l_tclv_rec
                          ,x_tclv_rec      => x_tclv_rec
                          );
Line: 1048

  PROCEDURE update_trx_cntrct_lines(
     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_tclv_rec                       IN  tclv_rec_type
    ,x_tclv_rec                       OUT NOCOPY tclv_rec_type) IS
    l_return_status                   VARCHAR2(1)   := OKC_API.G_RET_STS_SUCCESS;
Line: 1059

    okl_tcl_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_tclv_rec      => p_tclv_rec
                          ,x_tclv_rec      => x_tclv_rec
                          );
Line: 1086

  END update_trx_cntrct_lines;
Line: 1088

  PROCEDURE update_trx_cntrct_lines(
     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_tclv_tbl                       IN  tclv_tbl_type
    ,x_tclv_tbl                       OUT NOCOPY tclv_tbl_type) IS

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

        update_trx_cntrct_lines(
          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_tclv_rec                     => p_tclv_tbl(i),
          x_tclv_rec                     => x_tclv_tbl(i));
Line: 1144

  END update_trx_cntrct_lines;
Line: 1147

  PROCEDURE delete_trx_cntrct_lines(
     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_tclv_rec                       IN  tclv_rec_type) IS
    i                                 NUMBER :=0;
Line: 1157

    okl_tcl_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_tclv_rec      => p_tclv_rec);
Line: 1182

  END delete_trx_cntrct_lines;
Line: 1184

  PROCEDURE delete_trx_cntrct_lines(
     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_tclv_tbl                       IN  tclv_tbl_type) IS

    i                                 NUMBER :=0;
Line: 1202

        delete_trx_cntrct_lines(
                                  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_tclv_rec      => p_tclv_tbl(i));
Line: 1235

  END delete_trx_cntrct_lines;