DBA Data[Home] [Help]

APPS.OE_ORDER_PURGE_PVT dependencies on OE_SALES_CREDIT_HISTORY

Line 2159: FROM oe_sales_credit_history

2155: FOR UPDATE NOWAIT;
2156:
2157: CURSOR c_lock_sales_credit_hist IS
2158: SELECT header_id -- Lock all rows to be purged
2159: FROM oe_sales_credit_history
2160: WHERE header_id = p_header_id
2161: FOR UPDATE NOWAIT;
2162:
2163: --16193599 Audit History Purge Start

Line 2390: DELETE FROM oe_sales_credit_history WHERE header_id = p_header_id;

2386: OE_DEBUG_PUB.Add('After Deleting Price Adj history='|| to_char(p_header_id));
2387:
2388: OPEN c_lock_sales_credit_hist;
2389: CLOSE c_lock_sales_credit_hist;
2390: DELETE FROM oe_sales_credit_history WHERE header_id = p_header_id;
2391:
2392: OE_DEBUG_PUB.Add('After Deleting Sales Credit history='|| to_char(p_header_id));
2393:
2394: OPEN c_purge_set_history; --bug#5631508