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: where change_type_id = p_type_id;
899:
900: COMMIT;

Line 988: from eng_auto_number_ecn

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

Line 991: update eng_auto_number_ecn

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