DBA Data[Home] [Help]

APPS.FA_DISTRIBUTION_PVT dependencies on FA_ADDITIONS_B

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;