-- TAREFA 188896
DECLARE 
V_COUNT NUMBER (10,0); 
BEGIN 
	BEGIN 
		SELECT COUNT(COLUMN_ID) INTO V_COUNT FROM ALL_TAB_COLUMNS WHERE OWNER = 'EDUSOFT_MENTOR_AGENDADOR' AND TABLE_NAME = 'TB_PROCESSO' AND COLUMN_NAME = 'PRC_EMAL_RELUSER'; 
	EXCEPTION 
		WHEN NO_DATA_FOUND THEN 
			V_COUNT :=0; 
	END; 
	IF (V_COUNT = 0) 
	THEN 
		EXECUTE IMMEDIATE 
		'ALTER TABLE EDUSOFT_MENTOR_AGENDADOR.TB_PROCESSO ADD PRC_EMAL_RELUSER VARCHAR2 (255)  NULL '; 
	END IF; 
END;

 -- TAREFA 188896
DECLARE 
V_COUNT NUMBER (10,0); 
BEGIN 
	BEGIN 
		SELECT COUNT(COLUMN_ID) INTO V_COUNT FROM ALL_TAB_COLUMNS WHERE OWNER = 'EDUSOFT_MENTOR_AGENDADOR' AND TABLE_NAME = 'TB_PROCESSO' AND COLUMN_NAME = 'PRC_UNIDADE_EMALREL'; 
	EXCEPTION 
		WHEN NO_DATA_FOUND THEN 
			V_COUNT :=0; 
	END; 
	IF (V_COUNT = 0) 
	THEN 
		EXECUTE IMMEDIATE 
		'ALTER TABLE EDUSOFT_MENTOR_AGENDADOR.TB_PROCESSO ADD PRC_UNIDADE_EMALREL VARCHAR2 (255)  NULL '; 
	END IF; 
END;

 -- TAREFA 188896
DECLARE 
V_COUNT NUMBER (10,0); 
BEGIN 
	BEGIN 
		SELECT COUNT(COLUMN_ID) INTO V_COUNT FROM ALL_TAB_COLUMNS WHERE OWNER = 'EDUSOFT_MENTOR_AGENDADOR' AND TABLE_NAME = 'TB_PROCESSO' AND COLUMN_NAME = 'PRC_MODULOEMAIL_REL'; 
	EXCEPTION 
		WHEN NO_DATA_FOUND THEN 
			V_COUNT :=0; 
	END; 
	IF (V_COUNT = 0) 
	THEN 
		EXECUTE IMMEDIATE 
		'ALTER TABLE EDUSOFT_MENTOR_AGENDADOR.TB_PROCESSO ADD PRC_MODULOEMAIL_REL NUMBER (10 , 0)  NULL '; 
	END IF; 
END;

 -- TAREFA 188896
DECLARE 
V_COUNT NUMBER (10,0); 
BEGIN 
	BEGIN 
		SELECT COUNT(COLUMN_ID) INTO V_COUNT FROM ALL_TAB_COLUMNS WHERE OWNER = 'EDUSOFT_MENTOR_AGENDADOR' AND TABLE_NAME = 'TB_PROCESSO' AND COLUMN_NAME = 'PRC_SUBNIVEL_ENSINO'; 
	EXCEPTION 
		WHEN NO_DATA_FOUND THEN 
			V_COUNT :=0; 
	END; 
	IF (V_COUNT = 0) 
	THEN 
		EXECUTE IMMEDIATE 
		'ALTER TABLE EDUSOFT_MENTOR_AGENDADOR.TB_PROCESSO ADD PRC_SUBNIVEL_ENSINO VARCHAR2 (255)  NULL '; 
	END IF; 
END;