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
804: ds.production,
805: ds.ytd_production,
806: ds.ltd_production
807: from fa_transaction_headers th,
808: fa_books bks,
809: fa_additions_b ad,
810: fa_book_controls bc,
811: fa_category_books cb,
812: fa_deprn_summary ds,
1174: p_log_level_rec => l_log_level_rec
1175: ) then raise error_found;
1176: end if;
1177:
1178: -- Reflect post catch-up info to fa_books
1179: fa_books_pkg.update_row
1180: (X_asset_id => l_asset_hdr_rec.asset_id,
1181: X_book_type_code => l_asset_hdr_rec.book_type_code,
1182: X_Adjustment_Required_Status
1175: ) then raise error_found;
1176: end if;
1177:
1178: -- Reflect post catch-up info to fa_books
1179: fa_books_pkg.update_row
1180: (X_asset_id => l_asset_hdr_rec.asset_id,
1181: X_book_type_code => l_asset_hdr_rec.book_type_code,
1182: X_Adjustment_Required_Status
1183: => 'NONE',
1246: p_log_level_rec => l_log_level_rec) then
1247: raise error_found;
1248: end if;
1249:
1250: -- Reflect post catch-up info to fa_books
1251: fa_books_pkg.update_row
1252: (X_asset_id => l_asset_hdr_rec.asset_id,
1253: X_book_type_code => l_asset_hdr_rec.book_type_code,
1254: X_Adjustment_Required_Status
1247: raise error_found;
1248: end if;
1249:
1250: -- Reflect post catch-up info to fa_books
1251: fa_books_pkg.update_row
1252: (X_asset_id => l_asset_hdr_rec.asset_id,
1253: X_book_type_code => l_asset_hdr_rec.book_type_code,
1254: X_Adjustment_Required_Status
1255: => 'NONE',
1577: p_log_level_rec => l_log_level_rec
1578: ) then raise error_found;
1579: end if;
1580:
1581: -- Reflect post catch-up info to fa_books
1582: fa_books_pkg.update_row
1583: (X_asset_id => l_asset_hdr_rec.asset_id,
1584: X_book_type_code => l_asset_hdr_rec.book_type_code,
1585: X_Adjustment_Required_Status
1578: ) then raise error_found;
1579: end if;
1580:
1581: -- Reflect post catch-up info to fa_books
1582: fa_books_pkg.update_row
1583: (X_asset_id => l_asset_hdr_rec.asset_id,
1584: X_book_type_code => l_asset_hdr_rec.book_type_code,
1585: X_Adjustment_Required_Status
1586: => 'NONE',