##########################################################################
#File:          apd_daily_ops_pm
#Purpose:       Submit daily requests where date parameter is required (PM)
##########################################################################
#
echo ORACLE_SID:$ORACLE_SID
#
#applications wide variables
#
today=`date +%d-%b-%y`
oracle_uid=apps/apps
conc_params="wait=y concurrent"
#
#applications specific
#
user_name=RPTOPS
inv_shortname=mfg
responsibility="Oracle Manufacturing"
#
#program specific - Receiving Transactions Register
#
module="PO RCVTXRTR"
#
p1_RCVTXRTR="\"DAILY-RECEIPTS\"\"101\"\"RECEIVE\""
p2_RCVTXRTR="\"\"\"\"\"\"\"\"\"\"\"50134\""
p3_RCVTXRTR="\"\"\"\"\"\"\"\"\"\"\"\"\"\"\"\"\"\"\"\"\"\"\"\"\"N\"\"N\""
p0_RCVTXRTR="$p1_RCVTXRTR $today $today $p2_RCVTXRTR $p3_RCVTXRTR"
#
echo CONCSUB:$FND_TOP/bin/CONCSUB \
echo oracle_uid:$oracle_uid \
echo inv_shortname:$inv_shortname \
echo responsibility:"$responsibility" \
echo user_name:$user_name \
echo conc_params:$conc_params \
echo module:$module \
echo p1_:$p1_RCVTXRTR
echo p2_:$p2_RCVTXRTR
echo p3_:$p3_RCVTXRTR
#
#finally execute this thing...
#
$FND_TOP/bin/CONCSUB $oracle_uid \
$inv_shortname \
"$responsibility" \
$user_name \
$conc_params \
$module \
$p0_RCVTXRTR
#
##########################################################################

Have a Oracle Question
Do you have an Oracle Question?

Oracle Books
Oracle Certification, Database Administration, SQL, Application, Programming Reference Books

Oracle Application
Oracle Application Hints and Tips

Oracle Home
Oracle Database, SQL, Application, Programming Tips