APPS.OE_HEADER_PATTR_UTIL dependencies on OE_ORDER_PRICE_ATTRIBS

Line 170: FROM OE_ORDER_PRICE_ATTRIBS

166: ,FLEX_TITLE
167: ,ORDER_PRICE_ATTRIB_ID
168: ,OVERRIDE_FLAG
169: ,LOCK_CONTROL
170: FROM OE_ORDER_PRICE_ATTRIBS
171: WHERE ( ORDER_PRICE_ATTRIB_ID = p_order_price_attrib_id
172: OR
173: ( HEADER_ID = p_header_id AND LINE_ID IS NULL ));
174:

Line 3551: DELETE FROM OE_ORDER_PRICE_ATTRIBS

3547: --
3548: BEGIN
3549: IF p_Header_id <> FND_API.G_MISS_NUM Then
3550:
3551: DELETE FROM OE_ORDER_PRICE_ATTRIBS
3552: WHERE Header_Id = p_Header_id;
3553: Else
3554: DELETE FROM OE_ORDER_PRICE_ATTRIBS
3555: WHERE ORDER_PRICE_ATTRIB_ID = p_order_price_attrib_id;

Line 3554: DELETE FROM OE_ORDER_PRICE_ATTRIBS

3550:
3551: DELETE FROM OE_ORDER_PRICE_ATTRIBS
3552: WHERE Header_Id = p_Header_id;
3553: Else
3554: DELETE FROM OE_ORDER_PRICE_ATTRIBS
3555: WHERE ORDER_PRICE_ATTRIB_ID = p_order_price_attrib_id;
3556:
3557: end if;
3558:

Line 3589: INSERT INTO OE_ORDER_PRICE_ATTRIBS

3585: IF l_debug_level > 0 THEN
3586: oe_debug_pub.add( 'ENTERING OE_HEADER_PATT_UTIL.INSERT_ROW' , 1 ) ;
3587: END IF;
3588:
3589: INSERT INTO OE_ORDER_PRICE_ATTRIBS
3590: ( HEADER_ID
3591: ,LINE_ID
3592: ,CREATION_DATE
3593: ,CREATED_BY

Line 3897: FROM OE_ORDER_PRICE_ATTRIBS

3893:
3894: -- increment lock_control by 1 whenever record is updated
3895: SELECT lock_control
3896: INTO l_lock_control
3897: FROM OE_ORDER_PRICE_ATTRIBS
3898: WHERE order_price_attrib_id = p_Header_Price_Att_rec.order_price_attrib_id;
3899:
3900: l_lock_control := l_lock_control + 1;
3901:

Line 3902: UPDATE OE_ORDER_PRICE_ATTRIBS

3898: WHERE order_price_attrib_id = p_Header_Price_Att_rec.order_price_attrib_id;
3899:
3900: l_lock_control := l_lock_control + 1;
3901:
3902: UPDATE OE_ORDER_PRICE_ATTRIBS
3903: SET HEADER_ID = p_Header_Price_Att_rec.HEADER_ID
3904: ,LINE_ID = p_Header_Price_Att_rec.LINE_ID
3905: ,OVERRIDE_FLAG = p_Header_Price_Att_rec.OVERRIDE_FLAG
3906: ,CREATION_DATE = p_Header_Price_Att_rec.CREATION_DATE

Line 4094: FROM oe_order_price_attribs

4090: END IF;
4091:
4092: SELECT order_price_attrib_id
4093: INTO l_order_price_attrib_id
4094: FROM oe_order_price_attribs
4095: WHERE order_price_attrib_id = l_order_price_attrib_id
4096: FOR UPDATE NOWAIT;
4097:
4098: OE_Header_PAttr_Util.Query_Row

Line 4224: FROM oe_order_price_attribs

4220: IS
4221:
4222: CURSOR lock_pattr_hdr(p_header_id IN NUMBER) IS
4223: SELECT order_price_attrib_id
4224: FROM oe_order_price_attribs
4225: WHERE header_id = p_header_id
4226: FOR UPDATE NOWAIT;
4227:
4228: l_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

Line 4261: FROM oe_order_price_attribs

4257: IF p_order_price_attrib_id <> FND_API.G_MISS_NUM THEN
4258:
4259: SELECT order_price_attrib_id
4260: INTO l_order_price_attrib_id
4261: FROM oe_order_price_attribs
4262: WHERE order_price_attrib_id = p_order_price_attrib_id
4263: FOR UPDATE NOWAIT;
4264: END IF;
4265: