256: SELECT
257: LINE_ID
258: INTO LINE_ID
259: FROM
260: OE_ORDER_HOLDS
261: WHERE ORDER_HOLD_ID = P_ORDER_HOLD_ID;
262: IF LINE_ID IS NOT NULL THEN
263: RETURN ('LINE');
264: ELSE
280: SELECT
281: HEADER_ID
282: INTO HEADER_ID_VAR
283: FROM
284: OE_ORDER_HOLDS
285: WHERE HEADER_ID = HEADER_ID
286: AND LINE_ID is NULL
287: AND HOLD_RELEASE_ID is NULL;
288: END IF;