###################################################################################
p_logfile=./install.log
echo "Start to install R009 Program...\n" > $p_logfile
# Step 1 --- Create DB objects
echo "Start to create database objects\n" >> $p_logfile
echo "Password for APPS User:"
read apps_login
echo "Enter the DB Server Host Name:"
read dbHostName
echo "Enter the DB port:"
read dbPort
echo "Enter the DB Instance:"
read DBInstance
echo "\n"
# Step 1 --- Setup forms
echo "Begin to setup forms... \n" >> $p_logfile
FNDLOAD apps/$apps_login O Y UPLOAD $FND_TOP/patch/115/import/afsload.lct WST_PROJECT_TOOLING_FORM.ldt >> $p_logfile
FNDLOAD apps/$apps_login O Y UPLOAD $FND_TOP/patch/115/import/afsload.lct WST_PROJECT_TOOLING_FUN.ldt >> $p_logfile
# Step 2 --- Setup menu
echo "Begin to setup menu... \n" >> $p_logfile
FNDLOAD apps/$apps_login O Y UPLOAD $FND_TOP/patch/115/import/afsload.lct WST_PROJECT_TOOLING_MEAU.ldt
echo "End of setup menu ... \n" >> $p_logfile
# Step 3 --- Setup responsibility
echo "Begin to setup res... \n" >> $p_logfile
FNDLOAD apps/$apps_login O Y UPLOAD $FND_TOP/patch/115/import/afscursp.lct WST_PROJECT_TOOLING_R.ldt
echo "End of setup res ... \n" >> $p_logfile
# Step 4 --- Setup request group
echo "Begin to setup requestgroup... \n" >> $p_logfile
FNDLOAD apps/$apps_login 0 Y UPLOAD $FND_TOP/patch/115/import/afcpreqg.lct WST_PROJECT_TOOLING_REQUEST.ldt
echo "End of setup requestgroup ... \n" >> $p_logfile
# Step 5 --- Setup concurrent program
echo "Begin to setup concurrent program... \n" >> $p_logfile
FNDLOAD apps/$apps_login O Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct WST_PROJECT_TOOLING.ldt >> $p_logfile
echo "End of setup concurrent program ... \n" >> $p_logfile
# Step 6 --- Setup XML Publisher Template
FNDLOAD apps/$apps_login 0 Y UPLOAD $XDO_TOP/patch/115/import/xdotmpl.lct WST_PROJECT_TOOLING_XML.ldt
echo "End of setup values ... \n" >> $p_logfile
# Step 7 --- Setup values Set
echo "Begin to setup values... \n" >> $p_logfile
FNDLOAD apps/$apps_login 0 Y UPLOAD $FND_TOP/patch/115/import/afffload.lct WST_PROJECT_NUMBER_VALUES.ldt
echo "End of setup values ... \n" >> $p_logfile
#--upload rtf file
java oracle.apps.xdo.oa.util.XDOLoader UPLOAD \
-DB_USERNAME apps \
-DB_PASSWORD $apps_login \
-JDBC_CONNECTION $dbHostName:$dbPort:$DBInstance \
-LOB_TYPE TEMPLATE \
-APPS_SHORT_NAME WST \
-LOB_CODE WST_PROJECT_TOOLING \
-LANGUAGE zh \
-TERRITORY HK \
-XDO_FILE_TYPE RTF \
-NLS_LANG American_America.UTF8 \
-FILE_NAME WST_PROJECT_TOOLING.rtf \
-LOG_FILE WST_11XMLTMP.log
echo "End of Installation ...\n" >> $p_logfile