Upload Oracle Apps Custom Objects

xxcust_projectcode_install.sh

#!/usr/bin/ksh
#*******************************************************************************
#* 
#* $HeadURL$
#* 
#* Purpose : Install all components for XXXXXXXXXXX.
#*
#* $Author$ 
#*
#* $Date$
#*
#* $Revision$
#*
#* History : Refer to Source Control
#*
#* Notes   : exceute with ./xxcust_projectcode_install.sh <appspwd> 
#*             for example ./xxcust_projectcode_install.sh apps 
#*
#********************************************************************************
#* $Id$
USAGE="usage: $0 $1" # filename.sh appspwd

if [ "$1" == "" ]
then
  echo "Usage xxcust_projectcode_install.sh <apps password>"
  exit 1
fi
#---------------------------------------
# Arguments:
#  1 - Apps Password
#---------------------------------------
DBPASS=$1
LOG="$XXCUST_TOP/import/xxcust_projectcode_install.log"

print "Installing" >> $LOG
print "***********************************************" >> $LOG
print "Start Date: " + `date` + "\n" >> $LOG
print "***********************************************" >> $LOG

#---------------------------------------
# PL/SQL Package
#---------------------------------------
sqlplus apps/$DBPASS <<ENDOFSQL  >>$LOG
@$XXCUST_TOP/admin/sql/xxcust_gl_approval_pkg.pks
@$XXCUST_TOP/admin/sql/xxcust_gl_approval_pkg.pkb
EXIT
ENDOFSQL


#---------------------------------------
# Form Functions
#---------------------------------------
FNDLOAD apps/$DBPASS O Y UPLOAD \
$FND_TOP/patch/115/import/afsload.lct \
$XXCUST_TOP/import/xxcust_gl_form_function.ldt >> $LOG


#---------------------------------------
# Concurrent Programs
#---------------------------------------
FNDLOAD apps/$DBPASS O Y UPLOAD \
$FND_TOP/patch/115/import/afcpprog.lct \
$XXCUST_TOP/import/xxcust_invbip_sel_conc_prog.ldt >> $LOG


#---------------------------------------
# Request Groups
#---------------------------------------
FNDLOAD apps/$DBPASS O Y UPLOAD \
$FND_TOP/patch/115/import/afcpreqg.lct \
$XXCUST_TOP/import/xxcust_invbip_req_grp_cust.ldt >> $LOG


#---------------------------------------
# Profile Options
#---------------------------------------
FNDLOAD apps/$DBPASS O Y UPLOAD \
$FND_TOP/patch/115/import/afscprof.lct \
$XXCUST_TOP/xxcust_emp_term_notif_finance_flag_po.ldt >> $LOG


#---------------------------------------
# Messages
#---------------------------------------
FNDLOAD apps/$DBPASS 0 Y UPLOAD \
$FND_TOP/patch/115/import/afmdmsg.lct \
$XXCUST_TOP/import/poc_poreqcha_notif_msg.ldt >> $LOG


#---------------------------------------
# BIP Templates and Data Definitions
#---------------------------------------
FNDLOAD apps/$DBPASS O Y UPLOAD \
$XDO_TOP/patch/115/import/xdotmpl.lct \
$XXCUST_TOP/import/xxcustinvbip_sel_bip_def.ldt >> $LOG


#---------------------------------------
# BIP RTF Templates
#---------------------------------------
java oracle.apps.xdo.oa.util.XDOLoader UPLOAD \
-DB_USERNAME apps \
-DB_PASSWORD $DBPASS \
-JDBC_CONNECTION $XXCUSTDBHOST:$XXCUSTDBPORT:$XXCUSTDBSID \
-LOB_TYPE TEMPLATE \
-APPS_SHORT_NAME XXCUST \
-LOB_CODE ARCINVBIP_SEL \
-LANGUAGE en \
-TERRITORY 00 \
-XDO_FILE_TYPE RTF \
-NLS_LANG $NLS_LANG \
-FILE_NAME $XXCUST_TOP/import/xxcust_ap01_cheque_print.rtf \
-CUSTOM_MODE FORCE \
-USE_APPS_CONTEXT true \
-OWNER SYSADMIN \
-LOG_FILE $LOG \
-DEBUG true >> $LOG

#---------------------------------------
# Personalisations and Custom OAF Pages
#---------------------------------------
#####
# JRAD XML Import Personalisation to AAF Page/Region : /oracle/apps/ap/oie/workflow/apexp/webui/NotifExpLinesRN
#####
java oracle.jrad.tools.xml.importer.XMLImporter \
$XXCUST_TOP/mds/oracle/apps/ap/oie/workflow/apexp/webui/customizations/site/0/NotifExpLinesRN.xml \
 -username "apps" -password "$DBPASS" \
-dbconnection "(description=(address_list=(address=(community=tcp.world)(protocol=tcp)(host=$XXCUSTDBHOST)(port=$XXCUSTDBPORT)))(connect_data=(sid=$XXCUSTDBSID)))" \
-rootdir "$APC_TOP/mds/" \
-rootPackage "/" >> $LOG


#---------------------------------------
# Business Event and Business Event Subscription
#---------------------------------------
java oracle.apps.fnd.wf.WFXLoad -u \
apps $DBPASS "$XXCUSTDBHOST":"$XXCUSTDBPORT":"$XXCUSTDBSID" "thin" US \
$XXCUST_TOP/import/xxcust_emp_term_event_sub.wfx >> $LOG


#---------------------------------------
# Forms Personalisations
#---------------------------------------
FNDLOAD apps/$DBPASS 0 Y UPLOAD \
$FND_TOP/patch/115/import/affrmcus.lct \
$XXCUST_TOP/import/xxcust_inv_form.ldt >> $LOG


#---------------------------------------
# DFF's
#---------------------------------------
FNDLOAD apps/$DBPASS 0 Y UPLOAD \
$FND_TOP/patch/115/import/afffload.lct \
$XXCUST_TOP/import/xxcust_inv_header_dff.ldt >> $LOG


#---------------------------------------
# Workflow
#---------------------------------------
WFLOAD apps/$DBPASS 0 Y FORCE $XXCUST_TOP/import/xxcrepap.wft >> $LOG


#---------------------------------------
# Menus
#---------------------------------------
FNDLOAD apps/$DBPASS O Y UPLOAD \
$FND_TOP/patch/115/import/afsload.lct \
$XXCUST_TOP/import/ICX_POR_SSP_HOME.ldt >> $LOG

#---------------------------------------
# WebADI Integrator
#---------------------------------------
FNDLOAD apps/$DBPASS 0 Y UPLOAD \
$BNE_TOP/patch/115/import/bneintegrator.lct \
$XXCUST_TOP/import/XX_HR_101_INTG.ldt >> $LOG


#---------------------------------------
# Responsibility
#---------------------------------------
FNDLOAD apps/$DBPASS O Y UPLOAD \
$FND_TOP/patch/115/import/afscursp.lct \
$XXCUST_TOP/import/XX_PERSON_RESPY.ldt >> $LOG


#---------------------------------------
# Clear up FND Load log files
#---------------------------------------
mv $XXCUST_TOP/import/*.log $XXCUST_TOP/log

#---------------------------------------
# End Installation
#---------------------------------------
print "***********************************************" >> $LOG
print "End Date: " + `date` + "\n" >> $LOG
print "***********************************************" >> $LOG