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

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

Line: 61


    SELECT '1'
	FROM OKL_ANSR_SET_CRTRIA_V
	WHERE id = p_acvv_rec.asr_id;

Line: 110


    SELECT '1'
	FROM OKL_ANSR_SET_CN_VLS
	WHERE id = p_acvv_rec.asv_id;

Line: 158


    SELECT '1'
	FROM OKL_ANSWERS
	WHERE id = p_acvv_rec.awr_id;

Line: 239


    SELECT
            ID,
            AWR_ID,
            ASR_ID,
            ASV_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_Ansr_Crtrn_Vals
     WHERE okl_ansr_crtrn_vals.id = p_id;

Line: 298


              l_acv_rec.LAST_UPDATED_BY,
              l_acv_rec.LAST_UPDATE_DATE,
              l_acv_rec.LAST_UPDATE_LOGIN;

Line: 321


    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            AWR_ID,
            ASV_ID,
            ASR_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_Ansr_Crtrn_Vals_V
     WHERE okl_ansr_crtrn_vals_v.id = p_id;

Line: 380


              l_acvv_rec.LAST_UPDATED_BY,
              l_acvv_rec.LAST_UPDATE_DATE,
              l_acvv_rec.LAST_UPDATE_LOGIN;

Line: 470


    IF (l_acvv_rec.last_updated_by = Okl_Api.G_MISS_NUM) THEN
      l_acvv_rec.last_updated_by := NULL;

Line: 473


    IF (l_acvv_rec.last_update_date = Okl_Api.G_MISS_DATE) THEN
      l_acvv_rec.last_update_date := NULL;

Line: 476


    IF (l_acvv_rec.last_update_login = Okl_Api.G_MISS_NUM) THEN
      l_acvv_rec.last_update_login := NULL;

Line: 595


    p_to.last_updated_by := p_from.last_updated_by;

Line: 596


    p_to.last_update_date := p_from.last_update_date;

Line: 597


    p_to.last_update_login := p_from.last_update_login;

Line: 627


    p_to.last_updated_by := p_from.last_updated_by;

Line: 628


    p_to.last_update_date := p_from.last_update_date;

Line: 629


    p_to.last_update_login := p_from.last_update_login;

Line: 782


  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_acv_rec                      IN acv_rec_type,
    x_acv_rec                      OUT NOCOPY acv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 791


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

Line: 827


    INSERT INTO OKL_ANSR_CRTRN_VALS(
        id,
        awr_id,
        asr_id,
        asv_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_acv_rec.id,
        l_acv_rec.awr_id,
        l_acv_rec.asr_id,
        l_acv_rec.asv_id,
        l_acv_rec.object_version_number,
        l_acv_rec.attribute_category,
        l_acv_rec.attribute1,
        l_acv_rec.attribute2,
        l_acv_rec.attribute3,
        l_acv_rec.attribute4,
        l_acv_rec.attribute5,
        l_acv_rec.attribute6,
        l_acv_rec.attribute7,
        l_acv_rec.attribute8,
        l_acv_rec.attribute9,
        l_acv_rec.attribute10,
        l_acv_rec.attribute11,
        l_acv_rec.attribute12,
        l_acv_rec.attribute13,
        l_acv_rec.attribute14,
        l_acv_rec.attribute15,
        l_acv_rec.created_by,
        l_acv_rec.creation_date,
        l_acv_rec.last_updated_by,
        l_acv_rec.last_update_date,
        l_acv_rec.last_update_login);

Line: 915


  END insert_row;

Line: 919


  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_acvv_rec                     IN acvv_rec_type,
    x_acvv_rec                     OUT NOCOPY acvv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 929


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

Line: 945


      l_acvv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 946


      l_acvv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;

Line: 947


      l_acvv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;

Line: 1011


    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_acv_rec,
      lx_acv_rec
    );

Line: 1059


  END insert_row;

Line: 1063


  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_acvv_tbl                     IN acvv_tbl_type,
    x_acvv_tbl                     OUT NOCOPY acvv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1073


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

Line: 1082


        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_acvv_rec                     => p_acvv_tbl(i),
          x_acvv_rec                     => x_acvv_tbl(i));

Line: 1125


  END insert_row;

Line: 1143


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_ANSR_CRTRN_VALS
     WHERE ID = p_acv_rec.id
       AND OBJECT_VERSION_NUMBER = p_acv_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1150


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_ANSR_CRTRN_VALS
    WHERE ID = p_acv_rec.id;

Line: 1191


      Okl_Api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1200


      Okl_Api.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 1387


  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_acv_rec                      IN acv_rec_type,
    x_acv_rec                      OUT NOCOPY acv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1396


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

Line: 1510


      IF (x_acv_rec.last_updated_by = Okl_Api.G_MISS_NUM)
      THEN
        x_acv_rec.last_updated_by := l_acv_rec.last_updated_by;

Line: 1514


      IF (x_acv_rec.last_update_date = Okl_Api.G_MISS_DATE)
      THEN
        x_acv_rec.last_update_date := l_acv_rec.last_update_date;

Line: 1518


      IF (x_acv_rec.last_update_login = Okl_Api.G_MISS_NUM)
      THEN
        x_acv_rec.last_update_login := l_acv_rec.last_update_login;

Line: 1562


    UPDATE  OKL_ANSR_CRTRN_VALS
    SET AWR_ID = l_def_acv_rec.awr_id,
        ASR_ID = l_def_acv_rec.asr_id,
        ASV_ID = l_def_acv_rec.asv_id,
        OBJECT_VERSION_NUMBER = l_def_acv_rec.object_version_number,
        ATTRIBUTE_CATEGORY = l_def_acv_rec.attribute_category,
        ATTRIBUTE1 = l_def_acv_rec.attribute1,
        ATTRIBUTE2 = l_def_acv_rec.attribute2,
        ATTRIBUTE3 = l_def_acv_rec.attribute3,
        ATTRIBUTE4 = l_def_acv_rec.attribute4,
        ATTRIBUTE5 = l_def_acv_rec.attribute5,
        ATTRIBUTE6 = l_def_acv_rec.attribute6,
        ATTRIBUTE7 = l_def_acv_rec.attribute7,
        ATTRIBUTE8 = l_def_acv_rec.attribute8,
        ATTRIBUTE9 = l_def_acv_rec.attribute9,
        ATTRIBUTE10 = l_def_acv_rec.attribute10,
        ATTRIBUTE11 = l_def_acv_rec.attribute11,
        ATTRIBUTE12 = l_def_acv_rec.attribute12,
        ATTRIBUTE13 = l_def_acv_rec.attribute13,
        ATTRIBUTE14 = l_def_acv_rec.attribute14,
        ATTRIBUTE15 = l_def_acv_rec.attribute15,
        CREATED_BY = l_def_acv_rec.created_by,
        CREATION_DATE = l_def_acv_rec.creation_date,
        LAST_UPDATED_BY = l_def_acv_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_acv_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_acv_rec.last_update_login
    WHERE ID = l_def_acv_rec.id;

Line: 1623


  END update_row;

Line: 1627


  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_acvv_rec                     IN acvv_rec_type,
    x_acvv_rec                     OUT NOCOPY acvv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1637


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

Line: 1651


      l_acvv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 1652


      l_acvv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;

Line: 1653


      l_acvv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;

Line: 1765


      IF (x_acvv_rec.last_updated_by = Okl_Api.G_MISS_NUM)
      THEN
        x_acvv_rec.last_updated_by := l_acvv_rec.last_updated_by;

Line: 1769


      IF (x_acvv_rec.last_update_date = Okl_Api.G_MISS_DATE)
      THEN
        x_acvv_rec.last_update_date := l_acvv_rec.last_update_date;

Line: 1773


      IF (x_acvv_rec.last_update_login = Okl_Api.G_MISS_NUM)
      THEN
        x_acvv_rec.last_update_login := l_acvv_rec.last_update_login;

Line: 1844


    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_acv_rec,
      lx_acv_rec
    );

Line: 1891


  END update_row;

Line: 1895


  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_acvv_tbl                     IN acvv_tbl_type,
    x_acvv_tbl                     OUT NOCOPY acvv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1905


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

Line: 1914


        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_acvv_rec                     => p_acvv_tbl(i),
          x_acvv_rec                     => x_acvv_tbl(i));

Line: 1957


  END update_row;

Line: 1965


  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_acv_rec                      IN acv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1973


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

Line: 1987


    DELETE FROM OKL_ANSR_CRTRN_VALS
     WHERE ID = l_acv_rec.id;

Line: 2022


  END delete_row;

Line: 2026


  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_acvv_rec                     IN acvv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2035


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

Line: 2059


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

Line: 2103


  END delete_row;

Line: 2107


  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_acvv_tbl                     IN acvv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2116


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

Line: 2125


        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_acvv_rec                     => p_acvv_tbl(i));

Line: 2167


  END delete_row;