176: AND WAS.ACTIVITY_STATUS = 'NOTIFIED'
177: AND WAS.ITEM_TYPE = 'OEOH'
178: AND NOT EXISTS
179: (SELECT 1
180: FROM OE_ORDER_LINES_ALL
181: WHERE HEADER_ID = H.HEADER_ID
182: AND OPEN_FLAG = 'Y'
183: );
184: CURSOR CLOSE_SPECIFIC(c_item_key VARCHAR2 )
198: AND WAS.item_key = c_item_key
199: AND WAS.ITEM_TYPE = 'OEOH'
200: AND NOT EXISTS
201: (SELECT 1
202: FROM OE_ORDER_LINES_ALL
203: WHERE HEADER_ID = H.HEADER_ID
204: AND OPEN_FLAG = 'Y'
205: );
206: CURSOR ERRORS (c_header_id NUMBER)