39: WHEN NO_DATA_FOUND THEN
40:
41: select qp_pricing_attr_group_no_s.nextval
42: into l_attribute_grouping_no
43: from dual;
44:
45: return l_attribute_grouping_no;
46:
47: WHEN OTHERS THEN RETURN NULL;
109: BEGIN
110:
111: select qp_pricing_attributes_s.nextval
112: into l_pricing_attribute_id
113: from dual;
114:
115: RETURN l_pricing_attribute_id;
116:
117: EXCEPTION