NEW_USER_POSTOP

Arguments:

Source

Legend: comment string keyword reserved word operator

     1: procedure
     2: new_user_postop
     3: (
     4:     user_id_in IN number
     5: )
     6: is
     7:     org_id_val		number;
     8:     admin_group_val	number;
     9: begin
    10:     select org_id into org_id_val
    11:       from web_contact
    12:      where id = user_id_in;
    13:     select id into admin_group_val
    14:       from rhnUserGroup
    15:      where org_id = org_id_val
    16:        and group_type = (
    17: 		select	id
    18: 		from	rhnUserGroupType
    19: 		where	label = 'org_admin'
    20: 	   );
    21:     insert into rhnUserGroupMembers
    22:         (user_group_id, user_id)
    23:     values
    24:         (admin_group_val, user_id_in);
    25:     insert into rhnUserInfo
    26:         (user_id)
    27:     values
    28:         (user_id_in);
    29: end;