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

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

Line: 11


    DELETE FROM OKL_ASSET_COMPONENTS_TL T
    WHERE NOT EXISTS (SELECT NULL FROM OKL_ASSET_COMPONENTS_B B WHERE B.ID =T.ID);

Line: 14


    UPDATE OKL_ASSET_COMPONENTS_TL T
    SET (SHORT_DESCRIPTION,
        DESCRIPTION,
        COMMENTS) =
                     (SELECT
                      B.SHORT_DESCRIPTION,
                      B.DESCRIPTION,
                      B.COMMENTS
                      FROM
                      OKL_ASSET_COMPONENTS_TL B
                      WHERE
                      B.ID = T.ID
                      AND B.LANGUAGE = T.SOURCE_LANG)
    WHERE (T.ID, T.LANGUAGE) IN (SELECT
                                 SUBT.ID,
                                 SUBT.LANGUAGE
                                 FROM
                                 OKL_ASSET_COMPONENTS_TL SUBB,
                                 OKL_ASSET_COMPONENTS_TL SUBT
                                 WHERE
                                 SUBB.ID = SUBT.ID
                                 AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
                                 AND (SUBB.SHORT_DESCRIPTION <> SUBT.SHORT_DESCRIPTION
                                      OR (SUBB.DESCRIPTION <> SUBT.DESCRIPTION)
                                      OR (SUBB.COMMENTS <> SUBT.COMMENTS)
                                      OR (SUBB.SHORT_DESCRIPTION IS NULL AND SUBT.SHORT_DESCRIPTION IS NOT NULL)
                                      OR (SUBB.DESCRIPTION IS NULL AND SUBT.DESCRIPTION IS NOT NULL)
                                      OR (SUBB.COMMENTS IS NULL AND SUBT.COMMENTS IS NOT NULL)
                                     )
                                );

Line: 45


    INSERT INTO OKL_ASSET_COMPONENTS_TL (
        ID,
        LANGUAGE,
        SOURCE_LANG,
        SFWT_FLAG,
        CREATED_BY,
        CREATION_DATE,
        LAST_UPDATED_BY,
        LAST_UPDATE_DATE,
        LAST_UPDATE_LOGIN,
        SHORT_DESCRIPTION,
        DESCRIPTION,
        COMMENTS)
      SELECT
            B.ID,
            L.LANGUAGE_CODE,
            B.SOURCE_LANG,
            B.SFWT_FLAG,
            B.CREATED_BY,
            B.CREATION_DATE,
            B.LAST_UPDATED_BY,
            B.LAST_UPDATE_DATE,
            B.LAST_UPDATE_LOGIN,
            B.SHORT_DESCRIPTION,
            B.DESCRIPTION,
            B.COMMENTS
        FROM OKL_ASSET_COMPONENTS_TL B, FND_LANGUAGES L
       WHERE L.INSTALLED_FLAG IN ('I', 'B')
         AND B.LANGUAGE = USERENV('LANG')
         AND NOT EXISTS (
                    SELECT NULL
                      FROM OKL_ASSET_COMPONENTS_TL T
                     WHERE T.ID = B.ID
                       AND T.LANGUAGE = L.LANGUAGE_CODE
                    );

Line: 200


    SELECT
      id
      ,object_version_number
      ,attribute_category
      ,attribute1
      ,attribute2
      ,attribute3
      ,attribute4
      ,attribute5
      ,attribute6
      ,attribute7
      ,attribute8
      ,attribute9
      ,attribute10
      ,attribute11
      ,attribute12
      ,attribute13
      ,attribute14
      ,attribute15
      ,asset_id
      ,inv_item_id
      ,supplier_id
      ,primary_component
      ,unit_cost
      ,number_of_units
      ,manufacturer_name
      ,year_manufactured
      ,model_number
      ,short_description
      ,description
      ,comments
    INTO
      l_asov_rec.id
      ,l_asov_rec.object_version_number
      ,l_asov_rec.attribute_category
      ,l_asov_rec.attribute1
      ,l_asov_rec.attribute2
      ,l_asov_rec.attribute3
      ,l_asov_rec.attribute4
      ,l_asov_rec.attribute5
      ,l_asov_rec.attribute6
      ,l_asov_rec.attribute7
      ,l_asov_rec.attribute8
      ,l_asov_rec.attribute9
      ,l_asov_rec.attribute10
      ,l_asov_rec.attribute11
      ,l_asov_rec.attribute12
      ,l_asov_rec.attribute13
      ,l_asov_rec.attribute14
      ,l_asov_rec.attribute15
      ,l_asov_rec.asset_id
      ,l_asov_rec.inv_item_id
      ,l_asov_rec.supplier_id
      ,l_asov_rec.primary_component
      ,l_asov_rec.unit_cost
      ,l_asov_rec.number_of_units
      ,l_asov_rec.manufacturer_name
      ,l_asov_rec.year_manufactured
      ,l_asov_rec.model_number
      ,l_asov_rec.short_description
      ,l_asov_rec.description
      ,l_asov_rec.comments
    FROM OKL_ASSET_COMPONENTS_V
    WHERE id = p_id;

Line: 458


  PROCEDURE insert_row (x_return_status OUT NOCOPY VARCHAR2, p_aso_rec IN aso_rec_type) IS

    l_prog_name  VARCHAR2(61);

Line: 464


    l_prog_name := G_PKG_NAME||'.insert_row (B)';

Line: 466


    INSERT INTO okl_asset_components_b (
      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
      ,asset_id
      ,inv_item_id
      ,supplier_id
      ,primary_component
      ,unit_cost
      ,number_of_units
      ,manufacturer_name
      ,year_manufactured
      ,model_number
      )
    VALUES
      (
       p_aso_rec.id
      ,p_aso_rec.object_version_number
      ,p_aso_rec.attribute_category
      ,p_aso_rec.attribute1
      ,p_aso_rec.attribute2
      ,p_aso_rec.attribute3
      ,p_aso_rec.attribute4
      ,p_aso_rec.attribute5
      ,p_aso_rec.attribute6
      ,p_aso_rec.attribute7
      ,p_aso_rec.attribute8
      ,p_aso_rec.attribute9
      ,p_aso_rec.attribute10
      ,p_aso_rec.attribute11
      ,p_aso_rec.attribute12
      ,p_aso_rec.attribute13
      ,p_aso_rec.attribute14
      ,p_aso_rec.attribute15
      ,G_USER_ID
      ,SYSDATE
      ,G_USER_ID
      ,SYSDATE
      ,G_LOGIN_ID
      ,p_aso_rec.asset_id
      ,p_aso_rec.inv_item_id
      ,p_aso_rec.supplier_id
      ,p_aso_rec.primary_component
      ,p_aso_rec.unit_cost
      ,p_aso_rec.number_of_units
      ,p_aso_rec.manufacturer_name
      ,p_aso_rec.year_manufactured
      ,p_aso_rec.model_number
    );

Line: 553


  END insert_row;

Line: 559


  PROCEDURE insert_row (x_return_status OUT NOCOPY VARCHAR2, p_asotl_rec IN asotl_rec_type) IS

    CURSOR get_languages IS
      SELECT language_code
        FROM FND_LANGUAGES
       WHERE INSTALLED_FLAG IN ('I', 'B');

Line: 572


    l_prog_name := G_PKG_NAME||'.insert_row (TL)';

Line: 582


      INSERT INTO OKL_ASSET_COMPONENTS_TL (
        id
       ,language
       ,source_lang
       ,sfwt_flag
       ,created_by
       ,creation_date
       ,last_updated_by
       ,last_update_date
       ,last_update_login
       ,short_description
       ,description
       ,comments)
      VALUES (
        p_asotl_rec.id
       ,l_lang_rec.language_code
       ,USERENV('LANG')
       ,l_sfwt_flag
       ,G_USER_ID
       ,SYSDATE
       ,G_USER_ID
       ,SYSDATE
       ,G_LOGIN_ID
       ,p_asotl_rec.short_description
       ,p_asotl_rec.description
       ,p_asotl_rec.comments);

Line: 628


  END insert_row;

Line: 634


  PROCEDURE insert_row (
    x_return_status                OUT NOCOPY VARCHAR2,
    p_asov_rec                     IN asov_rec_type,
    x_asov_rec                     OUT NOCOPY asov_rec_type) IS

    l_return_status                VARCHAR2(1);

Line: 649


    l_prog_name := G_PKG_NAME||'.insert_row (V)';

Line: 653


    SELECT okl_aso_seq.nextval INTO l_asov_rec.ID FROM DUAL;

Line: 676


    insert_row (x_return_status => l_return_status, p_aso_rec => l_aso_rec);

Line: 684


    insert_row (x_return_status => l_return_status, p_asotl_rec => l_asotl_rec);

Line: 718


  END insert_row;

Line: 724


  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_asov_rec                     IN asov_rec_type,
    x_asov_rec                     OUT NOCOPY asov_rec_type) IS

    l_return_status              VARCHAR2(1);

Line: 739


    l_prog_name := G_PKG_NAME||'.insert_row (REC)';

Line: 745


    insert_row (x_return_status                => l_return_status,
                p_asov_rec                     => p_asov_rec,
                x_asov_rec                     => x_asov_rec);

Line: 780


  END insert_row;

Line: 786


  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_asov_tbl                     IN asov_tbl_type,
    x_asov_tbl                     OUT NOCOPY asov_tbl_type) IS

    l_return_status              VARCHAR2(1);

Line: 802


    l_prog_name := G_PKG_NAME||'.insert_row (TBL)';

Line: 813


          insert_row (x_return_status                => l_return_status,
                      p_asov_rec                     => p_asov_tbl(i),
                      x_asov_rec                     => x_asov_tbl(i));

Line: 861


  END insert_row;

Line: 874


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_ASSET_COMPONENTS_B
     WHERE ID = p_aso_rec.id
       AND OBJECT_VERSION_NUMBER = p_aso_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 881


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_ASSET_COMPONENTS_B
     WHERE ID = p_aso_rec.id;

Line: 968


  PROCEDURE update_row(x_return_status OUT NOCOPY VARCHAR2, p_aso_rec IN aso_rec_type) IS

    l_return_status           VARCHAR2(1);

Line: 976


    l_prog_name := G_PKG_NAME||'.update_row (B)';

Line: 986


    UPDATE okl_asset_components_b
    SET
      object_version_number = p_aso_rec.object_version_number+1
      ,attribute_category = p_aso_rec.attribute_category
      ,attribute1 = p_aso_rec.attribute1
      ,attribute2 = p_aso_rec.attribute2
      ,attribute3 = p_aso_rec.attribute3
      ,attribute4 = p_aso_rec.attribute4
      ,attribute5 = p_aso_rec.attribute5
      ,attribute6 = p_aso_rec.attribute6
      ,attribute7 = p_aso_rec.attribute7
      ,attribute8 = p_aso_rec.attribute8
      ,attribute9 = p_aso_rec.attribute9
      ,attribute10 = p_aso_rec.attribute10
      ,attribute11 = p_aso_rec.attribute11
      ,attribute12 = p_aso_rec.attribute12
      ,attribute13 = p_aso_rec.attribute13
      ,attribute14 = p_aso_rec.attribute14
      ,attribute15 = p_aso_rec.attribute15
      ,asset_id = p_aso_rec.asset_id
      ,inv_item_id = p_aso_rec.inv_item_id
      ,supplier_id = p_aso_rec.supplier_id
      ,primary_component = p_aso_rec.primary_component
      ,unit_cost = p_aso_rec.unit_cost
      ,number_of_units = p_aso_rec.number_of_units
      ,manufacturer_name = p_aso_rec.manufacturer_name
      ,year_manufactured = p_aso_rec.year_manufactured
      ,model_number = p_aso_rec.model_number
    WHERE id = p_aso_rec.id;

Line: 1038


  END update_row;

Line: 1044


  PROCEDURE update_row(x_return_status OUT NOCOPY VARCHAR2, p_asotl_rec IN asotl_rec_type) IS

    l_prog_name               VARCHAR2(61);

Line: 1050


    l_prog_name := G_PKG_NAME||'.update_row (TL)';

Line: 1052


    UPDATE OKL_ASSET_COMPONENTS_TL
    SET
      source_lang = USERENV('LANG')
      ,sfwt_flag = 'Y'
      ,last_updated_by = G_USER_ID
      ,last_update_date = SYSDATE
      ,last_update_login = G_LOGIN_ID
      ,short_description = p_asotl_rec.short_description
      ,description = p_asotl_rec.description
      ,comments = p_asotl_rec.comments
    WHERE ID = p_asotl_rec.id;

Line: 1064


    UPDATE OKL_ASSET_COMPONENTS_TL
    SET SFWT_FLAG = 'N'
    WHERE ID = p_asotl_rec.id
    AND SOURCE_LANG = LANGUAGE;

Line: 1086


  END update_row;

Line: 1092


  PROCEDURE update_row (
    x_return_status                OUT NOCOPY VARCHAR2,
    p_asov_rec                     IN asov_rec_type,
    x_asov_rec                     OUT NOCOPY asov_rec_type) IS

    l_prog_name                    VARCHAR2(61);

Line: 1241


    l_prog_name := G_PKG_NAME||'.update_row (V)';

Line: 1270


    update_row (x_return_status => l_return_status, p_aso_rec => l_aso_rec);

Line: 1278


    update_row (x_return_status => l_return_status, p_asotl_rec => l_asotl_rec);

Line: 1312


  END update_row;

Line: 1318


  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_asov_rec                     IN asov_rec_type,
    x_asov_rec                     OUT NOCOPY asov_rec_type) IS

    l_return_status              VARCHAR2(1);

Line: 1333


    l_prog_name := G_PKG_NAME||'.update_row (REC)';

Line: 1339


    update_row (x_return_status                => l_return_status,
                p_asov_rec                     => p_asov_rec,
                x_asov_rec                     => x_asov_rec);

Line: 1374


  END update_row;

Line: 1380


  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_asov_tbl                     IN asov_tbl_type,
    x_asov_tbl                     OUT NOCOPY asov_tbl_type) IS

    l_return_status              VARCHAR2(1);

Line: 1395


    l_prog_name := G_PKG_NAME||'.update_row (TBL)';

Line: 1410


          update_row (x_return_status                => l_return_status,
                      p_asov_rec                     => p_asov_tbl(i),
                      x_asov_rec                     => x_asov_tbl(i));

Line: 1458


  END update_row;

Line: 1464


  PROCEDURE delete_row(
    x_return_status                OUT NOCOPY VARCHAR2,
    p_id                           IN NUMBER) IS

    l_prog_name                  VARCHAR2(61);

Line: 1472


    l_prog_name := G_PKG_NAME||'.delete_row (V)';

Line: 1474


    DELETE FROM OKL_ASSET_COMPONENTS_B WHERE id = p_id;

Line: 1475


    DELETE FROM OKL_ASSET_COMPONENTS_TL WHERE id = p_id;

Line: 1494


  END delete_row;

Line: 1500


  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_asov_rec                     IN asov_rec_type) IS

    l_return_status              VARCHAR2(1);

Line: 1514


    l_prog_name := G_PKG_NAME||'.delete_row (REC)';

Line: 1520


    delete_row (x_return_status                => l_return_status,
                p_id                           => p_asov_rec.id);

Line: 1554


  END delete_row;

Line: 1560


  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_asov_tbl                     IN asov_tbl_type) IS

    l_return_status                VARCHAR2(1);

Line: 1575


    l_prog_name := G_PKG_NAME||'.delete_row (TBL)';

Line: 1589


          delete_row (x_return_status                => l_return_status,
                      p_id                           => p_asov_tbl(i).id);

Line: 1628


  END delete_row;