[Home] [Help]
28: p_period_counter number
29: ) IS
30: select rowid,
31: asset_id
32: from fa_deprn_summary
33: where book_type_code = p_book_type_code
34: and period_counter = p_period_counter
35: and event_id is null
36: and (deprn_amount - deprn_adjustment_amount <> 0 or
96: end if;
97:
98: l_batch_size := nvl(fa_cache_pkg.fa_batch_size, 200);
99:
100: select fa_deprn_summary_s.nextval
101: into l_deprn_run_id
102: from dual;
103:
104: if (g_log_level_rec.statement_level) then
162: p_log_level_rec => g_log_level_rec);
163: end if;
164:
165: FORALL l_count in 1..l_asset_id_tbl.count
166: UPDATE FA_DEPRN_SUMMARY
167: SET event_id = l_event_id_tbl(l_count),
168: deprn_run_id = l_deprn_run_id
169: WHERE rowid = l_rowid_tbl(l_count);
170:
237: fa_debug_pkg.add(l_calling_fn, 'before', 'secondary bulk insert',
238: p_log_level_rec => g_log_level_rec);
239: end if;
240:
241: select fa_deprn_summary_s.nextval
242: into l_secondary_deprn_run_id
243: from dual;
244:
245: fa_xla_events_pvt.create_bulk_deprn_event
504: p_log_level_rec => p_log_level_rec) then
505: raise error_found;
506: end if;
507:
508: select fa_deprn_summary_s.nextval
509: into l_deprn_run_id
510: from dual;
511:
512: if (p_log_level_rec.statement_level) then
535: fa_debug_pkg.add(l_calling_fn, 'Updating', 'primary deprn',
536: p_log_level_rec => p_log_level_rec);
537: end if;
538:
539: UPDATE FA_DEPRN_SUMMARY
540: SET event_id = l_event_id,
541: deprn_run_id = l_deprn_run_id
542: WHERE asset_id = p_asset_id
543: AND book_type_code = p_book_type_code
600: fa_debug_pkg.add(l_calling_fn, 'before', 'secondary event creation',
601: p_log_level_rec => p_log_level_rec);
602: end if;
603:
604: select fa_deprn_summary_s.nextval
605: into l_secondary_deprn_run_id
606: from dual;
607:
608: fa_xla_events_pvt.create_deprn_event