APPS.IGI_IMP_IAC_IMPORT_PKG dependencies on IGI_IMP_IAC_INTERFACE_CTRL

Line 238: FROM igi_imp_iac_interface_ctrl

234: CURSOR c_chk_transfer_to_iac
235: (cp_book_type_code igi_imp_iac_interface.book_type_code%TYPE,
236: cp_category_id igi_imp_iac_interface.category_id%TYPE) IS
237: SELECT transfer_status
238: FROM igi_imp_iac_interface_ctrl
239: WHERE book_type_code = cp_book_type_code
240: AND category_id = cp_category_id;
241:
242: Cursor C_book_class( cp_book_type_code igi_imp_iac_interface.book_type_code%TYPE) is

Line 264: l_transfer_status igi_imp_iac_interface_ctrl.transfer_status%TYPE;

260:
261: --
262: -- Bug 2499880 Start(2)
263: --
264: l_transfer_status igi_imp_iac_interface_ctrl.transfer_status%TYPE;
265: --
266: -- Bug 2499880 End(2)
267: --
268: l_deprn_flag fa_books.depreciate_flag%type;

Line 519: igi_imp_iac_interface_ctrl.book_type_code%TYPE,

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
519: igi_imp_iac_interface_ctrl.book_type_code%TYPE,
520: cp_category_id
521: igi_imp_iac_interface_ctrl.category_id%TYPE) IS
522: SELECT COUNT(*)
523: FROM igi_imp_iac_interface_ctrl

Line 521: igi_imp_iac_interface_ctrl.category_id%TYPE) IS

517: -- Cursor to validate category id
518: CURSOR c_category_id (cp_book_type_code
519: igi_imp_iac_interface_ctrl.book_type_code%TYPE,
520: cp_category_id
521: igi_imp_iac_interface_ctrl.category_id%TYPE) IS
522: SELECT COUNT(*)
523: FROM igi_imp_iac_interface_ctrl
524: WHERE book_type_code = cp_book_type_code
525: AND category_id = cp_category_id;

Line 523: FROM igi_imp_iac_interface_ctrl

519: igi_imp_iac_interface_ctrl.book_type_code%TYPE,
520: cp_category_id
521: igi_imp_iac_interface_ctrl.category_id%TYPE) IS
522: SELECT COUNT(*)
523: FROM igi_imp_iac_interface_ctrl
524: WHERE book_type_code = cp_book_type_code
525: AND category_id = cp_category_id;
526:
527: -- Cursor for count of files to process