524: SELECT
525: ORDER_NUMBER
526: INTO L_SOURCE_NUMBER
527: FROM
528: OE_ORDER_HEADERS_ALL
529: WHERE HEADER_ID = C_ORDER_HEADER_ID
530: AND ROWNUM < 2;
531: EXCEPTION
532: WHEN NO_DATA_FOUND THEN
567: SELECT
568: ORDER_NUMBER
569: INTO L_SOURCE_NUMBER
570: FROM
571: OE_ORDER_HEADERS_ALL
572: WHERE HEADER_ID = C_ORDER_HEADER_ID
573: AND ROWNUM < 2;
574: EXCEPTION
575: WHEN NO_DATA_FOUND THEN