DBA Data[Home] [Help]

APPS.QP_UPG_OE_PVT dependencies on OE_ORDER_PRICE_ATTRIBS

Line 176: SELECT OE_ORDER_PRICE_ATTRIBS_S.nextval

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

Line 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,

Line 285: SELECT OE_ORDER_PRICE_ATTRIBS_S.nextval

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

Line 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,

Line 395: SELECT OE_ORDER_PRICE_ATTRIBS_S.nextval

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

Line 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,