APPS.OE_LINE_PATTR_UTIL dependencies on OE_ORDER_PRICE_ATTRIBS

Line 168: FROM OE_ORDER_PRICE_ATTRIBS

164: ,ORDER_PRICE_ATTRIB_ID
165: ,OVERRIDE_FLAG
166: ,LOCK_CONTROL
167: ,ORIG_SYS_ATTS_REF
168: FROM OE_ORDER_PRICE_ATTRIBS
169: WHERE ( ORDER_PRICE_ATTRIB_ID = p_order_price_attrib_id
170: Or line_id = p_Line_Id );
171:
172:

Line 392: INSERT INTO OE_ORDER_PRICE_ATTRIBS

388: BEGIN
389:
390: oe_debug_pub.add('Entering OE_Line_Patt_UTIL.INSERT_ROW', 1);
391:
392: INSERT INTO OE_ORDER_PRICE_ATTRIBS
393: ( HEADER_ID
394: ,LINE_ID
395: ,CREATION_DATE
396: ,CREATED_BY

Line 694: DELETE FROM OE_ORDER_PRICE_ATTRIBS

690: IS
691: BEGIN
692: IF p_line_id <> FND_API.G_MISS_NUM then
693:
694: DELETE FROM OE_ORDER_PRICE_ATTRIBS
695: WHERE Line_Id = p_Line_id;
696: Else
697: DELETE FROM OE_ORDER_PRICE_ATTRIBS
698: WHERE ORDER_PRICE_ATTRIB_ID = p_order_price_attrib_id;

Line 697: DELETE FROM OE_ORDER_PRICE_ATTRIBS

693:
694: DELETE FROM OE_ORDER_PRICE_ATTRIBS
695: WHERE Line_Id = p_Line_id;
696: Else
697: DELETE FROM OE_ORDER_PRICE_ATTRIBS
698: WHERE ORDER_PRICE_ATTRIB_ID = p_order_price_attrib_id;
699:
700: end if;
701: EXCEPTION

Line 733: FROM OE_ORDER_PRICE_ATTRIBS

729:
730: -- increment lock_control by 1 whenever the record is updated
731: SELECT lock_control
732: INTO l_lock_control
733: FROM OE_ORDER_PRICE_ATTRIBS
734: WHERE order_price_attrib_id = p_line_Price_Att_rec.order_price_attrib_id;
735:
736: l_lock_control := l_lock_control + 1;
737:

Line 739: UPDATE OE_ORDER_PRICE_ATTRIBS

735:
736: l_lock_control := l_lock_control + 1;
737:
738:
739: UPDATE OE_ORDER_PRICE_ATTRIBS
740: SET HEADER_ID = p_Line_Price_Att_rec.HEADER_ID
741: ,LINE_ID = p_Line_Price_Att_rec.LINE_ID
742: ,OVERRIDE_FLAG = p_Line_Price_Att_rec.OVERRIDE_FLAG
743: ,CREATION_DATE = p_Line_Price_Att_rec.CREATION_DATE

Line 4188: FROM oe_order_price_attribs

4184: END IF;
4185:
4186: SELECT order_price_attrib_id
4187: INTO l_order_price_attrib_id
4188: FROM oe_order_price_attribs
4189: WHERE order_price_attrib_id = l_order_price_attrib_id
4190: FOR UPDATE NOWAIT;
4191:
4192: OE_Line_PAttr_Util.Query_Row

Line 4309: FROM oe_order_price_attribs

4305: IS
4306:
4307: CURSOR lock_pattr_lines(p_line_id IN NUMBER) IS
4308: SELECT order_price_attrib_id
4309: FROM oe_order_price_attribs
4310: WHERE line_id = p_line_id
4311: FOR UPDATE NOWAIT;
4312:
4313: l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

Line 4341: FROM oe_order_price_attribs

4337: IF p_order_price_attrib_id <> FND_API.G_MISS_NUM THEN
4338:
4339: SELECT order_price_attrib_id
4340: INTO l_order_price_attrib_id
4341: FROM oe_order_price_attribs
4342: WHERE order_price_attrib_id = p_order_price_attrib_id
4343: FOR UPDATE NOWAIT;
4344: END IF;
4345: