
/*------ ATD 335485 ------*/
DECLARE v_count NUMBER:=0;
BEGIN
SELECT Count(1) INTO v_count FROM USER_TAB_COLUMNS WHERE UPPER(table_name) = 'OPEVIPILIF' and UPPER(column_name) = 'INDICADORORIGEM';
IF v_count = 0 THEN
EXECUTE IMMEDIATE 'ALTER TABLE OPEVIPILIF ADD INDICADORORIGEM CHAR(1) NULL';
END IF;
END;


DECLARE v_count NUMBER:=0;
BEGIN
SELECT Count(1) INTO v_count FROM USER_TAB_COLUMNS WHERE UPPER(table_name) = 'OPEVIPILIF' and UPPER(column_name) = 'NUMERODOCUMENTO';
IF v_count = 0 THEN
EXECUTE IMMEDIATE 'ALTER TABLE OPEVIPILIF ADD NUMERODOCUMENTO VARCHAR2(20) NULL';
END IF;
END;