APPS.ENG_NEW_ITEM_REQ_UTIL dependencies on ENG_AUTO_NUMBER_ECN

Line 210: from eng_auto_number_ecn

206: THEN
207:
208: select alpha_prefix||next_available_number
209: INTO l_change_number
210: from eng_auto_number_ecn
211: where change_type_id = l_type_id;
212: -- Bug 5283630 Not necessary to update here. It is anyway done in Eng_Eco_Pub.Autogen_Change_Number() called from Process_Eco()
213: -- update eng_auto_number_ecn
214: -- set next_available_number = next_available_number+1

Line 213: -- update eng_auto_number_ecn

209: INTO l_change_number
210: from eng_auto_number_ecn
211: where change_type_id = l_type_id;
212: -- Bug 5283630 Not necessary to update here. It is anyway done in Eng_Eco_Pub.Autogen_Change_Number() called from Process_Eco()
213: -- update eng_auto_number_ecn
214: -- set next_available_number = next_available_number+1
215: -- where change_type_id = l_type_id;
216: END IF;
217: END LOOP;