APPS.OKC_QA_CHECK_LIST_PVT SQL Statements

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

Line: 16

    OKC_QCL_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_qclv_rec      => p_qclv_rec,
      x_qclv_rec      => x_qclv_rec);

Line: 26

  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
  BEGIN
    OKC_QCL_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_qclv_rec      => p_qclv_rec,
      x_qclv_rec      => x_qclv_rec);

Line: 43

  END update_qa_check_list;

Line: 45

  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
  BEGIN
    OKC_QCL_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_qclv_rec      => p_qclv_rec);

Line: 60

  END delete_qa_check_list;

Line: 106

    OKC_QLP_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_qlpv_rec      => p_qlpv_rec,
      x_qlpv_rec      => x_qlpv_rec);

Line: 116

  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
  BEGIN
    OKC_QLP_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_qlpv_rec      => p_qlpv_rec,
      x_qlpv_rec      => x_qlpv_rec);

Line: 133

  END update_qa_process;

Line: 135

  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
  BEGIN
    OKC_QLP_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_qlpv_rec      => p_qlpv_rec);

Line: 150

  END delete_qa_process;

Line: 196

    OKC_QPP_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_qppv_rec      => p_qppv_rec,
      x_qppv_rec      => x_qppv_rec);

Line: 206

  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
  BEGIN
    OKC_QPP_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_qppv_rec      => p_qppv_rec,
      x_qppv_rec      => x_qppv_rec);

Line: 223

  END update_qa_parm;

Line: 225

  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
  BEGIN
    OKC_QPP_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_qppv_rec      => p_qppv_rec);

Line: 240

  END delete_qa_parm;