一个程序发布的
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
