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 4229: FROM oe_order_price_attribs

4225: END IF;
4226:
4227: SELECT order_price_attrib_id
4228: INTO l_order_price_attrib_id
4229: FROM oe_order_price_attribs
4230: WHERE order_price_attrib_id = l_order_price_attrib_id
4231: FOR UPDATE NOWAIT;
4232:
4233: OE_Line_PAttr_Util.Query_Row

Line 4350: FROM oe_order_price_attribs

4346: IS
4347:
4348: CURSOR lock_pattr_lines(p_line_id IN NUMBER) IS
4349: SELECT order_price_attrib_id
4350: FROM oe_order_price_attribs
4351: WHERE line_id = p_line_id
4352: FOR UPDATE NOWAIT;
4353:
4354: l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

Line 4382: FROM oe_order_price_attribs

4378: IF p_order_price_attrib_id <> FND_API.G_MISS_NUM THEN
4379:
4380: SELECT order_price_attrib_id
4381: INTO l_order_price_attrib_id
4382: FROM oe_order_price_attribs
4383: WHERE order_price_attrib_id = p_order_price_attrib_id
4384: FOR UPDATE NOWAIT;
4385: END IF;
4386: