Release sales order lines , 4000 lines in each sales order
Dear Gurus,
I have 4 sales orders where each order is having 4000 lines each.
Now the user is unable to release the hold from the Front end.
So , I decided to develop some script to release the hold , for this i developed a procedure where the agenda is to release the hold . the script is as follows.
=============================================================================================================================
create or replace
PROCEDURE XXONT_RELEASEHOLDS (p_user_name VARCHAR2,
p_order_num_low NUMBER,
P_Order_Num_High Number
) IS
CURSOR cur_orders_hold
IS
SELECT
hdra.header_id
,hdra.order_number
,hsrc.hold_source_id
,hsrc.hold_id
FROM oe_order_headers_all hdra,
0