874: THEN
875: RETURN 2;
876: END IF;
877: 878: x_sql := 'BEGIN :x_ou1 := MSD_DEM_SR_UTIL.GET_MASTER_ORGANIZATION' || x_dblink || '; END;'; 879: EXECUTE IMMEDIATE x_sql USING OUT x_return_value;
880:
881: SELECT nvl(msi.ato_forecast_control, 3)
882: INTO x_is_fcstable
Line 1049: x_dummy_site VARCHAR2(100) := msd_dem_sr_util.get_null_code;
1045: p_customer_site_id IN NUMBER)
1046: RETURN VARCHAR2
1047: IS
1048: x_site VARCHAR2(255); 1049: x_dummy_site VARCHAR2(100) := msd_dem_sr_util.get_null_code; 1050: BEGIN
1051:
1052: IF (p_customer_site_id IS NOT NULL)
1053: THEN