一个程序发布的shell脚本实例(转)

转自： http://blog.itpub.net/post/36466/411774

 

发表人:OracleERPR12 | 发表时间: 2007年十一月07日, 16:52

一个程序发布的shell脚本实例，包括Form,library,Database object,concurrent register

把以下代码Copy到txt文本文件中，文本后缀名改为.sh

#!/bin/bash

#--
#---------------------------------------------------------------------------------------------
#-- File Name : XXUTS_MFG_ITEM_REVISION_Form_INSTALL.sh
#-- Purpose : QuQ Status Maintain Form
#-- Author : Simon
#-- Initial Build Date: 20-Aug-2007
#-- Version : 1.0
#--
#-- Modification History
#---------------------------------------------------------------------------------------------
#-- | WHEN | Ver | WHO | WHAT
#---------------------------------------------------------------------------------------------
#--
#-- 20-Aug-2007 | 1.0 | Heming | $UT$CMPEXT131 Inital Creation
# QuQ Status Maintain Form
#-- 04-Oct-2007 | 1.1 | Johnny Qu | Modify to follow the same process
#---------------------------------------------------------------------------------------------
#
#
#--------------------------------------------------------------------------
# Set the environmental variables and other administrative requirements.
#--------------------------------------------------------------------------
INSTALL_DIR=$XXUTS_TOP/install/CMPEXT131
OUT_DIR=$XXUTS_TOP/out
FORMS_DIR=$XXUTS_TOP/forms/US
OUTFILE=$OUT_DIR/XXUTS_MFG_ITEM_REVISION_Form_INSTALL.out

echo `date` > $OUTFILE

#--------------------------------------------------------------------------
# Define the function to get the APPS password.
#--------------------------------------------------------------------------
Psswd()
{
echo "Please enter APPS login =>"
stty -echo
read apps_login
stty echo

echo "Please enter APPS password =>"
stty -echo
read apps_pwd
stty echo
}

#--------------------------------------------------------------------------
# Function to move files.
#--------------------------------------------------------------------------
CreateCMP()
{

mkdir $INSTALL_DIR >> $OUTFILE

mv $XXUTS_TOP/install/XXUTS_MFG_ITEM_REVISION_Form_INSTALL.sh $INSTALL_DIR >> $OUTFILE
mv $XXUTS_TOP/install/XXUTS_MFG_ITEM_REVISION.fmb $INSTALL_DIR >> $OUTFILE
mv $XXUTS_TOP/install/XXUTS_ITEM_QUALIFY_STATUS_OBJECT.sql $INSTALL_DIR >> $OUTFILE
mv $XXUTS_TOP/install/XXUTS_MFG_Item_revision_pk.pck $INSTALL_DIR >> $OUTFILE
mv $XXUTS_TOP/install/XXUTS_AUTO_REFRESH_MPN_REG.sql $INSTALL_DIR >> $OUTFILE
mv $XXUTS_TOP/install/XXUTS_AUTO_REFRESH_MPN.ldt $INSTALL_DIR >> $OUTFILE
mv $XXUTS_TOP/install/XXUTS_MFG_ITEM_REVISION.pll $INSTALL_DIR >> $OUTFILE

cd $INSTALL_DIR

}

#--------------------------------------------------------------------------
# Function to copy files.
#--------------------------------------------------------------------------
CopyFiles()
{

cp XXUTS_MFG_ITEM_REVISION.fmb $FORMS_DIR >> $OUTFILE

}

#--------------------------------------------------------------------------
# Function to execute the script. to create the table and packages
#--------------------------------------------------------------------------
CreateDBObjs()
{
sqlplus $apps_login/$apps_pwd @XXUTS_ITEM_QUALIFY_STATUS_OBJECT.sql >>$OUTFILE
sqlplus $apps_login/$apps_pwd @XXUTS_MFG_Item_revision_pk.pck >>$OUTFILE

}

#-----------------------------------------------------------------------------
# Upload concurrent program definitions
#-----------------------------------------------------------------------------
CreateConcPgm()
{
$FND_TOP/bin/FNDLOAD $apps_login/$apps_pwd 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct XXUTS_AUTO_REFRESH_MPN.ldt >>$OUTFILE

}

#--------------------------------------------------------------------------
# Function to register AOL objects
#--------------------------------------------------------------------------

AolRegister()
{
sqlplus $apps_login/$apps_pwd @XXUTS_AUTO_REFRESH_MPN_REG.sql >> $OUTFILE
}

#--------------------------------------------------------------------------
# Function to compile libraries.
#--------------------------------------------------------------------------
CreateLibs()
{
cd $INSTALL_DIR
cp XXUTS_MFG_ITEM_REVISION.pll $AU_TOP/resource >> $OUTFILE

cd $AU_TOP/resource

frmcmp_batch module=XXUTS_MFG_ITEM_REVISION.pll module_type=library userid=$apps_login/$apps_pwd >> $OUTFILE
}

#--------------------------------------------------------------------------
# Function to compile forms.
#--------------------------------------------------------------------------
CreateForms()
{
cd $FORMS_DIR
frmcmp_batch module=$FORMS_DIR/XXUTS_MFG_ITEM_REVISION.fmb module_type=form. userid=$apps_login/$apps_pwd >> $OUTFILE
}

#---------------------------------------------------------------------
# Call the functions
#---------------------------------------------------------------------

Psswd
echo -e "nCREATING CMP Folder...n" >> $OUTFILE
CreateCMP

echo "Creating Objects ......."
CreateDBObjs

echo "Loading Program ........."
CreateConcPgm

echo "Registering Program ......"
AolRegister

echo -e "nMOVING Files...n" >> $OUTFILE
CopyFiles

echo -e "nCOMPILING Forms...XXUTS_MFG_ITEM_REVISION.fmbn" >> $OUTFILE
CreateForms

echo -e "nCOMPILING Libraries...n" >> $OUTFILE
CreateLibs

echo -e "nDone.n" >> $OUTFILE

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/24627116/viewspace-755550/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/24627116/viewspace-755550/