eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_QLP_PVT SQL Statements

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

Line: 34


      SELECT 'x'
        FROM OKC_QA_CHECK_LISTS_B qclv
       WHERE qclv.ID = p_qlpv_rec.QCL_ID;

Line: 112


      SELECT 'x'
        FROM OKC_PROCESS_DEFS_B pdfv
       WHERE pdfv.ID = p_qlpv_rec.PDF_ID;

Line: 389


    SELECT COUNT(1)
      INTO l_count
      FROM OKC_QA_LIST_PROCESSES_V qlp
     WHERE PDF_ID = p_qlpv_rec.pdf_id
       AND QCL_ID = p_qlpv_rec.qcl_id;

Line: 630


    SELECT
            PDF_ID,
            QCL_ID,
            SEVERITY,
            ACTIVE_YN,
            RUN_SEQUENCE,
            OBJECT_VERSION_NUMBER,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15,
            ACCESS_LEVEL
      FROM Okc_Qa_List_Processes
     WHERE okc_qa_list_processes.qcl_id = p_qcl_id
       AND okc_qa_list_processes.pdf_id = p_pdf_id;

Line: 678


              l_qlp_rec.LAST_UPDATED_BY,
              l_qlp_rec.LAST_UPDATE_DATE,
              l_qlp_rec.LAST_UPDATE_LOGIN,
              l_qlp_rec.ATTRIBUTE_CATEGORY,
              l_qlp_rec.ATTRIBUTE1,
              l_qlp_rec.ATTRIBUTE2,
              l_qlp_rec.ATTRIBUTE3,
              l_qlp_rec.ATTRIBUTE4,
              l_qlp_rec.ATTRIBUTE5,
              l_qlp_rec.ATTRIBUTE6,
              l_qlp_rec.ATTRIBUTE7,
              l_qlp_rec.ATTRIBUTE8,
              l_qlp_rec.ATTRIBUTE9,
              l_qlp_rec.ATTRIBUTE10,
              l_qlp_rec.ATTRIBUTE11,
              l_qlp_rec.ATTRIBUTE12,
              l_qlp_rec.ATTRIBUTE13,
              l_qlp_rec.ATTRIBUTE14,
              l_qlp_rec.ATTRIBUTE15,
              l_qlp_rec.ACCESS_LEVEL;

Line: 719


    SELECT
            QCL_ID,
            PDF_ID,
            OBJECT_VERSION_NUMBER,
            SEVERITY,
            ACTIVE_YN,
            RUN_SEQUENCE,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN,
            ACCESS_LEVEL
      FROM Okc_Qa_List_Processes_V
     WHERE okc_qa_list_processes_v.qcl_id = p_qcl_id
       AND okc_qa_list_processes_v.pdf_id = p_pdf_id;

Line: 783


              l_qlpv_rec.LAST_UPDATED_BY,
              l_qlpv_rec.LAST_UPDATE_DATE,
              l_qlpv_rec.LAST_UPDATE_LOGIN,
              l_qlpv_rec.ACCESS_LEVEL;

Line: 880


    IF (l_qlpv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
      l_qlpv_rec.last_updated_by := NULL;

Line: 883


    IF (l_qlpv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
      l_qlpv_rec.last_update_date := NULL;

Line: 886


    IF (l_qlpv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN
      l_qlpv_rec.last_update_login := NULL;

Line: 924


    p_to.last_updated_by := p_from.last_updated_by;

Line: 925


    p_to.last_update_date := p_from.last_update_date;

Line: 926


    p_to.last_update_login := p_from.last_update_login;

Line: 958


    p_to.last_updated_by := p_from.last_updated_by;

Line: 959


    p_to.last_update_date := p_from.last_update_date;

Line: 960


    p_to.last_update_login := p_from.last_update_login;

Line: 1130


  PROCEDURE insert_row(
    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_qlp_rec                      IN qlp_rec_type,
    x_qlp_rec                      OUT NOCOPY qlp_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1139


    l_api_name                     CONSTANT VARCHAR2(30) := 'PROCESSES_insert_row';

Line: 1175


    INSERT INTO OKC_QA_LIST_PROCESSES(
        pdf_id,
        qcl_id,
        severity,
        active_yn,
        run_sequence,
        object_version_number,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        last_update_login,
        attribute_category,
        attribute1,
        attribute2,
        attribute3,
        attribute4,
        attribute5,
        attribute6,
        attribute7,
        attribute8,
        attribute9,
        attribute10,
        attribute11,
        attribute12,
        attribute13,
        attribute14,
        attribute15,
        access_level)
      VALUES (
        l_qlp_rec.pdf_id,
        l_qlp_rec.qcl_id,
        l_qlp_rec.severity,
        l_qlp_rec.active_yn,
        l_qlp_rec.run_sequence,
        l_qlp_rec.object_version_number,
        l_qlp_rec.created_by,
        l_qlp_rec.creation_date,
        l_qlp_rec.last_updated_by,
        l_qlp_rec.last_update_date,
        l_qlp_rec.last_update_login,
        l_qlp_rec.attribute_category,
        l_qlp_rec.attribute1,
        l_qlp_rec.attribute2,
        l_qlp_rec.attribute3,
        l_qlp_rec.attribute4,
        l_qlp_rec.attribute5,
        l_qlp_rec.attribute6,
        l_qlp_rec.attribute7,
        l_qlp_rec.attribute8,
        l_qlp_rec.attribute9,
        l_qlp_rec.attribute10,
        l_qlp_rec.attribute11,
        l_qlp_rec.attribute12,
        l_qlp_rec.attribute13,
        l_qlp_rec.attribute14,
        l_qlp_rec.attribute15,
        l_qlp_rec.access_level);

Line: 1267


  END insert_row;

Line: 1271


  PROCEDURE insert_row(
    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_api_version                 CONSTANT NUMBER := 1;

Line: 1281


    l_api_name                     CONSTANT VARCHAR2(30) := 'V_insert_row';

Line: 1297


      l_qlpv_rec.LAST_UPDATE_DATE := l_qlpv_rec.CREATION_DATE;

Line: 1298


      l_qlpv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1299


      l_qlpv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1369


    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_qlp_rec,
      lx_qlp_rec
    );

Line: 1417


  END insert_row;

Line: 1421


  PROCEDURE insert_row(
    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

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1431


    l_api_name                     CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';

Line: 1440


        insert_row (
          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_qlpv_rec                     => p_qlpv_tbl(i),
          x_qlpv_rec                     => x_qlpv_tbl(i));

Line: 1483


  END insert_row;

Line: 1501


    SELECT OBJECT_VERSION_NUMBER
      FROM OKC_QA_LIST_PROCESSES
     WHERE QCL_ID = p_qlp_rec.qcl_id
       AND PDF_ID = p_qlp_rec.pdf_id
       AND OBJECT_VERSION_NUMBER = p_qlp_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1509


    SELECT OBJECT_VERSION_NUMBER
      FROM OKC_QA_LIST_PROCESSES
    WHERE QCL_ID = p_qlp_rec.qcl_id
       AND PDF_ID = p_qlp_rec.pdf_id;

Line: 1551


      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1560


      OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 1747


  PROCEDURE update_row(
    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_qlp_rec                      IN qlp_rec_type,
    x_qlp_rec                      OUT NOCOPY qlp_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1756


    l_api_name                     CONSTANT VARCHAR2(30) := 'PROCESSES_update_row';

Line: 1810


      IF (x_qlp_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_qlp_rec.last_updated_by := l_qlp_rec.last_updated_by;

Line: 1814


      IF (x_qlp_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_qlp_rec.last_update_date := l_qlp_rec.last_update_date;

Line: 1818


      IF (x_qlp_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_qlp_rec.last_update_login := l_qlp_rec.last_update_login;

Line: 1930


    UPDATE  OKC_QA_LIST_PROCESSES
    SET SEVERITY = l_def_qlp_rec.severity,
        ACTIVE_YN = l_def_qlp_rec.active_yn,
        RUN_SEQUENCE = l_def_qlp_rec.run_sequence,
        OBJECT_VERSION_NUMBER = l_def_qlp_rec.object_version_number,
        CREATED_BY = l_def_qlp_rec.created_by,
        CREATION_DATE = l_def_qlp_rec.creation_date,
        LAST_UPDATED_BY = l_def_qlp_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_qlp_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_qlp_rec.last_update_login,
        ATTRIBUTE_CATEGORY = l_def_qlp_rec.attribute_category,
        ATTRIBUTE1 = l_def_qlp_rec.attribute1,
        ATTRIBUTE2 = l_def_qlp_rec.attribute2,
        ATTRIBUTE3 = l_def_qlp_rec.attribute3,
        ATTRIBUTE4 = l_def_qlp_rec.attribute4,
        ATTRIBUTE5 = l_def_qlp_rec.attribute5,
        ATTRIBUTE6 = l_def_qlp_rec.attribute6,
        ATTRIBUTE7 = l_def_qlp_rec.attribute7,
        ATTRIBUTE8 = l_def_qlp_rec.attribute8,
        ATTRIBUTE9 = l_def_qlp_rec.attribute9,
        ATTRIBUTE10 = l_def_qlp_rec.attribute10,
        ATTRIBUTE11 = l_def_qlp_rec.attribute11,
        ATTRIBUTE12 = l_def_qlp_rec.attribute12,
        ATTRIBUTE13 = l_def_qlp_rec.attribute13,
        ATTRIBUTE14 = l_def_qlp_rec.attribute14,
        ATTRIBUTE15 = l_def_qlp_rec.attribute15,
        ACCESS_LEVEL = l_def_qlp_rec.access_level
    WHERE QCL_ID = l_def_qlp_rec.qcl_id
      AND PDF_ID = l_def_qlp_rec.pdf_id;

Line: 1993


  END update_row;

Line: 1997


  PROCEDURE update_row(
    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_api_version                 CONSTANT NUMBER := 1;

Line: 2007


    l_api_name                     CONSTANT VARCHAR2(30) := 'V_update_row';

Line: 2021


      l_qlpv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 2022


      l_qlpv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 2023


      l_qlpv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 2139


      IF (x_qlpv_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_qlpv_rec.last_updated_by := l_qlpv_rec.last_updated_by;

Line: 2143


      IF (x_qlpv_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_qlpv_rec.last_update_date := l_qlpv_rec.last_update_date;

Line: 2147


      IF (x_qlpv_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_qlpv_rec.last_update_login := l_qlpv_rec.last_update_login;

Line: 2222


    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_qlp_rec,
      lx_qlp_rec
    );

Line: 2269


  END update_row;

Line: 2273


  PROCEDURE update_row(
    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

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2283


    l_api_name                     CONSTANT VARCHAR2(30) := 'V_tbl_update_row';

Line: 2292


        update_row (
          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_qlpv_rec                     => p_qlpv_tbl(i),
          x_qlpv_rec                     => x_qlpv_tbl(i));

Line: 2335


  END update_row;

Line: 2343


  PROCEDURE delete_row(
    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_qlp_rec                      IN qlp_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2351


    l_api_name                     CONSTANT VARCHAR2(30) := 'PROCESSES_delete_row';

Line: 2365


    DELETE FROM OKC_QA_LIST_PROCESSES
     WHERE QCL_ID = l_qlp_rec.qcl_id AND
PDF_ID = l_qlp_rec.pdf_id;

Line: 2401


  END delete_row;

Line: 2405


  PROCEDURE delete_row(
    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_api_version                 CONSTANT NUMBER := 1;

Line: 2414


    l_api_name                     CONSTANT VARCHAR2(30) := 'V_delete_row';

Line: 2438


    delete_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_qlp_rec
    );

Line: 2482


  END delete_row;

Line: 2486


  PROCEDURE delete_row(
    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

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2495


    l_api_name                     CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';

Line: 2504


        delete_row (
          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_qlpv_rec                     => p_qlpv_tbl(i));

Line: 2546


  END delete_row;