APPS.IGI_IMP_IAC_WEBADI_PKG dependencies on IGI_IMP_IAC_INTERFACE_CTRL

Line 46: FROM igi_imp_iac_interface_ctrl

42: BEGIN
43:
44: SELECT COUNT(*)
45: INTO l_count
46: FROM igi_imp_iac_interface_ctrl
47: WHERE book_type_code = n_book_code
48: AND category_id = (SELECT category_id
49: FROM fa_categories_b_kfv
50: WHERE concatenated_segments = n_category_desc);

Line 66: l_tfr_stat igi_imp_iac_interface_ctrl.transfer_status%TYPE;

62: -- ===================================================================
63: FUNCTION Validate_Transfer(n_book_code IN VARCHAR2,
64: n_category_desc IN VARCHAR2)
65: RETURN VARCHAR2 IS
66: l_tfr_stat igi_imp_iac_interface_ctrl.transfer_status%TYPE;
67: BEGIN
68: SELECT transfer_status
69: INTO l_tfr_stat
70: FROM igi_imp_iac_interface_ctrl

Line 70: FROM igi_imp_iac_interface_ctrl

66: l_tfr_stat igi_imp_iac_interface_ctrl.transfer_status%TYPE;
67: BEGIN
68: SELECT transfer_status
69: INTO l_tfr_stat
70: FROM igi_imp_iac_interface_ctrl
71: WHERE book_type_code = n_book_code
72: AND category_id = (SELECT category_id
73: FROM fa_categories_b_kfv
74: WHERE concatenated_segments = n_category_desc);

Line 196: l_transfer_status igi_imp_iac_interface_ctrl.transfer_status%TYPE;

192: l_exists VARCHAR2(1);
193: l_count NUMBER;
194: l_adi_enabled VARCHAR2(3);
195: l_request_status igi_imp_iac_controls.request_status%TYPE;
196: l_transfer_status igi_imp_iac_interface_ctrl.transfer_status%TYPE;
197:
198: l_valid BOOLEAN := TRUE;
199:
200: l_deprn_flag fa_books.depreciate_flag%type;