256: END;
257: END IF;
258: IF P_ORGANIZATION_ID IS NOT NULL THEN
259: DECLARE
260: WAREHOUSE_NAME HR_ORGANIZATION_UNITS.NAME%TYPE;
261: BEGIN
262: SELECT
263: NAME
264: INTO WAREHOUSE_NAME
262: SELECT
263: NAME
264: INTO WAREHOUSE_NAME
265: FROM
266: HR_ORGANIZATION_UNITS
267: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID;
268: RP_WAREHOUSE := WAREHOUSE_NAME;
269: EXCEPTION
270: WHEN NO_DATA_FOUND THEN