/* $Id$ */
/*============================================================================*
 |                 Copyright (c) 2008 Applaud Solutions UK Ltd                |
 |                             All rights reserved                            |
 *===========================================================================*/

SET VERIFY OFF
SET FEEDBACK OFF
WHENEVER OSERROR  EXIT FAILURE ROLLBACK
WHENEVER SQLERROR EXIT FAILURE ROLLBACK

CREATE OR REPLACE TYPE XXAS_COM_HIER_TYPE AS OBJECT
  (person_id      number
  ,assignment_id  number
  ,dr_count       number)
/

CREATE OR REPLACE TYPE XXAS_COM_HIER_UP_TYPE AS OBJECT
  (person_id      number
  ,assignment_id  number
  ,hier_level     number)
/

CREATE OR REPLACE TYPE XXAS_COM_HIER_TABLE AS TABLE OF XXAS_COM_HIER_TYPE
/

CREATE OR REPLACE TYPE XXAS_COM_HIER_UP_TABLE AS TABLE OF XXAS_COM_HIER_UP_TYPE
/

COMMIT;
EXIT;
