SET SERVEROUTPUT ON
SET LINESIZE 500
BEGIN

  DBMS_OUTPUT.PUT_LINE('Beign to update OWBSYS repository due to bug 11740184');
  DELETE FROM CMPClassDefinition_r WHERE name = 'oracle.wh.repos.impl.application.KMMapModule' 
                                   AND superclass IS NULL AND overridee IS NOT NULL;
  UPDATE CMPClassDefinition_r SET superclass = (SELECT elementid FROM CMPClassDefinition_r WHERE name = 'oracle.wh.repos.impl.application.CMPDatabaseModule')
        WHERE name = 'oracle.wh.repos.impl.application.KMMapModule' AND overridee IS NULL;
  DBMS_OUTPUT.PUT_LINE('To update OWBSYS repository for bug 11740184 is done!');
END;
/