DBA Data[Home] [Help]

APPS.OKC_QA_CHECK_LIST_PUB SQL Statements

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

Line: 18

    l_qclv_rec.last_updated_by       := p_qclv_rec1.last_updated_by;
Line: 19

    l_qclv_rec.last_update_date      := p_qclv_rec1.last_update_date;
Line: 20

    l_qclv_rec.last_update_login     := p_qclv_rec1.last_update_login;
Line: 191

  PROCEDURE update_qa_check_list(
    p_api_version                  IN  NUMBER,
    p_init_msg_list                IN  VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_qclv_rec                     IN  qclv_rec_type,
    x_qclv_rec                     OUT NOCOPY qclv_rec_type) IS
    l_return_status                VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
Line: 200

    l_api_name                     CONSTANT VARCHAR2(30) := 'update_qa_check_list';
Line: 222

    OKC_QA_CHECK_LIST_PVT.update_qa_check_list(
      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_qclv_rec      => l_qclv_rec,
      x_qclv_rec      => x_qclv_rec);
Line: 271

  END update_qa_check_list;
Line: 276

  PROCEDURE update_qa_check_list(
    p_api_version                  IN  NUMBER,
    p_init_msg_list                IN  VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_qclv_tbl                     IN  qclv_tbl_type,
    x_qclv_tbl                     OUT NOCOPY qclv_tbl_type) IS
    i                              NUMBER := 0;
Line: 291

        update_qa_check_list(
          p_api_version   => p_api_version,
          p_init_msg_list => p_init_msg_list,
          x_return_status => l_return_status,
          x_msg_count     => x_msg_count,
          x_msg_data      => x_msg_data,
          p_qclv_rec      => p_qclv_tbl(i),
          x_qclv_rec      => x_qclv_tbl(i));
Line: 325

  END update_qa_check_list;
Line: 330

  PROCEDURE delete_qa_check_list(
    p_api_version                  IN  NUMBER,
    p_init_msg_list                IN  VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_qclv_rec                     IN  qclv_rec_type) IS
    l_return_status                VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
Line: 338

    l_api_name                     CONSTANT VARCHAR2(30) := 'delete_qa_check_list';
Line: 359

    OKC_QA_CHECK_LIST_PVT.delete_qa_check_list(
      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_qclv_rec      => p_qclv_rec);
Line: 407

  END delete_qa_check_list;
Line: 412

  PROCEDURE delete_qa_check_list(
    p_api_version                  IN  NUMBER,
    p_init_msg_list                IN  VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_qclv_tbl                     IN  qclv_tbl_type) IS
    i                              NUMBER := 0;
Line: 426

        delete_qa_check_list(
          p_api_version   => p_api_version,
          p_init_msg_list => p_init_msg_list,
          x_return_status => l_return_status,
          x_msg_count     => x_msg_count,
          x_msg_data      => x_msg_data,
          p_qclv_rec      => p_qclv_tbl(i));
Line: 459

  END delete_qa_check_list;
Line: 680

    l_qlpv_rec.last_updated_by       := p_qlpv_rec1.last_updated_by;
Line: 681

    l_qlpv_rec.last_update_date      := p_qlpv_rec1.last_update_date;
Line: 682

    l_qlpv_rec.last_update_login     := p_qlpv_rec1.last_update_login;
Line: 851

  PROCEDURE update_qa_process(
    p_api_version                  IN  NUMBER,
    p_init_msg_list                IN  VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_qlpv_rec                     IN  qlpv_rec_type,
    x_qlpv_rec                     OUT NOCOPY qlpv_rec_type) IS
    l_return_status                VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
Line: 860

    l_api_name                     CONSTANT VARCHAR2(30) := 'update_qa_process';
Line: 882

    OKC_QA_CHECK_LIST_PVT.update_qa_process(
      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_qlpv_rec      => l_qlpv_rec,
      x_qlpv_rec      => x_qlpv_rec);
Line: 931

  END update_qa_process;
Line: 936

  PROCEDURE update_qa_process(
    p_api_version                  IN  NUMBER,
    p_init_msg_list                IN  VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_qlpv_tbl                     IN  qlpv_tbl_type,
    x_qlpv_tbl                     OUT NOCOPY qlpv_tbl_type) IS
    i                              NUMBER := 0;
Line: 951

        update_qa_process(
          p_api_version   => p_api_version,
          p_init_msg_list => p_init_msg_list,
          x_return_status => l_return_status,
          x_msg_count     => x_msg_count,
          x_msg_data      => x_msg_data,
          p_qlpv_rec      => p_qlpv_tbl(i),
          x_qlpv_rec      => x_qlpv_tbl(i));
Line: 985

  END update_qa_process;
Line: 990

  PROCEDURE delete_qa_process(
    p_api_version                  IN  NUMBER,
    p_init_msg_list                IN  VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_qlpv_rec                     IN  qlpv_rec_type) IS
    l_return_status                VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
Line: 998

    l_api_name                     CONSTANT VARCHAR2(30) := 'delete_qa_process';
Line: 1019

    OKC_QA_CHECK_LIST_PVT.delete_qa_process(
      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_qlpv_rec      => p_qlpv_rec);
Line: 1067

  END delete_qa_process;
Line: 1072

  PROCEDURE delete_qa_process(
    p_api_version                  IN  NUMBER,
    p_init_msg_list                IN  VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_qlpv_tbl                     IN  qlpv_tbl_type) IS
    i                              NUMBER := 0;
Line: 1086

        delete_qa_process(
          p_api_version   => p_api_version,
          p_init_msg_list => p_init_msg_list,
          x_return_status => l_return_status,
          x_msg_count     => x_msg_count,
          x_msg_data      => x_msg_data,
          p_qlpv_rec      => p_qlpv_tbl(i));
Line: 1119

  END delete_qa_process;
Line: 1339

    l_qppv_rec.last_updated_by       := p_qppv_rec1.last_updated_by;
Line: 1340

    l_qppv_rec.last_update_date      := p_qppv_rec1.last_update_date;
Line: 1341

    l_qppv_rec.last_update_login     := p_qppv_rec1.last_update_login;
Line: 1509

  PROCEDURE update_qa_parm(
    p_api_version                  IN  NUMBER,
    p_init_msg_list                IN  VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_qppv_rec                     IN  qppv_rec_type,
    x_qppv_rec                     OUT NOCOPY qppv_rec_type) IS
    l_return_status                VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
Line: 1518

    l_api_name                     CONSTANT VARCHAR2(30) := 'update_qa_parm';
Line: 1540

    OKC_QA_CHECK_LIST_PVT.update_qa_parm(
      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_qppv_rec      => l_qppv_rec,
      x_qppv_rec      => x_qppv_rec);
Line: 1589

  END update_qa_parm;
Line: 1594

  PROCEDURE update_qa_parm(
    p_api_version                  IN  NUMBER,
    p_init_msg_list                IN  VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_qppv_tbl                     IN  qppv_tbl_type,
    x_qppv_tbl                     OUT NOCOPY qppv_tbl_type) IS
    i                              NUMBER := 0;
Line: 1609

        update_qa_parm(
          p_api_version   => p_api_version,
          p_init_msg_list => p_init_msg_list,
          x_return_status => l_return_status,
          x_msg_count     => x_msg_count,
          x_msg_data      => x_msg_data,
          p_qppv_rec      => p_qppv_tbl(i),
          x_qppv_rec      => x_qppv_tbl(i));
Line: 1643

  END update_qa_parm;
Line: 1648

  PROCEDURE delete_qa_parm(
    p_api_version                  IN  NUMBER,
    p_init_msg_list                IN  VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_qppv_rec                     IN  qppv_rec_type) IS
    l_return_status                VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
Line: 1656

    l_api_name                     CONSTANT VARCHAR2(30) := 'delete_qa_parm';
Line: 1677

    OKC_QA_CHECK_LIST_PVT.delete_qa_parm(
      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_qppv_rec      => p_qppv_rec);
Line: 1725

  END delete_qa_parm;
Line: 1730

  PROCEDURE delete_qa_parm(
    p_api_version                  IN  NUMBER,
    p_init_msg_list                IN  VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_qppv_tbl                     IN  qppv_tbl_type) IS
    i                              NUMBER := 0;
Line: 1744

        delete_qa_parm(
          p_api_version   => p_api_version,
          p_init_msg_list => p_init_msg_list,
          x_return_status => l_return_status,
          x_msg_count     => x_msg_count,
          x_msg_data      => x_msg_data,
          p_qppv_rec      => p_qppv_tbl(i));
Line: 1777

  END delete_qa_parm;