APPS.FA_DISTRIBUTION_PVT dependencies on FA_ADDITIONS

Line 309: -- update fa_additions

305: end if;
306: end if;
307:
308:
309: -- update fa_additions
310: if not update_additions(l_trans_rec,
311: l_asset_hdr_rec,
312: px_asset_cat_rec_new,
313: l_asset_desc_rec_new

Line 909: from fa_additions

905:
906: BEGIN
907: select current_units
908: into l_ad_units
909: from fa_additions
910: where asset_id = p_asset_hdr_rec.asset_id;
911:
912: select units
913: into l_ah_units

Line 1173: update fa_additions_b

1169: RETURN BOOLEAN IS
1170:
1171: BEGIN
1172: if (p_trans_rec.transaction_type_code in ('UNIT ADJUSTMENT','TRANSFER OUT')) then
1173: update fa_additions_b
1174: set current_units = p_asset_desc_rec_new.current_units,
1175: last_update_date = p_trans_rec.who_info.last_update_date,
1176: last_update_login = p_trans_rec.who_info.last_update_login,
1177: last_updated_by = p_trans_rec.who_info.last_updated_by

Line 1187: update fa_additions_b

1183: end if;
1184:
1185: -- Bug 3148518 : Assign context with context value not attribute_category_code
1186:
1187: update fa_additions_b
1188: set asset_category_id = p_asset_cat_rec_new.category_id,
1189: property_type_code = fa_cache_pkg.fazcat_record.property_type_code,
1190: property_1245_1250_code = fa_cache_pkg.fazcat_record.property_1245_1250_code,
1191: owned_leased = fa_cache_pkg.fazcat_record.owned_leased,

Line 1232: update fa_additions_b

1228: where asset_id = p_asset_hdr_rec.asset_id;
1229: end if;
1230:
1231: if (p_trans_rec.transaction_type_code in ('TRANSFER','UNIT ADJUSTMENT')) then
1232: update fa_additions_b
1233: set unit_adjustment_flag = 'NO'
1234: where asset_id = p_asset_hdr_rec.asset_id
1235: and unit_adjustment_flag = 'YES';
1236: end if;