APPS.OE_HEADER_ADJ_ASSOCS_UTIL dependencies on OE_PRICE_ADJ_ASSOCS

Line 55: from oe_price_adj_Assocs where

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

Line 134: INSERT INTO OE_PRICE_ADJ_ASSOCS

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

Line 197: FROM OE_PRICE_ADJ_ASSOCS

193: BEGIN
194:
195: SELECT lock_control
196: INTO l_lock_control
197: FROM OE_PRICE_ADJ_ASSOCS
198: WHERE price_adj_assoc_id = p_Header_Adj_Assoc_rec.price_adj_assoc_id;
199:
200: l_lock_control := l_lock_control + 1;
201:

Line 202: UPDATE OE_PRICE_ADJ_ASSOCS

198: WHERE price_adj_assoc_id = p_Header_Adj_Assoc_rec.price_adj_assoc_id;
199:
200: l_lock_control := l_lock_control + 1;
201:
202: UPDATE OE_PRICE_ADJ_ASSOCS
203: SET PRICE_ADJUSTMENT_ID = p_Header_Adj_Assoc_Rec.Price_Adjustment_id
204: ,CREATION_DATE = p_Header_Adj_Assoc_Rec.creation_date
205: ,CREATED_BY = p_Header_Adj_Assoc_Rec.created_by
206: ,LAST_UPDATE_DATE = p_Header_Adj_Assoc_Rec.last_update_date

Line 249: DELETE OE_PRICE_ADJ_ASSOCS opaa

245: --
246: BEGIN
247: IF p_price_adjustment_id <> FND_API.G_MISS_NUM then
248: -- SQL ID: 16486572
249: DELETE OE_PRICE_ADJ_ASSOCS opaa
250: WHERE opaa.price_adjustment_id = p_price_adjustment_id;
251: DELETE OE_PRICE_ADJ_ASSOCS opaa
252: WHERE opaa.rltd_price_adj_id = p_price_adjustment_id;
253: else

Line 251: DELETE OE_PRICE_ADJ_ASSOCS opaa

247: IF p_price_adjustment_id <> FND_API.G_MISS_NUM then
248: -- SQL ID: 16486572
249: DELETE OE_PRICE_ADJ_ASSOCS opaa
250: WHERE opaa.price_adjustment_id = p_price_adjustment_id;
251: DELETE OE_PRICE_ADJ_ASSOCS opaa
252: WHERE opaa.rltd_price_adj_id = p_price_adjustment_id;
253: else
254: DELETE OE_PRICE_ADJ_ASSOCS
255: WHERE PRICE_ADJ_Assoc_ID = p_price_adj_Assoc_id;

Line 254: DELETE OE_PRICE_ADJ_ASSOCS

250: WHERE opaa.price_adjustment_id = p_price_adjustment_id;
251: DELETE OE_PRICE_ADJ_ASSOCS opaa
252: WHERE opaa.rltd_price_adj_id = p_price_adjustment_id;
253: else
254: DELETE OE_PRICE_ADJ_ASSOCS
255: WHERE PRICE_ADJ_Assoc_ID = p_price_adj_Assoc_id;
256: end if;
257:
258: exception

Line 456: FROM oe_price_adj_assocs

452: END IF;
453:
454: SELECT price_adj_assoc_id
455: INTO l_price_adj_assoc_id
456: FROM oe_price_adj_assocs
457: WHERE price_adj_assoc_id = l_price_adj_assoc_id
458: FOR UPDATE NOWAIT;
459:
460: OE_Header_Adj_Assocs_Util.Query_Row

Line 578: FROM oe_price_adj_assocs

574: IS
575:
576: CURSOR lock_assoc_hdr(p_price_adjustment_id IN NUMBER) IS
577: SELECT price_adj_assoc_id
578: FROM oe_price_adj_assocs
579: WHERE price_adjustment_id = p_price_adjustment_id
580: FOR UPDATE NOWAIT;
581:
582: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

Line 615: FROM oe_price_adj_assocs

611: IF p_price_adj_assoc_id <> FND_API.G_MISS_NUM THEN
612:
613: SELECT price_adj_assoc_id
614: INTO l_price_adj_assoc_id
615: FROM oe_price_adj_assocs
616: WHERE price_adj_assoc_id = p_price_adj_assoc_id
617: FOR UPDATE NOWAIT;
618: END IF;
619: