APPS.OE_LINE_ADJ_ASSOCS_UTIL dependencies on OE_PRICE_ADJ_ASSOCS

Line 54: from oe_price_adj_Assocs where

50: ,PRICE_ADJ_ASSOC_ID
51: ,LINE_ID
52: ,RLTD_PRICE_ADJ_ID
53: ,LOCK_CONTROL
54: from oe_price_adj_Assocs where
55: ( PRICE_ADJ_assoc_ID = p_price_adj_Assoc_id
56: or price_adjustment_id = p_price_adjustment_id);
57:
58: --

Line 132: INSERT INTO OE_PRICE_ADJ_ASSOCS

128: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
129: --
130: BEGIN
131:
132: INSERT INTO OE_PRICE_ADJ_ASSOCS
133: ( PRICE_ADJUSTMENT_ID
134: ,CREATION_DATE
135: ,CREATED_BY
136: ,LAST_UPDATE_DATE

Line 195: FROM OE_PRICE_ADJ_ASSOCS

191: BEGIN
192:
193: SELECT lock_control
194: INTO l_lock_control
195: FROM OE_PRICE_ADJ_ASSOCS
196: WHERE price_adj_assoc_id = p_Line_Adj_Assoc_rec.price_adj_assoc_id;
197:
198: l_lock_control := l_lock_control + 1;
199:

Line 200: UPDATE OE_PRICE_ADJ_ASSOCS

196: WHERE price_adj_assoc_id = p_Line_Adj_Assoc_rec.price_adj_assoc_id;
197:
198: l_lock_control := l_lock_control + 1;
199:
200: UPDATE OE_PRICE_ADJ_ASSOCS
201: SET PRICE_ADJUSTMENT_ID = p_Line_Adj_Assoc_Rec.Price_Adjustment_id
202: ,CREATION_DATE = p_Line_Adj_Assoc_Rec.creation_date
203: ,CREATED_BY = p_Line_Adj_Assoc_Rec.created_by
204: ,LAST_UPDATE_DATE = p_Line_Adj_Assoc_Rec.last_update_date

Line 250: DELETE OE_PRICE_ADJ_ASSOCS opaa

246: IF l_debug_level > 0 THEN
247: oe_debug_pub.add( 'PRICE ADJ: DELETE ROW OE_LINE_ADJ_ASSOCS_UTIL' , 5 ) ;
248: END IF;
249: --Modified the below delete statement to fix bug 2626303
250: DELETE OE_PRICE_ADJ_ASSOCS opaa
251: WHERE opaa.rltd_price_adj_id in
252: ( select to_number(p_price_adjustment_id) from dual
253: UNION ALL
254: select opaa1.rltd_price_adj_id

Line 255: from OE_PRICE_ADJ_ASSOCS opaa1 where

251: WHERE opaa.rltd_price_adj_id in
252: ( select to_number(p_price_adjustment_id) from dual
253: UNION ALL
254: select opaa1.rltd_price_adj_id
255: from OE_PRICE_ADJ_ASSOCS opaa1 where
256: opaa1.price_adjustment_id = p_price_adjustment_id
257: ) ;
258: else
259: DELETE OE_PRICE_ADJ_ASSOCS

Line 259: DELETE OE_PRICE_ADJ_ASSOCS

255: from OE_PRICE_ADJ_ASSOCS opaa1 where
256: opaa1.price_adjustment_id = p_price_adjustment_id
257: ) ;
258: else
259: DELETE OE_PRICE_ADJ_ASSOCS
260: WHERE PRICE_ADJ_Assoc_ID = p_price_adj_Assoc_id;
261: end if;
262: exception
263: WHEN OTHERS THEN

Line 460: FROM oe_price_adj_assocs

456: END IF;
457:
458: SELECT price_adj_assoc_id
459: INTO l_price_adj_assoc_id
460: FROM oe_price_adj_assocs
461: WHERE price_adj_assoc_id = l_price_adj_assoc_id
462: FOR UPDATE NOWAIT;
463:
464: OE_Line_Adj_Assocs_Util.Query_Row

Line 582: FROM oe_price_adj_assocs

578: IS
579:
580: CURSOR lock_assoc_lines(p_price_adjustment_id IN NUMBER) IS
581: SELECT price_adj_assoc_id
582: FROM oe_price_adj_assocs
583: WHERE price_adjustment_id = p_price_adjustment_id
584: FOR UPDATE NOWAIT;
585:
586: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

Line 619: FROM oe_price_adj_assocs

615: IF p_price_adj_assoc_id <> FND_API.G_MISS_NUM THEN
616:
617: SELECT price_adj_assoc_id
618: INTO l_price_adj_assoc_id
619: FROM oe_price_adj_assocs
620: WHERE price_adj_assoc_id = p_price_adj_assoc_id
621: FOR UPDATE NOWAIT;
622: END IF;
623: