-- Gets User Id for a given loginName
  -- Parameters:
  --   p_loginName: username to be verified
  -- Returns:
  --   u_id: user id
  -- Raise NOT_DATA_FOUND: if user/pass do not match
  function getId(p_loginName varchar2, p_pass varchar2) return number is
    v_u_id number;
  begin
    select u_id into v_u_id from cms_users 
          where loginName=p_loginName and password=p_pass;
    return v_u_id;
  end getId;
  
  -- Gets Group Id for a given loginName
  -- Parameters:
  --   p_loginName: username to be verified
  -- Returns:
  --   g_id: Primary group id
  function getGid(p_loginName varchar2) return number is
    v_u_id number;
    v_g_id number;
  begin
    select u_id into v_u_id from cms_users where loginName=p_loginName;
    select g_id into v_g_id from cms_user_group 
          where u_id=v_u_id and rownum=1;
    return v_g_id;
  end getGid;
  
end cms_user;