fnGetFICTValues(){
arr_archdirs=`
sqlplus -s $rdbms_connect <<EOF
set heading off
set feedback off
select ARCHIVE_DIR from UHSPA.UHS_FICT_DETAILS where ARCHIVE_IND=1 and fict_id >13;
exit;`

  echo $arr_archdirs;
  echo -e "EXITING FUNCTION: fnGetFICTValues. n"

return
}

/nfs/middle_fs/custom_warehouses/m152e/code/script/mck_bill_item/archive
/nfs/middle_fs/custom_warehouses/p152e/code/script/mck_bill_item/archive
/nfs/middle_fs/custom_warehouses/c152c/code/script/mck_gtin_item/archive
/nfs/middle_fs/from_client_site/p152e/rc/ACO_Roster/archive
/nfs/middle_fs/custom_warehouses/b152c/code/script/mck_gtin_item/archive
/nfs/middle_fs/custom_warehouses/p152e/code/script/leapfrog/archive
/nfs/middle_fs/from_client_site/b152c/rc/ACO_Roster/archive
/nfs/middle_fs/from_client_site/c152c/rc/ACO_Roster/archive
/nfs/middle_fs/from_client_site/p152c/rc/ACO_Roster/archive
/nfs/client_fs/to_client_site/p152w/SOAD03/archive
EXITING FUNCTION: fnGetFICTValues.

fnLoopFictDetails(){
$dirdelete = $ARCHIVE_DIR/*
for files in $ARCHIVE_DIR/*

files=( "$dir"/*);
find $dir -type -rf -exec rm {} ;
done
echo -e "EXITING FUNCTION: fnLoopFictDetails. n"
return
}