490:
491: begin
492:
493: if ((p_location_id is null) or (p_zone_attr is null)) then
494: return msd_sr_util.get_null_desc;
495: else
496:
497: l_sql_stmt := ' select wrv.zone ' ||
498: ' from wsh_region_locations wrl, ' ||
515:
516: if (x_region_id is not null) then
517: return x_region_id;
518: else
519: return msd_sr_util.get_null_desc;
520: end if;
521: end if;
522: EXCEPTION
523: when others then return msd_sr_util.get_null_desc;
519: return msd_sr_util.get_null_desc;
520: end if;
521: end if;
522: EXCEPTION
523: when others then return msd_sr_util.get_null_desc;
524: end get_sr_zone_desc;
525:
526: FUNCTION get_sr_zone_pk ( p_location_id IN NUMBER,
527: p_zone_attr IN VARCHAR2) return number IS --jarora