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: 
    14:     select id into admin_group_val
    15:       from rhnUserGroup
    16:      where org_id = org_id_val
    17:        and group_type = (
    18: 		select	id
    19: 		from	rhnUserGroupType
    20: 		where	label = 'org_admin'
    21: 	   );
    22: 
    23:     insert into rhnUserGroupMembers
    24:         (user_group_id, user_id)
    25:     values
    26:         (admin_group_val, user_id_in);
    27: 
    28:     insert into rhnUserInfo
    29:         (user_id)
    30:     values
    31:         (user_id_in);
    32: end;