APPS.FA_IMPAIRMENT_DELETE_PVT dependencies on FA_MC_BOOKS

Line 47: fa_mc_books

43: del_err exception;
44:
45: Cursor c_mc_get_recs is
46: select transaction_header_id_in,asset_id from
47: fa_mc_books
48: where transaction_header_id_out is null
49: and book_type_code = p_book_type_code
50: and set_of_books_id = p_set_of_books_id
51: and asset_id in (select itf.asset_id

Line 84: delete from fa_mc_books

80: end if;
81:
82: if (p_mrc_sob_type_code = 'R') then
83: if G_release = 11 then
84: delete from fa_mc_books
85: where transaction_header_id_out is null
86: and book_type_code = p_book_type_code
87: and set_of_books_id = p_set_of_books_id
88: and asset_id in (select itf.asset_id

Line 168: from fa_mc_books

164: update fa_transaction_headers
165: set transaction_type_code ='ADDITION'
166: where transaction_header_id = (
167: select transaction_header_id_in
168: from fa_mc_books
169: where transaction_header_id_out = t_thid(i)
170: and set_of_books_id = p_set_of_books_id)
171: and transaction_type_code = 'ADDITION/VOID'
172: and book_type_code = p_book_type_code;

Line 175: update fa_mc_books

171: and transaction_type_code = 'ADDITION/VOID'
172: and book_type_code = p_book_type_code;
173:
174: FORALL i in 1..t_thid.count
175: update fa_mc_books
176: set date_ineffective = null
177: , transaction_header_id_out = null
178: where asset_id = t_asset_id(i)
179: and book_type_code = p_book_type_code

Line 1269: UPDATE FA_MC_BOOKS

1265: end if;
1266: end if;
1267:
1268: if (p_mrc_sob_type_code = 'R') then
1269: UPDATE FA_MC_BOOKS
1270: SET DATE_INEFFECTIVE = sysdate
1271: , TRANSACTION_HEADER_ID_OUT = l_thid
1272: WHERE ASSET_ID = p_asset_id
1273: AND BOOK_TYPE_CODE = p_book_type_code

Line 1289: INSERT INTO FA_MC_BOOKS( SET_OF_BOOKS_ID

1285: end if;
1286:
1287:
1288: if (p_mrc_sob_type_code = 'R') then
1289: INSERT INTO FA_MC_BOOKS( SET_OF_BOOKS_ID
1290: , BOOK_TYPE_CODE
1291: , ASSET_ID
1292: , DATE_PLACED_IN_SERVICE
1293: , DATE_EFFECTIVE

Line 1521: FROM FA_MC_BOOKS

1517: , OVER_DEPRECIATE_OPTION
1518: , DISABLED_FLAG
1519: , CASH_GENERATING_UNIT_ID
1520: , RATE_IN_USE
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

Line 1871: delete from fa_mc_books

1867:
1868: end if;--Event status
1869: elsif (l_event_id is null and p_mrc_sob_type_code = 'R') then
1870: /*if event is already deleted for primary currency,this block will execute for reporting currency */
1871: delete from fa_mc_books
1872: where transaction_header_id_out is null
1873: and transaction_header_id_in = p_thid
1874: and book_type_code = p_book_type_code
1875: and asset_id = p_asset_id

Line 1885: update fa_mc_books

1881: and book_type_code = p_book_type_code
1882: and period_counter_created = l_period_rec.period_counter
1883: and set_of_books_id = p_set_of_books_id;
1884:
1885: update fa_mc_books
1886: set date_ineffective = null
1887: , transaction_header_id_out = null
1888: where asset_id = p_asset_id
1889: and book_type_code = p_book_type_code