APPS.OE_ORDER_PURGE_PVT dependencies on OE_PRICE_ADJS_HISTORY

Line 2153: FROM oe_price_adjs_history

2149: FOR UPDATE NOWAIT;
2150:
2151: CURSOR c_lock_price_adj_hist IS
2152: SELECT header_id -- Lock all rows to be purged
2153: FROM oe_price_adjs_history
2154: WHERE header_id = p_header_id
2155: FOR UPDATE NOWAIT;
2156:
2157: CURSOR c_lock_sales_credit_hist IS

Line 2384: DELETE FROM oe_price_adjs_history WHERE header_id = p_header_id;

2380: OE_DEBUG_PUB.Add('After Deleting header history='|| to_char(p_header_id));
2381:
2382: OPEN c_lock_price_adj_hist;
2383: CLOSE c_lock_price_adj_hist;
2384: DELETE FROM oe_price_adjs_history WHERE header_id = p_header_id;
2385:
2386: OE_DEBUG_PUB.Add('After Deleting Price Adj history='|| to_char(p_header_id));
2387:
2388: OPEN c_lock_sales_credit_hist;