##########################################################################
#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
#
##########################################################################

Return to : Oracle Database, SQL, Application, Programming Tips