DBA Data[Home] [Help]

APPS.OKL_AR_EXTENSION_PVT SQL Statements

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

Line: 101

    okl_rxh_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_rxhv_rec      => p_rxhv_rec
      ,x_rxhv_rec      => x_rxhv_rec);
Line: 214

  PROCEDURE update_rxh_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_rxhv_rec              IN  rxhv_rec_type,
    p_rxlv_tbl              IN  rxlv_tbl_type,
    x_rxhv_rec              OUT NOCOPY rxhv_rec_type,
    x_rxlv_tbl              OUT NOCOPY rxlv_tbl_type) IS
    l_return_status         VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
Line: 227

    update_rxh_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_rxhv_rec      => p_rxhv_rec
      ,x_rxhv_rec      => x_rxhv_rec);
Line: 239

      update_rxl_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_rxlv_tbl      => p_rxlv_tbl
        ,x_rxlv_tbl      => x_rxlv_tbl);
Line: 261

  END update_rxh_extension;
Line: 457

  PROCEDURE update_rxh_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_rxhv_rec                   IN  rxhv_rec_type
    ,x_rxhv_rec                   OUT NOCOPY rxhv_rec_type) IS
    l_return_status               VARCHAR2(1)   := OKC_API.G_RET_STS_SUCCESS;
Line: 467

    okl_rxh_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_rxhv_rec      => p_rxhv_rec
      ,x_rxhv_rec      => x_rxhv_rec);
Line: 495

  END update_rxh_extension;
Line: 508

  PROCEDURE update_rxh_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_rxhv_tbl                   IN  rxhv_tbl_type
    ,x_rxhv_tbl                   OUT NOCOPY rxhv_tbl_type) IS
    l_return_status               VARCHAR2(1)   := OKC_API.G_RET_STS_SUCCESS;
Line: 525

        update_rxh_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_rxhv_rec                     => p_rxhv_tbl(i),
          x_rxhv_rec                     => x_rxhv_tbl(i));
Line: 559

  END update_rxh_extension;
Line: 572

  PROCEDURE delete_rxh_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_rxhv_rec              IN  rxhv_rec_type) IS
    i                        NUMBER :=0;
Line: 584

      SELECT rxl.line_extension_id
        FROM OKL_EXT_ar_LINE_SOURCES_B rxl
       WHERE rxl.header_extension_id = p_rxhv_rec.header_extension_id;
Line: 593

    delete_rxl_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_rxlv_tbl      => l_rxlv_tbl);
Line: 602

      okl_rxh_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_rxhv_rec      => p_rxhv_rec);
Line: 624

  END delete_rxh_extension;
Line: 637

  PROCEDURE delete_rxh_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_rxhv_tbl              IN  rxhv_tbl_type) IS
    i                        NUMBER :=0;
Line: 655

        delete_rxh_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_rxhv_rec      => p_rxhv_tbl(i));
Line: 688

  END delete_rxh_extension;
Line: 829

    okl_rxl_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_rxlv_rec      => p_rxlv_rec
      ,x_rxlv_rec      => x_rxlv_rec);
Line: 1057

  PROCEDURE update_rxl_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_rxlv_rec                       IN  rxlv_rec_type
    ,x_rxlv_rec                       OUT NOCOPY rxlv_rec_type)
  IS
    l_return_status                   VARCHAR2(1)   := OKC_API.G_RET_STS_SUCCESS;
Line: 1068

    okl_rxl_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_rxlv_rec      => p_rxlv_rec
                          ,x_rxlv_rec      => x_rxlv_rec
                          );
Line: 1098

  END update_rxl_extension;
Line: 1111

  PROCEDURE update_rxl_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_rxlv_tbl                       IN  rxlv_tbl_type
    ,x_rxlv_tbl                       OUT NOCOPY rxlv_tbl_type)
  IS
    l_return_status                   VARCHAR2(1)   := OKC_API.G_RET_STS_SUCCESS;
Line: 1130

        update_rxl_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_rxlv_rec                     => p_rxlv_tbl(i),
          x_rxlv_rec                     => x_rxlv_tbl(i));
Line: 1165

  END update_rxl_extension;
Line: 1178

  PROCEDURE delete_rxl_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_rxlv_rec                       IN  rxlv_rec_type) IS
    i                                 NUMBER :=0;
Line: 1188

    okl_rxl_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_rxlv_rec      => p_rxlv_rec);
Line: 1218

  END delete_rxl_extension;
Line: 1231

  PROCEDURE delete_rxl_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_rxlv_tbl                       IN  rxlv_tbl_type)
  IS
    i                                 NUMBER :=0;
Line: 1249

        delete_rxl_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_rxlv_rec      => p_rxlv_tbl(i));
Line: 1282

  END delete_rxl_extension;
Line: 1427

  okl_rxh_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_rxh_rec       => p_rxh_rec
                          ,p_rxhl_tbl      => p_rxhl_tbl
                          ,x_rxh_rec       => x_rxh_rec
                          ,x_rxhl_tbl      => x_rxhl_tbl
                          );
Line: 1488

    okl_rxl_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_rxl_rec       => p_rxl_rec
                          ,p_rxll_tbl      => p_rxll_tbl
                          ,x_rxl_rec       => x_rxl_rec
                          ,x_rxll_tbl      => x_rxll_tbl
                          );