drop type ULD_OBJECT;
drop type ULD_DETAILS_TAB;
drop type ULD_DETAILS;
PROMPT CREATE OR REPLACE TYPE ULD_DETAILS AS OBJECT

CREATE OR REPLACE TYPE ULD_DETAILS AS OBJECT(
  bag_tag      VARCHAR2(10)
, bag_seq      NUMBER(10)
, pax_sur      VARCHAR2(27)
, pax_init     VARCHAR2(4)
);
/
PROMPT CREATE OR REPLACE TYPE ULD_DETAILS_TAB AS TABLE OF ULD_DETAILS

CREATE OR REPLACE TYPE ULD_DETAILS_TAB AS TABLE OF ULD_DETAILS;
/

CREATE OR REPLACE TYPE ULD_OBJECT AS OBJECT(
  uld_no        VARCHAR2(10)
, flight_no     VARCHAR2(10)
, flight_date   VARCHAR2(5)
, no_of_bags    NUMBER(10)
, site_name     varchar2(70)
, site_host     VARCHAR2(30)
, site_port     number(10)
, wan_port      number(10)
, wan_host      varchar2(20)
, uld_content   ULD_DETAILS_TAB
, msg_id        varchar2(50)
);

/  



