APPS.FA_DISTRIBUTION_PVT dependencies on FA_ADDITIONS

Line 245: -- update fa_additions

241: end if;
242: end if;
243:
244:
245: -- update fa_additions
246: if not update_additions(l_trans_rec,
247: l_asset_hdr_rec,
248: px_asset_cat_rec_new,
249: l_asset_desc_rec_new

Line 784: from fa_additions

780:
781: BEGIN
782: select current_units
783: into l_ad_units
784: from fa_additions
785: where asset_id = p_asset_hdr_rec.asset_id;
786:
787: select units
788: into l_ah_units

Line 1041: update fa_additions_b

1037: RETURN BOOLEAN IS
1038:
1039: BEGIN
1040: if (p_trans_rec.transaction_type_code in ('UNIT ADJUSTMENT','TRANSFER OUT')) then
1041: update fa_additions_b
1042: set current_units = p_asset_desc_rec_new.current_units,
1043: last_update_date = p_trans_rec.who_info.last_update_date,
1044: last_update_login = p_trans_rec.who_info.last_update_login,
1045: last_updated_by = p_trans_rec.who_info.last_updated_by

Line 1055: update fa_additions_b

1051: end if;
1052:
1053: -- Bug 3148518 : Assign context with context value not attribute_category_code
1054:
1055: update fa_additions_b
1056: set asset_category_id = p_asset_cat_rec_new.category_id,
1057: property_type_code = fa_cache_pkg.fazcat_record.property_type_code,
1058: property_1245_1250_code = fa_cache_pkg.fazcat_record.property_1245_1250_code,
1059: owned_leased = fa_cache_pkg.fazcat_record.owned_leased,

Line 1100: update fa_additions_b

1096:
1097: end if;
1098:
1099: if (p_trans_rec.transaction_type_code in ('TRANSFER','UNIT ADJUSTMENT')) then
1100: update fa_additions_b
1101: set unit_adjustment_flag = 'NO'
1102: where asset_id = p_asset_hdr_rec.asset_id
1103: and unit_adjustment_flag = 'YES';
1104: end if;