APPS.IGI_IMP_IAC_WEBADI_PKG dependencies on IGI_IMP_IAC_CONTROLS

Line 20: l_req_status igi_imp_iac_controls.request_status%TYPE;

16: -- is valid and the request status for the book
17: -- ===================================================================
18: FUNCTION Validate_Book(n_book_code IN VARCHAR2)
19: RETURN VARCHAR2 IS
20: l_req_status igi_imp_iac_controls.request_status%TYPE;
21: BEGIN
22: SELECT request_status
23: INTO l_req_status
24: FROM igi_imp_iac_controls

Line 24: FROM igi_imp_iac_controls

20: l_req_status igi_imp_iac_controls.request_status%TYPE;
21: BEGIN
22: SELECT request_status
23: INTO l_req_status
24: FROM igi_imp_iac_controls
25: WHERE book_type_code = n_book_code;
26:
27: RETURN(l_req_status);
28: EXCEPTION

Line 195: l_request_status igi_imp_iac_controls.request_status%TYPE;

191:
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:

Line 235: -- validate if p_book_type_code exists in control table igi_imp_iac_controls

231: END IF;
232:
233: igi_iac_debug_pkg.debug_other_string(g_state_level, g_path||'upload_data', 'Web ADI is enabled');
234:
235: -- validate if p_book_type_code exists in control table igi_imp_iac_controls
236: l_request_status := validate_book(p_book_code);
237: IF (l_request_status IS NULL) THEN
238: l_valid := FALSE;
239: RAISE e_invalid_book;