Connecting to Oracle db and executing sql file (table (tbl),package specification,body,synonyms) through shell script and uploading rdf,request groups,request sets,dff,concurrent program ldt files,profile option through shell script

Executing sql file (table (tbl),package specification and body,synonyms) through shell script and uploading rdf,request groups,request sets,dff,concurrent program ldt files,profile option through shell script.

The below shell script will connect to the database with username,pwd and host details.
It is an working file

commands meaning
stty -echo
Disable echoing of terminal input.
stty echo
Re-enable echoing of terminal input.
# +============================================================================+
# |
# | File name:     XX_RPS_SUPP_INSTALL.sh
# | Author:      
# | Purpose:    
# |
# |
# |
# |
# | Change history:
# |
# | Date       Author            Version             Description of change
# +============================================================================+
# | 27-JAN-14  Sathish             1.0             Changes for Tkt #203372
# |
# +============================================================================+
CURRENT_PATH=`pwd`
echo "Please Enter the Apps Schema User Name"
read P_APPS_USER
echo "Please Enter the Apps Schema User Password"
stty -echo
read P_APPS_PASSWD
stty echo
echo "   Enter jdbc address in format like(Host Ip:Port:SID):  "

echo  "# ******************************************************************* #"
read jdbc

#************************************************************************************
#      Starting of Installation Scripts from staging directory
#***********************************************************************************/
echo "---------------------------------------"

echo"Creating Synonyms of Objects (Tables and Sequences) and Packages in APPS schema...."

echo "--Connecting to SQLPlus"

sqlplus -s $P_APPS_USER/$P_APPS_PASSWD <<EOF
prompt "--Creating Table QLRPS_SUPP_MESSAGE_REQUEST.tbl"

@XXRPS_SUPP_MESSAGE_REQUEST.tbl

prompt "--Creating Table XXRPS_SUPP_MESSAGE_RESPONSE.tbl"

@XXRPS_SUPP_MESSAGE_RESPONSE.tbl

prompt "--Creating Table XXRPS_SUPP_STATUS.tbl"

@XXRPS_SUPP_STATUS.tbl

prompt "--Creating Synonym XXRPS_SUPP_SYNONYM.syn"

@XXRPS_SUPP_SYNONYM.syn

prompt "--Creating Package XXRPS_MESS_REQ_SUPP_PACKAGE"

@XXRPS_MESS_REQ_SUPP_PACKAGE.pks
@XXRPS_MESS_REQ_SUPP_PACKAGE.pkb
EOF

echo "--Copying XXRPSSUPPCSTR.rdf to $XX_TOP/reports "

cp  XXRPSSUPPCSTR.rdf $QL_TOP/reports/US

chmod 777 XXRPSSUPPCSTR.rdf

echo "---------------------------------------"
echo "--Uploading Concurrent Program definitions"

FNDLOAD $P_APPS_USER/$P_APPS_PASSWD O Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct XXRPSSUPPCSTR_CCP.ldt

FNDLOAD $P_APPS_USER/$P_APPS_PASSWD O Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct XXRPSSUPPMSGREQ_CCP.ldt

FNDLOAD $P_APPS_USER/$P_APPS_PASSWD O Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct XXRPSSUPPMSGUPD_CCP.ldt

FNDLOAD $P_APPS_USER/$P_APPS_PASSWD O Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct XXRPSSUPPPARTYOVERRIDE_CCP.ldt

FNDLOAD $P_APPS_USER/$P_APPS_PASSWD O Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct XXRPSSUPPPARTYSCREEN_CCP.ldt

echo "--Uploading request set  - XX RPS Supplier Set"

FNDLOAD $P_APPS_USER/$P_APPS_PASSWD 0 Y UPLOAD $FND_TOP/patch/115/import/afcprset.lct FNDRSSUB2318_Link.ldt

FNDLOAD $P_APPS_USER/$P_APPS_PASSWD 0 Y UPLOAD $FND_TOP/patch/115/import/afcprset.lct FNDRSSUB2299_Link.ldt

echo "--Uploading Forms Personalization - PO_POXPOEPO"

FNDLOAD $P_APPS_USER/$P_APPS_PASSWD 0 Y UPLOAD $FND_TOP/patch/115/import/affrmcus.lct POXPOEPO.ldt

echo "--Request Groups--"

FNDLOAD $P_APPS_USER/$P_APPS_PASSWD O Y UPLOAD $FND_TOP/patch/115/import/afcpreqg.lct XXRPSSUPPCSTR_RG.ldt

FNDLOAD $P_APPS_USER/$P_APPS_PASSWD O Y UPLOAD $FND_TOP/patch/115/import/afcpreqg.lct XXRPSSUPPPARTYOVERRIDE_RG.ldt

FNDLOAD $P_APPS_USER/$P_APPS_PASSWD O Y UPLOAD $FND_TOP/patch/115/import/afcpreqg.lct XXRPSSUPPMSGUPD_RG.ldt

FNDLOAD $P_APPS_USER/$P_APPS_PASSWD O Y UPLOAD $FND_TOP/patch/115/import/afcpreqg.lct XXRPSSUPPPARTYSCREEN_RG.ldt

FNDLOAD $P_APPS_USER/$P_APPS_PASSWD O Y UPLOAD $FND_TOP/patch/115/import/afcpreqg.lct XXRPSSUPPMSGREQ_RG.ldt

echo "--Dff--"

FNDLOAD $P_APPS_USER/$P_APPS_PASSWD 0 Y UPLOAD $FND_TOP/patch/115/import/afffload.lct VendorSites.ldt

echo "--Profile Option--"

FNDLOAD $P_APPS_USER/$P_APPS_PASSWD 0 Y UPLOAD $FND_TOP/patch/115/import/afscprof.lct XXQL_RPS_TIMEOUT.ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

echo "..........End of Installation........."