APPS.FA_DISTRIBUTION_PVT dependencies on FA_DISTRIBUTION_HISTORY

Line 83: FROM fa_distribution_history

79: --Added for 8759611
80: CURSOR cur_dists_eff (c_asset_id NUMBER,c_transaction_id NUMBER,c_book VARCHAR2) IS
81: SELECT NULL distribution_id,units_assigned,units_assigned transaction_units,
82: code_combination_id expense_ccid,location_id location_ccid,assigned_to
83: FROM fa_distribution_history
84: WHERE asset_id = c_asset_id
85: AND transaction_header_id_in = c_transaction_id
86: AND book_type_code = c_book
87: UNION ALL

Line 90: FROM fa_distribution_history

86: AND book_type_code = c_book
87: UNION ALL
88: SELECT distribution_id,units_assigned,transaction_units,
89: code_combination_id expense_ccid,location_id location_ccid,assigned_to
90: FROM fa_distribution_history
91: WHERE asset_id = c_asset_id
92: AND transaction_header_id_out = c_transaction_id
93: AND book_type_code = c_book
94: ORDER BY distribution_id;

Line 135: from fa_distribution_history

131:
132: -- get current unit
133: select sum(units_assigned - nvl(transaction_units, 0))
134: into l_old_units
135: from fa_distribution_history
136: where asset_id = px_asset_hdr_rec.asset_id
137: and book_type_code = px_asset_hdr_rec.book_type_code
138: and date_ineffective IS NULL;
139:

Line 333: -- update fa_distribution_history

329: end if;
330:
331:
332: if (l_index = 1) then
333: -- update fa_distribution_history
334: if not update_dist_history(l_trans_rec,
335: l_asset_hdr_rec,
336: px_asset_dist_tbl
337: ,p_log_level_rec => p_log_level_rec) then

Line 523: from fa_distribution_history

519:
520: cursor DH_C1 is
521: select distribution_id,
522: units_assigned
523: from fa_distribution_history
524: where asset_id = l_asset_id
525: and nvl(assigned_to,-9999) = nvl(d_assigned_to,-9999)
526: and code_combination_id = d_expense_ccid
527: and location_id = d_location_ccid

Line 532: from fa_distribution_history

528: and date_ineffective is null;
529:
530: cursor DH_C2 is
531: select units_assigned
532: from fa_distribution_history
533: where asset_id = l_asset_id
534: and distribution_id = d_distribution_id;
535: -- and nvl(assigned_to,-9999) = nvl(d_assigned_to,-9999)
536: -- and code_combination_id = nvl(d_expense_ccid,code_combination_id)

Line 920: from fa_distribution_history

916: and date_ineffective IS NULL;
917:
918: select sum(units_assigned - nvl(transaction_units, 0))
919: into l_dh_units
920: from fa_distribution_history
921: where asset_id = p_asset_hdr_rec.asset_id
922: and book_type_code = p_asset_hdr_rec.book_type_code
923: and date_ineffective IS NULL;
924:

Line 1421: from fa_distribution_history dh

1417: RETURN BOOLEAN IS
1418:
1419: CURSOR dh_cur (l_asset_id IN NUMBER, l_distribution_id IN NUMBER) IS
1420: select dh.rowid row_id, dh.*
1421: from fa_distribution_history dh
1422: where asset_id = l_asset_id
1423: and distribution_id = l_distribution_id
1424: and date_ineffective is null;
1425:

Line 1477: FA_DISTRIBUTION_HISTORY_PKG.UPDATE_ROW

1473: if ((p_asset_dist_tbl(i).transaction_units +
1474: p_asset_dist_tbl(i).units_assigned) > 0) then
1475:
1476: -- terminate old row
1477: FA_DISTRIBUTION_HISTORY_PKG.UPDATE_ROW
1478: (X_Rowid => dh_rec.row_id,
1479: X_Distribution_Id => dh_rec.distribution_id,
1480: X_Book_Type_Code => dh_rec.book_type_code,
1481: X_Asset_Id => dh_rec.asset_id,

Line 1498: FA_DISTRIBUTION_HISTORY_PKG.INSERT_ROW

1494: X_Last_Update_Login => p_trans_rec.who_info.last_update_login,
1495: X_Calling_Fn => 'FA_DISTRIBUTION_PVT.update_dist_history', p_log_level_rec => p_log_level_rec);
1496:
1497: -- create new row with new units
1498: FA_DISTRIBUTION_HISTORY_PKG.INSERT_ROW
1499: (X_Rowid => l_rowid,
1500: X_Distribution_Id => l_distribution_id,
1501: X_Book_Type_Code => dh_rec.book_type_code,
1502: X_Asset_Id => dh_rec.asset_id,

Line 1521: FA_DISTRIBUTION_HISTORY_PKG.UPDATE_ROW

1517: X_Calling_Fn => 'FA_DISTRIBUTION_PVT.update_dist_history', p_log_level_rec => p_log_level_rec);
1518:
1519: else -- full unit change, then terminate the row only
1520:
1521: FA_DISTRIBUTION_HISTORY_PKG.UPDATE_ROW
1522: (X_Rowid => dh_rec.row_id,
1523: X_Distribution_Id => dh_rec.distribution_id,
1524: X_Book_Type_Code => dh_rec.book_type_code,
1525: X_Asset_Id => dh_rec.asset_id,

Line 1545: FA_DISTRIBUTION_HISTORY_PKG.INSERT_ROW

1541: l_tfr_det_dist_id := p_asset_dist_tbl(i).distribution_id;
1542: else
1543:
1544: -- create new row with new units
1545: FA_DISTRIBUTION_HISTORY_PKG.INSERT_ROW
1546: (X_Rowid => l_rowid,
1547: X_Distribution_Id => l_distribution_id,
1548: X_Book_Type_Code => p_asset_hdr_rec.book_type_code,
1549: X_Asset_Id => p_asset_hdr_rec.asset_id,