DROP TYPE APROVA_ALCADAS_TABLE
/

DROP TYPE APROVA_ALCADAS_TYPE
/

CREATE OR REPLACE TYPE APROVA_ALCADAS_TYPE AS OBJECT (
    NRAPROVALCADA       NUMBER, 
    NRCONFIGALCADA      NUMBER,         
    NMALCADA            VARCHAR2(30), 
    IDTIPOVRAPROV       VARCHAR2(10), 
    CDFILDEST           VARCHAR2(4), 
    CDFILLANC           VARCHAR2(4), 
    NRDEMANDA           VARCHAR2(10), 
    IDTPDEMANDA         VARCHAR2(30), 
    IDCLASSIFIC         VARCHAR2(30), 
    IDAPROVADO          VARCHAR2(30),
    DTINCLUSAO          DATE, 
    APROVADOR           VARCHAR2(12), 
    VRAPROVCMP          FLOAT, 
    NMFILDEST           VARCHAR2(30), 
    VRTOTALAF           VARCHAR2(30), 
    DSMOTVAFALCADA      VARCHAR2(2000),
    CDFORNECED          VARCHAR2(21), 
    NRINSJURFORN        VARCHAR2(20),
    NMRAZSOCFORN        VARCHAR2(100), 
    NMFANTFORN          VARCHAR2(250), 
    NRORG               NUMBER, 
    DTPROGENTAF         DATE,
    VRORCAMENTO         FLOAT, 
    VRREALIZADO         FLOAT, 
    VRDIFERENCA         FLOAT,
    IDEXIGJUSTIFICATIVA VARCHAR2(1),
    IDTPALCADA          VARCHAR2(30),
    CDFILCENTCMP        VARCHAR2(4),
    IDTIPOAF            VARCHAR2(30),
    IDLANCAFEXTRA       VARCHAR2(30),
    IDCONSISTVRAPROV    VARCHAR2(1)
)
/

CREATE TYPE APROVA_ALCADAS_TABLE AS TABLE OF APROVA_ALCADAS_TYPE
/