#!/bin/ksh

. ~/applprd.env


read A
read B

username=`echo $A`
echo "We have username $username ...."
pass=`echo $B`
echo "We have old password $pass ...."
passnew=`echo $pass | sed 's/./\\\&/g'`
echo "We have new password ------"$passnew"----- ...."

# Recieve apps and system password ...... 
password=`grep -i password $TOOLS_CONFIG_HOME/../iAS/Apache/Apache/../modplsql/cfg/wdbsvr.app | grep -v portal | cut -d"=" -f2 | sed
 's/ //g'| head -1`
digits_to_cut=`echo ${password} | sed 's/[a-zA-Z]//g' | awk '{print length($1)}'`
if [ ${digits_to_cut} -eq 4 ]; then
  begin_system=`echo ${password} |  sed "s/.\{${digits_to_cut}\}$//" | sed 's/.$/s/g'`
  digits=`echo ${password} | sed 's/[A-Za-z]//g'`
  system=${begin_system}${digits}
else
  begin_system=`echo ${password} |  sed "s/.\{5\}$//" | sed 's/.$/s/g'`
  digits=`echo ${password} | awk '{ print substr($1,length($1)-4,length($1)) }'`
  system=${begin_system}${digits}
fi



# We  recieve user id for changing password ....
USERID=`sqlplus -s apps/$password@ORAPRD_BALANCE << END
set pagesize 0 feedback off verify off heading off echo off
SELECT to_char(a.user_id)
FROM fnd_user a, per_all_people_f f
where a.EMPLOYEE_ID = f.person_id
AND sysdate between f.effective_start_date AND f.effective_end_date
and a.end_date is null
and a.user_name=upper('${username}');
exit;
END`


if [ "${USERID:-"CONTRACT_ID"}" = "CONTRACT_ID" ] ; then
USERID=`sqlplus -s apps/$password@ORAPRD_BALANCE << END
set pagesize 0 feedback off verify off heading off echo off
select to_char(a.user_id)
from fnd_user a
where a.user_name = '${username}';
exit;
END`
fi

echo "We have user_name = ${username} and it's user_id = ${USERID} ....."

# Changing password for specific user ....
cd $FND_TOP/bin
FNDCPASS apps/${password} 0 Y system/${system} USER ${username}  ${passnew}
#echo "User ${username} changed password on `date`  with password ${pass} ....." >> /opt/idm.log

./idm.sh << EOF
TEST_HR
123456as;
EOF