48: End;
49: ELSIF (p_product_attr = 'PRICING_ATTRIBUTE2') THEN
50: begin
51: select category_name into c_name
52: from qp_item_categories_v
53: where category_id = p_product_attr_val
54: and rownum = 1;
55: return c_name;
56: EXCEPTION WHEN OTHERS THEN
83: end;
84: ELSIF (p_product_attr = 'PRICING_ATTRIBUTE2') THEN
85: begin
86: select category_id into c_name_id
87: from qp_item_categories_v
88: where category_name = p_product_attr_val
89: and rownum = 1;
90: return c_name_id;
91: EXCEPTION WHEN OTHERS THEN