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

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

Line: 61


    SELECT '1'
	FROM OKL_ANSR_SET_CRTRIA_B
	WHERE id = p_asvv_rec.asr_id;

Line: 110


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

Line: 253


    SELECT
            ID,
            ASR_ID,
            SEQUENCE_NUMBER,
            CRN_ID,
            ASV_TYPE,
            OBJECT_VERSION_NUMBER,
            CVM_FROM,
            CVM_TO,
            FROM_OBJECT_ID1,
            FROM_OBJECT_ID2,
            TO_OBJECT_ID1,
            TO_OBJECT_ID2,
            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_Set_Cn_Vls
     WHERE okl_ansr_set_cn_vls.id = p_id;

Line: 326


              l_asv_rec.LAST_UPDATED_BY,
              l_asv_rec.LAST_UPDATE_DATE,
              l_asv_rec.LAST_UPDATE_LOGIN;

Line: 349


    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            ASR_ID,
            CRN_ID,
            FROM_OBJECT_ID1,
            FROM_OBJECT_ID2,
            TO_OBJECT_ID1,
            TO_OBJECT_ID2,
            SEQUENCE_NUMBER,
            CVM_FROM,
            CVM_TO,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15,
            ASV_TYPE,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okl_Ansr_Set_Cn_Vls_V
     WHERE okl_ansr_set_cn_vls_v.id = p_id;

Line: 422


              l_asvv_rec.LAST_UPDATED_BY,
              l_asvv_rec.LAST_UPDATE_DATE,
              l_asvv_rec.LAST_UPDATE_LOGIN;

Line: 533


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

Line: 536


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

Line: 539


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

Line: 675


    p_to.last_updated_by := p_from.last_updated_by;

Line: 676


    p_to.last_update_date := p_from.last_update_date;

Line: 677


    p_to.last_update_login := p_from.last_update_login;

Line: 714


    p_to.last_updated_by := p_from.last_updated_by;

Line: 715


    p_to.last_update_date := p_from.last_update_date;

Line: 716


    p_to.last_update_login := p_from.last_update_login;

Line: 869


  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_asv_rec                      IN asv_rec_type,
    x_asv_rec                      OUT NOCOPY asv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 878


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

Line: 914


    INSERT INTO OKL_ANSR_SET_CN_VLS(
        id,
        asr_id,
        sequence_number,
        crn_id,
        asv_type,
        object_version_number,
        cvm_from,
        cvm_to,
        from_object_id1,
        from_object_id2,
        to_object_id1,
        to_object_id2,
        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_asv_rec.id,
        l_asv_rec.asr_id,
        l_asv_rec.sequence_number,
        l_asv_rec.crn_id,
        l_asv_rec.asv_type,
        l_asv_rec.object_version_number,
        l_asv_rec.cvm_from,
        l_asv_rec.cvm_to,
        l_asv_rec.from_object_id1,
        l_asv_rec.from_object_id2,
        l_asv_rec.to_object_id1,
        l_asv_rec.to_object_id2,
        l_asv_rec.attribute_category,
        l_asv_rec.attribute1,
        l_asv_rec.attribute2,
        l_asv_rec.attribute3,
        l_asv_rec.attribute4,
        l_asv_rec.attribute5,
        l_asv_rec.attribute6,
        l_asv_rec.attribute7,
        l_asv_rec.attribute8,
        l_asv_rec.attribute9,
        l_asv_rec.attribute10,
        l_asv_rec.attribute11,
        l_asv_rec.attribute12,
        l_asv_rec.attribute13,
        l_asv_rec.attribute14,
        l_asv_rec.attribute15,
        l_asv_rec.created_by,
        l_asv_rec.creation_date,
        l_asv_rec.last_updated_by,
        l_asv_rec.last_update_date,
        l_asv_rec.last_update_login);

Line: 1016


  END insert_row;

Line: 1020


  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_asvv_rec                     IN asvv_rec_type,
    x_asvv_rec                     OUT NOCOPY asvv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1030


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

Line: 1046


      l_asvv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 1047


      l_asvv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;

Line: 1048


      l_asvv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;

Line: 1112


    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_asv_rec,
      lx_asv_rec
    );

Line: 1160


  END insert_row;

Line: 1164


  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_asvv_tbl                     IN asvv_tbl_type,
    x_asvv_tbl                     OUT NOCOPY asvv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1174


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

Line: 1183


        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_asvv_rec                     => p_asvv_tbl(i),
          x_asvv_rec                     => x_asvv_tbl(i));

Line: 1226


  END insert_row;

Line: 1244


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_ANSR_SET_CN_VLS
     WHERE ID = p_asv_rec.id
       AND OBJECT_VERSION_NUMBER = p_asv_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1251


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_ANSR_SET_CN_VLS
    WHERE ID = p_asv_rec.id;

Line: 1292


      okl_api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1301


      okl_api.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 1488


  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_asv_rec                      IN asv_rec_type,
    x_asv_rec                      OUT NOCOPY asv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1497


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

Line: 1639


      IF (x_asv_rec.last_updated_by = okl_api.G_MISS_NUM)
      THEN
        x_asv_rec.last_updated_by := l_asv_rec.last_updated_by;

Line: 1643


      IF (x_asv_rec.last_update_date = okl_api.G_MISS_DATE)
      THEN
        x_asv_rec.last_update_date := l_asv_rec.last_update_date;

Line: 1647


      IF (x_asv_rec.last_update_login = okl_api.G_MISS_NUM)
      THEN
        x_asv_rec.last_update_login := l_asv_rec.last_update_login;

Line: 1691


    UPDATE  OKL_ANSR_SET_CN_VLS
    SET ASR_ID = l_def_asv_rec.asr_id,
        SEQUENCE_NUMBER = l_def_asv_rec.sequence_number,
        CRN_ID = l_def_asv_rec.crn_id,
        ASV_TYPE = l_def_asv_rec.asv_type,
        OBJECT_VERSION_NUMBER = l_def_asv_rec.object_version_number,
        CVM_FROM = l_def_asv_rec.cvm_from,
        CVM_TO = l_def_asv_rec.cvm_to,
        FROM_OBJECT_ID1 = l_def_asv_rec.from_object_id1,
        FROM_OBJECT_ID2 = l_def_asv_rec.from_object_id2,
        TO_OBJECT_ID1 = l_def_asv_rec.to_object_id1,
        TO_OBJECT_ID2 = l_def_asv_rec.to_object_id2,
        ATTRIBUTE_CATEGORY = l_def_asv_rec.attribute_category,
        ATTRIBUTE1 = l_def_asv_rec.attribute1,
        ATTRIBUTE2 = l_def_asv_rec.attribute2,
        ATTRIBUTE3 = l_def_asv_rec.attribute3,
        ATTRIBUTE4 = l_def_asv_rec.attribute4,
        ATTRIBUTE5 = l_def_asv_rec.attribute5,
        ATTRIBUTE6 = l_def_asv_rec.attribute6,
        ATTRIBUTE7 = l_def_asv_rec.attribute7,
        ATTRIBUTE8 = l_def_asv_rec.attribute8,
        ATTRIBUTE9 = l_def_asv_rec.attribute9,
        ATTRIBUTE10 = l_def_asv_rec.attribute10,
        ATTRIBUTE11 = l_def_asv_rec.attribute11,
        ATTRIBUTE12 = l_def_asv_rec.attribute12,
        ATTRIBUTE13 = l_def_asv_rec.attribute13,
        ATTRIBUTE14 = l_def_asv_rec.attribute14,
        ATTRIBUTE15 = l_def_asv_rec.attribute15,
        CREATED_BY = l_def_asv_rec.created_by,
        CREATION_DATE = l_def_asv_rec.creation_date,
        LAST_UPDATED_BY = l_def_asv_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_asv_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_asv_rec.last_update_login
    WHERE ID = l_def_asv_rec.id;

Line: 1759


  END update_row;

Line: 1763


  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_asvv_rec                     IN asvv_rec_type,
    x_asvv_rec                     OUT NOCOPY asvv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1773


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

Line: 1787


      l_asvv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 1788


      l_asvv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;

Line: 1789


      l_asvv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;

Line: 1929


      IF (x_asvv_rec.last_updated_by = okl_api.G_MISS_NUM)
      THEN
        x_asvv_rec.last_updated_by := l_asvv_rec.last_updated_by;

Line: 1933


      IF (x_asvv_rec.last_update_date = okl_api.G_MISS_DATE)
      THEN
        x_asvv_rec.last_update_date := l_asvv_rec.last_update_date;

Line: 1937


      IF (x_asvv_rec.last_update_login = okl_api.G_MISS_NUM)
      THEN
        x_asvv_rec.last_update_login := l_asvv_rec.last_update_login;

Line: 2008


    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_asv_rec,
      lx_asv_rec
    );

Line: 2055


  END update_row;

Line: 2059


  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_asvv_tbl                     IN asvv_tbl_type,
    x_asvv_tbl                     OUT NOCOPY asvv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2069


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

Line: 2078


        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_asvv_rec                     => p_asvv_tbl(i),
          x_asvv_rec                     => x_asvv_tbl(i));

Line: 2121


  END update_row;

Line: 2129


  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_asv_rec                      IN asv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2137


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

Line: 2151


    DELETE FROM OKL_ANSR_SET_CN_VLS
     WHERE ID = l_asv_rec.id;

Line: 2186


  END delete_row;

Line: 2190


  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_asvv_rec                     IN asvv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2199


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

Line: 2223


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

Line: 2267


  END delete_row;

Line: 2271


  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_asvv_tbl                     IN asvv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2280


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

Line: 2289


        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_asvv_rec                     => p_asvv_tbl(i));

Line: 2331


  END delete_row;