/* $Id$ */
/*============================================================================*
 |                 Copyright (c) 2011 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_ORG_CHART_TYPE AS OBJECT
  (entity_code           varchar2(30)
  ,primary_key_id        number
  ,person_id             number
  ,parent_entity_code    varchar2(30)
  ,parent_primary_key_id number
  ,hier_level            number
  ,dr_count              number
  ,total_count           number)
/

CREATE OR REPLACE TYPE XXAS_COM_ORG_CHART_VARRAY AS
VARRAY(100000) OF xxas_com_org_chart_type
/

COMMIT;
EXIT;
