APPS.IGI_IMP_IAC_IMPORT_PKG dependencies on IGI_IMP_IAC_INTERMEDIATE

Line 136: UPDATE igi_imp_iac_intermediate

132: RAISE e_loader_failure;
133: END IF;
134:
135: -- Update concurrent process details to loaded records
136: UPDATE igi_imp_iac_intermediate
137: SET request_id = l_request_id
138: ,program_id = FND_GLOBAL.Conc_Program_Id
139: ,program_application_id = FND_GLOBAL.Prog_Appl_Id
140: ,program_update_date = SYSDATE

Line 194: FROM igi_imp_iac_intermediate

190:
191: -- Count records to process
192: CURSOR c_count_recs IS
193: SELECT COUNT(*)
194: FROM igi_imp_iac_intermediate
195: WHERE errored_flag IS NULL;
196:
197: -- Get records to process
198: CURSOR c_recs_to_process IS

Line 215: FROM igi_imp_iac_intermediate

211: ,request_id
212: ,program_application_id
213: ,program_id
214: ,program_update_date
215: FROM igi_imp_iac_intermediate
216: WHERE errored_flag IS NULL;
217:
218: -- Validate the asset
219: CURSOR c_validate_asset (cp_asset_id igi_imp_iac_interface.asset_id%TYPE,

Line 449: DELETE FROM igi_imp_iac_intermediate

445:
446:
447: END IF;
448: -- Delete the successful record from intermediate
449: DELETE FROM igi_imp_iac_intermediate
450: WHERE asset_id = cv_recs_to_process.asset_id
451: AND asset_number = cv_recs_to_process.asset_number
452: AND book_type_code = cv_recs_to_process.book_type_code
453: AND category_id = cv_recs_to_process.category_id;

Line 458: UPDATE igi_imp_iac_intermediate

454:
455: ELSE -- not a valid record
456:
457: -- Update the error status to intermediate
458: UPDATE igi_imp_iac_intermediate
459: SET errored_flag = 'Y'
460: WHERE asset_id = cv_recs_to_process.asset_id
461: AND asset_number = cv_recs_to_process.asset_number
462: AND book_type_code = cv_recs_to_process.book_type_code

Line 603: DELETE FROM igi_imp_iac_intermediate;

599: RAISE e_invalid_category_id;
600: END IF;
601:
602: -- Delete old records from the intermediate table
603: DELETE FROM igi_imp_iac_intermediate;
604: COMMIT;
605:
606: -- Strip book type code blank spaces
607: -- l_new_book_type_code := strip_blank_spaces(l_book_type_code); -- Commented since check is performed using the function igi_imp_iac_export_pkg.trim_invalid_chars