132: SELECT
133: ORDER_NUMBER
134: INTO L_ORDER_NUM_LOW
135: FROM
136: OE_ORDER_HEADERS_ALL
137: WHERE HEADER_ID = P_HEADER_ID_LOW;
138: END IF;
139: IF P_HEADER_ID_HIGH IS NOT NULL THEN
140: SELECT
140: SELECT
141: ORDER_NUMBER
142: INTO L_ORDER_NUM_HIGH
143: FROM
144: OE_ORDER_HEADERS_ALL
145: WHERE HEADER_ID = P_HEADER_ID_HIGH;
146: END IF;
147: RP_ORDER_RANGE := 'From ' || NVL(L_ORDER_NUM_LOW
148: ,' ') || ' To ' || NVL(L_ORDER_NUM_HIGH