The following lines contain the word 'select', 'insert', 'update' or 'delete':
name => 'FA_ADD_CANT_DELETE'
,p_log_level_rec => p_log_level_rec);
select count(*)
into l_count
from fa_books
where book_type_code = px_asset_hdr_rec.book_type_code
and group_asset_id = px_asset_hdr_rec.asset_id;
name => '***FA_DELETE_GORUP_ASSET***'
,p_log_level_rec => p_log_level_rec);
select count(*)
into l_count
from fa_books
where asset_id = px_asset_hdr_rec.asset_id
and book_type_code = px_asset_hdr_rec.book_type_code
and group_asset_id is not null;
name => '***FA_DELETE_GORUP_MEMBER***'
,p_log_level_rec => p_log_level_rec);
select count(*)
into l_count
from fa_asset_invoices
where asset_id = px_asset_hdr_rec.asset_id
and feeder_system_name = 'ORACLE PROJECTS';
name => 'FA_ADD_CANT_DELETE_PROJECT'
,p_log_level_rec => p_log_level_rec);
SELECT count(*)
INTO l_count
FROM FA_ADDITIONS_B
WHERE LEASE_ID = p_asset_desc_rec.lease_id
AND ASSET_CATEGORY_ID =
ANY (SELECT CATEGORY_ID
FROM FA_CATEGORIES
WHERE CATEGORY_TYPE = 'LEASEHOLD IMPROVEMENT');
name => 'FA_ADD_DELETE_LHOLD'
,p_log_level_rec => p_log_level_rec);
select count(*)
into l_count
from fa_transaction_headers th,
xla_transaction_entities en,
xla_events ev,
fa_book_controls bc
where bc.distribution_source_book = px_asset_hdr_rec.book_type_code
and th.book_type_code = bc.book_type_code
and th.asset_id = px_asset_hdr_rec.asset_id
and en.application_id = 140
and en.ledger_id = bc.set_of_books_id
and en.entity_code = 'TRANSACTIONS'
and nvl(en.source_id_int_1, (-99)) = th.transaction_header_id
and ev.application_id = 140
and ev.entity_id = en.entity_id
and ev.event_status_code = 'P';
name => 'FA_ADD_CANT_DELETE');
select count(*)
into l_count
from xla_transaction_entities en,
xla_events ev,
fa_book_controls bc
where bc.distribution_source_book = px_asset_hdr_rec.book_type_code
and en.application_id = 140
and en.ledger_id = bc.set_of_books_id
and en.entity_code = 'DEPRECIATION'
and nvl(en.source_id_int_1, (-99)) = px_asset_hdr_rec.asset_id
and nvl(en.source_id_char_1, ' ') = bc.book_type_code
and ev.application_id = 140
and ev.entity_id = en.entity_id
and ev.event_status_code = 'P';
name => 'FA_ADD_CANT_DELETE');
select count(*)
into l_count
from fa_transaction_headers th,
xla_transaction_entities en,
xla_events ev,
fa_book_controls bc
where bc.distribution_source_book = px_asset_hdr_rec.book_type_code
and th.book_type_code = bc.book_type_code
and th.asset_id = px_asset_hdr_rec.asset_id
and en.application_id = 140
and en.ledger_id = bc.set_of_books_id
and en.entity_code = 'INTER_ASSET_TRANSACTIONS'
and nvl(en.source_id_int_1, (-99)) = th.trx_reference_id
and ev.application_id = 140
and ev.entity_id = en.entity_id
and ev.event_status_code = 'P';
name => 'FA_ADD_CANT_DELETE');