APPS.FA_DISTRIBUTION_PVT dependencies on FA_DISTRIBUTION_HISTORY

Line 109: from fa_distribution_history

105:
106: -- get current unit
107: select sum(units_assigned - nvl(transaction_units, 0))
108: into l_old_units
109: from fa_distribution_history
110: where asset_id = px_asset_hdr_rec.asset_id
111: and book_type_code = px_asset_hdr_rec.book_type_code
112: and date_ineffective IS NULL;
113:

Line 268: -- update fa_distribution_history

264: end if;
265:
266:
267: if (l_index = 1) then
268: -- update fa_distribution_history
269: if not update_dist_history(l_trans_rec,
270: l_asset_hdr_rec,
271: px_asset_dist_tbl
272: ,p_log_level_rec => p_log_level_rec) then

Line 379: from fa_distribution_history

375:
376: cursor DH_C1 is
377: select distribution_id,
378: units_assigned
379: from fa_distribution_history
380: where asset_id = l_asset_id
381: and nvl(assigned_to,-9999) = nvl(d_assigned_to,-9999)
382: and code_combination_id = d_expense_ccid
383: and location_id = d_location_ccid

Line 388: from fa_distribution_history

384: and date_ineffective is null;
385:
386: cursor DH_C2 is
387: select units_assigned
388: from fa_distribution_history
389: where asset_id = l_asset_id
390: and distribution_id = d_distribution_id;
391: -- and nvl(assigned_to,-9999) = nvl(d_assigned_to,-9999)
392: -- and code_combination_id = nvl(d_expense_ccid,code_combination_id)

Line 795: from fa_distribution_history

791: and date_ineffective IS NULL;
792:
793: select sum(units_assigned - nvl(transaction_units, 0))
794: into l_dh_units
795: from fa_distribution_history
796: where asset_id = p_asset_hdr_rec.asset_id
797: and book_type_code = p_asset_hdr_rec.book_type_code
798: and date_ineffective IS NULL;
799:

Line 1181: from fa_distribution_history dh

1177: RETURN BOOLEAN IS
1178:
1179: CURSOR dh_cur (l_asset_id IN NUMBER, l_distribution_id IN NUMBER) IS
1180: select dh.rowid row_id, dh.*
1181: from fa_distribution_history dh
1182: where asset_id = l_asset_id
1183: and distribution_id = l_distribution_id
1184: and date_ineffective is null;
1185:

Line 1237: FA_DISTRIBUTION_HISTORY_PKG.UPDATE_ROW

1233: if ((p_asset_dist_tbl(i).transaction_units +
1234: p_asset_dist_tbl(i).units_assigned) > 0) then
1235:
1236: -- terminate old row
1237: FA_DISTRIBUTION_HISTORY_PKG.UPDATE_ROW
1238: (X_Rowid => dh_rec.row_id,
1239: X_Distribution_Id => dh_rec.distribution_id,
1240: X_Book_Type_Code => dh_rec.book_type_code,
1241: X_Asset_Id => dh_rec.asset_id,

Line 1258: FA_DISTRIBUTION_HISTORY_PKG.INSERT_ROW

1254: X_Last_Update_Login => p_trans_rec.who_info.last_update_login,
1255: X_Calling_Fn => 'FA_DISTRIBUTION_PVT.update_dist_history');
1256:
1257: -- create new row with new units
1258: FA_DISTRIBUTION_HISTORY_PKG.INSERT_ROW
1259: (X_Rowid => l_rowid,
1260: X_Distribution_Id => l_distribution_id,
1261: X_Book_Type_Code => dh_rec.book_type_code,
1262: X_Asset_Id => dh_rec.asset_id,

Line 1280: FA_DISTRIBUTION_HISTORY_PKG.UPDATE_ROW

1276: X_Last_Update_Login => p_trans_rec.who_info.last_update_login,
1277: X_Calling_Fn => 'FA_DISTRIBUTION_PVT.update_dist_history');
1278:
1279: else -- full unit change, then terminate the row only
1280: FA_DISTRIBUTION_HISTORY_PKG.UPDATE_ROW
1281: (X_Rowid => dh_rec.row_id,
1282: X_Distribution_Id => dh_rec.distribution_id,
1283: X_Book_Type_Code => dh_rec.book_type_code,
1284: X_Asset_Id => dh_rec.asset_id,

Line 1303: FA_DISTRIBUTION_HISTORY_PKG.INSERT_ROW

1299: end if;
1300: l_tfr_det_dist_id := p_asset_dist_tbl(i).distribution_id;
1301: else
1302: -- create new row with new units
1303: FA_DISTRIBUTION_HISTORY_PKG.INSERT_ROW
1304: (X_Rowid => l_rowid,
1305: X_Distribution_Id => l_distribution_id,
1306: X_Book_Type_Code => p_asset_hdr_rec.book_type_code,
1307: X_Asset_Id => p_asset_hdr_rec.asset_id,