APPS.OE_CANCEL dependencies on SO_LINE_SERVICE_DETAILS

Line 116: -- need to cleanup the so_line_service_details if there were any

112: -- Need to insert a record into so_order_cancellations indicating
113: -- the order level cancellation. We also need to detele the
114: -- corresponding so_line_details for the order just cancelled,
115: -- excluding any line details that have been released. Also
116: -- need to cleanup the so_line_service_details if there were any
117: -- lines that were of a service nature.
118: --
119: -- RETURNS:
120: -- 1 -> order has been cancelled

Line 322: DELETE FROM SO_LINE_SERVICE_DETAILS

318: WHERE HEADER_ID = V_HEADER_ID)
319: AND RELEASED_FLAG = 'N';
320:
321:
322: DELETE FROM SO_LINE_SERVICE_DETAILS
323: WHERE LINE_ID IN (
324: SELECT LINE_ID
325: FROM SO_LINES
326: WHERE HEADER_ID = V_HEADER_ID);