/*****************************************************************************
*
* Filename         - $Workfile:   arch_procs.sql  $
*
*                     Name              Date      Version     CR Number
*                     Martin Helliwell 16/08/01   1.10        15488
* 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         - Create all archive schema procedures
*
* Language         - Oracle SQL*Plus script
*
* Classification   - Commercial In Confidence
*
*          (c) Ultra Electronics Limited, 1997
*
*****************************************************************************/
/****************************************************************************
* @(#)$Workfile:   arch_procs.sql  $  $Revision:   1.10  $
*
* 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/arch/procedures/arch_procs.sqv  $
*
*    Rev 1.10   16 Aug 2001 14:42:12   tagtrak
* OR:
* CR: 15487
* REV: 1.1
* DESC: Add mws_web and pbc
*
*    Rev 1.9   06 Jun 2000 09:09:02   tagtrak
*
*
*    Rev 1.8   08 Apr 1999 15:20:02   tagtrak
* OR: 13206
* CR:
* REV:
* Andrew Walker
* (branch build revision copied to trunk.)
* Neil Bishop
*
*    Rev 1.7.1.0   25 Feb 1999 15:30:34   tagtrak
* OR: 13206
* CR:
* REV:
* Andrew Walker
*
*    Rev 1.7   12 Oct 1998 16:41:08   tagtrak
* OR: 12682 12683 12678 12654 12419 12265 12805 12285
* CR: 12682 12683 12678 12654 12419 12265 12805
* REV:
* Vienna enhancements/fixes for database V0.4.1E
* branch ATS revision moved to trunk.
* Andrew Walker
*
*    Rev 1.6.1.0   25 Sep 1998 12:35:24   tagtrak
* OR: 12682 12683 12678 12654 12419 12265 12285
* CR: 12682 12683 12678 12654 12419 12265
* REV:
* Vienna enhancements for Database 0.4.1
* Andrew Walker
*
*    Rev 1.6   03 Sep 1998 08:46:06   tagtrak
* OR: 12484
* CR: 12484
* REV:
* Added derive_seq_no.sql
*
*    Rev 1.5   02 Apr 1998 19:00:28   tagtrak
* OR:
* CR:
* REV:
* Initial Issue
* For concession see label
*
*    Rev 1.4   15 Jan 1998 15:04:08   tagtrak
* OR:
* CR:
* REV:
* Minor update to hide headers of subsequent scripts
*
*    Rev 1.3   28 Oct 1997 15:07:00   tagtrak
* Added PVCS header
*
****************************************************************************/

set doc off;
@@../live_schema/stored_procs/flight_id2.sql
@@../live_schema/stored_procs/flight_loading_progress.sql
@@../live_schema/stored_procs/flight_no.sql
@@../live_schema/stored_procs/check_flight_access.sql
@@../live_schema/stored_procs/flts_ldg_prog_by_time.sql
@@../live_schema/stored_procs/get_first_bag_load1.sql
@@../live_schema/stored_procs/get_last_bag_load1.sql
@@../live_schema/stored_procs/get_last_bld_trace.sql
@@../live_schema/stored_procs/pax_bag_count.sql
@@../live_schema/stored_procs/flts_pax_bag_count_by_time_mws.sql
@@../live_schema/stored_procs/uld_ldg_prog.sql
@@../live_schema/stored_procs/derive_seq_no.sql
@@../live_schema/stored_procs/get_gate_apron.sql
@@../live_schema/stored_procs/add_blo_indicator.sql
@@../live_schema/stored_procs/pax_and_bag_count.sql
@@../live_schema/stored_procs/pbc.sql
@@../live_schema/stored_procs/uld_loading_progress.sql
@@../live_schema/stored_procs/loading_prog_by_time.sql
@@../live_schema/stored_procs/flts_pax_bag_count_by_time.sql
@@../arch_schema/stored_procs/mws_web.sql
@@../live_schema/stored_procs/multi_site.sql
@@../live_schema/stored_procs/terminating_count.sql
@@../live_schema/stored_procs/uld_class_list.sql
@@../live_schema/stored_procs/onward_count.sql
@@../live_schema/stored_procs/onward_reports.sql
@@../live_schema/stored_procs/bag_report_utils.sql
@@../live_schema/stored_procs/exceed_track_type.sql
@@../live_schema/stored_procs/missed_track_type.sql
@@../live_schema/stored_procs/critical_track_type.sql
@@../live_schema/stored_procs/mws_tracking.sql
@@../live_schema/stored_procs/eq_tracking.sql  
@@../live_schema/stored_procs/flight_list.sql
@@../live_schema/stored_procs/pax_and_bag_counts_rec.sql
@@../live_schema/stored_procs/pax_and_bag_counts_tab.sql
@@../live_schema/stored_procs/multi_flight_pax_and_bag_count.sql
@@../live_schema/stored_procs/aggregate_misc_exceptions.sql
@@../live_schema/stored_procs/first_successful_load.sql
@@unauthorised_bags.sql
@@../live_schema/stored_procs/uld_bag_weight.sql
@@../live_schema/stored_procs/uld_max_weight.sql
@@../live_schema/stored_procs/ulds_pkg_spec.sql
@@../live_schema/stored_procs/ulds_pkg.sql
@@../live_schema/stored_procs/get_best_arrival_time.sql
@@../live_schema/stored_procs/stop_reason.sql
@@../live_schema/stored_procs/get_best_schd_time.sql
@@../live_schema/stored_procs/count_ulds.sql
@@../live_schema/stored_procs/count_bags.sql
@@../live_schema/stored_procs/normalise_flight_no.sql
@@../live_schema/stored_procs/get_arr_stand.sql
@@../live_schema/types/flight_list_rec.sql
@@../live_schema/types/flight_list_tab.sql
@@../live_schema/stored_procs/flight_loop_data_pkg_spec.sql
@@../live_schema/stored_procs/flight_loop_data_pkg.sql
