172: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute14 IS NOT NULL) OR
173: (OE_Upg_SO_NEW.g_line_rec.pricing_attribute15 IS NOT NULL)
174:
175: THEN
176: SELECT OE_ORDER_PRICE_ATTRIBS_S.nextval
177: INTO v_order_price_attrib_id
178: FROM dual;
179:
180: insert into oe_order_price_attribs
281: (oe_upg_so_new.g_line_rec.pricing_attribute15 IS NOT NULL)
282:
283: THEN
284:
285: SELECT OE_ORDER_PRICE_ATTRIBS_S.nextval
286: INTO v_order_price_attrib_id
287: FROM dual;
288:
289: insert into oe_order_price_attribs
391: (p_upg_line_rec.pricing_attribute14 IS NOT NULL) OR
392: (p_upg_line_rec.pricing_attribute15 IS NOT NULL)
393:
394: THEN
395: SELECT OE_ORDER_PRICE_ATTRIBS_S.nextval
396: INTO v_order_price_attrib_id
397: FROM dual;
398:
399: insert into oe_order_price_attribs