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 3539: DELETE FROM OE_ORDER_PRICE_ATTRIBS

3535: --
3536: BEGIN
3537: IF p_Header_id <> FND_API.G_MISS_NUM Then
3538:
3539: DELETE FROM OE_ORDER_PRICE_ATTRIBS
3540: WHERE Header_Id = p_Header_id;
3541: Else
3542: DELETE FROM OE_ORDER_PRICE_ATTRIBS
3543: WHERE ORDER_PRICE_ATTRIB_ID = p_order_price_attrib_id;

Line 3542: DELETE FROM OE_ORDER_PRICE_ATTRIBS

3538:
3539: DELETE FROM OE_ORDER_PRICE_ATTRIBS
3540: WHERE Header_Id = p_Header_id;
3541: Else
3542: DELETE FROM OE_ORDER_PRICE_ATTRIBS
3543: WHERE ORDER_PRICE_ATTRIB_ID = p_order_price_attrib_id;
3544:
3545: end if;
3546:

Line 3577: INSERT INTO OE_ORDER_PRICE_ATTRIBS

3573: IF l_debug_level > 0 THEN
3574: oe_debug_pub.add( 'ENTERING OE_HEADER_PATT_UTIL.INSERT_ROW' , 1 ) ;
3575: END IF;
3576:
3577: INSERT INTO OE_ORDER_PRICE_ATTRIBS
3578: ( HEADER_ID
3579: ,LINE_ID
3580: ,CREATION_DATE
3581: ,CREATED_BY

Line 3885: FROM OE_ORDER_PRICE_ATTRIBS

3881:
3882: -- increment lock_control by 1 whenever record is updated
3883: SELECT lock_control
3884: INTO l_lock_control
3885: FROM OE_ORDER_PRICE_ATTRIBS
3886: WHERE order_price_attrib_id = p_Header_Price_Att_rec.order_price_attrib_id;
3887:
3888: l_lock_control := l_lock_control + 1;
3889:

Line 3890: UPDATE OE_ORDER_PRICE_ATTRIBS

3886: WHERE order_price_attrib_id = p_Header_Price_Att_rec.order_price_attrib_id;
3887:
3888: l_lock_control := l_lock_control + 1;
3889:
3890: UPDATE OE_ORDER_PRICE_ATTRIBS
3891: SET HEADER_ID = p_Header_Price_Att_rec.HEADER_ID
3892: ,LINE_ID = p_Header_Price_Att_rec.LINE_ID
3893: ,OVERRIDE_FLAG = p_Header_Price_Att_rec.OVERRIDE_FLAG
3894: ,CREATION_DATE = p_Header_Price_Att_rec.CREATION_DATE

Line 4082: FROM oe_order_price_attribs

4078: END IF;
4079:
4080: SELECT order_price_attrib_id
4081: INTO l_order_price_attrib_id
4082: FROM oe_order_price_attribs
4083: WHERE order_price_attrib_id = l_order_price_attrib_id
4084: FOR UPDATE NOWAIT;
4085:
4086: OE_Header_PAttr_Util.Query_Row

Line 4212: FROM oe_order_price_attribs

4208: IS
4209:
4210: CURSOR lock_pattr_hdr(p_header_id IN NUMBER) IS
4211: SELECT order_price_attrib_id
4212: FROM oe_order_price_attribs
4213: WHERE header_id = p_header_id
4214: FOR UPDATE NOWAIT;
4215:
4216: l_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

Line 4249: FROM oe_order_price_attribs

4245: IF p_order_price_attrib_id <> FND_API.G_MISS_NUM THEN
4246:
4247: SELECT order_price_attrib_id
4248: INTO l_order_price_attrib_id
4249: FROM oe_order_price_attribs
4250: WHERE order_price_attrib_id = p_order_price_attrib_id
4251: FOR UPDATE NOWAIT;
4252: END IF;
4253: