FCP_LOGIN=`echo $*|awk '{print $3}'`
DATA_FILE=`echo $*|awk '{print $9}'`
DATA_SET_NAME=`echo $*|awk '{print $10}'`

echo $FCP_LOGIN
FCP_LOGIN=${FCP_LOGIN#FCP_LOGIN=$quotes}
FCP_USERID=${FCP_USERID#FCP_USERID=$quotes}
#FCP_LOGIN=${FCP_LOGIN%$quotes}
FCP_LOGIN=`echo $FCP_LOGIN|sed 's/"//g'`
echo $FCP_LOGIN

DATA_FILE=`echo $DATA_FILE|sed 's/"//g'`
DATA_SET_NAME=`echo $DATA_SET_NAME|sed 's/"//g'`



rm -f $SMC_BOM_TOP/bin/SMCBOMFBDLOAD.ctl
rm -f $SMC_BOM_TOP/bin/SMCBOMFBDLOAD.log


echo "LOAD DATA
APPEND
INTO TABLE SMCBOM.SMCBOM_FB_DOLLAR_VALUES
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '\"'
( DATA_SET_NAME CONSTANT \""$DATA_SET_NAME\"" ,
  DEPARTMENT,
  REPORT_COMPONENT, 
  QUARTER,
  FISCAL_YEAR,
  DOLLAR_VALUE,
  Q_START_DATE DATE,
  Q_END_DATE DATE, 
  CREATED_BY CONSTANT  \""-1\"" ,
  CREATION_DATE SYSDATE ,
  LAST_UPDATED_BY CONSTANT \""-1\"" ,
  LAST_UPDATE_DATE SYSDATE 
  )" >> $SMC_BOM_TOP/bin/SMCBOMFBDLOAD.ctl


$ORACLE_HOME/bin/sqlload userid=$FCP_LOGIN control=$SMC_BOM_TOP/bin/SMCBOMFBDLOAD.ctl data=$DATA_FILE LOG=$SMC_BOM_TOP/bin/SMCBOMFBDLOAD.log

after this point you can use CONSUB to call a Validation program
Assumption:
You have developed a different concurrent program which validates your data