DBA Data[Home] [Help]

APPS.MSD_DEM_SR_UTIL dependencies on MSD_SR_UTIL

Line 494: return msd_sr_util.get_null_desc;

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, ' ||

Line 519: return msd_sr_util.get_null_desc;

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;

Line 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