203: BEGIN
204:
205: SELECT resource_name
206: INTO p_default_owner
207: FROM cs_sr_owners_v
208: WHERE resource_id = p_default_owner_id and
209: resource_type = l_default_owner_type;
210:
211: EXCEPTION
393: (p_default_group_type IS NOT NULL) THEN
394: BEGIN
395: SELECT resource_name
396: INTO p_default_group_owner
397: FROM cs_sr_owners_v
398: WHERE resource_id = p_default_group_owner_id and
399: resource_type = p_default_group_type;
400:
401: EXCEPTION