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

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

Line: 11


    DELETE FROM OKL_ASSETS_TL T
    WHERE NOT EXISTS (SELECT NULL FROM OKL_ASSETS_B B WHERE B.ID =T.ID);

Line: 14


    UPDATE OKL_ASSETS_TL T
    SET (SHORT_DESCRIPTION,
        DESCRIPTION,
        COMMENTS) =
                     (SELECT
                      B.SHORT_DESCRIPTION,
                      B.DESCRIPTION,
                      B.COMMENTS
                      FROM
                      OKL_ASSETS_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_ASSETS_TL SUBB,
                                 OKL_ASSETS_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_ASSETS_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_ASSETS_TL B, FND_LANGUAGES L
       WHERE L.INSTALLED_FLAG IN ('I', 'B')
         AND B.LANGUAGE = USERENV('LANG')
         AND NOT EXISTS (
                    SELECT NULL
                      FROM OKL_ASSETS_TL T
                     WHERE T.ID = B.ID
                       AND T.LANGUAGE = L.LANGUAGE_CODE
                    );

Line: 221


    SELECT
      id
      ,object_version_number
      ,attribute_category
      ,attribute1
      ,attribute2
      ,attribute3
      ,attribute4
      ,attribute5
      ,attribute6
      ,attribute7
      ,attribute8
      ,attribute9
      ,attribute10
      ,attribute11
      ,attribute12
      ,attribute13
      ,attribute14
      ,attribute15
      ,parent_object_code
      ,parent_object_id
      ,asset_number
      ,install_site_id
      ,structured_pricing
      ,rate_template_id
      ,rate_card_id
      ,lease_rate_factor
      ,target_arrears
      ,oec
      ,oec_percentage
      ,end_of_term_value_default
      ,end_of_term_value
      ,orig_asset_id
      ,target_amount
      ,target_frequency
      ,short_description
      ,description
      ,comments
    INTO
      l_assv_rec.id
      ,l_assv_rec.object_version_number
      ,l_assv_rec.attribute_category
      ,l_assv_rec.attribute1
      ,l_assv_rec.attribute2
      ,l_assv_rec.attribute3
      ,l_assv_rec.attribute4
      ,l_assv_rec.attribute5
      ,l_assv_rec.attribute6
      ,l_assv_rec.attribute7
      ,l_assv_rec.attribute8
      ,l_assv_rec.attribute9
      ,l_assv_rec.attribute10
      ,l_assv_rec.attribute11
      ,l_assv_rec.attribute12
      ,l_assv_rec.attribute13
      ,l_assv_rec.attribute14
      ,l_assv_rec.attribute15
      ,l_assv_rec.parent_object_code
      ,l_assv_rec.parent_object_id
      ,l_assv_rec.asset_number
      ,l_assv_rec.install_site_id
      ,l_assv_rec.structured_pricing
      ,l_assv_rec.rate_template_id
      ,l_assv_rec.rate_card_id
      ,l_assv_rec.lease_rate_factor
      ,l_assv_rec.target_arrears
      ,l_assv_rec.oec
      ,l_assv_rec.oec_percentage
      ,l_assv_rec.end_of_term_value_default
      ,l_assv_rec.end_of_term_value
      ,l_assv_rec.orig_asset_id
      ,l_assv_rec.target_amount
      ,l_assv_rec.target_frequency
      ,l_assv_rec.short_description
      ,l_assv_rec.description
      ,l_assv_rec.comments
    FROM OKL_ASSETS_V
    WHERE id = p_id;

Line: 398


   SELECT 'Y'
   FROM okl_assets_b
   WHERE asset_number = cp_asset_number;

Line: 536


  PROCEDURE insert_row (x_return_status OUT NOCOPY VARCHAR2, p_ass_rec IN ass_rec_type) IS

    l_prog_name  VARCHAR2(61);

Line: 542


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

Line: 544


    INSERT INTO okl_assets_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
      ,parent_object_code
      ,parent_object_id
      ,asset_number
      ,install_site_id
      ,structured_pricing
      ,rate_template_id
      ,rate_card_id
      ,lease_rate_factor
      ,target_arrears
      ,oec
      ,oec_percentage
      ,end_of_term_value_default
      ,end_of_term_value
      ,orig_asset_id
      ,target_amount
      ,target_frequency
      )
    VALUES
      (
       p_ass_rec.id
      ,p_ass_rec.object_version_number
      ,p_ass_rec.attribute_category
      ,p_ass_rec.attribute1
      ,p_ass_rec.attribute2
      ,p_ass_rec.attribute3
      ,p_ass_rec.attribute4
      ,p_ass_rec.attribute5
      ,p_ass_rec.attribute6
      ,p_ass_rec.attribute7
      ,p_ass_rec.attribute8
      ,p_ass_rec.attribute9
      ,p_ass_rec.attribute10
      ,p_ass_rec.attribute11
      ,p_ass_rec.attribute12
      ,p_ass_rec.attribute13
      ,p_ass_rec.attribute14
      ,p_ass_rec.attribute15
      ,G_USER_ID
      ,SYSDATE
      ,G_USER_ID
      ,SYSDATE
      ,G_LOGIN_ID
      ,p_ass_rec.parent_object_code
      ,p_ass_rec.parent_object_id
      ,p_ass_rec.asset_number
      ,p_ass_rec.install_site_id
      ,p_ass_rec.structured_pricing
      ,p_ass_rec.rate_template_id
      ,p_ass_rec.rate_card_id
      ,p_ass_rec.lease_rate_factor
      ,p_ass_rec.target_arrears
      ,p_ass_rec.oec
      ,p_ass_rec.oec_percentage
      ,p_ass_rec.end_of_term_value_default
      ,p_ass_rec.end_of_term_value
      ,p_ass_rec.orig_asset_id
      ,p_ass_rec.target_amount
      ,p_ass_rec.target_frequency
    );

Line: 645


  END insert_row;

Line: 651


  PROCEDURE insert_row (x_return_status OUT NOCOPY VARCHAR2, p_asstl_rec IN asstl_rec_type) IS

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

Line: 664


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

Line: 674


      INSERT INTO OKL_ASSETS_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_asstl_rec.id
       ,l_lang_rec.language_code
       ,USERENV('LANG')
       ,l_sfwt_flag
       ,G_USER_ID
       ,SYSDATE
       ,G_USER_ID
       ,SYSDATE
       ,G_LOGIN_ID
       ,p_asstl_rec.short_description
       ,p_asstl_rec.description
       ,p_asstl_rec.comments);

Line: 720


  END insert_row;

Line: 726


  PROCEDURE insert_row (
    x_return_status                OUT NOCOPY VARCHAR2,
    p_assv_rec                     IN assv_rec_type,
    x_assv_rec                     OUT NOCOPY assv_rec_type) IS

    l_return_status                VARCHAR2(1);

Line: 741


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

Line: 746


      SELECT okl_ass_seq.nextval INTO l_assv_rec.id FROM DUAL;

Line: 770


    insert_row (x_return_status => l_return_status, p_ass_rec => l_ass_rec);

Line: 778


    insert_row (x_return_status => l_return_status, p_asstl_rec => l_asstl_rec);

Line: 812


  END insert_row;

Line: 818


  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_assv_rec                     IN assv_rec_type,
    x_assv_rec                     OUT NOCOPY assv_rec_type) IS

    l_return_status              VARCHAR2(1);

Line: 833


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

Line: 839


    insert_row (x_return_status                => l_return_status,
                p_assv_rec                     => p_assv_rec,
                x_assv_rec                     => x_assv_rec);

Line: 874


  END insert_row;

Line: 880


  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_assv_tbl                     IN assv_tbl_type,
    x_assv_tbl                     OUT NOCOPY assv_tbl_type) IS

    l_return_status              VARCHAR2(1);

Line: 896


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

Line: 907


          insert_row (x_return_status                => l_return_status,
                      p_assv_rec                     => p_assv_tbl(i),
                      x_assv_rec                     => x_assv_tbl(i));

Line: 955


  END insert_row;

Line: 968


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_ASSETS_B
     WHERE ID = p_ass_rec.id
       AND OBJECT_VERSION_NUMBER = p_ass_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 975


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_ASSETS_B
     WHERE ID = p_ass_rec.id;

Line: 1062


  PROCEDURE update_row(x_return_status OUT NOCOPY VARCHAR2, p_ass_rec IN ass_rec_type) IS

    l_return_status           VARCHAR2(1);

Line: 1070


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

Line: 1080


    UPDATE okl_assets_b
    SET
      object_version_number = p_ass_rec.object_version_number+1
      ,attribute_category = p_ass_rec.attribute_category
      ,attribute1 = p_ass_rec.attribute1
      ,attribute2 = p_ass_rec.attribute2
      ,attribute3 = p_ass_rec.attribute3
      ,attribute4 = p_ass_rec.attribute4
      ,attribute5 = p_ass_rec.attribute5
      ,attribute6 = p_ass_rec.attribute6
      ,attribute7 = p_ass_rec.attribute7
      ,attribute8 = p_ass_rec.attribute8
      ,attribute9 = p_ass_rec.attribute9
      ,attribute10 = p_ass_rec.attribute10
      ,attribute11 = p_ass_rec.attribute11
      ,attribute12 = p_ass_rec.attribute12
      ,attribute13 = p_ass_rec.attribute13
      ,attribute14 = p_ass_rec.attribute14
      ,attribute15 = p_ass_rec.attribute15
      ,parent_object_code = p_ass_rec.parent_object_code
      ,parent_object_id = p_ass_rec.parent_object_id
      ,asset_number = p_ass_rec.asset_number
      ,install_site_id = p_ass_rec.install_site_id
      ,structured_pricing = p_ass_rec.structured_pricing
      ,rate_template_id = p_ass_rec.rate_template_id
      ,rate_card_id = p_ass_rec.rate_card_id
      ,lease_rate_factor = p_ass_rec.lease_rate_factor
      ,target_arrears = p_ass_rec.target_arrears
      ,oec = p_ass_rec.oec
      ,oec_percentage = p_ass_rec.oec_percentage
      ,end_of_term_value_default = p_ass_rec.end_of_term_value_default
      ,end_of_term_value = p_ass_rec.end_of_term_value
      ,orig_asset_id = p_ass_rec.orig_asset_id
      ,target_amount = p_ass_rec.target_amount
      ,target_frequency = p_ass_rec.target_frequency
    WHERE id = p_ass_rec.id;

Line: 1139


  END update_row;

Line: 1145


  PROCEDURE update_row(x_return_status OUT NOCOPY VARCHAR2, p_asstl_rec IN asstl_rec_type) IS

    l_prog_name               VARCHAR2(61);

Line: 1151


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

Line: 1153


    UPDATE OKL_ASSETS_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_asstl_rec.short_description
      ,description = p_asstl_rec.description
      ,comments = p_asstl_rec.comments
    WHERE ID = p_asstl_rec.id;

Line: 1165


    UPDATE OKL_ASSETS_TL
    SET SFWT_FLAG = 'N'
    WHERE ID = p_asstl_rec.id
    AND SOURCE_LANG = LANGUAGE;

Line: 1187


  END update_row;

Line: 1193


  PROCEDURE update_row (
    x_return_status                OUT NOCOPY VARCHAR2,
    p_assv_rec                     IN assv_rec_type,
    x_assv_rec                     OUT NOCOPY assv_rec_type) IS

    l_prog_name                    VARCHAR2(61);

Line: 1361


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

Line: 1391


    update_row (x_return_status => l_return_status, p_ass_rec => l_ass_rec);

Line: 1399


    update_row (x_return_status => l_return_status, p_asstl_rec => l_asstl_rec);

Line: 1433


  END update_row;

Line: 1439


  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_assv_rec                     IN assv_rec_type,
    x_assv_rec                     OUT NOCOPY assv_rec_type) IS

    l_return_status              VARCHAR2(1);

Line: 1454


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

Line: 1460


    update_row (x_return_status                => l_return_status,
                p_assv_rec                     => p_assv_rec,
                x_assv_rec                     => x_assv_rec);

Line: 1495


  END update_row;

Line: 1501


  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_assv_tbl                     IN assv_tbl_type,
    x_assv_tbl                     OUT NOCOPY assv_tbl_type) IS

    l_return_status              VARCHAR2(1);

Line: 1516


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

Line: 1531


          update_row (x_return_status                => l_return_status,
                      p_assv_rec                     => p_assv_tbl(i),
                      x_assv_rec                     => x_assv_tbl(i));

Line: 1579


  END update_row;

Line: 1585


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

    l_prog_name                  VARCHAR2(61);

Line: 1593


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

Line: 1595


    DELETE FROM OKL_ASSETS_B WHERE id = p_id;

Line: 1596


    DELETE FROM OKL_ASSETS_TL WHERE id = p_id;

Line: 1615


  END delete_row;

Line: 1621


  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_assv_rec                     IN assv_rec_type) IS

    l_return_status              VARCHAR2(1);

Line: 1635


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

Line: 1641


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

Line: 1675


  END delete_row;

Line: 1681


  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_assv_tbl                     IN assv_tbl_type) IS

    l_return_status                VARCHAR2(1);

Line: 1696


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

Line: 1710


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

Line: 1749


  END delete_row;