/*****************************************************************************
*
* Filename         - $Workfile:   compile_triggers.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: recompile all triggers in the schema
*
* Language         - Oracle SQL*Plus script
*
* Classification   - Commercial In Confidence
*
*          (c) Ultra Electronics Limited, 1997
*
*****************************************************************************/
/****************************************************************************
* @(#)$Workfile:   compile_triggers.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/live/triggers/compile_triggers.svl  $
* 
*    Rev 1.10   21 Jun 2001 15:04:04   tagtrak
* OR:
* CR:
* Re-baseline version 4.0.0 to include patches.
* 
*    Rev 1.9   26 Jul 1999 10:02:00   tagtrak
* OR:
* CR: 14077
* REV:
* Helsinki FIDS changes.
* 
* Neil Bishop.
* 
*    Rev 1.8.1.0   07 Jul 1999 11:54:28   tagtrak
* OR:
* CR: 14077 
* REV:
* Helsinki FIDS changes.
* 
* Neil Bishop.
* 
*    Rev 1.7   08 Apr 1999 15:24:28   tagtrak
* OR: 
* CR: 13385
* REV:
* Modifications to provide interface for Ferranti (FASL) Flight
* Information at San Francisco.
* -------------
* Andrew Walker
* (branch build revision copied to trunk.)
* Neil Bishop
* 
*    Rev 1.6.1.0   25 Feb 1999 15:21:48   tagtrak
* OR: 
* CR: 13385
* REV:
* Modifications to provide interface for Ferranti (FASL) Flight
* Information at San Francisco.
* -------------
* Andrew Walker
* 
*    Rev 1.6   04 Nov 1998 16:26:10   tagtrak
* OR: 12648
* CR: 12648
* REV:
* Bag Trace records were not cleared by Archive & Backup
* Andrew Walker
* (branch ATS revision copied to trunk.)
* Andrew Walker
* 
*    Rev 1.5.1.0   22 Oct 1998 14:02:58   tagtrak
* OR: 12648
* CR: 12648
* REV:
* Bag Trace records were not cleared by Archive & Backup
* Andrew Walker
* 
*    Rev 1.5   12 Oct 1998 16:44:14   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.4.1.0   25 Sep 1998 12:33:00   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.3.2.0   18 Aug 1998 09:33:22   tagtrak
* OR: 12484
* CR: 12484
* REV:
* Merging Vienna (0.3.1E) and Core Product (0.2.5E).
* Andrew Walker
* 
*    Rev 1.3.1.0   04 Jun 1998 15:31:02   tagtrak
* OR:
* CR: 12098
* REV:
* Vienna Modifications
* Andrew Walker
* 
*    Rev 1.3   02 Apr 1998 19:45:58   tagtrak
* OR:
* CR:
* REV:
* Initial Issue
* See label for concession
* 
*    Rev 1.2   26 Feb 1998 11:52:12   tagtrak
* OR:
* CR:
* REV:
* Initial core product version
* 
*    Rev 1.1   15 Jan 1998 13:38:52   tagtrak
* OR: OR11101, TN13, TN15
* CR:
* REV:
* Phase 2C to Phase 3 upgrade plus code review actions and resolving some technical issues.
* 
* 
*    Rev 1.0   22 Oct 1997 16:38:24   tagtrak
* OR:
* CR:
* REV:
* Initial check-in
*
****************************************************************************/

/*
 * - Compile all of the SQL triggers.
*/

alter trigger POST_FS_EVENT compile;
alter trigger TD2_SYSTEM_CFG compile;
alter trigger TD_AGENTS compile;
alter trigger TD_CONTRACTED_AGENTS compile;
alter trigger TD_ERROR compile;
alter trigger TD_FLIGHT_ACCESS compile;
alter trigger TD_FLIGHT_PRIV compile;
alter trigger TD_LOCATION compile;
alter trigger TD_MBA_FLIGHTS compile;
alter trigger TD_PRIVILEGE compile;
alter trigger TD_SYSTEM_CFG compile;
alter trigger TD_TAGTRAK_USERS compile;
alter trigger TD_USER_GROUP compile;
alter trigger TIAS_FLIGHT compile;
alter trigger TIA_FLIGHT compile;
alter trigger TIA_FLIGHT_PRIV compile;
alter trigger TIB_FLIGHT_PRIV compile;
alter trigger TI_AGENTS compile;
alter trigger TI_BAG compile;
alter trigger TI_BAG_ALERT compile;
alter trigger TI_BAG_TRACE compile;
alter trigger TI_CARRIER_LOOKUP compile;
alter trigger TI_CONTRACTED_AGENTS compile;
alter trigger TI_DB_VERSION compile;
alter trigger TI_ERROR compile;
alter trigger TI_FLIGHT compile;
alter trigger TI_FLIGHT_ACCESS compile;
alter trigger TI_LOCATION compile;
alter trigger TI_LOG_TABLE compile;
alter trigger TI_MAIL_GLOBAL compile;
alter trigger TI_MAIL_INDIV compile;
alter trigger TI_PAX compile;
alter trigger TI_PRIVILEGE compile;
alter trigger TI_TAGTRAK_USERS compile;
alter trigger TI_ULD_TRACE compile;
alter trigger TI_USER_GROUP compile;
alter trigger TU2_SYSTEM_CFG compile;
alter trigger TUAS_FLIGHT compile;
alter trigger TUAS_TAGTRAK_USERS compile;
alter trigger TUA_FLIGHT compile;
alter trigger TUBS_TAGTRAK_USERS compile;
alter trigger TU_AGENTS compile;
alter trigger TU_BAG compile;
alter trigger TD_BAG compile;
alter trigger TU_CARRIER_LOOKUP compile;
alter trigger TU_CONTRACTED_AGENTS compile;
alter trigger TU_ERROR compile;
alter trigger TU_FLIGHT compile;
alter trigger TD_FLIGHT compile;
alter trigger TU_FLIGHT_ACCESS compile;
alter trigger TU_FLIGHT_PRIV compile;
alter trigger TU_LOCATION compile;
alter trigger TU_LOG_TABLE compile;
alter trigger TU_MWS_SEARCH_PLANS compile;
alter trigger TU_PAX compile;
alter trigger TU_PRIVILEGE compile;
alter trigger TU_SYSTEM_CFG compile;
alter trigger TU_TAGTRAK_USERS compile;
alter trigger TU_ULD_TRACE compile;
alter trigger TU_ULD_TYPES compile;
alter trigger TU_USER_GROUP compile;
alter trigger TI_CODE_SHARE compile;
alter trigger TD_CODE_SHARE compile;
alter trigger TIAS_FLIGHT_PRIV compile;
alter trigger TIA_CODE_SHARE compile;
alter trigger TI_WEIGHTS compile;
alter trigger ti_carrier_map compile;
alter trigger ti_mach_flight_info compile;
alter trigger ti_fasl_flight_info compile;
alter trigger tu_fasl_flight_info compile;
alter trigger tia_fasl_flight_info compile;
alter trigger tua_fasl_flight_info compile;
alter trigger ti_hel_fids_flight_info compile;
alter trigger tu_hel_fids_flight_info compile;
alter trigger tia_hel_fids_flight_info compile;
alter trigger tua_hel_fids_flight_info compile;
alter trigger ti_flight_dests compile;
alter trigger tu_ulds compile;
alter trigger tuas_ulds compile;
alter trigger ti_site_info compile;
alter trigger ti_onward_flight compile;
