297: -- fetch the user id to get the timezone conversion preferences
298:
299: select Nvl(user_id, -1)
300: INTO l_user_id
301: FROM fnd_user
302: WHERE user_name = x_buyer_user_name;
303:
304: IF l_user_id <> -1 THEN
305:
997: x_buyer_user_displayname);
998:
999: select Nvl(user_id, -1)
1000: INTO l_user_id
1001: FROM fnd_user
1002: WHERE user_name = x_buyer_user_name;
1003:
1004: IF l_user_id <> -1 THEN
1005: