/* $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_HIER2_TYPE AS OBJECT
  (person_id            number
  ,assignment_id        number
  ,parent_assignment_id number
  ,dr_count             number
  ,hier_level           number)
/

CREATE OR REPLACE TYPE XXAS_COM_HIER2_TABLE AS TABLE OF XXAS_COM_HIER2_TYPE
/

COMMIT;
EXIT;
