DROP TYPE T_AFW_ADD_FIELDS_ROW;
/

CREATE OR REPLACE TYPE AFW_ADD_FIELDS_ROW AS OBJECT (
    fl_int_id_field         NUMBER (11, 0),
	fl_str_identifier       VARCHAR2 (255),
    fl_str_name             VARCHAR2 (255),
    fl_str_description      VARCHAR2 (255),
    fl_int_field_type       NUMBER (11, 0),
    fl_int_id_project       NUMBER (11, 0),
    fl_int_registry_type    NUMBER (11, 0),
    fl_int_mandatory_user   NUMBER (11, 0),
    fl_int_mandatory_esp    NUMBER (11, 0),
    fl_int_visible_user     NUMBER (11, 0),
    fl_int_visible_esp      NUMBER (11, 0),
    fl_int_editable_user    NUMBER (11, 0),
    fl_int_editable_esp     NUMBER (11, 0),
    fl_int_category_field   NUMBER (11, 0),
    fl_int_category_field_2 NUMBER (11, 0),
    fl_int_category_value   NUMBER (11, 0),
    fl_str_mask             VARCHAR2 (255),
    fl_int_order            NUMBER (11, 0),
    sentence                VARCHAR2 (255),
    rel_field_id            NUMBER (11, 0),
    lvl                     NUMBER (11, 0),
    fl_str_field_value      VARCHAR2 (4000),
    fl_int_field_value      NUMBER (11, 0),
    fl_date_field_value     DATE,
    lookup_id               NUMBER (11, 0),
    trg_lookup_id           NUMBER (11, 0)
);
/

CREATE TYPE T_AFW_ADD_FIELDS_ROW AS TABLE OF AFW_ADD_FIELDS_ROW;
/