APPS.FA_DEPRN_EVENTS_PKG dependencies on FA_MC_DEPRN_SUMMARY

Line 46: from fa_mc_deprn_summary

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

Line 190: UPDATE FA_MC_DEPRN_SUMMARY

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

Line 305: UPDATE FA_MC_DEPRN_SUMMARY

301: p_log_level_rec => g_log_level_rec);
302: end if;
303:
304: FORALL l_count in 1..l_asset_id_tbl.count
305: UPDATE FA_MC_DEPRN_SUMMARY
306: SET event_id = l_event_id_tbl(l_count),
307: deprn_run_id = l_deprn_run_id
308: WHERE rowid = l_rowid_tbl(l_count);
309:

Line 326: UPDATE FA_MC_DEPRN_SUMMARY

322: end if;
323:
324: -- now process all matching mrc rows for summary
325: FORALL l_count in 1..l_asset_id_tbl.count
326: UPDATE FA_MC_DEPRN_SUMMARY
327: SET event_id = l_event_id_tbl(l_count),
328: deprn_run_id = l_deprn_run_id
329: WHERE set_of_books_id <> l_sob_tbl(l_sob_index)
330: AND asset_id = l_asset_id_tbl(l_count)