APPS.ENG_ECO_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 891

   	select alpha_prefix||next_available_number
		INTO l_change_number
		from eng_auto_number_ecn
		where change_type_id = p_type_id FOR UPDATE OF next_available_number;

Line: 896

		update eng_auto_number_ecn
		set next_available_number = next_available_number+1
		where change_type_id = p_type_id;

Line: 930

  SELECT ecotv_in.type_name
  FROM eng_change_order_types_vl ecotv_in
  WHERE ecotv_in.change_mgmt_type_code = 'CHANGE_ORDER'
  AND ecotv_in.type_classification='CATEGORY';

Line: 940

  SELECT ecotv1.change_order_type_id change_mgmt_type_id,
	ecotv2.change_order_type_id,
	ecotv2.auto_numbering_method,
	ecotv1.auto_numbering_method change_mgmt_method
  FROM eng_change_order_types_vl  ecotv1, eng_change_order_types_vl ecotv2
  WHERE ecotv1.type_name  = cp_change_type_name
  AND ecotv1.TYPE_CLASSIFICATION= 'CATEGORY'
  AND ecotv1.change_mgmt_type_code = ecotv2.change_mgmt_type_code
  AND ecotv2.type_name = p_CHANGE_ORDER_TYPE
  AND ecotv2.TYPE_CLASSIFICATION = 'HEADER';

Line: 986

			select alpha_prefix||next_available_number
			INTO l_change_number
			from eng_auto_number_ecn
			where change_type_id = l_type_id;

Line: 991

			update eng_auto_number_ecn
			set next_available_number = next_available_number+1
			where change_type_id = l_type_id;