DELIMITER $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `params178`(
in p_param1 varchar(45),
in p_param2 varchar(45),
in p_param3 varchar(45),
in p_param4 varchar(45),
in p_param5 varchar(45),
in p_param6 varchar(45),
in p_param7 varchar(45),
in p_param8 varchar(45),
in p_param9 varchar(45),
in p_param10 varchar(45),
in p_param11 varchar(45),
in p_param12 varchar(45),
in p_param13 varchar(45),
in p_param14 varchar(45),
in p_param15 varchar(45),
in p_param16 varchar(45),
in p_param17 varchar(45),
in p_param18 varchar(45),
in p_param19 varchar(45),
in p_param20 varchar(45),
in p_param21 varchar(45),
in p_param22 varchar(45),
in p_param23 varchar(45),
in p_param24 varchar(45),
in p_param25 varchar(45),
in p_param26 varchar(45),
in p_param27 varchar(45),
in p_param28 varchar(45),
in p_param29 varchar(45),
in p_param30 varchar(45),
in p_param31 varchar(45),
in p_param32 varchar(45),
in p_param33 varchar(45),
in p_param34 varchar(45),
in p_param35 varchar(45),
in p_param36 varchar(45),
in p_param37 varchar(45),
in p_param38 varchar(45),
in p_param39 varchar(45),
in p_param40 varchar(45),
in p_param41 varchar(45),
in p_param42 varchar(45),
in p_param43 varchar(45),
in p_param44 varchar(45),
in p_param45 varchar(45),
in p_param46 varchar(45),
in p_param47 varchar(45),
in p_param48 varchar(45),
in p_param49 varchar(45),
in p_param50 varchar(45),
in p_param51 varchar(45),
in p_param52 varchar(45),
in p_param53 varchar(45),
in p_param54 varchar(45),
in p_param55 varchar(45),
in p_param56 varchar(45),
in p_param57 varchar(45),
in p_param58 varchar(45),
in p_param59 varchar(45),
in p_param60 varchar(45),
in p_param61 varchar(45),
in p_param62 varchar(45),
in p_param63 varchar(45),
in p_param64 varchar(45),
in p_param65 varchar(45),
in p_param66 varchar(45),
in p_param67 varchar(45),
in p_param68 varchar(45),
in p_param69 varchar(45),
in p_param70 varchar(45),
in p_param71 varchar(45),
in p_param72 varchar(45),
in p_param73 varchar(45),
in p_param74 varchar(45),
in p_param75 varchar(45),
in p_param76 varchar(45),
in p_param77 varchar(45),
in p_param78 varchar(45),
in p_param79 varchar(45),
in p_param80 varchar(45),
in p_param81 varchar(45),
in p_param82 varchar(45),
in p_param83 varchar(45),
in p_param84 varchar(45),
in p_param85 varchar(45),
in p_param86 varchar(45),
in p_param87 varchar(45),
in p_param88 varchar(45),
in p_param89 varchar(45),
in p_param90 varchar(45),
in p_param91 varchar(45),
in p_param92 varchar(45),
in p_param93 varchar(45),
in p_param94 varchar(45),
in p_param95 varchar(45),
in p_param96 varchar(45),
in p_param97 varchar(45),
in p_param98 varchar(45),
in p_param99 varchar(45),
in p_param100 varchar(45),
in p_param101 varchar(45),
in p_param102 varchar(45),
in p_param103 varchar(45),
in p_param104 varchar(45),
in p_param105 varchar(45),
in p_param106 varchar(45),
in p_param107 varchar(45),
in p_param108 varchar(45),
in p_param109 varchar(45),
in p_param110 varchar(45),
in p_param111 varchar(45),
in p_param112 varchar(45),
in p_param113 varchar(45),
in p_param114 varchar(45),
in p_param115 varchar(45),
in p_param116 varchar(45),
in p_param117 varchar(45),
in p_param118 varchar(45),
in p_param119 varchar(45),
in p_param120 varchar(45),
in p_param121 varchar(45),
in p_param122 varchar(45),
in p_param123 varchar(45),
in p_param124 varchar(45),
in p_param125 varchar(45),
in p_param126 varchar(45),
in p_param127 varchar(45),
in p_param128 varchar(45),
in p_param129 varchar(45),
in p_param130 varchar(45),
in p_param131 varchar(45),
in p_param132 varchar(45),
in p_param133 varchar(45),
in p_param134 varchar(45),
in p_param135 varchar(45),
in p_param136 varchar(45),
in p_param137 varchar(45),
in p_param138 varchar(45),
in p_param139 varchar(45),
in p_param140 varchar(45),
in p_param141 varchar(45),
in p_param142 varchar(45),
in p_param143 varchar(45),
in p_param144 varchar(45),
in p_param145 varchar(45),
in p_param146 varchar(45),
in p_param147 varchar(45),
in p_param148 varchar(45),
in p_param149 varchar(45),
in p_param150 varchar(45),
in p_param151 varchar(45),
in p_param152 varchar(45),
in p_param153 varchar(45),
in p_param154 varchar(45),
in p_param155 varchar(45),
in p_param156 varchar(45),
in p_param157 varchar(45),
in p_param158 varchar(45),
in p_param159 varchar(45),
in p_param160 varchar(45),
in p_param161 varchar(45),
in p_param162 varchar(45),
in p_param163 varchar(45),
in p_param164 varchar(45),
in p_param165 varchar(45),
in p_param166 varchar(45),
in p_param167 varchar(45),
in p_param168 varchar(45),
in p_param169 varchar(45),
in p_param170 varchar(45),
in p_param171 varchar(45),
in p_param172 varchar(45),
in p_param173 varchar(45),
in p_param174 varchar(45),
in p_param175 varchar(45),
in p_param176 varchar(45),
in p_param177 varchar(45),
in p_param178 varchar(45)
)
BEGIN
   UPDATE `asi_locations` SET gutter_code = p_param1 WHERE location_id = 1;
   UPDATE `asi_locations` SET gutter_code = p_param2 WHERE location_id = 2;
   UPDATE `asi_locations` SET gutter_code = p_param3 WHERE location_id = 3;
   UPDATE `asi_locations` SET gutter_code = p_param4 WHERE location_id = 4;
   UPDATE `asi_locations` SET gutter_code = p_param5 WHERE location_id = 5;
   UPDATE `asi_locations` SET gutter_code = p_param6 WHERE location_id = 6;
   UPDATE `asi_locations` SET gutter_code = p_param7 WHERE location_id = 7;
   UPDATE `asi_locations` SET gutter_code = p_param8 WHERE location_id = 8;
   UPDATE `asi_locations` SET gutter_code = p_param9 WHERE location_id = 9;
   UPDATE `asi_locations` SET gutter_code = p_param10 WHERE location_id = 10;
   UPDATE `asi_locations` SET gutter_code = p_param11 WHERE location_id = 11;
   UPDATE `asi_locations` SET gutter_code = p_param12 WHERE location_id = 12;
   UPDATE `asi_locations` SET gutter_code = p_param13 WHERE location_id = 13;
   UPDATE `asi_locations` SET gutter_code = p_param14 WHERE location_id = 14;
   UPDATE `asi_locations` SET gutter_code = p_param15 WHERE location_id = 15;
   UPDATE `asi_locations` SET gutter_code = p_param16 WHERE location_id = 16;
   UPDATE `asi_locations` SET gutter_code = p_param17 WHERE location_id = 17;
   UPDATE `asi_locations` SET gutter_code = p_param18 WHERE location_id = 18;
   UPDATE `asi_locations` SET gutter_code = p_param19 WHERE location_id = 19;
   UPDATE `asi_locations` SET gutter_code = p_param20 WHERE location_id = 20;
   UPDATE `asi_locations` SET gutter_code = p_param21 WHERE location_id = 21;
   UPDATE `asi_locations` SET gutter_code = p_param22 WHERE location_id = 22;
   UPDATE `asi_locations` SET gutter_code = p_param23 WHERE location_id = 23;
   UPDATE `asi_locations` SET gutter_code = p_param24 WHERE location_id = 24;
   UPDATE `asi_locations` SET gutter_code = p_param25 WHERE location_id = 25;
   UPDATE `asi_locations` SET gutter_code = p_param26 WHERE location_id = 26;
   UPDATE `asi_locations` SET gutter_code = p_param27 WHERE location_id = 27;
   UPDATE `asi_locations` SET gutter_code = p_param28 WHERE location_id = 28;
   UPDATE `asi_locations` SET gutter_code = p_param29 WHERE location_id = 29;
   UPDATE `asi_locations` SET gutter_code = p_param30 WHERE location_id = 30;
   UPDATE `asi_locations` SET gutter_code = p_param31 WHERE location_id = 31;
   UPDATE `asi_locations` SET gutter_code = p_param32 WHERE location_id = 32;
   UPDATE `asi_locations` SET gutter_code = p_param33 WHERE location_id = 33;
   UPDATE `asi_locations` SET gutter_code = p_param34 WHERE location_id = 34;
   UPDATE `asi_locations` SET gutter_code = p_param35 WHERE location_id = 35;
   UPDATE `asi_locations` SET gutter_code = p_param36 WHERE location_id = 36;
   UPDATE `asi_locations` SET gutter_code = p_param37 WHERE location_id = 37;
   UPDATE `asi_locations` SET gutter_code = p_param38 WHERE location_id = 38;
   UPDATE `asi_locations` SET gutter_code = p_param39 WHERE location_id = 39;
   UPDATE `asi_locations` SET gutter_code = p_param40 WHERE location_id = 40;
   UPDATE `asi_locations` SET gutter_code = p_param41 WHERE location_id = 41;
   UPDATE `asi_locations` SET gutter_code = p_param42 WHERE location_id = 42;
   UPDATE `asi_locations` SET gutter_code = p_param43 WHERE location_id = 43;
   UPDATE `asi_locations` SET gutter_code = p_param44 WHERE location_id = 44;
   UPDATE `asi_locations` SET gutter_code = p_param45 WHERE location_id = 45;
   UPDATE `asi_locations` SET gutter_code = p_param46 WHERE location_id = 46;
   UPDATE `asi_locations` SET gutter_code = p_param47 WHERE location_id = 47;
   UPDATE `asi_locations` SET gutter_code = p_param48 WHERE location_id = 48;
   UPDATE `asi_locations` SET gutter_code = p_param49 WHERE location_id = 49;
   UPDATE `asi_locations` SET gutter_code = p_param50 WHERE location_id = 50;
   UPDATE `asi_locations` SET gutter_code = p_param51 WHERE location_id = 51;
   UPDATE `asi_locations` SET gutter_code = p_param52 WHERE location_id = 52;
   UPDATE `asi_locations` SET gutter_code = p_param53 WHERE location_id = 53;
   UPDATE `asi_locations` SET gutter_code = p_param54 WHERE location_id = 54;
   UPDATE `asi_locations` SET gutter_code = p_param55 WHERE location_id = 55;
   UPDATE `asi_locations` SET gutter_code = p_param56 WHERE location_id = 56;
   UPDATE `asi_locations` SET gutter_code = p_param57 WHERE location_id = 57;
   UPDATE `asi_locations` SET gutter_code = p_param58 WHERE location_id = 58;
   UPDATE `asi_locations` SET gutter_code = p_param59 WHERE location_id = 59;
   UPDATE `asi_locations` SET gutter_code = p_param60 WHERE location_id = 60;
   UPDATE `asi_locations` SET gutter_code = p_param61 WHERE location_id = 61;
   UPDATE `asi_locations` SET gutter_code = p_param62 WHERE location_id = 62;
   UPDATE `asi_locations` SET gutter_code = p_param63 WHERE location_id = 63;
   UPDATE `asi_locations` SET gutter_code = p_param64 WHERE location_id = 64;
   UPDATE `asi_locations` SET gutter_code = p_param65 WHERE location_id = 65;
   UPDATE `asi_locations` SET gutter_code = p_param66 WHERE location_id = 66;
   UPDATE `asi_locations` SET gutter_code = p_param67 WHERE location_id = 67;
   UPDATE `asi_locations` SET gutter_code = p_param68 WHERE location_id = 68;
   UPDATE `asi_locations` SET gutter_code = p_param69 WHERE location_id = 69;
   UPDATE `asi_locations` SET gutter_code = p_param70 WHERE location_id = 70;
   UPDATE `asi_locations` SET gutter_code = p_param71 WHERE location_id = 71;
   UPDATE `asi_locations` SET gutter_code = p_param72 WHERE location_id = 72;
   UPDATE `asi_locations` SET gutter_code = p_param73 WHERE location_id = 73;
   UPDATE `asi_locations` SET gutter_code = p_param74 WHERE location_id = 74;
   UPDATE `asi_locations` SET gutter_code = p_param75 WHERE location_id = 75;
   UPDATE `asi_locations` SET gutter_code = p_param76 WHERE location_id = 76;
   UPDATE `asi_locations` SET gutter_code = p_param77 WHERE location_id = 77;
   UPDATE `asi_locations` SET gutter_code = p_param78 WHERE location_id = 78;
   UPDATE `asi_locations` SET gutter_code = p_param79 WHERE location_id = 79;
   UPDATE `asi_locations` SET gutter_code = p_param80 WHERE location_id = 80;
   UPDATE `asi_locations` SET gutter_code = p_param81 WHERE location_id = 81;
   UPDATE `asi_locations` SET gutter_code = p_param82 WHERE location_id = 82;
   UPDATE `asi_locations` SET gutter_code = p_param83 WHERE location_id = 83;
   UPDATE `asi_locations` SET gutter_code = p_param84 WHERE location_id = 84;
   UPDATE `asi_locations` SET gutter_code = p_param85 WHERE location_id = 85;
   UPDATE `asi_locations` SET gutter_code = p_param86 WHERE location_id = 86;
   UPDATE `asi_locations` SET gutter_code = p_param87 WHERE location_id = 87;
   UPDATE `asi_locations` SET gutter_code = p_param88 WHERE location_id = 88;
   UPDATE `asi_locations` SET gutter_code = p_param89 WHERE location_id = 89;
   UPDATE `asi_locations` SET gutter_code = p_param90 WHERE location_id = 90;
   UPDATE `asi_locations` SET gutter_code = p_param91 WHERE location_id = 91;
   UPDATE `asi_locations` SET gutter_code = p_param92 WHERE location_id = 92;
   UPDATE `asi_locations` SET gutter_code = p_param93 WHERE location_id = 93;
   UPDATE `asi_locations` SET gutter_code = p_param94 WHERE location_id = 94;
   UPDATE `asi_locations` SET gutter_code = p_param95 WHERE location_id = 95;
   UPDATE `asi_locations` SET gutter_code = p_param96 WHERE location_id = 96;
   UPDATE `asi_locations` SET gutter_code = p_param97 WHERE location_id = 97;
   UPDATE `asi_locations` SET gutter_code = p_param98 WHERE location_id = 98;
   UPDATE `asi_locations` SET gutter_code = p_param99 WHERE location_id = 99;
   UPDATE `asi_locations` SET gutter_code = p_param100 WHERE location_id = 100;
   UPDATE `asi_locations` SET gutter_code = p_param101 WHERE location_id = 101;
   UPDATE `asi_locations` SET gutter_code = p_param102 WHERE location_id = 102;
   UPDATE `asi_locations` SET gutter_code = p_param103 WHERE location_id = 103;
   UPDATE `asi_locations` SET gutter_code = p_param104 WHERE location_id = 104;
   UPDATE `asi_locations` SET gutter_code = p_param105 WHERE location_id = 105;
   UPDATE `asi_locations` SET gutter_code = p_param106 WHERE location_id = 106;
   UPDATE `asi_locations` SET gutter_code = p_param107 WHERE location_id = 107;
   UPDATE `asi_locations` SET gutter_code = p_param108 WHERE location_id = 108;
   UPDATE `asi_locations` SET gutter_code = p_param109 WHERE location_id = 109;
   UPDATE `asi_locations` SET gutter_code = p_param110 WHERE location_id = 110;
   UPDATE `asi_locations` SET gutter_code = p_param111 WHERE location_id = 111;
   UPDATE `asi_locations` SET gutter_code = p_param112 WHERE location_id = 112;
   UPDATE `asi_locations` SET gutter_code = p_param113 WHERE location_id = 113;
   UPDATE `asi_locations` SET gutter_code = p_param114 WHERE location_id = 114;
   UPDATE `asi_locations` SET gutter_code = p_param115 WHERE location_id = 115;
   UPDATE `asi_locations` SET gutter_code = p_param116 WHERE location_id = 116;
   UPDATE `asi_locations` SET gutter_code = p_param117 WHERE location_id = 117;
   UPDATE `asi_locations` SET gutter_code = p_param118 WHERE location_id = 118;
   UPDATE `asi_locations` SET gutter_code = p_param119 WHERE location_id = 119;
   UPDATE `asi_locations` SET gutter_code = p_param120 WHERE location_id = 120;
   UPDATE `asi_locations` SET gutter_code = p_param121 WHERE location_id = 121;
   UPDATE `asi_locations` SET gutter_code = p_param122 WHERE location_id = 122;
   UPDATE `asi_locations` SET gutter_code = p_param123 WHERE location_id = 123;
   UPDATE `asi_locations` SET gutter_code = p_param124 WHERE location_id = 124;
   UPDATE `asi_locations` SET gutter_code = p_param125 WHERE location_id = 125;
   UPDATE `asi_locations` SET gutter_code = p_param126 WHERE location_id = 126;
   UPDATE `asi_locations` SET gutter_code = p_param127 WHERE location_id = 127;
   UPDATE `asi_locations` SET gutter_code = p_param128 WHERE location_id = 128;
   UPDATE `asi_locations` SET gutter_code = p_param129 WHERE location_id = 129;
   UPDATE `asi_locations` SET gutter_code = p_param130 WHERE location_id = 130;
   UPDATE `asi_locations` SET gutter_code = p_param131 WHERE location_id = 131;
   UPDATE `asi_locations` SET gutter_code = p_param132 WHERE location_id = 132;
   UPDATE `asi_locations` SET gutter_code = p_param133 WHERE location_id = 133;
   UPDATE `asi_locations` SET gutter_code = p_param134 WHERE location_id = 134;
   UPDATE `asi_locations` SET gutter_code = p_param135 WHERE location_id = 135;
   UPDATE `asi_locations` SET gutter_code = p_param136 WHERE location_id = 136;
   UPDATE `asi_locations` SET gutter_code = p_param137 WHERE location_id = 137;
   UPDATE `asi_locations` SET gutter_code = p_param138 WHERE location_id = 138;
   UPDATE `asi_locations` SET gutter_code = p_param139 WHERE location_id = 139;
   UPDATE `asi_locations` SET gutter_code = p_param140 WHERE location_id = 140;
   UPDATE `asi_locations` SET gutter_code = p_param141 WHERE location_id = 141;
   UPDATE `asi_locations` SET gutter_code = p_param142 WHERE location_id = 142;
   UPDATE `asi_locations` SET gutter_code = p_param143 WHERE location_id = 143;
   UPDATE `asi_locations` SET gutter_code = p_param144 WHERE location_id = 144;
   UPDATE `asi_locations` SET gutter_code = p_param145 WHERE location_id = 145;
   UPDATE `asi_locations` SET gutter_code = p_param146 WHERE location_id = 146;
   UPDATE `asi_locations` SET gutter_code = p_param147 WHERE location_id = 147;
   UPDATE `asi_locations` SET gutter_code = p_param148 WHERE location_id = 148;
   UPDATE `asi_locations` SET gutter_code = p_param149 WHERE location_id = 149;
   UPDATE `asi_locations` SET gutter_code = p_param150 WHERE location_id = 150;
   UPDATE `asi_locations` SET gutter_code = p_param151 WHERE location_id = 151;
   UPDATE `asi_locations` SET gutter_code = p_param152 WHERE location_id = 152;
   UPDATE `asi_locations` SET gutter_code = p_param153 WHERE location_id = 153;
   UPDATE `asi_locations` SET gutter_code = p_param154 WHERE location_id = 154;
   UPDATE `asi_locations` SET gutter_code = p_param155 WHERE location_id = 155;
   UPDATE `asi_locations` SET gutter_code = p_param156 WHERE location_id = 156;
   UPDATE `asi_locations` SET gutter_code = p_param157 WHERE location_id = 157;
   UPDATE `asi_locations` SET gutter_code = p_param158 WHERE location_id = 158;
   UPDATE `asi_locations` SET gutter_code = p_param159 WHERE location_id = 159;
   UPDATE `asi_locations` SET gutter_code = p_param160 WHERE location_id = 160;
   UPDATE `asi_locations` SET gutter_code = p_param161 WHERE location_id = 161;
   UPDATE `asi_locations` SET gutter_code = p_param162 WHERE location_id = 162;
   UPDATE `asi_locations` SET gutter_code = p_param163 WHERE location_id = 163;
   UPDATE `asi_locations` SET gutter_code = p_param164 WHERE location_id = 164;
   UPDATE `asi_locations` SET gutter_code = p_param165 WHERE location_id = 165;
   UPDATE `asi_locations` SET gutter_code = p_param166 WHERE location_id = 166;
   UPDATE `asi_locations` SET gutter_code = p_param167 WHERE location_id = 167;
   UPDATE `asi_locations` SET gutter_code = p_param168 WHERE location_id = 168;
   UPDATE `asi_locations` SET gutter_code = p_param169 WHERE location_id = 169;
   UPDATE `asi_locations` SET gutter_code = p_param170 WHERE location_id = 170;
   UPDATE `asi_locations` SET gutter_code = p_param171 WHERE location_id = 171;
   UPDATE `asi_locations` SET gutter_code = p_param172 WHERE location_id = 172;
   UPDATE `asi_locations` SET gutter_code = p_param173 WHERE location_id = 173;
   UPDATE `asi_locations` SET gutter_code = p_param174 WHERE location_id = 174;
   UPDATE `asi_locations` SET gutter_code = p_param175 WHERE location_id = 175;
   UPDATE `asi_locations` SET gutter_code = p_param176 WHERE location_id = 176;
   UPDATE `asi_locations` SET gutter_code = p_param177 WHERE location_id = 177;
   UPDATE `asi_locations` SET gutter_code = p_param178 WHERE location_id = 178;

END$$
DELIMITER ;
