APPS.OE_ORDER_PURGE_PVT dependencies on OE_ORDER_HEADER_HISTORY

Line 2147: FROM oe_order_header_history

2143: FOR UPDATE NOWAIT;
2144:
2145: CURSOR c_lock_header_hist IS
2146: SELECT header_id -- Lock all rows to be purged
2147: FROM oe_order_header_history
2148: WHERE header_id = p_header_id
2149: FOR UPDATE NOWAIT;
2150:
2151: CURSOR c_lock_price_adj_hist IS

Line 2378: DELETE FROM oe_order_header_history WHERE header_id = p_header_id;

2374: -- Purge the History tables
2375:
2376: OPEN c_lock_header_hist;
2377: CLOSE c_lock_header_hist;
2378: DELETE FROM oe_order_header_history WHERE header_id = p_header_id;
2379:
2380: OE_DEBUG_PUB.Add('After Deleting header history='|| to_char(p_header_id));
2381:
2382: OPEN c_lock_price_adj_hist;