192: THEN
193:
194: select alpha_prefix||next_available_number
195: INTO l_change_number
196: from eng_auto_number_ecn
197: where change_type_id = l_type_id;
198: -- Bug 5283630 Not necessary to update here. It is anyway done in Eng_Eco_Pub.Autogen_Change_Number() called from Process_Eco()
199: -- update eng_auto_number_ecn
200: -- set next_available_number = next_available_number+1
195: INTO l_change_number
196: from eng_auto_number_ecn
197: where change_type_id = l_type_id;
198: -- Bug 5283630 Not necessary to update here. It is anyway done in Eng_Eco_Pub.Autogen_Change_Number() called from Process_Eco()
199: -- update eng_auto_number_ecn
200: -- set next_available_number = next_available_number+1
201: -- where change_type_id = l_type_id;
202: END IF;
203: END LOOP;