Line 252: from fnd_user where upper(user_name) = upper(p_username);
248: -- now need to insert a line into fnd_exception_notes for each exceptions
249: -- so, retrieve user id
250:
251: select user_id into v_userid 252: from fnd_user where upper(user_name) = upper(p_username); 253:
254: declare
255: v_curr_index number := 1;
256: v_curr_id varchar2(100);