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

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

Line: 29


    SELECT 1
    FROM DUAL
    WHERE EXISTS (SELECT id
                  FROM okc_k_headers_b
                  WHERE id = p_dnz_chr_id);

Line: 109


    SELECT lse.lty_code
    FROM okc_k_lines_b cle,
         okc_line_styles_b lse
    WHERE cle.id = p_cle_id
    AND cle.lse_id = lse.id;

Line: 119


    SELECT 1
    FROM DUAL
    WHERE EXISTS (SELECT t1.id
                  FROM okc_line_styles_b t1
                       ,okc_line_styles_b t2
                       ,okc_line_styles_b t3
                       ,okc_subclass_top_line t4
                       ,okc_k_lines_b cle
                  WHERE t1.lty_code = p_code
                  AND cle.id = p_cle_id
                  AND cle.lse_id = t1.id
                  AND t2.lty_code = p_code2
                  AND t1.lse_parent_id = t2.id
                  AND t2.lse_parent_id = t3.id
                  AND t3.lty_code = G_FIN_LINE_LTY_CODE
                  AND t4.lse_id = t3.id
                  AND t4.scs_code = 'LEASE');

Line: 311


    SELECT  ID,
            MAJOR_VERSION,
            OBJECT_VERSION_NUMBER,
            DNZ_CHR_ID,
            IB_CLE_ID,
            NAME,
            DESCRIPTION,
            INVENTORY_ITEM_ID,
            CURRENT_SERIAL_NUMBER,
            INSTALL_SITE_USE_ID,
            QUANTITY,
            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,
	    --Added by dpsingh for LE uptake
            LEGAL_ENTITY_ID
      FROM Okl_Contract_Ib_Hv
      WHERE Okl_Contract_Ib_Hv.ID = p_id;

Line: 383


              l_vibv_rec.last_updated_by,
              l_vibv_rec.last_update_date,
              l_vibv_rec.last_update_login,
	      --Added by dpsingh for LE uptake
              l_vibv_rec.legal_entity_id;

Line: 428


    SELECT  ID,
            MAJOR_VERSION,
            OBJECT_VERSION_NUMBER,
            DNZ_CHR_ID,
            IB_CLE_ID,
            NAME,
            DESCRIPTION,
            INVENTORY_ITEM_ID,
            CURRENT_SERIAL_NUMBER,
            INSTALL_SITE_USE_ID,
            QUANTITY,
            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,
	    --Added by dpsingh for LE uptake
            LEGAL_ENTITY_ID
      FROM Okl_Contract_Ib_H
      WHERE Okl_Contract_Ib_H.ID = p_id;

Line: 500


              l_vib_rec.last_updated_by,
              l_vib_rec.last_update_date,
              l_vib_rec.last_update_login,
	      --Added by dpsingh for LE uptake
              l_vib_rec.legal_entity_id;

Line: 632


    IF (l_vibv_rec.last_updated_by = OKL_API.G_MISS_NUM ) THEN
      l_vibv_rec.last_updated_by := NULL;

Line: 635


    IF (l_vibv_rec.last_update_date = OKL_API.G_MISS_DATE ) THEN
      l_vibv_rec.last_update_date := NULL;

Line: 638


    IF (l_vibv_rec.last_update_login = OKL_API.G_MISS_NUM ) THEN
      l_vibv_rec.last_update_login := NULL;

Line: 765


    p_to.last_updated_by := p_from.last_updated_by;

Line: 766


    p_to.last_update_date := p_from.last_update_date;

Line: 767


    p_to.last_update_login := p_from.last_update_login;

Line: 808


    p_to.last_updated_by := p_from.last_updated_by;

Line: 809


    p_to.last_update_date := p_from.last_update_date;

Line: 810


    p_to.last_update_login := p_from.last_update_login;

Line: 963


  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_vib_rec                      IN vib_rec_type,
    x_vib_rec                      OUT NOCOPY vib_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 972


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

Line: 1008


    INSERT INTO OKL_CONTRACT_IB_H(
      id,
      major_version,
      object_version_number,
      dnz_chr_id,
      ib_cle_id,
      name,
      description,
      inventory_item_id,
      current_serial_number,
      install_site_use_id,
      quantity,
      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,
      --Added by dpsingh for LE uptake
      legal_entity_id)
    VALUES (
      l_vib_rec.id,
      l_vib_rec.major_version,
      l_vib_rec.object_version_number,
      l_vib_rec.dnz_chr_id,
      l_vib_rec.ib_cle_id,
      l_vib_rec.name,
      l_vib_rec.description,
      l_vib_rec.inventory_item_id,
      l_vib_rec.current_serial_number,
      l_vib_rec.install_site_use_id,
      l_vib_rec.quantity,
      l_vib_rec.attribute_category,
      l_vib_rec.attribute1,
      l_vib_rec.attribute2,
      l_vib_rec.attribute3,
      l_vib_rec.attribute4,
      l_vib_rec.attribute5,
      l_vib_rec.attribute6,
      l_vib_rec.attribute7,
      l_vib_rec.attribute8,
      l_vib_rec.attribute9,
      l_vib_rec.attribute10,
      l_vib_rec.attribute11,
      l_vib_rec.attribute12,
      l_vib_rec.attribute13,
      l_vib_rec.attribute14,
      l_vib_rec.attribute15,
      l_vib_rec.created_by,
      l_vib_rec.creation_date,
      l_vib_rec.last_updated_by,
      l_vib_rec.last_update_date,
      l_vib_rec.last_update_login,

     --Added by dpsingh for LE uptake
      l_vib_rec.legal_entity_id);

Line: 1114


  END insert_row;

Line: 1118


  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_vibv_rec                     IN vibv_rec_type,
    x_vibv_rec                     OUT NOCOPY vibv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1128


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

Line: 1144


      l_vibv_rec.LAST_UPDATE_DATE := l_vibv_rec.CREATION_DATE;

Line: 1145


      l_vibv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1146


      l_vibv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1210


    insert_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_vib_rec,
      lx_vib_rec
    );

Line: 1259


  END insert_row;

Line: 1263


  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_vibv_tbl                     IN vibv_tbl_type,
    x_vibv_tbl                     OUT NOCOPY vibv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1273


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

Line: 1281


        insert_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => p_init_msg_list,
            x_return_status                => x_return_status,
            x_msg_count                    => x_msg_count,
            x_msg_data                     => x_msg_data,
            p_vibv_rec                     => p_vibv_tbl(i),
            x_vibv_rec                     => x_vibv_tbl(i));

Line: 1325


  END insert_row;

Line: 1342


    SELECT OBJECT_VERSION_NUMBER
    FROM OKL_CONTRACT_IB_H
    WHERE OBJECT_VERSION_NUMBER = p_vib_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1348


    SELECT OBJECT_VERSION_NUMBER
    FROM OKL_CONTRACT_IB_H
    WHERE ID = p_vib_rec.id;

Line: 1388


      OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1397


      OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 1585


  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_vib_rec                      IN vib_rec_type,
    x_vib_rec                      OUT NOCOPY vib_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1594


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

Line: 1730


        IF (x_vib_rec.last_updated_by = OKL_API.G_MISS_NUM)
        THEN
          x_vib_rec.last_updated_by := l_vib_rec.last_updated_by;

Line: 1734


        IF (x_vib_rec.last_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_vib_rec.last_update_date := l_vib_rec.last_update_date;

Line: 1738


        IF (x_vib_rec.last_update_login = OKL_API.G_MISS_NUM)
        THEN
          x_vib_rec.last_update_login := l_vib_rec.last_update_login;

Line: 1789


    UPDATE OKL_CONTRACT_IB_H
    SET ID = l_def_vib_rec.id,
        MAJOR_VERSION = l_def_vib_rec.major_version,
        OBJECT_VERSION_NUMBER = l_def_vib_rec.object_version_number,
        DNZ_CHR_ID = l_def_vib_rec.dnz_chr_id,
        IB_CLE_ID = l_def_vib_rec.ib_cle_id,
        NAME = l_def_vib_rec.name,
        DESCRIPTION = l_def_vib_rec.description,
        INVENTORY_ITEM_ID = l_def_vib_rec.inventory_item_id,
        CURRENT_SERIAL_NUMBER = l_def_vib_rec.current_serial_number,
        INSTALL_SITE_USE_ID = l_def_vib_rec.install_site_use_id,
        QUANTITY = l_def_vib_rec.quantity,
        ATTRIBUTE_CATEGORY = l_def_vib_rec.attribute_category,
        ATTRIBUTE1 = l_def_vib_rec.attribute1,
        ATTRIBUTE2 = l_def_vib_rec.attribute2,
        ATTRIBUTE3 = l_def_vib_rec.attribute3,
        ATTRIBUTE4 = l_def_vib_rec.attribute4,
        ATTRIBUTE5 = l_def_vib_rec.attribute5,
        ATTRIBUTE6 = l_def_vib_rec.attribute6,
        ATTRIBUTE7 = l_def_vib_rec.attribute7,
        ATTRIBUTE8 = l_def_vib_rec.attribute8,
        ATTRIBUTE9 = l_def_vib_rec.attribute9,
        ATTRIBUTE10 = l_def_vib_rec.attribute10,
        ATTRIBUTE11 = l_def_vib_rec.attribute11,
        ATTRIBUTE12 = l_def_vib_rec.attribute12,
        ATTRIBUTE13 = l_def_vib_rec.attribute13,
        ATTRIBUTE14 = l_def_vib_rec.attribute14,
        ATTRIBUTE15 = l_def_vib_rec.attribute15,
        CREATED_BY = l_def_vib_rec.created_by,
        CREATION_DATE = l_def_vib_rec.creation_date,
        LAST_UPDATED_BY = l_def_vib_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_vib_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_vib_rec.last_update_login,
	--Added by dpsingh for LE uptake
        LEGAL_ENTITY_ID  = l_def_vib_rec.legal_entity_id
    WHERE ID = l_def_vib_rec.id;

Line: 1859


  END update_row;

Line: 1863


  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_vibv_rec                     IN vibv_rec_type,
    x_vibv_rec                     OUT NOCOPY vibv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1873


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

Line: 1888


      l_vibv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 1889


      l_vibv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1890


      l_vibv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 2022


        IF (x_vibv_rec.last_updated_by = OKL_API.G_MISS_NUM)
        THEN
          x_vibv_rec.last_updated_by := l_db_vibv_rec.last_updated_by;

Line: 2026


        IF (x_vibv_rec.last_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_vibv_rec.last_update_date := l_db_vibv_rec.last_update_date;

Line: 2030


        IF (x_vibv_rec.last_update_login = OKL_API.G_MISS_NUM)
        THEN
          x_vibv_rec.last_update_login := l_db_vibv_rec.last_update_login;

Line: 2105


    update_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_vib_rec,
      lx_vib_rec
    );

Line: 2153


  END update_row;

Line: 2157


  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_vibv_tbl                     IN vibv_tbl_type,
    x_vibv_tbl                     OUT NOCOPY vibv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2167


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

Line: 2175


        update_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => p_init_msg_list,
            x_return_status                => x_return_status,
            x_msg_count                    => x_msg_count,
            x_msg_data                     => x_msg_data,
            p_vibv_rec                     => p_vibv_tbl(i),
            x_vibv_rec                     => x_vibv_tbl(i));

Line: 2219


  END update_row;

Line: 2226


  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_vib_rec                      IN vib_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2234


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

Line: 2249


    DELETE FROM OKL_CONTRACT_IB_H
    WHERE ID = l_vib_rec.id;

Line: 2284


  END delete_row;

Line: 2288


  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_vibv_rec                     IN vibv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2297


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

Line: 2321


    delete_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_vib_rec
    );

Line: 2366


  END delete_row;

Line: 2370


  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_vibv_tbl                     IN vibv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2379


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

Line: 2387


        delete_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => p_init_msg_list,
            x_return_status                => x_return_status,
            x_msg_count                    => x_msg_count,
            x_msg_data                     => x_msg_data,
            p_vibv_rec                     => p_vibv_tbl(i));

Line: 2430


  END delete_row;