APPS.OKL_TAL_PVT SQL Statements

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

Line: 60

    SELECT 1
    FROM DUAL
    WHERE EXISTS (SELECT id
                 FROM OKL_TRX_ASSETS
                 WHERE id = p_id);

Line: 139

    SELECT 1
    FROM DUAL
    WHERE EXISTS (SELECT id1
                 FROM OKX_AST_LOCS_V
                 WHERE id1 = p_id
                 AND id2 = G_ID2);

Line: 213

    SELECT 1
    FROM DUAL
    WHERE EXISTS (SELECT id1
                 FROM OKX_AST_LOCS_V
                 WHERE id1 = p_id
                 AND id2 = G_ID2);

Line: 287

    SELECT 1
    FROM DUAL
    WHERE EXISTS (SELECT id1
                 FROM OKX_ASST_CATGRS_V
                 WHERE id1 = p_id
                 AND id2 = G_ID2);

Line: 361

    SELECT 1
    FROM DUAL
    WHERE EXISTS (SELECT id1
                 FROM OKX_ASST_CATGRS_V
                 WHERE id1 = p_id
                 AND id2 = G_ID2);

Line: 436

    SELECT 1
    FROM DUAL
    WHERE EXISTS (SELECT id
                 FROM OKL_K_LINES_V
                 WHERE id = p_id);

Line: 576

  SELECT 1
  FROM DUAL
  WHERE EXISTS (SELECT chrv.authoring_org_id
                FROM OKC_K_HEADERS_B chrv,
                     OKC_K_LINES_B cle,
                     OKL_K_LINES_V kle
                WHERE kle.id = p_kle_id
                AND kle.id = cle.id
                AND cle.dnz_chr_id = chrv.id
                AND chrv.authoring_org_id = p_org_id);

Line: 814

    SELECT 1
    FROM DUAL
    WHERE EXISTS (SELECT '1'
                  FROM OKX_ASST_CATGRS_V
                  WHERE id1 = p_id1
                  and id2 = G_ID2);

Line: 888

    SELECT 1
    FROM DUAL
    WHERE EXISTS (SELECT '1'
                  FROM OKX_AST_LOCS_V
                  WHERE id1 = p_fa_location_id
                  AND id2 = G_ID2);

Line: 965

    SELECT 1
    FROM DUAL
    WHERE EXISTS (SELECT '1'
                  FROM OKC_K_HEADERS_B chrv
                  WHERE chrv.id = p_dnz_khr_id);

Line: 1039

    SELECT 1
    FROM DUAL
    WHERE EXISTS (SELECT id1
                 FROM OKX_ASST_BK_CONTROLS_V
                 WHERE name = p_name
                 AND book_class = 'CORPORATE');

Line: 1113

    SELECT 1
    FROM DUAL
    WHERE EXISTS (SELECT method_code
                 FROM OKX_ASST_DEP_METHODS_V
                 WHERE method_code  = p_deprn_method);

Line: 1346

  select 'Y'
  from   FA_ASSET_KEYWORDS fak
  where  fak.CODE_COMBINATION_ID   = p_asset_key_id
  and    fak.enabled_flag          = 'Y';

Line: 1585

  SELECT 'Y'
  FROM   gl_daily_conversion_types
  WHERE  conversion_type = p_conv_type;

Line: 1590

  SELECT 'Y'
  FROM   gl_currencies
  WHERE  currency_code = p_curr_code
  AND    TRUNC(SYSDATE) BETWEEN NVL(TRUNC(start_date_active), TRUNC(SYSDATE)) AND
                                NVL(TRUNC(end_date_active), TRUNC(SYSDATE));

Line: 1600

      Select CURRENCY_CODE,CONVERSION_TYPE,CONVERSION_RATE,CONVERSION_RATE_DATE
        into var_curr_code,var_CONVERSION_TYPE,var_CONVERSION_RATE,var_CONVERSION_RATE_DATE
        from OKC_k_headers_all_b
       where ID=p_talv_rec.dnz_khr_id ;

Line: 1764

    DELETE FROM OKL_TXL_ASSETS_TL T
     WHERE NOT EXISTS (
        SELECT NULL
          FROM OKL_TXL_ASSETS_B B   --fixed bug 3321017 by kmotepal
         WHERE B.ID = T.ID
        );

Line: 1771

    UPDATE OKL_TXL_ASSETS_TL T SET (
        DESCRIPTION) = (SELECT
                                  B.DESCRIPTION
                                FROM OKL_TXL_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_TXL_ASSETS_TL SUBB, OKL_TXL_ASSETS_TL SUBT
               WHERE SUBB.ID = SUBT.ID
                 AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
                 AND (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
                      OR (SUBB.DESCRIPTION IS NULL AND SUBT.DESCRIPTION IS NOT NULL)
                      OR (SUBB.DESCRIPTION IS NOT NULL AND SUBT.DESCRIPTION IS NULL)
              ));

Line: 1791

    INSERT INTO OKL_TXL_ASSETS_TL (
        ID,
        LANGUAGE,
        SOURCE_LANG,
        SFWT_FLAG,
        DESCRIPTION,
        CREATED_BY,
        CREATION_DATE,
        LAST_UPDATED_BY,
        LAST_UPDATE_DATE,
        LAST_UPDATE_LOGIN)
      SELECT
            B.ID,
            L.LANGUAGE_CODE,
            B.SOURCE_LANG,
            B.SFWT_FLAG,
            B.DESCRIPTION,
            B.CREATED_BY,
            B.CREATION_DATE,
            B.LAST_UPDATED_BY,
            B.LAST_UPDATE_DATE,
            B.LAST_UPDATE_LOGIN
        FROM OKL_TXL_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_TXL_ASSETS_TL T
                     WHERE T.ID = B.ID
                       AND T.LANGUAGE = L.LANGUAGE_CODE
                    );

Line: 1833

    SELECT ID,
           OBJECT_VERSION_NUMBER,
           TAS_ID,
           ILO_ID,
           ILO_ID_OLD,
           IAY_ID,
           IAY_ID_NEW,
           KLE_ID,
           DNZ_KHR_ID,
           LINE_NUMBER,
           ORG_ID,
           TAL_TYPE,
           ASSET_NUMBER,
           FA_LOCATION_ID,
           ORIGINAL_COST,
           CURRENT_UNITS,
           MANUFACTURER_NAME,
           YEAR_MANUFACTURED,
           SUPPLIER_ID,
           USED_ASSET_YN,
           TAG_NUMBER,
           MODEL_NUMBER,
           CORPORATE_BOOK,
           DATE_PURCHASED,
           DATE_DELIVERY,
           IN_SERVICE_DATE,
           LIFE_IN_MONTHS,
           DEPRECIATION_ID,
           DEPRECIATION_COST,
           DEPRN_METHOD,
           DEPRN_RATE,
           SALVAGE_VALUE,
           PERCENT_SALVAGE_VALUE,
--Bug# 2981308
           ASSET_KEY_ID,
-- Bug# 4028371
           FA_TRX_DATE,
--Bug# 4899328
           FA_COST,
           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,
           DEPRECIATE_YN,
           HOLD_PERIOD_DAYS,
           OLD_SALVAGE_VALUE,
           NEW_RESIDUAL_VALUE,
           OLD_RESIDUAL_VALUE,
           UNITS_RETIRED,
           COST_RETIRED,
           SALE_PROCEEDS,
           REMOVAL_COST,
           DNZ_ASSET_ID,
           DATE_DUE,
           REP_ASSET_ID,
           LKE_ASSET_ID,
           MATCH_AMOUNT,
           SPLIT_INTO_SINGLES_FLAG,
           SPLIT_INTO_UNITS,
        -- Multi-Currency Change
           currency_code,
           currency_conversion_type,
           currency_conversion_rate,
           currency_conversion_date,
        -- Multi-Currency Change
        -- VRS Project - START
           RESIDUAL_SHR_PARTY_ID,
           RESIDUAL_SHR_AMOUNT,
           RETIREMENT_ID
        -- VRS Project - END
       FROM Okl_Txl_Assets_B
     WHERE okl_txl_assets_b.id  = p_id;

Line: 1986

              l_tal_rec.LAST_UPDATED_BY,
              l_tal_rec.LAST_UPDATE_DATE,
              l_tal_rec.LAST_UPDATE_LOGIN,
              l_tal_rec.DEPRECIATE_YN,
              l_tal_rec.HOLD_PERIOD_DAYS,
              l_tal_rec.OLD_SALVAGE_VALUE,
              l_tal_rec.NEW_RESIDUAL_VALUE,
              l_tal_rec.OLD_RESIDUAL_VALUE,
              l_tal_rec.UNITS_RETIRED,
              l_tal_rec.COST_RETIRED,
              l_tal_rec.SALE_PROCEEDS,
              l_tal_rec.REMOVAL_COST,
              l_tal_rec.DNZ_ASSET_ID,
              l_tal_rec.DATE_DUE,
              l_tal_rec.REP_ASSET_ID,
              l_tal_rec.LKE_ASSET_ID,
              l_tal_rec.MATCH_AMOUNT,
              l_tal_rec.SPLIT_INTO_SINGLES_FLAG,
              l_tal_rec.SPLIT_INTO_UNITS,
        -- Multi-Currency Change
              l_tal_rec.currency_code,
              l_tal_rec.currency_conversion_type,
              l_tal_rec.currency_conversion_rate,
              l_tal_rec.currency_conversion_date,
        -- Multi-Currency Change
        -- VRS Project - START
              l_tal_rec.RESIDUAL_SHR_PARTY_ID,
              l_tal_rec.RESIDUAL_SHR_AMOUNT,
              l_tal_rec.RETIREMENT_ID;

Line: 2037

    SELECT
            ID,
            LANGUAGE,
            SOURCE_LANG,
            SFWT_FLAG,
            DESCRIPTION,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okl_Txl_Assets_Tl
     WHERE okl_txl_assets_tl.id = p_id
       AND okl_txl_assets_tl.language = p_language;

Line: 2066

              l_okl_txl_assets_tl_rec.LAST_UPDATED_BY,
              l_okl_txl_assets_tl_rec.LAST_UPDATE_DATE,
              l_okl_txl_assets_tl_rec.LAST_UPDATE_LOGIN;

Line: 2089

    SELECT ID,
           OBJECT_VERSION_NUMBER,
           SFWT_FLAG,
           TAS_ID,
           ILO_ID,
           ILO_ID_OLD,
           IAY_ID,
           IAY_ID_NEW,
           KLE_ID,
           DNZ_KHR_ID,
           LINE_NUMBER,
           ORG_ID,
           TAL_TYPE,
           ASSET_NUMBER,
           DESCRIPTION,
           FA_LOCATION_ID,
           ORIGINAL_COST,
           CURRENT_UNITS,
           MANUFACTURER_NAME,
           YEAR_MANUFACTURED,
           SUPPLIER_ID,
           USED_ASSET_YN,
           TAG_NUMBER,
           MODEL_NUMBER,
           CORPORATE_BOOK,
           DATE_PURCHASED,
           DATE_DELIVERY,
           IN_SERVICE_DATE,
           LIFE_IN_MONTHS,
           DEPRECIATION_ID,
           DEPRECIATION_COST,
           DEPRN_METHOD,
           DEPRN_RATE,
           SALVAGE_VALUE,
           PERCENT_SALVAGE_VALUE,
--Bug# 2981308
           ASSET_KEY_ID,
-- Bug# 4028371
           FA_TRX_DATE,
-- Bug# 4899328
           FA_COST,
           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,
           DEPRECIATE_YN,
           HOLD_PERIOD_DAYS,
           OLD_SALVAGE_VALUE,
           NEW_RESIDUAL_VALUE,
           OLD_RESIDUAL_VALUE,
           UNITS_RETIRED,
           COST_RETIRED,
           SALE_PROCEEDS,
           REMOVAL_COST,
           DNZ_ASSET_ID,
           DATE_DUE,
           REP_ASSET_ID,
           LKE_ASSET_ID,
           MATCH_AMOUNT,
           SPLIT_INTO_SINGLES_FLAG,
           SPLIT_INTO_UNITS,
        -- Multi-Currency Change
           currency_code,
           currency_conversion_type,
           currency_conversion_rate,
           currency_conversion_date,
        -- Multi-Currency Change
        -- VRS Project - START
           RESIDUAL_SHR_PARTY_ID,
           RESIDUAL_SHR_AMOUNT,
           RETIREMENT_ID
        -- VRS Project - END
     FROM Okl_Txl_Assets_V
     WHERE okl_txl_assets_v.id  = p_id;

Line: 2246

              l_talv_rec.LAST_UPDATED_BY,
              l_talv_rec.LAST_UPDATE_DATE,
              l_talv_rec.LAST_UPDATE_LOGIN,
              l_talv_rec.DEPRECIATE_YN,
              l_talv_rec.HOLD_PERIOD_DAYS,
              l_talv_rec.OLD_SALVAGE_VALUE,
              l_talv_rec.NEW_RESIDUAL_VALUE,
              l_talv_rec.OLD_RESIDUAL_VALUE,
              l_talv_rec.UNITS_RETIRED,
              l_talv_rec.COST_RETIRED,
              l_talv_rec.SALE_PROCEEDS,
              l_talv_rec.REMOVAL_COST,
              l_talv_rec.DNZ_ASSET_ID,
              l_talv_rec.DATE_DUE,
              l_talv_rec.REP_ASSET_ID,
              l_talv_rec.LKE_ASSET_ID,
              l_talv_rec.MATCH_AMOUNT,
              l_talv_rec.SPLIT_INTO_SINGLES_FLAG,
              l_talv_rec.SPLIT_INTO_UNITS,
        -- Multi-Currency Change
              l_talv_rec.currency_code,
              l_talv_rec.currency_conversion_type,
              l_talv_rec.currency_conversion_rate,
              l_talv_rec.currency_conversion_date,
        -- Multi-Currency Change
          -- VRS Project - START
              l_talv_rec.RESIDUAL_SHR_PARTY_ID,
              l_talv_rec.RESIDUAL_SHR_AMOUNT,
              l_talv_rec.RETIREMENT_ID;

Line: 2466

    IF (l_talv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
      l_talv_rec.last_updated_by := NULL;

Line: 2469

    IF (l_talv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
      l_talv_rec.last_update_date := NULL;

Line: 2472

    IF (l_talv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN
      l_talv_rec.last_update_login := NULL;

Line: 2873

    p_to.last_updated_by := p_from.last_updated_by;

Line: 2874

    p_to.last_update_date := p_from.last_update_date;

Line: 2875

    p_to.last_update_login := p_from.last_update_login;

Line: 2967

    p_to.last_updated_by := p_from.last_updated_by;

Line: 2968

    p_to.last_update_date := p_from.last_update_date;

Line: 2969

    p_to.last_update_login := p_from.last_update_login;

Line: 3009

    p_to.last_updated_by := p_from.last_updated_by;

Line: 3010

    p_to.last_update_date := p_from.last_update_date;

Line: 3011

    p_to.last_update_login := p_from.last_update_login;

Line: 3023

    p_to.last_updated_by := p_from.last_updated_by;

Line: 3024

    p_to.last_update_date := p_from.last_update_date;

Line: 3025

    p_to.last_update_login := p_from.last_update_login;

Line: 3179

  PROCEDURE insert_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_tal_rec                      IN tal_rec_type,
    x_tal_rec                      OUT NOCOPY tal_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3188

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

Line: 3224

    INSERT INTO OKL_TXL_ASSETS_B(
        id,
        object_version_number,
        tas_id,
        ilo_id,
        ilo_id_old,
        iay_id,
        iay_id_new,
        kle_id,
        dnz_khr_id,
        line_number,
        org_id,
        tal_type,
        asset_number,
        fa_location_Id,
        original_cost,
        current_units,
        manufacturer_name,
        year_manufactured,
        supplier_id,
        used_asset_yn,
        tag_number,
        model_number,
        corporate_book,
        date_purchased,
        date_delivery,
        in_service_date,
        life_in_months,
        depreciation_id,
        depreciation_cost,
        deprn_method,
        deprn_rate,
        salvage_value,
        percent_salvage_value,
--Bug# 2981308
        asset_key_id,
-- Bug# 4028371
        fa_trx_date,
--Bug# 4899328
        fa_cost,
        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,
        depreciate_yn,
        hold_period_days,
        old_salvage_value,
        new_residual_value,
        old_residual_value,
        units_retired,
        cost_retired,
        sale_proceeds,
        removal_cost,
        dnz_asset_id,
        date_due,
        rep_asset_id,
        lke_asset_id,
        match_amount,
        split_into_singles_flag,
        split_into_units,
        -- Multi-Currency Change
        currency_code,
        currency_conversion_type,
        currency_conversion_rate,
        currency_conversion_date,
        -- Multi-Currency Change
        -- VRS Project - END
        RESIDUAL_SHR_PARTY_ID,
        RESIDUAL_SHR_AMOUNT,
        RETIREMENT_ID
        -- VRS Project - END
        )
      VALUES (
        l_tal_rec.id,
        l_tal_rec.object_version_number,
        l_tal_rec.tas_id,
        l_tal_rec.ilo_id,
        l_tal_rec.ilo_id_old,
        l_tal_rec.iay_id,
        l_tal_rec.iay_id_new,
        l_tal_rec.kle_id,
        l_tal_rec.dnz_khr_id,
        l_tal_rec.line_number,
        l_tal_rec.org_id,
        l_tal_rec.tal_type,
        l_tal_rec.asset_number,
        l_tal_rec.fa_location_id,
        l_tal_rec.original_cost,
        l_tal_rec.current_units,
        l_tal_rec.manufacturer_name,
        l_tal_rec.year_manufactured,
        l_tal_rec.supplier_id,
        l_tal_rec.used_asset_yn,
        l_tal_rec.tag_number,
        l_tal_rec.model_number,
        l_tal_rec.corporate_book,
        l_tal_rec.date_purchased,
        l_tal_rec.date_delivery,
        l_tal_rec.in_service_date,
        l_tal_rec.life_in_months,
        l_tal_rec.depreciation_id,
        l_tal_rec.depreciation_cost,
        l_tal_rec.deprn_method,
        l_tal_rec.deprn_rate,
        l_tal_rec.salvage_value,
        l_tal_rec.percent_salvage_value,
--Bug# 2981308
        l_tal_rec.asset_key_id,
-- Bug# 4028371
        l_tal_rec.fa_trx_date,
--bug# 4899328
        l_tal_rec.fa_cost,
        l_tal_rec.attribute_category,
        l_tal_rec.attribute1,
        l_tal_rec.attribute2,
        l_tal_rec.attribute3,
        l_tal_rec.attribute4,
        l_tal_rec.attribute5,
        l_tal_rec.attribute6,
        l_tal_rec.attribute7,
        l_tal_rec.attribute8,
        l_tal_rec.attribute9,
        l_tal_rec.attribute10,
        l_tal_rec.attribute11,
        l_tal_rec.attribute12,
        l_tal_rec.attribute13,
        l_tal_rec.attribute14,
        l_tal_rec.attribute15,
        l_tal_rec.created_by,
        l_tal_rec.creation_date,
        l_tal_rec.last_updated_by,
        l_tal_rec.last_update_date,
        l_tal_rec.last_update_login,
        l_tal_rec.depreciate_yn,
        l_tal_rec.hold_period_days,
        l_tal_rec.old_salvage_value,
        l_tal_rec.new_residual_value,
        l_tal_rec.old_residual_value,
        l_tal_rec.units_retired,
        l_tal_rec.cost_retired,
        l_tal_rec.sale_proceeds,
        l_tal_rec.removal_cost,
        l_tal_rec.dnz_asset_id,
        l_tal_rec.date_due,
        l_tal_rec.rep_asset_id,
        l_tal_rec.lke_asset_id,
        l_tal_rec.match_amount,
        l_tal_rec.split_into_singles_flag,
        l_tal_rec.split_into_units,
        -- Multi-Currency Change
        l_tal_rec.currency_code,
        l_tal_rec.currency_conversion_type,
        l_tal_rec.currency_conversion_rate,
        l_tal_rec.currency_conversion_date,
        -- Multi-Currency Change
        -- VRS Project - END
        l_tal_rec.RESIDUAL_SHR_PARTY_ID,
        l_tal_rec.RESIDUAL_SHR_AMOUNT,
        l_tal_rec.RETIREMENT_ID
        -- VRS Project - END
        );

Line: 3437

  END insert_row;

Line: 3441

  PROCEDURE insert_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_okl_txl_assets_tl_rec        IN okl_txl_assets_tl_rec_type,
    x_okl_txl_assets_tl_rec        OUT NOCOPY okl_txl_assets_tl_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3450

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

Line: 3455

      SELECT *
        FROM FND_LANGUAGES
       WHERE INSTALLED_FLAG IN ('I', 'B');

Line: 3494

      INSERT INTO OKL_TXL_ASSETS_TL(
          id,
          language,
          source_lang,
          sfwt_flag,
          description,
          created_by,
          creation_date,
          last_updated_by,
          last_update_date,
          last_update_login)
        VALUES (
          l_okl_txl_assets_tl_rec.id,
          l_okl_txl_assets_tl_rec.language,
          l_okl_txl_assets_tl_rec.source_lang,
          l_okl_txl_assets_tl_rec.sfwt_flag,
          l_okl_txl_assets_tl_rec.description,
          l_okl_txl_assets_tl_rec.created_by,
          l_okl_txl_assets_tl_rec.creation_date,
          l_okl_txl_assets_tl_rec.last_updated_by,
          l_okl_txl_assets_tl_rec.last_update_date,
          l_okl_txl_assets_tl_rec.last_update_login);

Line: 3551

  END insert_row;

Line: 3555

  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_talv_rec                     IN talv_rec_type,
    x_talv_rec                     OUT NOCOPY talv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3565

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

Line: 3584

      l_talv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 3585

      l_talv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 3586

      l_talv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 3701

    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_tal_rec,
      lx_tal_rec
    );

Line: 3715

    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_okl_txl_assets_tl_rec,
      lx_okl_txl_assets_tl_rec
    );

Line: 3763

  END insert_row;

Line: 3767

  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_talv_tbl                     IN talv_tbl_type,
    x_talv_tbl                     OUT NOCOPY talv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3777

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

Line: 3786

        insert_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => OKC_API.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_talv_rec                     => p_talv_tbl(i),
          x_talv_rec                     => x_talv_tbl(i));

Line: 3829

  END insert_row;

Line: 3847

    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_TXL_ASSETS_B
     WHERE ID = p_tal_rec.id
       AND OBJECT_VERSION_NUMBER = p_tal_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 3854

    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_TXL_ASSETS_B
    WHERE ID = p_tal_rec.id;

Line: 3895

      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 3904

      OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 3953

    SELECT *
      FROM OKL_TXL_ASSETS_TL
     WHERE ID = p_okl_txl_assets_tl_rec.id
    FOR UPDATE NOWAIT;

Line: 3989

      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 4190

  PROCEDURE update_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_tal_rec                      IN tal_rec_type,
    x_tal_rec                      OUT NOCOPY tal_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 4199

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

Line: 4436

      IF (x_tal_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_tal_rec.last_updated_by := l_tal_rec.last_updated_by;

Line: 4440

      IF (x_tal_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_tal_rec.last_update_date := l_tal_rec.last_update_date;

Line: 4444

      IF (x_tal_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_tal_rec.last_update_login := l_tal_rec.last_update_login;

Line: 4587

    UPDATE  OKL_TXL_ASSETS_B
    SET TAS_ID = l_def_tal_rec.tas_id,
        OBJECT_VERSION_NUMBER = l_def_tal_rec.object_version_number,
        ILO_ID = l_def_tal_rec.ilo_id,
        ILO_ID_OLD = l_def_tal_rec.ilo_id_old,
        IAY_ID = l_def_tal_rec.iay_id,
        IAY_ID_NEW = l_def_tal_rec.iay_id_new,
        KLE_ID = l_def_tal_rec.kle_id,
        DNZ_KHR_ID = l_def_tal_rec.dnz_khr_id,
        LINE_NUMBER = l_def_tal_rec.line_number,
        ORG_ID = l_def_tal_rec.org_id,
        TAL_TYPE = l_def_tal_rec.tal_type,
        ASSET_NUMBER = l_def_tal_rec.asset_number,
        FA_LOCATION_ID = l_def_tal_rec.fa_location_id,
        ORIGINAL_COST = l_def_tal_rec.original_cost,
        CURRENT_UNITS = l_def_tal_rec.current_units,
        MANUFACTURER_NAME = l_def_tal_rec.manufacturer_name,
        YEAR_MANUFACTURED = l_def_tal_rec.year_manufactured,
        SUPPLIER_ID = l_def_tal_rec.supplier_id,
        USED_ASSET_YN = l_def_tal_rec.used_asset_yn,
        TAG_NUMBER = l_def_tal_rec.tag_number,
        MODEL_NUMBER = l_def_tal_rec.model_number,
        CORPORATE_BOOK = l_def_tal_rec.corporate_book,
        DATE_PURCHASED = l_def_tal_rec.date_purchased,
        DATE_DELIVERY = l_def_tal_rec.date_delivery,
        IN_SERVICE_DATE = l_def_tal_rec.in_service_date,
        LIFE_IN_MONTHS = l_def_tal_rec.life_in_months,
        DEPRECIATION_ID = l_def_tal_rec.depreciation_id,
        DEPRECIATION_COST = l_def_tal_rec.depreciation_cost,
        DEPRN_METHOD = l_def_tal_rec.deprn_method,
        DEPRN_RATE = l_def_tal_rec.deprn_rate,
        SALVAGE_VALUE = l_def_tal_rec.salvage_value,
        PERCENT_SALVAGE_VALUE = l_def_tal_rec.percent_salvage_value,
--Bug# 2981308
        ASSET_KEY_ID = l_def_tal_rec.asset_key_id,
-- Bug# 4028371
        FA_TRX_DATE = l_def_tal_rec.fa_trx_date,
--Bug# 4899328
        FA_COST = l_def_tal_rec.fa_cost,
        ATTRIBUTE_CATEGORY = l_def_tal_rec.attribute_category,
        ATTRIBUTE1 = l_def_tal_rec.attribute1,
        ATTRIBUTE2 = l_def_tal_rec.attribute2,
        ATTRIBUTE3 = l_def_tal_rec.attribute3,
        ATTRIBUTE4 = l_def_tal_rec.attribute4,
        ATTRIBUTE5 = l_def_tal_rec.attribute5,
        ATTRIBUTE6 = l_def_tal_rec.attribute6,
        ATTRIBUTE7 = l_def_tal_rec.attribute7,
        ATTRIBUTE8 = l_def_tal_rec.attribute8,
        ATTRIBUTE9 = l_def_tal_rec.attribute9,
        ATTRIBUTE10 = l_def_tal_rec.attribute10,
        ATTRIBUTE11 = l_def_tal_rec.attribute11,
        ATTRIBUTE12 = l_def_tal_rec.attribute12,
        ATTRIBUTE13 = l_def_tal_rec.attribute13,
        ATTRIBUTE14 = l_def_tal_rec.attribute14,
        ATTRIBUTE15 = l_def_tal_rec.attribute15,
        CREATED_BY = l_def_tal_rec.created_by,
        CREATION_DATE = l_def_tal_rec.creation_date,
        LAST_UPDATED_BY = l_def_tal_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_tal_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_tal_rec.last_update_login,
        DEPRECIATE_YN = l_def_tal_rec.depreciate_yn,
        HOLD_PERIOD_DAYS = l_def_tal_rec.hold_period_days,
        OLD_SALVAGE_VALUE = l_def_tal_rec.old_salvage_value,
        NEW_RESIDUAL_VALUE = l_def_tal_rec.new_residual_value,
        OLD_RESIDUAL_VALUE = l_def_tal_rec.old_residual_value,
        UNITS_RETIRED = l_def_tal_rec.units_retired,
        COST_RETIRED = l_def_tal_rec.cost_retired,
        SALE_PROCEEDS = l_def_tal_rec.sale_proceeds,
        REMOVAL_COST = l_def_tal_rec.removal_cost,
        DNZ_ASSET_ID = l_def_tal_rec.dnz_asset_id,
        DATE_DUE = l_def_tal_rec.date_due,
        REP_ASSET_ID = l_def_tal_rec.rep_asset_id,
        LKE_ASSET_ID = l_def_tal_rec.lke_asset_id,
        MATCH_AMOUNT = l_def_tal_rec.match_amount,
        SPLIT_INTO_SINGLES_FLAG = l_def_tal_rec.split_into_singles_flag,
        SPLIT_INTO_UNITS = l_def_tal_rec.split_into_units,
        CURRENCY_CODE = l_def_tal_rec.currency_code,
        CURRENCY_CONVERSION_TYPE = l_def_tal_rec.currency_conversion_type,
        CURRENCY_CONVERSION_RATE = l_def_tal_rec.currency_conversion_rate,
        CURRENCY_CONVERSION_DATE = l_def_tal_rec.currency_conversion_date,

        -- VRS Project - START
        RESIDUAL_SHR_PARTY_ID =l_def_tal_rec.RESIDUAL_SHR_PARTY_ID,
        RESIDUAL_SHR_AMOUNT   =l_def_tal_rec.RESIDUAL_SHR_AMOUNT,
        RETIREMENT_ID = l_def_tal_rec.RETIREMENT_ID
        -- VRS Project - END

        WHERE ID = l_def_tal_rec.id;

Line: 4709

  END update_row;

Line: 4713

  PROCEDURE update_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_okl_txl_assets_tl_rec        IN okl_txl_assets_tl_rec_type,
    x_okl_txl_assets_tl_rec        OUT NOCOPY okl_txl_assets_tl_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 4722

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

Line: 4772

      IF (x_okl_txl_assets_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_okl_txl_assets_tl_rec.last_updated_by := l_okl_txl_assets_tl_rec.last_updated_by;

Line: 4776

      IF (x_okl_txl_assets_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_okl_txl_assets_tl_rec.last_update_date := l_okl_txl_assets_tl_rec.last_update_date;

Line: 4780

      IF (x_okl_txl_assets_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_okl_txl_assets_tl_rec.last_update_login := l_okl_txl_assets_tl_rec.last_update_login;

Line: 4826

    UPDATE  OKL_TXL_ASSETS_TL
    SET DESCRIPTION = l_def_okl_txl_assets_tl_rec.description,
        --Bug# 3641933 :
        SOURCE_LANG = l_def_okl_txl_assets_tl_rec.source_lang,
        CREATED_BY = l_def_okl_txl_assets_tl_rec.created_by,
        CREATION_DATE = l_def_okl_txl_assets_tl_rec.creation_date,
        LAST_UPDATED_BY = l_def_okl_txl_assets_tl_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_okl_txl_assets_tl_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_okl_txl_assets_tl_rec.last_update_login
    WHERE ID = l_def_okl_txl_assets_tl_rec.id
      --Bug# 3641933 :
      AND  USERENV('LANG') in (SOURCE_LANG,LANGUAGE);

Line: 4840

    UPDATE  OKL_TXL_ASSETS_TL
    SET SFWT_FLAG = 'Y'
    WHERE ID = l_def_okl_txl_assets_tl_rec.id
      AND SOURCE_LANG <> USERENV('LANG');

Line: 4878

  END update_row;

Line: 4882

  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_talv_rec                     IN talv_rec_type,
    x_talv_rec                     OUT NOCOPY talv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 4892

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

Line: 4909

      l_talv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 4910

      l_talv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 4911

      l_talv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 5158

      IF (x_talv_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_talv_rec.last_updated_by := l_talv_rec.last_updated_by;

Line: 5162

      IF (x_talv_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_talv_rec.last_update_date := l_talv_rec.last_update_date;

Line: 5166

      IF (x_talv_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_talv_rec.last_update_login := l_talv_rec.last_update_login;

Line: 5382

    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_okl_txl_assets_tl_rec,
      lx_okl_txl_assets_tl_rec
    );

Line: 5396

    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_tal_rec,
      lx_tal_rec
    );

Line: 5443

  END update_row;

Line: 5447

  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_talv_tbl                     IN talv_tbl_type,
    x_talv_tbl                     OUT NOCOPY talv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 5457

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

Line: 5466

        update_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => OKC_API.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_talv_rec                     => p_talv_tbl(i),
          x_talv_rec                     => x_talv_tbl(i));

Line: 5509

  END update_row;

Line: 5517

  PROCEDURE delete_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_tal_rec                      IN tal_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 5525

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

Line: 5539

    DELETE FROM OKL_TXL_ASSETS_B
     WHERE ID = l_tal_rec.id;

Line: 5574

  END delete_row;

Line: 5578

  PROCEDURE delete_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_okl_txl_assets_tl_rec        IN okl_txl_assets_tl_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 5586

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

Line: 5623

    DELETE FROM OKL_TXL_ASSETS_TL
     WHERE ID = l_okl_txl_assets_tl_rec.id;

Line: 5658

  END delete_row;

Line: 5662

  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_talv_rec                     IN talv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 5671

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

Line: 5697

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

Line: 5709

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

Line: 5753

  END delete_row;

Line: 5757

  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_talv_tbl                     IN talv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 5766

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

Line: 5775

        delete_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => OKC_API.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_talv_rec                     => p_talv_tbl(i));

Line: 5817

  END delete_row;