The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT COUNT(*)
FROM fnd_concurrent_programs
WHERE concurrent_program_name = p_program_name
AND concurrent_program_id = FND_GLOBAL.Conc_Program_Id
AND application_id = FND_GLOBAL.Prog_Appl_Id;
UPDATE igi_imp_iac_intermediate
SET request_id = l_request_id
,program_id = FND_GLOBAL.Conc_Program_Id
,program_application_id = FND_GLOBAL.Prog_Appl_Id
,program_update_date = SYSDATE
WHERE errored_flag IS NULL;
PROCEDURE Validate_Update_IMP_Data ( p_file_name IN VARCHAR2
, p_book_type_code IN VARCHAR2
, p_category_id IN NUMBER
) IS
-- Count records to process
CURSOR c_count_recs IS
SELECT COUNT(*)
FROM igi_imp_iac_intermediate
WHERE errored_flag IS NULL;
SELECT asset_id
,asset_number
,book_type_code
,category_id
,cost_mhca
,ytd_mhca
,accum_deprn_mhca
,reval_reserve_mhca
,backlog_mhca
,general_fund_mhca
,operating_account_cost
,operating_account_backlog
,request_id
,program_application_id
,program_id
,program_update_date
FROM igi_imp_iac_intermediate
WHERE errored_flag IS NULL;
SELECT COUNT(*)
FROM igi_imp_iac_interface
WHERE asset_id = cp_asset_id
AND asset_number = cp_asset_number
AND book_type_code = cp_book_type_code
AND category_id = cp_category_id;
SELECT transfer_status
FROM igi_imp_iac_interface_ctrl
WHERE book_type_code = cp_book_type_code
AND category_id = cp_category_id;
Select book_class
from fa_booK_controls
where book_type_code = cp_book_type_code;
select depreciate_flag
from fa_books
where book_type_code =cp_book_type_code
and asset_id =cp_asset_id
and transaction_header_id_out is null;
l_path_name VARCHAR2(150) := g_path||'validate_update_imp_data';
UPDATE igi_imp_iac_interface
SET cost_mhca = cv_recs_to_process.cost_mhca
,ytd_mhca = cv_recs_to_process.ytd_mhca
,accum_deprn_mhca = cv_recs_to_process.accum_deprn_mhca
,reval_reserve_mhca = cv_recs_to_process.reval_reserve_mhca
,backlog_mhca = cv_recs_to_process.backlog_mhca
,general_fund_mhca = cv_recs_to_process.general_fund_mhca
,operating_account_cost = (-1) * cv_recs_to_process.operating_account_cost
,operating_account_backlog = (-1) * cv_recs_to_process.operating_account_backlog
,import_file = l_file_name
,import_date = SYSDATE
,request_id = cv_recs_to_process.request_id
,program_id = cv_recs_to_process.program_id
,program_application_id = cv_recs_to_process.program_application_id
,program_update_date = cv_recs_to_process.program_update_date
,valid_flag = 'N'
WHERE asset_id = cv_recs_to_process.asset_id
AND asset_number = cv_recs_to_process.asset_number
AND book_type_code = cv_recs_to_process.book_type_code
AND category_id = cv_recs_to_process.category_id;
UPDATE igi_imp_iac_interface
SET cost_mhca = cv_recs_to_process.cost_mhca
,reval_reserve_mhca = cv_recs_to_process.reval_reserve_mhca
,operating_account_cost = (-1) * cv_recs_to_process.operating_account_cost
,import_file = l_file_name
,import_date = SYSDATE
,request_id = cv_recs_to_process.request_id
,program_id = cv_recs_to_process.program_id
,program_application_id = cv_recs_to_process.program_application_id
,program_update_date = cv_recs_to_process.program_update_date
,valid_flag = 'N'
WHERE asset_id = cv_recs_to_process.asset_id
AND asset_number = cv_recs_to_process.asset_number
AND book_type_code = cv_recs_to_process.book_type_code
AND category_id = cv_recs_to_process.category_id;
DELETE FROM igi_imp_iac_intermediate
WHERE asset_id = cv_recs_to_process.asset_id
AND asset_number = cv_recs_to_process.asset_number
AND book_type_code = cv_recs_to_process.book_type_code
AND category_id = cv_recs_to_process.category_id;
UPDATE igi_imp_iac_intermediate
SET errored_flag = 'Y'
WHERE asset_id = cv_recs_to_process.asset_id
AND asset_number = cv_recs_to_process.asset_number
AND book_type_code = cv_recs_to_process.book_type_code
AND category_id = cv_recs_to_process.category_id;
END Validate_Update_IMP_Data;
SELECT request_status
FROM igi_imp_iac_controls
WHERE book_type_code = cp_book_type_code;
SELECT COUNT(*)
FROM igi_imp_iac_interface_ctrl
WHERE book_type_code = cp_book_type_code
AND category_id = cp_category_id;
SELECT COUNT(DISTINCT group_id)
FROM igi_imp_iac_interface
WHERE book_type_code = cp_book_type_code
AND category_id = cp_category_id
AND group_id IS NOT NULL;
SELECT DISTINCT group_id
FROM igi_imp_iac_interface
WHERE book_type_code = cp_book_type_code
AND category_id = cp_category_id
AND group_id IS NOT NULL;
DELETE FROM igi_imp_iac_intermediate;
Validate_Update_IMP_Data( l_file_name
, l_book_type_code
, l_category_id
);