APPS.IGI_IMP_IAC_IMPORT_PKG dependencies on IGI_IMP_IAC_CONTROLS

Line 512: igi_imp_iac_controls.book_type_code%TYPE) IS

508: ) IS
509:
510: -- Cursor to validate book type code
511: CURSOR c_book_type_code (cp_book_type_code
512: igi_imp_iac_controls.book_type_code%TYPE) IS
513: SELECT request_status
514: FROM igi_imp_iac_controls
515: WHERE book_type_code = cp_book_type_code;
516:

Line 514: FROM igi_imp_iac_controls

510: -- Cursor to validate book type code
511: CURSOR c_book_type_code (cp_book_type_code
512: igi_imp_iac_controls.book_type_code%TYPE) IS
513: SELECT request_status
514: FROM igi_imp_iac_controls
515: WHERE book_type_code = cp_book_type_code;
516:
517: -- Cursor to validate category id
518: CURSOR c_category_id (cp_book_type_code

Line 550: l_request_status igi_imp_iac_controls.request_status%TYPE;

546: -- l_new_book_type_code igi_imp_iac_interface.book_type_code%TYPE; -- Bug No. 2843747 (Tpradhan) - Coommented since no longer in use
547: l_category_id igi_imp_iac_interface.category_id%TYPE;
548: l_category_name VARCHAR2(350);
549:
550: l_request_status igi_imp_iac_controls.request_status%TYPE;
551: l_message VARCHAR2(1000);
552: l_file_path VARCHAR2(1000);
553: l_file_name VARCHAR2(1000);
554: l_count NUMBER := 0;