[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select rowid,
asset_id
from fa_deprn_summary
where book_type_code = p_book_type_code
and period_counter = p_period_counter
and event_id is null
and (deprn_amount - deprn_adjustment_amount <> 0 or
reval_amortization <> 0)
and MOD(asset_id, p_total_requests) = (p_request_number - 1)
and deprn_source_code <> 'TRACK';
select rowid,
asset_id
from fa_mc_deprn_summary
where set_of_books_id = p_set_of_books_id
and book_type_code = p_book_type_code
and period_counter = p_period_counter
and event_id is null
and (deprn_amount - deprn_adjustment_amount <> 0 or
reval_amortization <> 0)
and MOD(asset_id, p_total_requests) = (p_request_number - 1)
and deprn_source_code <> 'TRACK';
select fa_deprn_summary_s.nextval
into l_deprn_run_id
from dual;
fa_debug_pkg.add(l_calling_fn, 'performing', 'bulk update - primary',
p_log_level_rec => g_log_level_rec);
UPDATE FA_DEPRN_SUMMARY
SET event_id = l_event_id_tbl(l_count),
deprn_run_id = l_deprn_run_id
WHERE rowid = l_rowid_tbl(l_count);
UPDATE FA_DEPRN_DETAIL
SET event_id = l_event_id_tbl(l_count),
deprn_run_id = l_deprn_run_id
WHERE asset_id = l_asset_id_tbl(l_count)
AND book_type_code = p_book_type_code
AND period_counter = p_period_counter;
fa_debug_pkg.add(l_calling_fn, 'performing', 'bulk update - reporting',
p_log_level_rec => g_log_level_rec);
UPDATE FA_MC_DEPRN_SUMMARY
SET event_id = l_event_id_tbl(l_count),
deprn_run_id = l_deprn_run_id
WHERE asset_id = l_asset_id_tbl(l_count)
AND book_type_code = p_book_type_code
AND period_counter = p_period_counter;
UPDATE FA_MC_DEPRN_DETAIL
SET event_id = l_event_id_tbl(l_count),
deprn_run_id = l_deprn_run_id
WHERE asset_id = l_asset_id_tbl(l_count)
AND book_type_code = p_book_type_code
AND period_counter = p_period_counter;
fa_debug_pkg.add(l_calling_fn, 'done', 'bulk updates',
p_log_level_rec => g_log_level_rec);
INSERT into fa_deprn_events
(asset_id ,
book_type_code ,
period_counter ,
deprn_run_id ,
deprn_run_date ,
event_id ,
reversal_event_id
)
VALUES
(l_asset_id_tbl(l_count),
p_book_type_code,
p_period_counter,
l_deprn_run_id,
sysdate,
l_event_id_tbl(l_count),
null);
fa_debug_pkg.add(l_calling_fn, 'done', 'bulk insert',
p_log_level_rec => g_log_level_rec);
fa_debug_pkg.add(l_calling_fn, 'before', 'secondary bulk insert',
p_log_level_rec => g_log_level_rec);
select fa_deprn_summary_s.nextval
into l_secondary_deprn_run_id
from dual;
fa_debug_pkg.add(l_calling_fn, 'after', 'secondary bulk insert',
p_log_level_rec => g_log_level_rec);
UPDATE FA_MC_DEPRN_SUMMARY
SET event_id = l_secondary_event_id_tbl(l_count),
deprn_run_id = l_secondary_deprn_run_id
WHERE asset_id = l_asset_id_tbl(l_count)
AND book_type_code = p_book_type_code
AND period_counter = p_period_counter
and set_of_books_id = l_secondary_sob_id;
UPDATE FA_MC_DEPRN_DETAIL
SET event_id = l_secondary_event_id_tbl(l_count),
deprn_run_id = l_secondary_deprn_run_id
WHERE asset_id = l_asset_id_tbl(l_count)
AND book_type_code = p_book_type_code
AND period_counter = p_period_counter
and set_of_books_id = l_secondary_sob_id;
fa_debug_pkg.add(l_calling_fn, 'performing', 'bulk update - reporting1',
p_log_level_rec => g_log_level_rec);
UPDATE FA_MC_DEPRN_SUMMARY
SET event_id = l_event_id_tbl(l_count),
deprn_run_id = l_deprn_run_id
WHERE rowid = l_rowid_tbl(l_count);
UPDATE FA_MC_DEPRN_DETAIL
SET event_id = l_event_id_tbl(l_count),
deprn_run_id = l_deprn_run_id
WHERE asset_id = l_asset_id_tbl(l_count)
AND book_type_code = p_book_type_code
AND period_counter = p_period_counter;
fa_debug_pkg.add(l_calling_fn, 'performing', 'bulk update - reporting2',
p_log_level_rec => g_log_level_rec);
UPDATE FA_MC_DEPRN_SUMMARY
SET event_id = l_event_id_tbl(l_count),
deprn_run_id = l_deprn_run_id
WHERE set_of_books_id <> l_sob_tbl(l_sob_index)
AND asset_id = l_asset_id_tbl(l_count)
AND book_type_code = p_book_type_code
AND period_counter = p_period_counter;
fa_debug_pkg.add(l_calling_fn, 'done', 'mc bulk updates',
p_log_level_rec => g_log_level_rec);
INSERT into fa_deprn_events
(asset_id ,
book_type_code ,
period_counter ,
deprn_run_id ,
deprn_run_date ,
event_id ,
reversal_event_id
)
VALUES
(l_asset_id_tbl(l_count),
p_book_type_code,
p_period_counter,
l_deprn_run_id,
sysdate,
l_event_id_tbl(l_count),
null);
fa_debug_pkg.add(l_calling_fn, 'done', 'bulk insert',
p_log_level_rec => g_log_level_rec);
select fa_deprn_summary_s.nextval
into l_deprn_run_id
from dual;
UPDATE FA_DEPRN_SUMMARY
SET event_id = l_event_id,
deprn_run_id = l_deprn_run_id
WHERE asset_id = p_asset_id
AND book_type_code = p_book_type_code
AND period_counter = p_period_counter;
UPDATE FA_DEPRN_DETAIL
SET event_id = l_event_id,
deprn_run_id = l_deprn_run_id
WHERE asset_id = p_asset_id
AND book_type_code = p_book_type_code
AND period_counter = p_period_counter;
UPDATE FA_MC_DEPRN_SUMMARY
SET event_id = l_event_id,
deprn_run_id = l_deprn_run_id
WHERE asset_id = p_asset_id
AND book_type_code = p_book_type_code
AND period_counter = p_period_counter;
UPDATE FA_MC_DEPRN_DETAIL
SET event_id = l_event_id,
deprn_run_id = l_deprn_run_id
WHERE asset_id = p_asset_id
AND book_type_code = p_book_type_code
AND period_counter = p_period_counter;
fa_debug_pkg.add(l_calling_fn, 'Inserting', 'deprn_events',
p_log_level_rec => p_log_level_rec);
INSERT into fa_deprn_events
(asset_id ,
book_type_code ,
period_counter ,
deprn_run_id ,
deprn_run_date ,
event_id ,
reversal_event_id
)
VALUES
(p_asset_id,
p_book_type_code,
p_period_counter,
l_deprn_run_id,
sysdate,
l_event_id,
null);
select fa_deprn_summary_s.nextval
into l_secondary_deprn_run_id
from dual;
UPDATE FA_MC_DEPRN_SUMMARY
SET event_id = l_secondary_event_id,
deprn_run_id = l_secondary_deprn_run_id
WHERE asset_id = p_asset_id
AND book_type_code = p_book_type_code
AND period_counter = p_period_counter
and set_of_books_id = l_secondary_sob_id;
UPDATE FA_MC_DEPRN_DETAIL
SET event_id = l_secondary_event_id,
deprn_run_id = l_secondary_deprn_run_id
WHERE asset_id = p_asset_id
AND book_type_code = p_book_type_code
AND period_counter = p_period_counter
and set_of_books_id = l_secondary_sob_id;