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_QPP_PVT SQL Statements

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

Line: 133


      SELECT 'x'
        FROM OKC_PROCESS_DEF_PARMS_B pdpv
       WHERE pdpv.ID = p_qppv_rec.PDP_ID;

Line: 372


    SELECT
            PDP_ID,
            QLP_PDF_ID,
            QLP_QCL_ID,
            QLP_RUN_SEQUENCE,
            PARM_VALUE,
            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
      FROM Okc_Qa_Process_Parms
     WHERE okc_qa_process_parms.qlp_qcl_id = p_qlp_qcl_id
       AND okc_qa_process_parms.qlp_pdf_id = p_qlp_pdf_id
       AND okc_qa_process_parms.pdp_id = p_pdp_id;

Line: 421


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

Line: 463


    SELECT
            QLP_QCL_ID,
            QLP_PDF_ID,
            QLP_RUN_SEQUENCE,
            PDP_ID,
            OBJECT_VERSION_NUMBER,
            PARM_VALUE,
            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
      FROM Okc_Qa_Process_Parms_V
     WHERE okc_qa_process_parms_v.qlp_qcl_id = p_qlp_qcl_id
       AND okc_qa_process_parms_v.qlp_pdf_id = p_qlp_pdf_id
       AND okc_qa_process_parms_v.qlp_run_sequence = p_qlp_run_sequence
       AND okc_qa_process_parms_v.pdp_id = p_pdp_id;

Line: 530


              l_qppv_rec.LAST_UPDATED_BY,
              l_qppv_rec.LAST_UPDATE_DATE,
              l_qppv_rec.LAST_UPDATE_LOGIN;

Line: 626


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

Line: 629


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

Line: 632


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

Line: 691


    SELECT COUNT(1)
    INTO l_count
    FROM OKC_QA_PROCESS_PARMS_V qpp
    WHERE QLP_QCL_ID = p_qppv_rec.qlp_qcl_id
    AND QLP_PDF_ID = p_qppv_rec.qlp_pdf_id
    AND PDP_ID = p_qppv_rec.pdp_id
    AND QLP_RUN_SEQUENCE = p_qppv_rec.qlp_run_sequence;

Line: 731


        SELECT COUNT(1)
       INTO l_count
      FROM OKC_QA_PROCESS_PARMS_V qpp
     WHERE QLP_QCL_ID = p_qppv_rec.qlp_qcl_id
    AND QLP_PDF_ID = p_qppv_rec.qlp_pdf_id
   AND PDP_ID = p_qppv_rec.pdp_id
 AND QLP_RUN_SEQUENCE = p_qppv_rec.qlp_run_sequence;

Line: 783


    p_to.last_updated_by := p_from.last_updated_by;

Line: 784


    p_to.last_update_date := p_from.last_update_date;

Line: 785


    p_to.last_update_login := p_from.last_update_login;

Line: 816


    p_to.last_updated_by := p_from.last_updated_by;

Line: 817


    p_to.last_update_date := p_from.last_update_date;

Line: 818


    p_to.last_update_login := p_from.last_update_login;

Line: 987


  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_qpp_rec                      IN qpp_rec_type,
    x_qpp_rec                      OUT NOCOPY qpp_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 996


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

Line: 1032


    INSERT INTO OKC_QA_PROCESS_PARMS(
        pdp_id,
        qlp_pdf_id,
        qlp_qcl_id,
        qlp_run_sequence,
        parm_value,
        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)
      VALUES (
        l_qpp_rec.pdp_id,
        l_qpp_rec.qlp_pdf_id,
        l_qpp_rec.qlp_qcl_id,
        l_qpp_rec.qlp_run_sequence,
        l_qpp_rec.parm_value,
        l_qpp_rec.object_version_number,
        l_qpp_rec.created_by,
        l_qpp_rec.creation_date,
        l_qpp_rec.last_updated_by,
        l_qpp_rec.last_update_date,
        l_qpp_rec.last_update_login,
        l_qpp_rec.attribute_category,
        l_qpp_rec.attribute1,
        l_qpp_rec.attribute2,
        l_qpp_rec.attribute3,
        l_qpp_rec.attribute4,
        l_qpp_rec.attribute5,
        l_qpp_rec.attribute6,
        l_qpp_rec.attribute7,
        l_qpp_rec.attribute8,
        l_qpp_rec.attribute9,
        l_qpp_rec.attribute10,
        l_qpp_rec.attribute11,
        l_qpp_rec.attribute12,
        l_qpp_rec.attribute13,
        l_qpp_rec.attribute14,
        l_qpp_rec.attribute15);

Line: 1122


  END insert_row;

Line: 1126


  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_qppv_rec                     IN qppv_rec_type,
    x_qppv_rec                     OUT NOCOPY qppv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1136


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

Line: 1153


      l_qppv_rec.LAST_UPDATE_DATE := l_qppv_rec.CREATION_DATE ;

Line: 1154


      l_qppv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1155


      l_qppv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1217


    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_qpp_rec,
      lx_qpp_rec
    );

Line: 1265


  END insert_row;

Line: 1269


  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_qppv_tbl                     IN qppv_tbl_type,
    x_qppv_tbl                     OUT NOCOPY qppv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1279


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

Line: 1288


        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_qppv_rec                     => p_qppv_tbl(i),
          x_qppv_rec                     => x_qppv_tbl(i));

Line: 1331


  END insert_row;

Line: 1349


    SELECT OBJECT_VERSION_NUMBER
      FROM OKC_QA_PROCESS_PARMS
     WHERE QLP_QCL_ID = p_qpp_rec.qlp_qcl_id
       AND QLP_PDF_ID = p_qpp_rec.qlp_pdf_id
       AND QLP_RUN_SEQUENCE = p_qpp_rec.qlp_run_sequence
       AND PDP_ID = p_qpp_rec.pdp_id
       AND OBJECT_VERSION_NUMBER = p_qpp_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1359


    SELECT OBJECT_VERSION_NUMBER
      FROM OKC_QA_PROCESS_PARMS
    WHERE QLP_QCL_ID = p_qpp_rec.qlp_qcl_id
       AND QLP_PDF_ID = p_qpp_rec.qlp_pdf_id
       AND PDP_ID = p_qpp_rec.pdp_id;

Line: 1402


      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1411


      OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 1598


  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_qpp_rec                      IN qpp_rec_type,
    x_qpp_rec                      OUT NOCOPY qpp_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1607


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

Line: 1661


      IF (x_qpp_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_qpp_rec.last_updated_by := l_qpp_rec.last_updated_by;

Line: 1665


      IF (x_qpp_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_qpp_rec.last_update_date := l_qpp_rec.last_update_date;

Line: 1669


      IF (x_qpp_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_qpp_rec.last_update_login := l_qpp_rec.last_update_login;

Line: 1777


    UPDATE  OKC_QA_PROCESS_PARMS
    SET PARM_VALUE = l_def_qpp_rec.parm_value,
        OBJECT_VERSION_NUMBER = l_def_qpp_rec.object_version_number,
        CREATED_BY = l_def_qpp_rec.created_by,
        CREATION_DATE = l_def_qpp_rec.creation_date,
        LAST_UPDATED_BY = l_def_qpp_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_qpp_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_qpp_rec.last_update_login,
        ATTRIBUTE_CATEGORY = l_def_qpp_rec.attribute_category,
        ATTRIBUTE1 = l_def_qpp_rec.attribute1,
        ATTRIBUTE2 = l_def_qpp_rec.attribute2,
        ATTRIBUTE3 = l_def_qpp_rec.attribute3,
        ATTRIBUTE4 = l_def_qpp_rec.attribute4,
        ATTRIBUTE5 = l_def_qpp_rec.attribute5,
        ATTRIBUTE6 = l_def_qpp_rec.attribute6,
        ATTRIBUTE7 = l_def_qpp_rec.attribute7,
        ATTRIBUTE8 = l_def_qpp_rec.attribute8,
        ATTRIBUTE9 = l_def_qpp_rec.attribute9,
        ATTRIBUTE10 = l_def_qpp_rec.attribute10,
        ATTRIBUTE11 = l_def_qpp_rec.attribute11,
        ATTRIBUTE12 = l_def_qpp_rec.attribute12,
        ATTRIBUTE13 = l_def_qpp_rec.attribute13,
        ATTRIBUTE14 = l_def_qpp_rec.attribute14,
        ATTRIBUTE15 = l_def_qpp_rec.attribute15
    WHERE QLP_QCL_ID = l_def_qpp_rec.qlp_qcl_id
      AND QLP_PDF_ID = l_def_qpp_rec.qlp_pdf_id
      AND QLP_RUN_SEQUENCE = l_def_qpp_rec.qlp_run_sequence
      AND PDP_ID = l_def_qpp_rec.pdp_id;

Line: 1839


  END update_row;

Line: 1843


  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_qppv_rec                     IN qppv_rec_type,
    x_qppv_rec                     OUT NOCOPY qppv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1853


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

Line: 1867


      l_qppv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 1868


      l_qppv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1869


      l_qppv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1985


      IF (x_qppv_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_qppv_rec.last_updated_by := l_qppv_rec.last_updated_by;

Line: 1989


      IF (x_qppv_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_qppv_rec.last_update_date := l_qppv_rec.last_update_date;

Line: 1993


      IF (x_qppv_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_qppv_rec.last_update_login := l_qppv_rec.last_update_login;

Line: 2064


    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_qpp_rec,
      lx_qpp_rec
    );

Line: 2111


  END update_row;

Line: 2115


  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_qppv_tbl                     IN qppv_tbl_type,
    x_qppv_tbl                     OUT NOCOPY qppv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2125


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

Line: 2134


        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_qppv_rec                     => p_qppv_tbl(i),
          x_qppv_rec                     => x_qppv_tbl(i));

Line: 2177


  END update_row;

Line: 2185


  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_qpp_rec                      IN qpp_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2193


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

Line: 2207


    DELETE FROM OKC_QA_PROCESS_PARMS
     WHERE QLP_QCL_ID = l_qpp_rec.qlp_qcl_id AND
QLP_PDF_ID = l_qpp_rec.qlp_pdf_id AND
QLP_RUN_SEQUENCE = l_qpp_rec.qlp_run_sequence AND
PDP_ID = l_qpp_rec.pdp_id;

Line: 2245


  END delete_row;

Line: 2249


  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_qppv_rec                     IN qppv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2258


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

Line: 2282


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

Line: 2326


  END delete_row;

Line: 2330


  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_qppv_tbl                     IN qppv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2339


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

Line: 2348


        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_qppv_rec                     => p_qppv_tbl(i));

Line: 2390


  END delete_row;