[Home] [Help]
2198: aname => 'FORWARD_TO_USERNAME');
2199:
2200: /*if l_user_name is not null then
2201: select user_id into l_verified_by
2202: from fnd_user where user_name = l_user_name;
2203: end if;*/
2204:
2205: /*Bug#14001547.Commented this part as this is not retrieving the exact user_name in case of approval based on position hierarchy.
2206: Added below code to fetch the userid and then username of the person who approved the transaction at the latest incase of approval based on position hierarchy.*/
2206: Added below code to fetch the userid and then username of the person who approved the transaction at the latest incase of approval based on position hierarchy.*/
2207:
2208: if ((l_user_name is not null) and (substr(l_user_name,1,3) NOT IN ('POS','PQH') )) then /*Added PHQ for bug#14806618*/
2209: select user_id into l_verified_by
2210: from fnd_user where user_name = l_user_name;
2211: elsif ((l_user_name is not null) and (substr(l_user_name,1,3) IN ('POS','PQH') )) then /*Added PHQ for bug#14806618*/
2212: select USER_NAME
2213: into l_verified_by_user_name
2214: from PQH_SS_APPROVAL_HISTORY
2217: from PQH_SS_APPROVAL_HISTORY
2218: where transaction_history_id = p_transaction_id);
2219:
2220: select user_id into l_verified_by
2221: from fnd_user where user_name = l_verified_by_user_name;
2222: end if;
2223:
2224: l_verified_date := sysdate;
2225: