APPS.FA_IMPAIRMENT_DELETE_PVT dependencies on FA_BOOKS

Line 64: fa_books

60: and imp.status = 'DELETING POST');
61:
62: Cursor c_get_recs is
63: select transaction_header_id_in,asset_id from
64: fa_books
65: where transaction_header_id_out is null
66: and book_type_code = p_book_type_code
67: and asset_id in (select itf.asset_id
68: from fa_impairments imp

Line 194: delete from fa_books

190: and set_of_books_id = p_set_of_books_id;
191:
192: else
193: if G_release = 11 then
194: delete from fa_books
195: where transaction_header_id_out is null
196: and book_type_code = p_book_type_code
197: and asset_id in (select itf.asset_id
198: from fa_impairments imp

Line 270: from fa_books

266: update fa_transaction_headers
267: set transaction_type_code='ADDITION'
268: where transaction_header_id in(
269: select transaction_header_id_in
270: from fa_books
271: where transaction_header_id_out = t_thid(i))
272: and transaction_type_code = 'ADDITION/VOID'
273: and book_type_code = p_book_type_code;
274:

Line 276: update fa_books

272: and transaction_type_code = 'ADDITION/VOID'
273: and book_type_code = p_book_type_code;
274:
275: FORALL i in 1..t_thid.count
276: update fa_books
277: set date_ineffective = null
278: , transaction_header_id_out = null
279: where asset_id = t_asset_id(i)
280: and book_type_code = p_book_type_code

Line 1167: delete from fa_books

1163: if (p_log_level_rec.statement_level) then
1164: fa_debug_pkg.add(l_calling_fn,'deleted accounting impacts for impairment thid',p_thid,p_log_level_rec => p_log_level_rec);
1165: end if;
1166:
1167: delete from fa_books
1168: where transaction_header_id_out is null
1169: and transaction_header_id_in = p_thid
1170: and book_type_code = p_book_type_code
1171: and asset_id = p_asset_id ;

Line 1179: update fa_books

1175: and asset_id = p_asset_id
1176: and book_type_code = p_book_type_code
1177: and period_counter_created = l_period_rec.period_counter;
1178:
1179: update fa_books
1180: set date_ineffective = null
1181: , transaction_header_id_out = null
1182: where asset_id = p_asset_id
1183: and book_type_code = p_book_type_code

Line 1264: fa_debug_pkg.add(l_calling_fn,'Deactivating ', 'FA_BOOKS', p_log_level_rec => p_log_level_rec);

1260: set event_id = l_rev_event_id
1261: where transaction_header_id = l_thid;
1262:
1263: if (p_log_level_rec.statement_level) then
1264: fa_debug_pkg.add(l_calling_fn,'Deactivating ', 'FA_BOOKS', p_log_level_rec => p_log_level_rec);
1265: end if;
1266: end if;
1267:
1268: if (p_mrc_sob_type_code = 'R') then

Line 1278: UPDATE FA_BOOKS

1274: AND TRANSACTION_HEADER_ID_in = p_thid
1275: AND TRANSACTION_HEADER_ID_OUT is null
1276: AND SET_OF_BOOKS_ID = p_set_of_books_id;
1277: else
1278: UPDATE FA_BOOKS
1279: SET DATE_INEFFECTIVE = sysdate
1280: , TRANSACTION_HEADER_ID_OUT = l_thid
1281: WHERE ASSET_ID = p_asset_id
1282: AND BOOK_TYPE_CODE = p_book_type_code

Line 1525: INSERT INTO FA_BOOKS( BOOK_TYPE_CODE

1521: FROM FA_MC_BOOKS
1522: WHERE TRANSACTION_HEADER_ID_out = p_thid
1523: AND SET_OF_BOOKS_ID = p_set_of_books_id ;
1524: else
1525: INSERT INTO FA_BOOKS( BOOK_TYPE_CODE
1526: , ASSET_ID
1527: , DATE_PLACED_IN_SERVICE
1528: , DATE_EFFECTIVE
1529: , DEPRN_START_DATE

Line 1755: FROM FA_BOOKS

1751: , OVER_DEPRECIATE_OPTION
1752: , DISABLED_FLAG
1753: , CASH_GENERATING_UNIT_ID
1754: , RATE_IN_USE
1755: FROM FA_BOOKS
1756: WHERE TRANSACTION_HEADER_ID_out = p_thid;
1757: end if;
1758: if (p_mrc_sob_type_code = 'R') then
1759: open c_mrc_adjustments(p_thid => p_thid);