APPS.IEU_DIAG_AUDIT_TRACK_PVT dependencies on FND_USER

Line 226: l_user_id FND_USER.USER_ID%TYPE;

222: l_temp_count number;
223: work_item_number number;
224: l_ws_code varchar2(2000);
225: l_ws_name varchar2(2000);
226: l_user_id FND_USER.USER_ID%TYPE;
227: l_sql VARCHAR2(4000);
228:
229: cursor cur_items IS
230: Select a.workitem_pk_id,

Line 275: l_sql := ' select user_id from fnd_user where upper(user_name) like upper( :p_user_name)';

271: -- msista 1/14/06 - the following sql can be removed because the queried
272: -- user_id is not used, but the query is used for
273: -- validating the user_name as a part of the diagnostic
274: -- test, so leaving it as is.
275: l_sql := ' select user_id from fnd_user where upper(user_name) like upper( :p_user_name)';
276: EXECUTE IMMEDIATE l_sql into l_user_id USING p_user_name;
277:
278: EXCEPTION
279: WHEN NO_DATA_FOUND THEN