APPS.FA_DEPRN_EVENTS_PKG dependencies on FA_MC_DEPRN_SUMMARY

Line 47: from fa_mc_deprn_summary

43: p_period_counter number
44: ) IS
45: select rowid,
46: asset_id
47: from fa_mc_deprn_summary
48: where set_of_books_id = p_set_of_books_id
49: and book_type_code = p_book_type_code
50: and period_counter = p_period_counter
51: and event_id is null

Line 186: UPDATE FA_MC_DEPRN_SUMMARY

182: end if;
183:
184: -- now process all matching mrc rows
185: FORALL l_count in 1..l_asset_id_tbl.count
186: UPDATE FA_MC_DEPRN_SUMMARY
187: SET event_id = l_event_id_tbl(l_count),
188: deprn_run_id = l_deprn_run_id
189: WHERE asset_id = l_asset_id_tbl(l_count)
190: AND book_type_code = p_book_type_code

Line 263: UPDATE FA_MC_DEPRN_SUMMARY

259: p_log_level_rec => g_log_level_rec);
260: end if;
261:
262: FORALL l_count in 1..l_asset_id_tbl.count
263: UPDATE FA_MC_DEPRN_SUMMARY
264: SET event_id = l_secondary_event_id_tbl(l_count),
265: deprn_run_id = l_secondary_deprn_run_id
266: WHERE asset_id = l_asset_id_tbl(l_count)
267: AND book_type_code = p_book_type_code

Line 358: UPDATE FA_MC_DEPRN_SUMMARY

354: p_log_level_rec => g_log_level_rec);
355: end if;
356:
357: FORALL l_count in 1..l_asset_id_tbl.count
358: UPDATE FA_MC_DEPRN_SUMMARY
359: SET event_id = l_event_id_tbl(l_count),
360: deprn_run_id = l_deprn_run_id
361: WHERE rowid = l_rowid_tbl(l_count);
362:

Line 378: UPDATE FA_MC_DEPRN_SUMMARY

374: end if;
375:
376: -- now process all matching mrc rows for summary
377: FORALL l_count in 1..l_asset_id_tbl.count
378: UPDATE FA_MC_DEPRN_SUMMARY
379: SET event_id = l_event_id_tbl(l_count),
380: deprn_run_id = l_deprn_run_id
381: WHERE set_of_books_id <> l_sob_tbl(l_sob_index)
382: AND asset_id = l_asset_id_tbl(l_count)

Line 558: UPDATE FA_MC_DEPRN_SUMMARY

554: fa_debug_pkg.add(l_calling_fn, 'Updating', 'reporting deprn',
555: p_log_level_rec => p_log_level_rec);
556: end if;
557:
558: UPDATE FA_MC_DEPRN_SUMMARY
559: SET event_id = l_event_id,
560: deprn_run_id = l_deprn_run_id
561: WHERE asset_id = p_asset_id
562: AND book_type_code = p_book_type_code

Line 624: UPDATE FA_MC_DEPRN_SUMMARY

620: fa_debug_pkg.add(l_calling_fn, 'Updating', 'secondary deprn',
621: p_log_level_rec => p_log_level_rec);
622: end if;
623:
624: UPDATE FA_MC_DEPRN_SUMMARY
625: SET event_id = l_secondary_event_id,
626: deprn_run_id = l_secondary_deprn_run_id
627: WHERE asset_id = p_asset_id
628: AND book_type_code = p_book_type_code