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.OKL_QCN_PVT SQL Statements

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

Line: 61


    SELECT '1'
	FROM OKL_CRITERIA_B
	WHERE id = p_qcnv_rec.crn_id;

Line: 110


    SELECT '1'
	FROM OKL_QUESTION_TYPES_B
	WHERE id = p_qcnv_rec.qty_id;

Line: 190


    SELECT
            ID,
            CRN_ID,
            QTY_ID,
            OBJECT_VERSION_NUMBER,
            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 Okl_Question_Crtrns
     WHERE okl_question_crtrns.id = p_id;

Line: 247


              l_qcn_rec.LAST_UPDATED_BY,
              l_qcn_rec.LAST_UPDATE_DATE,
              l_qcn_rec.LAST_UPDATE_LOGIN;

Line: 270


    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            CRN_ID,
            QTY_ID,
            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 Okl_Question_Crtrns_V
     WHERE okl_question_crtrns_v.id = p_id;

Line: 327


              l_qcnv_rec.LAST_UPDATED_BY,
              l_qcnv_rec.LAST_UPDATE_DATE,
              l_qcnv_rec.LAST_UPDATE_LOGIN;

Line: 414


    IF (l_qcnv_rec.last_updated_by = okl_api.G_MISS_NUM) THEN
      l_qcnv_rec.last_updated_by := NULL;

Line: 417


    IF (l_qcnv_rec.last_update_date = okl_api.G_MISS_DATE) THEN
      l_qcnv_rec.last_update_date := NULL;

Line: 420


    IF (l_qcnv_rec.last_update_login = okl_api.G_MISS_NUM) THEN
      l_qcnv_rec.last_update_login := NULL;

Line: 550


    p_to.last_updated_by := p_from.last_updated_by;

Line: 551


    p_to.last_update_date := p_from.last_update_date;

Line: 552


    p_to.last_update_login := p_from.last_update_login;

Line: 581


    p_to.last_updated_by := p_from.last_updated_by;

Line: 582


    p_to.last_update_date := p_from.last_update_date;

Line: 583


    p_to.last_update_login := p_from.last_update_login;

Line: 736


  PROCEDURE insert_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT okl_api.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_qcn_rec                      IN qcn_rec_type,
    x_qcn_rec                      OUT NOCOPY qcn_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 745


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

Line: 781


    INSERT INTO OKL_QUESTION_CRTRNS(
        id,
        crn_id,
        qty_id,
        object_version_number,
        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)
      VALUES (
        l_qcn_rec.id,
        l_qcn_rec.crn_id,
        l_qcn_rec.qty_id,
        l_qcn_rec.object_version_number,
        l_qcn_rec.attribute_category,
        l_qcn_rec.attribute1,
        l_qcn_rec.attribute2,
        l_qcn_rec.attribute3,
        l_qcn_rec.attribute4,
        l_qcn_rec.attribute5,
        l_qcn_rec.attribute6,
        l_qcn_rec.attribute7,
        l_qcn_rec.attribute8,
        l_qcn_rec.attribute9,
        l_qcn_rec.attribute10,
        l_qcn_rec.attribute11,
        l_qcn_rec.attribute12,
        l_qcn_rec.attribute13,
        l_qcn_rec.attribute14,
        l_qcn_rec.attribute15,
        l_qcn_rec.created_by,
        l_qcn_rec.creation_date,
        l_qcn_rec.last_updated_by,
        l_qcn_rec.last_update_date,
        l_qcn_rec.last_update_login);

Line: 867


  END insert_row;

Line: 871


  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT okl_api.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_qcnv_rec                     IN qcnv_rec_type,
    x_qcnv_rec                     OUT NOCOPY qcnv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 881


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

Line: 897


      l_qcnv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 898


      l_qcnv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;

Line: 899


      l_qcnv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;

Line: 963


    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_qcn_rec,
      lx_qcn_rec
    );

Line: 1011


  END insert_row;

Line: 1015


  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT okl_api.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_qcnv_tbl                     IN qcnv_tbl_type,
    x_qcnv_tbl                     OUT NOCOPY qcnv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1025


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

Line: 1034


        insert_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => okl_api.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_qcnv_rec                     => p_qcnv_tbl(i),
          x_qcnv_rec                     => x_qcnv_tbl(i));

Line: 1077


  END insert_row;

Line: 1095


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_QUESTION_CRTRNS
     WHERE ID = p_qcn_rec.id
       AND OBJECT_VERSION_NUMBER = p_qcn_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1102


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_QUESTION_CRTRNS
    WHERE ID = p_qcn_rec.id;

Line: 1143


      okl_api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1152


      okl_api.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 1339


  PROCEDURE update_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT okl_api.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_qcn_rec                      IN qcn_rec_type,
    x_qcn_rec                      OUT NOCOPY qcn_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1348


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

Line: 1458


      IF (x_qcn_rec.last_updated_by = okl_api.G_MISS_NUM)
      THEN
        x_qcn_rec.last_updated_by := l_qcn_rec.last_updated_by;

Line: 1462


      IF (x_qcn_rec.last_update_date = okl_api.G_MISS_DATE)
      THEN
        x_qcn_rec.last_update_date := l_qcn_rec.last_update_date;

Line: 1466


      IF (x_qcn_rec.last_update_login = okl_api.G_MISS_NUM)
      THEN
        x_qcn_rec.last_update_login := l_qcn_rec.last_update_login;

Line: 1510


    UPDATE  OKL_QUESTION_CRTRNS
    SET CRN_ID = l_def_qcn_rec.crn_id,
        QTY_ID = l_def_qcn_rec.qty_id,
        OBJECT_VERSION_NUMBER = l_def_qcn_rec.object_version_number,
        ATTRIBUTE_CATEGORY = l_def_qcn_rec.attribute_category,
        ATTRIBUTE1 = l_def_qcn_rec.attribute1,
        ATTRIBUTE2 = l_def_qcn_rec.attribute2,
        ATTRIBUTE3 = l_def_qcn_rec.attribute3,
        ATTRIBUTE4 = l_def_qcn_rec.attribute4,
        ATTRIBUTE5 = l_def_qcn_rec.attribute5,
        ATTRIBUTE6 = l_def_qcn_rec.attribute6,
        ATTRIBUTE7 = l_def_qcn_rec.attribute7,
        ATTRIBUTE8 = l_def_qcn_rec.attribute8,
        ATTRIBUTE9 = l_def_qcn_rec.attribute9,
        ATTRIBUTE10 = l_def_qcn_rec.attribute10,
        ATTRIBUTE11 = l_def_qcn_rec.attribute11,
        ATTRIBUTE12 = l_def_qcn_rec.attribute12,
        ATTRIBUTE13 = l_def_qcn_rec.attribute13,
        ATTRIBUTE14 = l_def_qcn_rec.attribute14,
        ATTRIBUTE15 = l_def_qcn_rec.attribute15,
        CREATED_BY = l_def_qcn_rec.created_by,
        CREATION_DATE = l_def_qcn_rec.creation_date,
        LAST_UPDATED_BY = l_def_qcn_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_qcn_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_qcn_rec.last_update_login
    WHERE ID = l_def_qcn_rec.id;

Line: 1570


  END update_row;

Line: 1574


  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT okl_api.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_qcnv_rec                     IN qcnv_rec_type,
    x_qcnv_rec                     OUT NOCOPY qcnv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1584


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

Line: 1598


      l_qcnv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 1599


      l_qcnv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;

Line: 1600


      l_qcnv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;

Line: 1708


      IF (x_qcnv_rec.last_updated_by = okl_api.G_MISS_NUM)
      THEN
        x_qcnv_rec.last_updated_by := l_qcnv_rec.last_updated_by;

Line: 1712


      IF (x_qcnv_rec.last_update_date = okl_api.G_MISS_DATE)
      THEN
        x_qcnv_rec.last_update_date := l_qcnv_rec.last_update_date;

Line: 1716


      IF (x_qcnv_rec.last_update_login = okl_api.G_MISS_NUM)
      THEN
        x_qcnv_rec.last_update_login := l_qcnv_rec.last_update_login;

Line: 1787


    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_qcn_rec,
      lx_qcn_rec
    );

Line: 1834


  END update_row;

Line: 1838


  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT okl_api.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_qcnv_tbl                     IN qcnv_tbl_type,
    x_qcnv_tbl                     OUT NOCOPY qcnv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1848


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

Line: 1857


        update_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => okl_api.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_qcnv_rec                     => p_qcnv_tbl(i),
          x_qcnv_rec                     => x_qcnv_tbl(i));

Line: 1900


  END update_row;

Line: 1908


  PROCEDURE delete_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT okl_api.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_qcn_rec                      IN qcn_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1916


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

Line: 1930


    DELETE FROM OKL_QUESTION_CRTRNS
     WHERE ID = l_qcn_rec.id;

Line: 1965


  END delete_row;

Line: 1969


  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT okl_api.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_qcnv_rec                     IN qcnv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1978


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

Line: 2002


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

Line: 2046


  END delete_row;

Line: 2050


  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT okl_api.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_qcnv_tbl                     IN qcnv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2059


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

Line: 2068


        delete_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => okl_api.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_qcnv_rec                     => p_qcnv_tbl(i));

Line: 2110


  END delete_row;