/*****************************************************************************
*
* Filename         - $Workfile:   all_procs.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         -
*		An sqlplus script to create the procedures and packages
* 	    which make up the live database schema
*
* Language         - Oracle SQL*Plus script
*
* Classification   - Commercial In Confidence
*
*          (c) Ultra Electronics Limited, 1997
*
*****************************************************************************/
/****************************************************************************
* @(#)$Workfile:   all_procs.sql  $  $Revision:   1.22  $
*
* 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/all_procs.sqv  $
* 
*    Rev 1.22   21 Jun 2001 14:42:00   tagtrak
* OR:
* CR:
* Re-baseline version 4.0.0 to include patches.
* 
*    Rev 1.20   31 Jan 2000 14:49:26   tagtrak
*  
* 
*    Rev 1.19   20 Sep 1999 14:40:12   tagtrak
*  
* 
*    Rev 1.18.2.1   26 Jul 1999 10:03:14   tagtrak
* OR:
* CR: 14077
* REV:
* Helsinki FIDS changes.
* 
* Neil Bishop.
* 
*    Rev 1.18.2.0.1.0   07 Jul 1999 11:55:20   tagtrak
* OR:
* CR: 14077 
* REV:
* Helsinki FIDS changes.
* 
* Neil Bishop.
* 
*    Rev 1.19   10 Jun 1999 14:51:42   tagtrak
* OR:
* CR: 14043
* REV:
* Changed Archive and Backup so that the database
* can be accessed during the eraseLive function.
* 
* Neil Bishop.
* 
*    Rev 1.18   08 Apr 1999 15:21:22   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.17.1.0   25 Feb 1999 15:22:52   tagtrak
* OR: 
* CR: 13385
* REV:
* Modifications to provide interface for Ferranti (FASL) Flight
* Information at San Francisco.
* -------------
* Andrew Walker
* 
*    Rev 1.17   16 Dec 1998 11:33:48   tagtrak
* OR: 12529 12356
* CR: 12529 12356
* REV:
* 12529
* Modifications to rectify issues noted in Core Product
* during Air France development
* 12356
* Enhance functionality of adding gate passengers from scanner
* as part of the duplicate sequence numbers solution.
* -------------
* Andrew Walker
* -------------
* (branch ATS revision copied to trunk.)
* Andrew Walker
* 
*    Rev 1.16.1.1   02 Dec 1998 13:51:26   tagtrak
* OR: 12529 12356
* CR: 12529 12356
* REV:
* 12529
* Modifications to rectify issues noted in Core Product
* during Air France development
* --------------------------
* 12356
* Enhance functionality of adding gate passengers from scanner
* as part of the duplicate sequence numbers solution.
* -------------
* Andrew Walker
* 
*    Rev 1.16.1.0   19 Nov 1998 16:14:10   tagtrak
* OR: 12529
* CR: 12529
* REV:
* Modifications to rectify issues noted in Core Product
* during Air France development
* -------------
* Andrew Walker
* 
*    Rev 1.16   04 Nov 1998 16:25:32   tagtrak
* OR: 12686
* CR: 12686
* REV:
* Show ULD hold position on bag_search report
* Andrew Walker
* (branch ATS revision copied to trunk.)
* Andrew Walker
* 
*    Rev 1.15.1.0   22 Oct 1998 14:04:14   tagtrak
* OR: 12686
* CR: 12686
* REV:
* Show ULD hold position on bag_search report
* Andrew Walker
* 
*    Rev 1.15   12 Oct 1998 16:42:24   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.14.1.0   25 Sep 1998 12:33:16   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.13.3.1   03 Sep 1998 08:40:16   tagtrak
* OR: 12484
* CR: 12484
* REV:
* Added derive_seq_no.sql
* 
*    Rev 1.13.3.0   18 Aug 1998 09:34:16   tagtrak
* OR: 12484
* CR: 12484
* REV:
* Merging Vienna (0.3.1E) and Core Product (0.2.5E).
* Andrew Walker
* 
*    Rev 1.13.1.0   04 Jun 1998 15:31:52   tagtrak
* OR:
* CR: 12098
* REV:
* Vienna Modifications
* Andrew Walker
* 
*    Rev 1.13   02 Apr 1998 19:31:58   tagtrak
* OR:
* CR:
* REV:
* Initial Issue
* See label for concession
* 
*    Rev 1.12   11 Mar 1998 15:10:28   tagtrak
* OR:
* CR:
* REV:
* Added the stored procedure reuse_exception_bag in
* the scripts.
* 
*    Rev 1.11   26 Feb 1998 10:08:06   tagtrak
* OR:
* CR:
* REV:
* Initial core product version
* 
*    Rev 1.10   15 Jan 1998 12:11:10   tagtrak
* OR: OR11101, TN13, TN15
* CR:
* REV:
* Phase 2C to Phase 3 upgrade plus code review actions and resolving some technical isses.
* 
*    Rev 1.9   24 Oct 1997 11:45:36   tagtrak
* Verifying PVCS conversion
* 
*    Rev 1.8   24 Oct 1997 11:00:56   tagtrak
* Added PVCS header information
*
****************************************************************************/

/*
 * - Call all of the SQL procedures
 * - Compile all schema objects
 * - select all of the objects that are invalid
 */

set doc off;
@@proc1.sql
@@proc2.sql
@@proc3.sql
@@proc4.sql
@@proc5.sql
@@proc6.sql
@@proc7.sql
@@proc8.sql

set pagesize 0

select
	'... Compiling all schema objects ... please wait ...'
from
	dual;

execute dbms_utility.compile_schema(USER);
set pagesize 24

select
	substr(object_name,1,40),
	object_type,
	status
from
	user_objects
where
	status = 'INVALID';
