DBA Data[Home] [Help]

APPS.OKL_FA_EXTENSION_PVT SQL Statements

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

Line: 101

    okl_fxh_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_fxhv_rec      => p_fxhv_rec
      ,x_fxhv_rec      => x_fxhv_rec);
Line: 214

  PROCEDURE update_fxh_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_fxhv_rec              IN  fxhv_rec_type,
    p_fxlv_tbl              IN  fxlv_tbl_type,
    x_fxhv_rec              OUT NOCOPY fxhv_rec_type,
    x_fxlv_tbl              OUT NOCOPY fxlv_tbl_type) IS
    l_return_status         VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
Line: 227

    update_fxh_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_fxhv_rec      => p_fxhv_rec
      ,x_fxhv_rec      => x_fxhv_rec);
Line: 239

      update_fxl_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_fxlv_tbl      => p_fxlv_tbl
        ,x_fxlv_tbl      => x_fxlv_tbl);
Line: 261

  END update_fxh_extension;
Line: 457

  PROCEDURE update_fxh_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_fxhv_rec                   IN  fxhv_rec_type
    ,x_fxhv_rec                   OUT NOCOPY fxhv_rec_type) IS
    l_return_status               VARCHAR2(1)   := OKC_API.G_RET_STS_SUCCESS;
Line: 467

    okl_fxh_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_fxhv_rec      => p_fxhv_rec
      ,x_fxhv_rec      => x_fxhv_rec);
Line: 495

  END update_fxh_extension;
Line: 508

  PROCEDURE update_fxh_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_fxhv_tbl                   IN  fxhv_tbl_type
    ,x_fxhv_tbl                   OUT NOCOPY fxhv_tbl_type) IS
    l_return_status               VARCHAR2(1)   := OKC_API.G_RET_STS_SUCCESS;
Line: 525

        update_fxh_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_fxhv_rec                     => p_fxhv_tbl(i),
          x_fxhv_rec                     => x_fxhv_tbl(i));
Line: 559

  END update_fxh_extension;
Line: 572

  PROCEDURE delete_fxh_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_fxhv_rec              IN  fxhv_rec_type) IS
    i                        NUMBER :=0;
Line: 584

      SELECT fxl.line_extension_id
        FROM OKL_EXT_FA_LINE_SOURCES_B fxl
       WHERE fxl.header_extension_id = p_fxhv_rec.header_extension_id;
Line: 593

    delete_fxl_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_fxlv_tbl      => l_fxlv_tbl);
Line: 602

      okl_fxh_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_fxhv_rec      => p_fxhv_rec);
Line: 624

  END delete_fxh_extension;
Line: 637

  PROCEDURE delete_fxh_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_fxhv_tbl              IN  fxhv_tbl_type) IS
    i                        NUMBER :=0;
Line: 655

        delete_fxh_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_fxhv_rec      => p_fxhv_tbl(i));
Line: 688

  END delete_fxh_extension;
Line: 829

    okl_fxl_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_fxlv_rec      => p_fxlv_rec
      ,x_fxlv_rec      => x_fxlv_rec);
Line: 1057

  PROCEDURE update_fxl_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_fxlv_rec                       IN  fxlv_rec_type
    ,x_fxlv_rec                       OUT NOCOPY fxlv_rec_type)
  IS
    l_return_status                   VARCHAR2(1)   := OKC_API.G_RET_STS_SUCCESS;
Line: 1068

    okl_fxl_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_fxlv_rec      => p_fxlv_rec
                          ,x_fxlv_rec      => x_fxlv_rec
                          );
Line: 1098

  END update_fxl_extension;
Line: 1111

  PROCEDURE update_fxl_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_fxlv_tbl                       IN  fxlv_tbl_type
    ,x_fxlv_tbl                       OUT NOCOPY fxlv_tbl_type)
  IS
    l_return_status                   VARCHAR2(1)   := OKC_API.G_RET_STS_SUCCESS;
Line: 1130

        update_fxl_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_fxlv_rec                     => p_fxlv_tbl(i),
          x_fxlv_rec                     => x_fxlv_tbl(i));
Line: 1165

  END update_fxl_extension;
Line: 1178

  PROCEDURE delete_fxl_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_fxlv_rec                       IN  fxlv_rec_type) IS
    i                                 NUMBER :=0;
Line: 1188

    okl_fxl_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_fxlv_rec      => p_fxlv_rec);
Line: 1218

  END delete_fxl_extension;
Line: 1231

  PROCEDURE delete_fxl_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_fxlv_tbl                       IN  fxlv_tbl_type)
  IS
    i                                 NUMBER :=0;
Line: 1249

        delete_fxl_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_fxlv_rec      => p_fxlv_tbl(i));
Line: 1282

  END delete_fxl_extension;
Line: 1426

  okl_fxh_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_fxh_rec       => p_fxh_rec
                          ,p_fxhl_tbl      => p_fxhl_tbl
                          ,x_fxh_rec       => x_fxh_rec
                          ,x_fxhl_tbl      => x_fxhl_tbl
                          );
Line: 1487

    okl_fxl_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_fxl_rec       => p_fxl_rec
                          ,p_fxll_tbl      => p_fxll_tbl
                          ,x_fxl_rec       => x_fxl_rec
                          ,x_fxll_tbl      => x_fxll_tbl
                          );