-- Wrapper package for accesing to cms_users tables.
create or replace package body cms_user as
  -- Adds a new user to the CMS users
  -- Parameters:
  --   g_id:  Primary Group id
  --   loginName: login name used for login for example invitado
  --   realName: Full Name of the user, for example Usuario Invitado
  --   pass: password in plain text, for example my_pass
  -- Returns:
  --   u_id (number) the user id
  function addUser(p_g_id number,
                   p_loginName varchar2,
                   p_realName varchar2,
                   p_pass varchar2,
		   p_eMail varchar2) return number is
    v_u_id number;
  begin
     select cms_users_seq.nextval into v_u_id from dual;
     insert into cms_users values (v_u_id,p_loginName,p_realName,p_pass,p_eMail);
     insert into cms_user_group values (v_u_id,p_g_id);
     return v_u_id;
  end addUser;