DBA Data[Home] [Help]

APPS.MSD_DEM_SR_UTIL dependencies on MSD_SR_UTIL

Line 470: return msd_sr_util.get_null_desc;

466:
467: begin
468:
469: if ((p_location_id is null) or (p_zone_attr is null)) then
470: return msd_sr_util.get_null_desc;
471: else
472:
473: l_sql_stmt := ' select wrv.zone ' ||
474: ' from wsh_region_locations wrl, ' ||

Line 495: return msd_sr_util.get_null_desc;

491:
492: if (x_region_id is not null) then
493: return x_region_id;
494: else
495: return msd_sr_util.get_null_desc;
496: end if;
497: end if;
498: EXCEPTION
499: when others then return msd_sr_util.get_null_desc;

Line 499: when others then return msd_sr_util.get_null_desc;

495: return msd_sr_util.get_null_desc;
496: end if;
497: end if;
498: EXCEPTION
499: when others then return msd_sr_util.get_null_desc;
500: end get_sr_zone_desc;
501:
502: FUNCTION get_sr_zone_pk ( p_location_id IN NUMBER,
503: p_zone_attr IN VARCHAR2) return number IS --jarora