#!/bin/sh
#*******************************************************************************
#             PACOR II SOFTWARE
#       Property of the U.S. Government
#            NASA/GSFC/Code 560
#*******************************************************************************
#PURPOSE:  Load procedures and functions into the PICS database
#
#INVOCATION METHOD:  LoadProcedures userid/password
#
# EXTERNAL VARIABLES:
# Source               Name               Type   Use  Description
# ----------------------------------------------------------------------------
# dps_db.create     DPS_DBA_HOME          char    I   location of db create scripts
#
#
#DEVELOPMENT HISTORY:
#
#    Author     Change-ID  Release    Date        Description of Change
# ------------  ---------  -------  --------  -----------------------------
# J. Whelan        N/A     R2.1/B4  10/26/94  Initial implementation
# J. Whelan     PAC2951000 R2.2     03/21/95  Replace del_rawsched.proc with
#                                             del_schedmsg.proc
# I. Horowitz   ACE0615   ACE R2.0  06/30/96  Removed use of local log file
# I. Horowitz   TRACE0138  R2.0.2   05/13/97  Merged Pacor II Rel 3.1 change with 
#						ACE changes
# I. Horowitz   TRACE      R3.0     06/08/98  Replace time conversion functions
#						with time_conv package.
#
# Notes:
#  	1) Pacor II R3.1 change
# 		J. Raymond    PAC2961542 R3.1     06/27/96  Added del_gpseqnum.proc
#
#
#*********************************************************************************
if test $# -ne 1
then
   echo '***********************************************'
   echo 'Error, you must enter an Oracle UserID/Password'
   echo '***********************************************'
   exit
fi

#
# load functions
#
echo ""
echo "Loading time conversion package . . ."
$DPS_DBA_HOME/time_conv.sp $1 
#
# load procedures
#
echo ""
echo "Loading procedures . . ."
echo "   del_sessionid.proc"
$DPS_DBA_HOME/del_sessionid.proc $1 
echo "   del_eventlog.proc"
$DPS_DBA_HOME/del_eventlog.proc $1 
echo "   del_proddata.proc"
$DPS_DBA_HOME/del_proddata.proc $1
echo "   del_gpseqnum.proc"
$DPS_DBA_HOME/del_gpseqnum.proc $1

echo "******************************************************"
echo " Completed loading DPS functions and procedures"
echo "******************************************************"

