[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select 1
into l_check
from fa_books
where book_type_code = p_book_type_code
and asset_id = p_asset_id
and transaction_header_id_out is null
and rownum < 2;
Select TRANSACTION_INTERFACE_ID,
TRANSACTION_DATE,
TRANSACTION_TYPE_CODE,
POSTING_STATUS,
BOOK_TYPE_CODE,
ASSET_KEY_PROJECT_VALUE,
ASSET_KEY_HIERARCHY_VALUE,
ASSET_KEY_NEW_HIERARCHY_VALUE,
REFERENCE_NUMBER,
COMMENTS,
CONCURRENT_REQUEST_ID,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN
from fa_transaction_interface
where book_type_code = c_book_type_Code;
select lookup_code
from fa_lookups
where lookup_type = c_lookup_type
and enabled_flag = 'Y'
and nvl(end_date_active, sysdate) >= sysdate
and rownum = 1;
SELECT code_combination_id
INTO l_akey_ccid
FROM fa_asset_keywords
WHERE nvl(segment1, '-1') = nvl(c_akey_seg(1), '-1')
and nvl(segment2, '-1') = nvl(c_akey_seg(2), '-1')
and nvl(segment3, '-1') = nvl(c_akey_seg(3), '-1')
and nvl(segment4, '-1') = nvl(c_akey_seg(4), '-1')
and nvl(segment5, '-1') = nvl(c_akey_seg(5), '-1')
and nvl(segment6, '-1') = nvl(c_akey_seg(6), '-1')
and nvl(segment7, '-1') = nvl(c_akey_seg(7), '-1')
and nvl(segment8, '-1') = nvl(c_akey_seg(8), '-1')
and nvl(segment9, '-1') = nvl(c_akey_seg(9), '-1')
and nvl(segment10, '-1') = nvl(c_akey_seg(10), '-1');
select asset_id
from fa_additions
where asset_type = 'CIP'
and asset_key_ccid in
(SELECT code_combination_id
FROM fa_asset_keywords
WHERE nvl(segment1, '-1') =
nvl(c_akey_seg(1), nvl(segment1, '-1'))
and nvl(segment2, '-1') =
nvl(c_akey_seg(2), nvl(segment2, '-1'))
and nvl(segment3, '-1') =
nvl(c_akey_seg(3), nvl(segment1, '-1'))
and nvl(segment4, '-1') =
nvl(c_akey_seg(4), nvl(segment4, '-1'))
and nvl(segment5, '-1') =
nvl(c_akey_seg(5), nvl(segment5, '-1'))
and nvl(segment6, '-1') =
nvl(c_akey_seg(6), nvl(segment6, '-1'))
and nvl(segment7, '-1') =
nvl(c_akey_seg(7), nvl(segment7, '-1'))
and nvl(segment8, '-1') =
nvl(c_akey_seg(8), nvl(segment8, '-1'))
and nvl(segment9, '-1') =
nvl(c_akey_seg(9), nvl(segment9, '-1'))
and nvl(segment10, '-1') =
nvl(c_akey_seg(10), nvl(segment10, '-1')));
l_err_stage := 'check whether asset belongs to selected book';
/* check whether asset belongs to selected book or not */
if (check_asset_book(p_book_type_code, l_asset_id)) then
if (l_trans_int_rec.transaction_type_code = 'CAPITALIZE') then
l_err_stage := 'Calling FA_AFE_TRANSACTIONS_PKG.process_capitalize';