1573:
1574: h_asset_id := X_Asset_Id;
1575: h_asset_number := X_Asset_Number;
1576:
1577: user_id := fnd_load_util.owner_id (X_Owner);
1578:
1579: select count(*)
1580: into h_record_exists
1581: from fa_additions_b
1587: into db_last_updated_by, db_last_update_date
1588: from fa_additions_b
1589: where asset_id = X_Asset_Id;
1590:
1591: if (fnd_load_util.upload_test(user_id, x_last_update_date,
1592: db_last_updated_by, db_last_update_date,
1593: X_CUSTOM_MODE
1594: )) then
1595:
1825: from fa_additions_tl
1826: where userenv('LANG') in (LANGUAGE, SOURCE_LANG)
1827: and asset_id = X_Asset_ID;
1828:
1829: user_id := fnd_load_util.owner_id (X_Owner);
1830:
1831: if (fnd_load_util.upload_test(user_id, x_last_update_date,
1832: db_last_updated_by, db_last_update_date,
1833: X_CUSTOM_MODE )) then
1827: and asset_id = X_Asset_ID;
1828:
1829: user_id := fnd_load_util.owner_id (X_Owner);
1830:
1831: if (fnd_load_util.upload_test(user_id, x_last_update_date,
1832: db_last_updated_by, db_last_update_date,
1833: X_CUSTOM_MODE )) then
1834:
1835: update FA_ADDITIONS_TL set