DBA Data[Home] [Help]

APPS.IGI_IMP_IAC_IMPORT_PKG dependencies on IGI_IMP_IAC_EXPORT_PKG

Line 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

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
608:
609: -- Check count of files to process
610: OPEN c_group_count(l_book_type_code,l_category_id);
611: FETCH c_group_count INTO l_count;

Line 622: l_file_name := l_file_path||igi_imp_iac_export_pkg.trim_invalid_chars(l_book_type_code)|| '_' ||

618: FND_PROFILE.Get('IGI_IMP_IAC_FILE_LOCN',l_file_path);
619:
620: -- Build file names to be processed
621: FOR cv_group_id IN c_group_id(l_book_type_code,l_category_id) LOOP
622: l_file_name := l_file_path||igi_imp_iac_export_pkg.trim_invalid_chars(l_book_type_code)|| '_' ||
623: igi_imp_iac_export_pkg.trim_invalid_chars(l_category_name)|| '_' ||
624: TO_CHAR(cv_group_id.group_id)|| '_' ||
625: 'in.csv';
626:

Line 623: igi_imp_iac_export_pkg.trim_invalid_chars(l_category_name)|| '_' ||

619:
620: -- Build file names to be processed
621: FOR cv_group_id IN c_group_id(l_book_type_code,l_category_id) LOOP
622: l_file_name := l_file_path||igi_imp_iac_export_pkg.trim_invalid_chars(l_book_type_code)|| '_' ||
623: igi_imp_iac_export_pkg.trim_invalid_chars(l_category_name)|| '_' ||
624: TO_CHAR(cv_group_id.group_id)|| '_' ||
625: 'in.csv';
626:
627: -- Write file name to log file