150: BEGIN
151: -- IF P_Version IS NULL THEN
152: BEGIN
153: SELECT 'Y' INTO lv_exists_flag
154: FROM DUAL
155: WHERE EXISTS
156: ( SELECT 'x' FROM XDP_OE_ORDER_HEADERS
157: WHERE ORDER_NUMBER =
158: UPPER(P_Order_Number));
163: END;
164: /* ELSE
165: BEGIN
166: SELECT 'Y' INTO lv_exists_flag
167: FROM DUAL
168: WHERE EXISTS
169: ( SELECT 'x' FROM XDP_OE_ORDER_HEADERS
170: WHERE ORDER_NUMBER =
171: UPPER( P_Order_Number) AND