DBA Data[Home] [Help]

APPS.OKL_AP_EXTENSION_PVT SQL Statements

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

Line: 100

    okl_pxh_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_pxhv_rec      => p_pxhv_rec
      ,x_pxhv_rec      => x_pxhv_rec);
Line: 213

  PROCEDURE update_pxh_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_pxhv_rec              IN  pxhv_rec_type,
    p_pxlv_tbl              IN  pxlv_tbl_type,
    x_pxhv_rec              OUT NOCOPY pxhv_rec_type,
    x_pxlv_tbl              OUT NOCOPY pxlv_tbl_type) IS
    l_return_status         VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
Line: 226

    update_pxh_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_pxhv_rec      => p_pxhv_rec
      ,x_pxhv_rec      => x_pxhv_rec);
Line: 238

      update_pxl_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_pxlv_tbl      => p_pxlv_tbl
        ,x_pxlv_tbl      => x_pxlv_tbl);
Line: 260

  END update_pxh_extension;
Line: 456

  PROCEDURE update_pxh_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_pxhv_rec                   IN  pxhv_rec_type
    ,x_pxhv_rec                   OUT NOCOPY pxhv_rec_type) IS
    l_return_status               VARCHAR2(1)   := OKC_API.G_RET_STS_SUCCESS;
Line: 466

    okl_pxh_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_pxhv_rec      => p_pxhv_rec
      ,x_pxhv_rec      => x_pxhv_rec);
Line: 494

  END update_pxh_extension;
Line: 507

  PROCEDURE update_pxh_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_pxhv_tbl                   IN  pxhv_tbl_type
    ,x_pxhv_tbl                   OUT NOCOPY pxhv_tbl_type) IS
    l_return_status               VARCHAR2(1)   := OKC_API.G_RET_STS_SUCCESS;
Line: 524

        update_pxh_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_pxhv_rec                     => p_pxhv_tbl(i),
          x_pxhv_rec                     => x_pxhv_tbl(i));
Line: 558

  END update_pxh_extension;
Line: 571

  PROCEDURE delete_pxh_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_pxhv_rec              IN  pxhv_rec_type) IS
    i                        NUMBER :=0;
Line: 583

      SELECT pxl.line_extension_id
        FROM OKL_EXT_ap_LINE_SOURCES_B pxl
       WHERE pxl.header_extension_id = p_pxhv_rec.header_extension_id;
Line: 592

    delete_pxl_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_pxlv_tbl      => l_pxlv_tbl);
Line: 601

      okl_pxh_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_pxhv_rec      => p_pxhv_rec);
Line: 623

  END delete_pxh_extension;
Line: 636

  PROCEDURE delete_pxh_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_pxhv_tbl              IN  pxhv_tbl_type) IS
    i                        NUMBER :=0;
Line: 654

        delete_pxh_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_pxhv_rec      => p_pxhv_tbl(i));
Line: 687

  END delete_pxh_extension;
Line: 828

    okl_pxl_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_pxlv_rec      => p_pxlv_rec
      ,x_pxlv_rec      => x_pxlv_rec);
Line: 1056

  PROCEDURE update_pxl_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_pxlv_rec                       IN  pxlv_rec_type
    ,x_pxlv_rec                       OUT NOCOPY pxlv_rec_type)
  IS
    l_return_status                   VARCHAR2(1)   := OKC_API.G_RET_STS_SUCCESS;
Line: 1067

    okl_pxl_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_pxlv_rec      => p_pxlv_rec
                          ,x_pxlv_rec      => x_pxlv_rec
                          );
Line: 1097

  END update_pxl_extension;
Line: 1110

  PROCEDURE update_pxl_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_pxlv_tbl                       IN  pxlv_tbl_type
    ,x_pxlv_tbl                       OUT NOCOPY pxlv_tbl_type)
  IS
    l_return_status                   VARCHAR2(1)   := OKC_API.G_RET_STS_SUCCESS;
Line: 1129

        update_pxl_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_pxlv_rec                     => p_pxlv_tbl(i),
          x_pxlv_rec                     => x_pxlv_tbl(i));
Line: 1164

  END update_pxl_extension;
Line: 1177

  PROCEDURE delete_pxl_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_pxlv_rec                       IN  pxlv_rec_type) IS
    i                                 NUMBER :=0;
Line: 1187

    okl_pxl_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_pxlv_rec      => p_pxlv_rec);
Line: 1217

  END delete_pxl_extension;
Line: 1230

  PROCEDURE delete_pxl_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_pxlv_tbl                       IN  pxlv_tbl_type)
  IS
    i                                 NUMBER :=0;
Line: 1248

        delete_pxl_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_pxlv_rec      => p_pxlv_tbl(i));
Line: 1281

  END delete_pxl_extension;
Line: 1426

  okl_pxh_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_pxh_rec       => p_pxh_rec
                          ,p_pxhl_tbl      => p_pxhl_tbl
                          ,x_pxh_rec       => x_pxh_rec
                          ,x_pxhl_tbl      => x_pxhl_tbl
                          );
Line: 1487

    okl_pxl_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_pxl_rec       => p_pxl_rec
                          ,p_pxll_tbl      => p_pxll_tbl
                          ,x_pxl_rec       => x_pxl_rec
                          ,x_pxll_tbl      => x_pxll_tbl
                          );