drop package us_selection;

drop table us_bind_vars;

drop table us_selections;

delete from acs_objects where object_type = 'us_selection';

begin
   acs_object_type.drop_type('us_selection');
end;
/
show errors