APPS.FA_TRANSFER_XIT_PKG dependencies on FA_ADJUSTMENTS

Line 330: -- FA_ADJUSTMENTS rows to the database

326: raise ERROR_FOUND; end if;
327: end if;
328:
329: -- move the reval_reserve, set flush = TRUE to insert all the
330: -- FA_ADJUSTMENTS rows to the database
331:
332: if (nvl(h_dpr.reval_rsv,0) <> 0) then
333: h_adj.flush_adj_flag := TRUE;
334: if (NOT fadotfr(X_adj_ptr => h_adj,

Line 874: -- individual fa_adjustments rows. other values already set in fautfr.

870: X_adj.code_combination_id := h_ccid;
871: X_adj.distribution_id := h_dist_id;
872:
873: -- call the insert into fa_adjusments funtion in SINGLE mode to insert the
874: -- individual fa_adjustments rows. other values already set in fautfr.
875:
876: X_adj.selection_mode := fa_adjust_type_pkg.FA_AJ_TRANSFER_SINGLE;
877: X_adj.gen_ccid_flag := TRUE;
878:

Line 1950: from fa_adjustments adj

1946: -adj.adjustment_amount)) adjustment_amount,
1947: sum(decode(adj.debit_credit_flag,'DR', adj.annualized_adjustment,
1948: -adj.annualized_adjustment)) annualized_adjustment,
1949: max(adj.track_member_flag) -- Bug7461343
1950: from fa_adjustments adj
1951: ,fa_additions_b ad
1952: ,fa_distribution_history fad
1953: where adj.asset_id = p_asset_id
1954: and adj.book_type_code = p_book_type_code

Line 2242: delete from fa_adjustments adj

2238: and adj1.adjustment_type in ('EXPENSE', 'BONUS EXPENSE', 'IMPAIR EXPENSE'));
2239:
2240: else
2241:
2242: delete from fa_adjustments adj
2243: where adj.asset_id = X_asset_id
2244: and adj.book_type_code = X_book_type_code
2245: and adj.period_counter_created = l_pc
2246: and adj.source_type_code = 'DEPRECIATION'

Line 2254: from fa_adjustments adj1

2250: from fa_distribution_history dh
2251: where dh.transaction_header_id_out = X_th_id)
2252: and exists
2253: (select adj1.transaction_header_id
2254: from fa_adjustments adj1
2255: where adj1.asset_id = X_asset_id
2256: and adj1.transaction_header_id = X_th_id
2257: and adj1.book_type_code = X_book_type_code
2258: and adj1.period_counter_created = l_pc