317: BEGIN
318: --
319: SELECT user_entity_id
320: INTO l_user_entity_id
321: FROM ff_user_entities
322: WHERE user_entity_name = upper(p_user_entity_name);
323: --
324: EXCEPTION WHEN NO_DATA_FOUND THEN
325: --
339: p_record_inserted => l_record_inserted);
340: --
341: SELECT user_entity_id
342: INTO l_user_entity_id
343: FROM ff_user_entities
344: WHERE user_entity_name = p_user_entity_name;
345: --
346: -- Add any route parameter values
347: --