CREATE_NEW_USER

Arguments:

Returns:

Source

Legend: comment string keyword reserved word operator

     1: function
     2: create_new_user
     3: (
     4:     org_id_in		in number,
     5:     login_in		in varchar2,
     6:     password_in		in varchar2,
     7:     oracle_contact_id_in in number,
     8:     prefix_in		in varchar2,
     9:     first_names_in	in varchar2,
    10:     last_name_in	in varchar2,
    11:     genqual_in		in varchar2,
    12:     parent_company_in	in varchar2,
    13:     company_in		in varchar2,
    14:     title_in		in varchar2,
    15:     phone_in		in varchar2,
    16:     fax_in		in varchar2,
    17:     email_in		in varchar2,
    18:     pin_in		in varchar2,
    19:     first_names_ol_in	in varchar2,
    20:     last_name_ol_in	in varchar2,
    21:     address1_in		in varchar2,
    22:     address2_in		in varchar2,
    23:     address3_in		in varchar2,
    24:     city_in		in varchar2,
    25:     state_in		in varchar2,
    26:     zip_in		in varchar2,
    27:     country_in		in varchar2,
    28:     alt_first_names_in  in varchar2,
    29:     alt_last_name_in    in varchar2,
    30:     contact_call_in	varchar2 := 'N',
    31:     contact_mail_in	varchar2 := 'N',
    32:     contact_email_in	varchar2 := 'N',
    33:     contact_fax_in	varchar2 := 'N'
    34: )
    35: return number
    36: is
    37:     user_id		number;
    38: begin
    39:     select web_contact_id_seq.nextval into user_id from dual;
    40: 
    41:     insert into web_contact
    42:         (id, org_id, login, login_uc, password, oracle_contact_id)
    43:     values
    44:         (user_id, org_id_in, login_in, upper(login_in), password_in, oracle_contact_id_in);
    45: 
    46:     insert into web_user_contact_permission
    47:         (web_user_id, call, mail, email, fax)
    48:     values
    49:         (user_id, contact_call_in, contact_mail_in, contact_email_in, contact_fax_in);
    50: 
    51:     insert into web_user_personal_info
    52:         (web_user_id, prefix, first_names, last_name, genqual,
    53: 	parent_company, company, title, phone, fax, email, pin,
    54: 	first_names_ol, last_name_ol)
    55:     values
    56:         (user_id, prefix_in, first_names_in, last_name_in, genqual_in,
    57: 	parent_company_in, company_in, title_in, phone_in, fax_in, email_in, pin_in,
    58: 	first_names_ol_in, last_name_ol_in);
    59: 
    60:     if address1_in != '.' then
    61:         insert into web_user_site_info
    62: 	    (id, web_user_id, email,
    63: 	    address1, address2, address3,
    64: 	    city, state, zip, country, phone, fax, type,
    65: 	    alt_first_names, alt_last_name)
    66: 	values
    67: 	    (web_user_site_info_id_seq.nextval, user_id, email_in,
    68: 	    address1_in, address2_in, address3_in,
    69: 	    city_in, state_in, zip_in, country_in, phone_in, fax_in, 'M',
    70: 	    alt_first_names_in, alt_last_name_in);
    71:     end if;
    72: 
    73:     insert into rhnUserInfo
    74:         (user_id)
    75:     values
    76:         (user_id);
    77: 
    78:     return user_id;
    79: end;