Rem  Copyright (c) 1994 by Oracle Corporation 
Rem    NAME
Rem      ciass.mps - <one-line expansion of the name>
Rem    DESCRIPTION
Rem      <short description of component this file declares/defines>
Rem    RETURNS
Rem 
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem    MODIFIED   (MM/DD/YY)
Rem     cvanes     11/02/99 -  Creation 
CREATE OR REPLACE PACKAGE cimaen IS

-- Gets all AENS in this Association except for this one
CURSOR get_all_other_aens(aen_ref number) is
  select other_aen.id
        ,other_aen.association_role_in
        ,nvl(nvl(other_aen.entity_object_reference, 
                 other_aen.generic_class_reference), 
                 other_aen.interface_classifier_reference) role_in_classifier_reference
        ,other_aen.association_reference
    from ci_association_ends other_aen
        ,ci_association_ends my_aen
   where other_aen.association_reference = my_aen.association_reference
     and other_aen.id != my_aen.id
     and my_aen.id = get_all_other_aens.aen_ref;
     
PROCEDURE check_cihaene_class_aggregate(conid rm.reference);
PROCEDURE check_cihaene_uniqueness(conid rm.reference);
PROCEDURE check_cihaene_uniqueness_2(conid rm.reference);
PROCEDURE check_cihaene_uniqueness_3(conid rm.reference);
PROCEDURE check_cihaene_name_uniqueness(conid rm.reference);
FUNCTION is_aen_att_met_name_unique(elem_ref number, class_ref number, elem_name varchar2, 
                                    elem_type varchar2, clash_id out number, clash_type out varchar2)
RETURN boolean;
END;
/