APPS.FA_DISTRIBUTION_PVT dependencies on FA_ASSET_HISTORY

Line 297: -- update fa_asset_history

293: ,p_log_level_rec => p_log_level_rec) then
294: raise error_found;
295: end if;
296:
297: -- update fa_asset_history
298: if px_trans_rec.transaction_type_code <> 'TRANSFER' then
299: if not update_asset_history(l_trans_rec,
300: l_asset_hdr_rec,
301: px_asset_cat_rec_new,

Line 914: from fa_asset_history

910: where asset_id = p_asset_hdr_rec.asset_id;
911:
912: select units
913: into l_ah_units
914: from fa_asset_history
915: where asset_id = p_asset_hdr_rec.asset_id
916: and date_ineffective IS NULL;
917:
918: select sum(units_assigned - nvl(transaction_units, 0))

Line 1059: from fa_asset_history ah

1055: transaction_header_id_out,
1056: last_update_date,
1057: last_updated_by,
1058: last_update_login
1059: from fa_asset_history ah
1060: where asset_id = l_asset_id
1061: and date_ineffective is null;
1062:
1063: ah_rec ah_cur%ROWTYPE;

Line 1090: FA_ASSET_HISTORY_PKG.Update_Row

1086: --
1087: if (p_asset_hdr_rec.period_of_addition = 'Y' and
1088: G_release = 11) then
1089:
1090: FA_ASSET_HISTORY_PKG.Update_Row
1091: (X_Rowid => ah_rec.Row_Id,
1092: X_Asset_Id => ah_rec.Asset_Id,
1093: X_Category_Id => p_asset_cat_rec_new.category_id,
1094: X_Asset_Type => ah_rec.Asset_Type,

Line 1113: FA_ASSET_HISTORY_PKG.Update_Row

1109:
1110: else
1111:
1112: -- terminate old_asset_history
1113: FA_ASSET_HISTORY_PKG.Update_Row
1114: (X_Rowid => ah_rec.Row_Id,
1115: X_Asset_Id => ah_rec.Asset_Id,
1116: X_Category_Id => ah_rec.Category_Id,
1117: X_Asset_Type => ah_rec.Asset_Type,

Line 1135: FA_ASSET_HISTORY_PKG.Insert_Row

1131: end if;
1132:
1133:
1134: -- insert new row with new units and new category if applicable
1135: FA_ASSET_HISTORY_PKG.Insert_Row
1136: (X_Rowid => l_rowid,
1137: X_Asset_Id => p_asset_hdr_rec.asset_id,
1138: X_Category_Id => p_asset_cat_rec_new.category_id,
1139: X_Asset_Type => ah_rec.asset_type,