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: cursor c_purge_set_history is --bug#5631508
2332: OE_DEBUG_PUB.Add('After Deleting Price Adj history='|| to_char(p_header_id));
2333:
2334: OPEN c_lock_sales_credit_hist;
2335: CLOSE c_lock_sales_credit_hist;
2336: DELETE FROM oe_sales_credit_history WHERE header_id = p_header_id;
2337:
2338: OE_DEBUG_PUB.Add('After Deleting Sales Credit history='|| to_char(p_header_id));
2339:
2340: OPEN c_purge_set_history; --bug#5631508