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 2324: DELETE FROM oe_order_header_history WHERE header_id = p_header_id;

2320: -- Purge the History tables
2321:
2322: OPEN c_lock_header_hist;
2323: CLOSE c_lock_header_hist;
2324: DELETE FROM oe_order_header_history WHERE header_id = p_header_id;
2325:
2326: OE_DEBUG_PUB.Add('After Deleting header history='|| to_char(p_header_id));
2327:
2328: OPEN c_lock_price_adj_hist;