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
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
181: ( header_id,
182: line_id,
183: creation_date,
184: created_by,
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
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
290: ( header_id,
291: line_id,
292: creation_date,
293: created_by,
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
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
400: ( header_id,
401: line_id,
402: creation_date,
403: created_by,