APPS.ENG_ECO_PUB dependencies on ENG_AUTO_NUMBER_ECN

Line 893: from eng_auto_number_ecn

889: l_change_number eng_engineering_changes.CHANGE_NOTICE%TYPE := NULL;
890: BEGIN
891: select alpha_prefix||next_available_number
892: INTO l_change_number
893: from eng_auto_number_ecn
894: where change_type_id = p_type_id FOR UPDATE OF next_available_number;
895:
896: update eng_auto_number_ecn
897: set next_available_number = next_available_number+1

Line 896: update eng_auto_number_ecn

892: INTO l_change_number
893: from eng_auto_number_ecn
894: where change_type_id = p_type_id FOR UPDATE OF next_available_number;
895:
896: update eng_auto_number_ecn
897: set next_available_number = next_available_number+1
898: -- 14148324, add the two column value
899: , last_updated_by = FND_GLOBAL.user_id
900: , last_update_date = sysdate

Line 991: from eng_auto_number_ecn

987: /*
988: commented for bug 5862743, moved logic to GET_NEXT_CHANGE_NUMBER
989: select alpha_prefix||next_available_number
990: INTO l_change_number
991: from eng_auto_number_ecn
992: where change_type_id = l_type_id;
993:
994: update eng_auto_number_ecn
995: set next_available_number = next_available_number+1

Line 994: update eng_auto_number_ecn

990: INTO l_change_number
991: from eng_auto_number_ecn
992: where change_type_id = l_type_id;
993:
994: update eng_auto_number_ecn
995: set next_available_number = next_available_number+1
996: where change_type_id = l_type_id;
997: */
998: END IF;