Download Concurrent Program LDT using shell script

To get shell script to Download the ldts for more than one concurrent program having same name but different Applications。

#!/bin/sh

SRCDIR=`pwd`

ORASID=`echo ${TWO_TASK:0:6} | tr '[A-Z]' '[a-z]'`
LOGDIR=${SRCDIR}

DATE=`date +%Y%m%d`
TIME=`date +%H%M%S`
FILE=${LOGDIR}/XX_GENERATE_LDT_INSTALL_${DATE}${TIME}.log

TEE="tee -a ${FILE}"

if [ ! -d ${LOGDIR} ] ; then
  echo "Unable to locate ${LOGDIR}"
  exit 1
fi

# +=================================================================================+
# | VALIDATE LOGIN ID AND PASSWORD
# +=================================================================================+
CHKLOGIN(){
    if sqlplus -s /nolog </dev/null 2>&1
        WHENEVER SQLERROR EXIT 1;
        CONNECT $1 ;

        EXIT;
!
    then
        echo OK
    else
        echo NOK
    fi
}


# +=================================================================================+
# | GET APPS LOGIN ID AND PASSWORD
# +=================================================================================+
while [ "${APPSID}" = "" -o `CHKLOGIN "${APPSID}"` = "NOK" ]
do
    echo "Enter APPS Userid/Passwd: "
    read APPSID
done
APPS_SCHEMA_NAME=`echo ${APPSID} | awk -F"/" '{print $1}'`
APPS_USER=`echo $APPSID|cut -d '/' -f1`
APPS_PASSWD=`echo $APPSID|cut -d '/' -f2`


# +=================================================================================+
# | GET APPS DBHOST and DBPORT
# +=================================================================================+
while [ "${DBHOST}" = "" ]
do
    echo "Enter APPS DB Host Name: "
    read DBHOST
done

while [ "${DBPORT}" = "" ]
do
    echo "Enter APPS DB Port: "
    read DBPORT
done

# +=================================================================================+
# | GET CONCURRENT PROGRAM NAME
# +=================================================================================+
while [ "${CONPROGRNAME}" = "" ]
do
    echo "Enter Concurrent Program Name: "
    read CONPROGRNAME
    echo "Entered Concurrent Program Name: ${CONPROGRNAME}"
done

# +=================================================================================+
# | GENERATE LDT FOR CONCURRENT PROGRAM
# +=================================================================================+
GENLDT(){

RESULT=`sqlplus -s < 
# +=================================================================================+

# GENLDT
#
GENLDT

# +=================================================================================+
# | FINISH
# +=================================================================================+
echo " "                                                               | ${TEE}
echo "END OF DOWNLOADING LDT PROCESS."                                 | ${TEE}


# +=================================================================================+
# | CREATE LOGFILE FOOTER
# +=================================================================================+
WRAPLOG


# +=================================================================================+
# |                                 END OF SCRIPT                                   |
# +=================================================================================+