IS_USER_APPLICANT

Arguments:

Returns:

Source

Legend: comment string keyword reserved word operator

     1: function
     2: is_user_applicant
     3: (
     4:     user_id_in IN number
     5: )
     6: return number
     7: is
     8:     org_id_val		number;
     9:     app_group_val	number;
    10:     applicant           number;
    11: begin
    12:     select org_id into org_id_val
    13:       from web_contact
    14:      where id = user_id_in;
    15:     select id into app_group_val
    16:       from rhnUserGroup
    17:      where org_id = org_id_val
    18:        and group_type = (
    19: 		select	id
    20: 		from	rhnUserGroupType
    21: 		where	label = 'org_applicant'
    22: 	   );
    23:     select count(1) into applicant
    24:       from rhnUserGroupMembers
    25:      where user_group_id = app_group_val
    26:        and user_id = user_id_in;
    27:    return applicant;
    28: end;