11997: --
11998: BEGIN
11999: SELECT value
12000: INTO l_extract_etc
12001: FROM pji_system_parameters
12002: WHERE name = 'EXTRACT_ETC_FULLLOAD';
12003: EXCEPTION
12004: WHEN OTHERS THEN
12005: l_extract_etc := 'Y';
12005: l_extract_etc := 'Y';
12006: END;
12007:
12008: IF (l_extract_etc = 'N') THEN
12009: UPDATE pji_system_parameters
12010: SET value = 'Y'
12011: WHERE name = 'EXTRACT_ETC_FULLLOAD';
12012: END IF;
12013: