APPS.OE_LINE_PRICE_AATTR_UTIL dependencies on OE_PRICE_ADJ_ATTRIBS

Line 59: from oe_price_adj_attribs where

55: ,COMPARISON_OPERATOR
56: ,FLEX_TITLE
57: ,PRICE_ADJ_ATTRIB_ID
58: ,LOCK_CONTROL
59: from oe_price_adj_attribs where
60: PRICE_ADJ_ATTRIB_ID = p_price_adj_attrib_id
61: Union all
62: SELECT
63: PRICE_ADJUSTMENT_ID

Line 81: from oe_price_adj_attribs where

77: ,COMPARISON_OPERATOR
78: ,FLEX_TITLE
79: ,PRICE_ADJ_ATTRIB_ID
80: ,LOCK_CONTROL
81: from oe_price_adj_attribs where
82: price_adjustment_id = p_price_adjustment_id;
83:
84: --
85: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 163: INSERT INTO OE_PRICE_ADJ_ATTRIBS

159: IF l_debug_level > 0 THEN
160: oe_debug_pub.add('Entering Oe_Line_Price_Aattr_util.insert_row');
161: END IF;
162:
163: INSERT INTO OE_PRICE_ADJ_ATTRIBS
164: ( PRICE_ADJUSTMENT_ID
165: ,PRICING_CONTEXT
166: ,PRICING_ATTRIBUTE
167: ,CREATION_DATE

Line 242: FROM OE_PRICE_ADJ_ATTRIBS

238: --
239: BEGIN
240: SELECT lock_control
241: INTO l_lock_control
242: FROM OE_PRICE_ADJ_ATTRIBS
243: WHERE price_adj_attrib_id = p_Line_Adj_Att_rec.price_adj_attrib_id;
244:
245: l_lock_control := l_lock_control + 1;
246:

Line 247: UPDATE OE_PRICE_ADJ_ATTRIBS

243: WHERE price_adj_attrib_id = p_Line_Adj_Att_rec.price_adj_attrib_id;
244:
245: l_lock_control := l_lock_control + 1;
246:
247: UPDATE OE_PRICE_ADJ_ATTRIBS
248: SET PRICE_ADJUSTMENT_ID = p_Line_Adj_Att_Rec.Price_Adjustment_id
249: ,PRICING_CONTEXT = p_Line_Adj_Att_Rec.Pricing_Context
250: ,PRICING_ATTRIBUTE = p_Line_Adj_Att_Rec.Pricing_Attribute
251: ,CREATION_DATE = p_Line_Adj_Att_Rec.creation_date

Line 302: DELETE FROM OE_PRICE_ADJ_ATTRIBS

298:
299: IF p_price_adjustment_id <> FND_API.G_MISS_NUM then
300: --bug3528335 splitting the DELETE statement to delete attributes corresponding to child lines first (if the parent is PBH) and then the parent
301: --bug3405372 deleting the rows corresponding to the child lines of PBH modifiers as well.
302: DELETE FROM OE_PRICE_ADJ_ATTRIBS
303: WHERE PRICE_ADJUSTMENT_ID IN (SELECT RLTD_PRICE_ADJ_ID
304: FROM OE_PRICE_ADJ_ASSOCS ASSOCS,
305: OE_PRICE_ADJUSTMENTS PARENT
306: WHERE ASSOCS.PRICE_ADJUSTMENT_ID=PARENT.PRICE_ADJUSTMENT_ID

Line 315: DELETE FROM OE_PRICE_ADJ_ATTRIBS

311: END IF;
312:
313:
314:
315: DELETE FROM OE_PRICE_ADJ_ATTRIBS
316: WHERE PRICE_ADJUSTMENT_ID = p_price_adjustment_id;
317: --bug3528335 end
318: else
319: DELETE OE_PRICE_ADJ_ATTRIBS

Line 319: DELETE OE_PRICE_ADJ_ATTRIBS

315: DELETE FROM OE_PRICE_ADJ_ATTRIBS
316: WHERE PRICE_ADJUSTMENT_ID = p_price_adjustment_id;
317: --bug3528335 end
318: else
319: DELETE OE_PRICE_ADJ_ATTRIBS
320: WHERE PRICE_ADJ_ATTRIB_ID = p_price_adj_attrib_id;
321: end if;
322:
323: EXCEPTION

Line 554: FROM oe_price_adj_attribs

550: END IF;
551:
552: SELECT price_adj_attrib_id
553: INTO l_price_adj_attrib_id
554: FROM oe_price_adj_attribs
555: WHERE price_adj_attrib_id = l_price_adj_attrib_id
556: FOR UPDATE NOWAIT;
557:
558: OE_Line_Price_Aattr_Util.Query_Row

Line 675: FROM oe_price_adj_attribs

671: IS
672:
673: CURSOR lock_att_lines(p_price_adjustment_id IN NUMBER) IS
674: SELECT price_adj_attrib_id
675: FROM oe_price_adj_attribs
676: WHERE price_adjustment_id = p_price_adjustment_id
677: FOR UPDATE NOWAIT;
678:
679: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

Line 712: FROM oe_price_adj_attribs

708: IF p_price_adj_attrib_id <> FND_API.G_MISS_NUM THEN
709:
710: SELECT price_adj_attrib_id
711: INTO l_price_adj_attrib_id
712: FROM oe_price_adj_attribs
713: WHERE price_adj_attrib_id = p_price_adj_attrib_id
714: FOR UPDATE NOWAIT;
715: END IF;
716: