33: ad.current_units ,
34: bc.set_of_books_id
35: from fa_transaction_headers th,
36: fa_deprn_periods dp,
37: fa_books bk,
38: fa_category_books cb,
39: fa_additions_b ad,
40: fa_book_controls bc
41: where th.rowid between p_start_rowid and p_end_rowid
787: ds.production,
788: ds.ytd_production,
789: ds.ltd_production
790: from fa_transaction_headers th,
791: fa_books bks,
792: fa_additions_b ad,
793: fa_book_controls bc,
794: fa_category_books cb,
795: fa_deprn_summary ds,
1155: p_log_level_rec => l_log_level_rec
1156: ) then raise error_found;
1157: end if;
1158:
1159: -- Reflect post catch-up info to fa_books
1160: fa_books_pkg.update_row
1161: (X_asset_id => l_asset_hdr_rec.asset_id,
1162: X_book_type_code => l_asset_hdr_rec.book_type_code,
1163: X_Adjustment_Required_Status
1156: ) then raise error_found;
1157: end if;
1158:
1159: -- Reflect post catch-up info to fa_books
1160: fa_books_pkg.update_row
1161: (X_asset_id => l_asset_hdr_rec.asset_id,
1162: X_book_type_code => l_asset_hdr_rec.book_type_code,
1163: X_Adjustment_Required_Status
1164: => 'NONE',
1218: p_log_level_rec => l_log_level_rec) then
1219: raise error_found;
1220: end if;
1221:
1222: -- Reflect post catch-up info to fa_books
1223: fa_books_pkg.update_row
1224: (X_asset_id => l_asset_hdr_rec.asset_id,
1225: X_book_type_code => l_asset_hdr_rec.book_type_code,
1226: X_Adjustment_Required_Status
1219: raise error_found;
1220: end if;
1221:
1222: -- Reflect post catch-up info to fa_books
1223: fa_books_pkg.update_row
1224: (X_asset_id => l_asset_hdr_rec.asset_id,
1225: X_book_type_code => l_asset_hdr_rec.book_type_code,
1226: X_Adjustment_Required_Status
1227: => 'NONE',
1538: p_log_level_rec => l_log_level_rec
1539: ) then raise error_found;
1540: end if;
1541:
1542: -- Reflect post catch-up info to fa_books
1543: fa_books_pkg.update_row
1544: (X_asset_id => l_asset_hdr_rec.asset_id,
1545: X_book_type_code => l_asset_hdr_rec.book_type_code,
1546: X_Adjustment_Required_Status
1539: ) then raise error_found;
1540: end if;
1541:
1542: -- Reflect post catch-up info to fa_books
1543: fa_books_pkg.update_row
1544: (X_asset_id => l_asset_hdr_rec.asset_id,
1545: X_book_type_code => l_asset_hdr_rec.book_type_code,
1546: X_Adjustment_Required_Status
1547: => 'NONE',