APPS.OE_HEADER_PRICE_AATTR_UTIL dependencies on OE_PRICE_ADJ_ATTRIBS

Line 57: from oe_price_adj_attribs where

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

Line 79: from oe_price_adj_attribs where

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

Line 160: INSERT INTO OE_PRICE_ADJ_ATTRIBS

156: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
157: --
158: BEGIN
159:
160: INSERT INTO OE_PRICE_ADJ_ATTRIBS
161: ( PRICE_ADJUSTMENT_ID
162: ,PRICING_CONTEXT
163: ,PRICING_ATTRIBUTE
164: ,CREATION_DATE

Line 230: FROM OE_PRICE_ADJ_ATTRIBS

226: --
227: BEGIN
228: SELECT lock_control
229: INTO l_lock_control
230: FROM OE_PRICE_ADJ_ATTRIBS
231: WHERE price_adj_attrib_id = p_Header_Adj_Att_rec.price_adj_attrib_id;
232:
233: l_lock_control := l_lock_control + 1;
234:

Line 235: UPDATE OE_PRICE_ADJ_ATTRIBS

231: WHERE price_adj_attrib_id = p_Header_Adj_Att_rec.price_adj_attrib_id;
232:
233: l_lock_control := l_lock_control + 1;
234:
235: UPDATE OE_PRICE_ADJ_ATTRIBS
236: SET PRICE_ADJUSTMENT_ID = p_Header_Adj_Att_Rec.Price_Adjustment_id
237: ,PRICING_CONTEXT = p_Header_Adj_Att_Rec.Pricing_Context
238: ,PRICING_ATTRIBUTE = p_Header_Adj_Att_Rec.Pricing_Attribute
239: ,CREATION_DATE = p_Header_Adj_Att_Rec.creation_date

Line 289: DELETE OE_PRICE_ADJ_ATTRIBS

285: BEGIN
286:
287: IF p_price_adjustment_id <> FND_API.G_MISS_NUM then
288:
289: DELETE OE_PRICE_ADJ_ATTRIBS
290: WHERE price_adjustment_id = p_price_adjustment_id;
291: else
292: DELETE OE_PRICE_ADJ_ATTRIBS
293: WHERE PRICE_ADJ_ATTRIB_ID = p_price_adj_attrib_id;

Line 292: DELETE OE_PRICE_ADJ_ATTRIBS

288:
289: DELETE OE_PRICE_ADJ_ATTRIBS
290: WHERE price_adjustment_id = p_price_adjustment_id;
291: else
292: DELETE OE_PRICE_ADJ_ATTRIBS
293: WHERE PRICE_ADJ_ATTRIB_ID = p_price_adj_attrib_id;
294: end if;
295:
296: EXCEPTION

Line 527: FROM oe_price_adj_attribs

523: END IF;
524:
525: SELECT price_adj_attrib_id
526: INTO l_price_adj_attrib_id
527: FROM oe_price_adj_attribs
528: WHERE price_adj_attrib_id = l_price_adj_attrib_id
529: FOR UPDATE NOWAIT;
530:
531: OE_Header_Price_Aattr_Util.Query_Row

Line 649: FROM oe_price_adj_attribs

645: IS
646:
647: CURSOR lock_att_hdr(p_price_adjustment_id IN NUMBER) IS
648: SELECT price_adj_attrib_id
649: FROM oe_price_adj_attribs
650: WHERE price_adjustment_id = p_price_adjustment_id
651: FOR UPDATE NOWAIT;
652:
653: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

Line 686: FROM oe_price_adj_attribs

682: IF p_price_adj_attrib_id <> FND_API.G_MISS_NUM THEN
683:
684: SELECT price_adj_attrib_id
685: INTO l_price_adj_attrib_id
686: FROM oe_price_adj_attribs
687: WHERE price_adj_attrib_id = p_price_adj_attrib_id
688: FOR UPDATE NOWAIT;
689: END IF;
690: