/*****************************************************************************
*
* Filename         - $Workfile:   onward_flight_defs.sql  $
*
*                     Name              Date      Version     CR Number
* Author           - See revision history below.
* Last Update      - See revision history below.
*
* Project Name     - TAGTRAK(Oracle Database)
*
* Source Code
* Identifier       - 0/3/300/8010/112
*
* Design Spec
* Section          -
*
* Contents         - Live Schema Stored Procedure
*
* Language         - Oracle SQL*Plus script
*
* Classification   - Commercial In Confidence
*
*          (c) Ultra Electronics Limited, 1998
*
*****************************************************************************/
/****************************************************************************
* @(#)$Workfile:   onward_flight_defs.sql  $  $Revision:   1.3  $
*
* Revision History
*
* Note that user tagtrak is many users. For these users the user
* name is entered as the last line in the change description.
*
* $Log:   /pvcsarch/db_ora/db/source/live/procedures/onward_flight_defs.svl  $
* 
*    Rev 1.3   20 Sep 1999 14:41:52   tagtrak
*  
* 
*    Rev 1.2   26 Feb 1999 08:58:48   tagtrak
*  
* 
*    Rev 1.1   26 Feb 1999 08:49:04   tagtrak
*  
*
****************************************************************************/

/****************************************************************************
   Definition of pl/sql table used to access onward_flight data.
****************************************************************************/

PROMPT CREATE OR REPLACE PACKAGE onward_flight_defs 

CREATE OR REPLACE PACKAGE onward_flight_defs 
AS
   TYPE onwd_flt_rec_t IS RECORD
   (
      NO         onward_flight.no%TYPE,
      ODATE      onward_flight.odate%TYPE,
      DEST       onward_flight.dest%TYPE,
      DEST_ORDER onward_flight.dest_order%TYPE,
      CLASS      onward_flight.class%TYPE
   );

   TYPE onwd_flt_t IS 
  		TABLE OF onwd_flt_rec_t
  		INDEX BY BINARY_INTEGER;

   TYPE onwd_dest_t IS
      TABLE OF onward_flight.dest%TYPE
      INDEX BY BINARY_INTEGER; 

   TYPE onwd_no_t IS
      TABLE OF onward_flight.no%TYPE
      INDEX BY BINARY_INTEGER;

   TYPE onwd_date_t IS
      TABLE OF onward_flight.odate%TYPE
      INDEX BY BINARY_INTEGER;

   TYPE onwd_class_t IS
      TABLE OF onward_flight.class%TYPE
      INDEX BY BINARY_INTEGER;

END onward_flight_defs;
/
