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

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

Line: 61


    SELECT '1'
	FROM OKL_ANSWER_SETS_B
	WHERE id = p_awrv_rec.ant_id;

Line: 110


    SELECT '1'
	FROM OKC_RULES_B
	WHERE id = p_awrv_rec.rul_id;

Line: 214


    SELECT
            ID,
            ANT_ID,
            RUL_ID,
            SORT_SEQUENCE,
            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_Answers
     WHERE okl_answers.id       = p_id;

Line: 273


              l_awr_rec.LAST_UPDATED_BY,
              l_awr_rec.LAST_UPDATE_DATE,
              l_awr_rec.LAST_UPDATE_LOGIN;

Line: 296


    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            ANT_ID,
            RUL_ID,
            SORT_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
      FROM Okl_Answers_V
     WHERE okl_answers_v.id     = p_id;

Line: 355


              l_awrv_rec.LAST_UPDATED_BY,
              l_awrv_rec.LAST_UPDATE_DATE,
              l_awrv_rec.LAST_UPDATE_LOGIN;

Line: 445


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

Line: 448


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

Line: 451


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

Line: 570


    p_to.last_updated_by := p_from.last_updated_by;

Line: 571


    p_to.last_update_date := p_from.last_update_date;

Line: 572


    p_to.last_update_login := p_from.last_update_login;

Line: 602


    p_to.last_updated_by := p_from.last_updated_by;

Line: 603


    p_to.last_update_date := p_from.last_update_date;

Line: 604


    p_to.last_update_login := p_from.last_update_login;

Line: 757


  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_awr_rec                      IN awr_rec_type,
    x_awr_rec                      OUT NOCOPY awr_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 766


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

Line: 802


    INSERT INTO OKL_ANSWERS(
        id,
        ant_id,
        rul_id,
        sort_sequence,
        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_awr_rec.id,
        l_awr_rec.ant_id,
        l_awr_rec.rul_id,
        l_awr_rec.sort_sequence,
        l_awr_rec.object_version_number,
        l_awr_rec.attribute_category,
        l_awr_rec.attribute1,
        l_awr_rec.attribute2,
        l_awr_rec.attribute3,
        l_awr_rec.attribute4,
        l_awr_rec.attribute5,
        l_awr_rec.attribute6,
        l_awr_rec.attribute7,
        l_awr_rec.attribute8,
        l_awr_rec.attribute9,
        l_awr_rec.attribute10,
        l_awr_rec.attribute11,
        l_awr_rec.attribute12,
        l_awr_rec.attribute13,
        l_awr_rec.attribute14,
        l_awr_rec.attribute15,
        l_awr_rec.created_by,
        l_awr_rec.creation_date,
        l_awr_rec.last_updated_by,
        l_awr_rec.last_update_date,
        l_awr_rec.last_update_login);

Line: 890


  END insert_row;

Line: 894


  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_awrv_rec                     IN awrv_rec_type,
    x_awrv_rec                     OUT NOCOPY awrv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 904


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

Line: 920


      l_awrv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 921


      l_awrv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;

Line: 922


      l_awrv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;

Line: 986


    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_awr_rec,
      lx_awr_rec
    );

Line: 1034


  END insert_row;

Line: 1038


  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_awrv_tbl                     IN awrv_tbl_type,
    x_awrv_tbl                     OUT NOCOPY awrv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1048


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

Line: 1057


        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_awrv_rec                     => p_awrv_tbl(i),
          x_awrv_rec                     => x_awrv_tbl(i));

Line: 1100


  END insert_row;

Line: 1118


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_ANSWERS
     WHERE ID = p_awr_rec.id
       AND OBJECT_VERSION_NUMBER = p_awr_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1125


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_ANSWERS
    WHERE ID = p_awr_rec.id;

Line: 1166


      okl_api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1175


      okl_api.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 1362


  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_awr_rec                      IN awr_rec_type,
    x_awr_rec                      OUT NOCOPY awr_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1371


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

Line: 1485


      IF (x_awr_rec.last_updated_by = okl_api.G_MISS_NUM)
      THEN
        x_awr_rec.last_updated_by := l_awr_rec.last_updated_by;

Line: 1489


      IF (x_awr_rec.last_update_date = okl_api.G_MISS_DATE)
      THEN
        x_awr_rec.last_update_date := l_awr_rec.last_update_date;

Line: 1493


      IF (x_awr_rec.last_update_login = okl_api.G_MISS_NUM)
      THEN
        x_awr_rec.last_update_login := l_awr_rec.last_update_login;

Line: 1537


    UPDATE  OKL_ANSWERS
    SET ANT_ID = l_def_awr_rec.ant_id,
        RUL_ID = l_def_awr_rec.rul_id,
        SORT_SEQUENCE = l_def_awr_rec.sort_sequence,
        OBJECT_VERSION_NUMBER = l_def_awr_rec.object_version_number,
        ATTRIBUTE_CATEGORY = l_def_awr_rec.attribute_category,
        ATTRIBUTE1 = l_def_awr_rec.attribute1,
        ATTRIBUTE2 = l_def_awr_rec.attribute2,
        ATTRIBUTE3 = l_def_awr_rec.attribute3,
        ATTRIBUTE4 = l_def_awr_rec.attribute4,
        ATTRIBUTE5 = l_def_awr_rec.attribute5,
        ATTRIBUTE6 = l_def_awr_rec.attribute6,
        ATTRIBUTE7 = l_def_awr_rec.attribute7,
        ATTRIBUTE8 = l_def_awr_rec.attribute8,
        ATTRIBUTE9 = l_def_awr_rec.attribute9,
        ATTRIBUTE10 = l_def_awr_rec.attribute10,
        ATTRIBUTE11 = l_def_awr_rec.attribute11,
        ATTRIBUTE12 = l_def_awr_rec.attribute12,
        ATTRIBUTE13 = l_def_awr_rec.attribute13,
        ATTRIBUTE14 = l_def_awr_rec.attribute14,
        ATTRIBUTE15 = l_def_awr_rec.attribute15,
        CREATED_BY = l_def_awr_rec.created_by,
        CREATION_DATE = l_def_awr_rec.creation_date,
        LAST_UPDATED_BY = l_def_awr_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_awr_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_awr_rec.last_update_login
    WHERE ID = l_def_awr_rec.id;

Line: 1598


  END update_row;

Line: 1602


  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_awrv_rec                     IN awrv_rec_type,
    x_awrv_rec                     OUT NOCOPY awrv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1612


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

Line: 1626


      l_awrv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 1627


      l_awrv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;

Line: 1628


      l_awrv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;

Line: 1740


      IF (x_awrv_rec.last_updated_by = okl_api.G_MISS_NUM)
      THEN
        x_awrv_rec.last_updated_by := l_awrv_rec.last_updated_by;

Line: 1744


      IF (x_awrv_rec.last_update_date = okl_api.G_MISS_DATE)
      THEN
        x_awrv_rec.last_update_date := l_awrv_rec.last_update_date;

Line: 1748


      IF (x_awrv_rec.last_update_login = okl_api.G_MISS_NUM)
      THEN
        x_awrv_rec.last_update_login := l_awrv_rec.last_update_login;

Line: 1819


    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_awr_rec,
      lx_awr_rec
    );

Line: 1866


  END update_row;

Line: 1870


  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_awrv_tbl                     IN awrv_tbl_type,
    x_awrv_tbl                     OUT NOCOPY awrv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1880


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

Line: 1889


        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_awrv_rec                     => p_awrv_tbl(i),
          x_awrv_rec                     => x_awrv_tbl(i));

Line: 1932


  END update_row;

Line: 1940


  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_awr_rec                      IN awr_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1948


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

Line: 1962


    DELETE FROM OKL_ANSWERS
     WHERE ID = l_awr_rec.id;

Line: 1997


  END delete_row;

Line: 2001


  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_awrv_rec                     IN awrv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2010


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

Line: 2034


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

Line: 2078


  END delete_row;

Line: 2082


  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_awrv_tbl                     IN awrv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2091


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

Line: 2100


        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_awrv_rec                     => p_awrv_tbl(i));

Line: 2142


  END delete_row;