Rem    NAME 
Rem      ckupgdrp.sql
Rem    DESCRIPTION
Rem      Drop Upg_<tables> used for Specific PreUpgrades
Rem    RETURNS
Rem 	 None
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem    CREATED
Rem	  23/04/1999


BEGIN

  update ck_migration_objects set ci_created = 'N' where ci_stage = 'CKWKCOMP';

  FOR this_wa in (select irid, name
                  from   i$sdd_workareas
                  where  name = '%s')
  LOOP

     dbms_output.put_line('Compiling Migration WorkArea '||this_wa.name);

     jr_workarea.compile (this_wa.irid);

  END LOOP;

  update ck_migration_objects set ci_created = 'Y' where ci_stage = 'CKWKCOMP';
 
  COMMIT;

EXCEPTION 
  when others then 
     dbms_output.put_line (' ** Exception Raised ** ');
     raise;
END;
/


  
