APPS.FA_DISTRIBUTION_PVT dependencies on FA_ASSET_HISTORY

Line 233: -- update fa_asset_history

229: ,p_log_level_rec => p_log_level_rec) then
230: raise error_found;
231: end if;
232:
233: -- update fa_asset_history
234: if px_trans_rec.transaction_type_code <> 'TRANSFER' then
235: if not update_asset_history(l_trans_rec,
236: l_asset_hdr_rec,
237: px_asset_cat_rec_new,

Line 789: from fa_asset_history

785: where asset_id = p_asset_hdr_rec.asset_id;
786:
787: select units
788: into l_ah_units
789: from fa_asset_history
790: where asset_id = p_asset_hdr_rec.asset_id
791: and date_ineffective IS NULL;
792:
793: select sum(units_assigned - nvl(transaction_units, 0))

Line 922: from fa_asset_history ah

918: transaction_header_id_out,
919: last_update_date,
920: last_updated_by,
921: last_update_login
922: from fa_asset_history ah
923: where asset_id = l_asset_id
924: and date_ineffective is null;
925:
926: ah_rec ah_cur%ROWTYPE;

Line 954: FA_ASSET_HISTORY_PKG.Update_Row

950: -- SLA: opbsolete
951: /*
952: if (p_asset_hdr_rec.period_of_addition = 'Y') then
953:
954: FA_ASSET_HISTORY_PKG.Update_Row
955: (X_Rowid => ah_rec.Row_Id,
956: X_Asset_Id => ah_rec.Asset_Id,
957: X_Category_Id => p_asset_cat_rec_new.category_id,
958: X_Asset_Type => ah_rec.Asset_Type,

Line 978: FA_ASSET_HISTORY_PKG.Update_Row

974: else
975: */
976:
977: -- terminate old_asset_history
978: FA_ASSET_HISTORY_PKG.Update_Row
979: (X_Rowid => ah_rec.Row_Id,
980: X_Asset_Id => ah_rec.Asset_Id,
981: X_Category_Id => ah_rec.Category_Id,
982: X_Asset_Type => ah_rec.Asset_Type,

Line 1000: FA_ASSET_HISTORY_PKG.Insert_Row

996: end if;
997:
998:
999: -- insert new row with new units and new category if applicable
1000: FA_ASSET_HISTORY_PKG.Insert_Row
1001: (X_Rowid => l_rowid,
1002: X_Asset_Id => p_asset_hdr_rec.asset_id,
1003: X_Category_Id => p_asset_cat_rec_new.category_id,
1004: X_Asset_Type => ah_rec.asset_type,