Problem with OE_ORDER_PUB
I have been asked to perform a mass change on all of our booked orders to either cancel or close them (depending on the state of the lines). I have tried to use OE_ORDER_PUB to perform this mass change. I called the following procedures in the OE_ORDER_PUB package:
Update_line
Update_header
For both these procedures, I pass in the header_id form oe_order_headers_all and line_id from oe_order_Lines_all for update_line. I also pass in the cancelled_flag of 'Y' and also status of Cancelled.
I have also added the following to my code before each procedure call: