ora-04043 object does not exist

create or replace procedure AIM_SP_Login_Check(p_recordset1 OUT SYS_REFCURSOR)
             AS
BEGIN
  OPEN p_recordset1 FOR
  Select T005_CODE, T010_CODE, T010_NAME From AIM_M_DIVISION  Order by T005_CODE, T010_CODE;
END;

SQL> create procedure p1
  2    is
  3    begin
  4        null;
  5  end;
  6  /

Procedure created.

SQL> grant execute on scott.p1 to u1
  2  /

Grant succeeded.

SQL> connect u1@orcl
Enter password: **
Connected.
SQL> select  count(*)
  2    from  all_objects
  3    where owner = 'SCOTT'
  4      and object_name = 'P1'
  5      and object_type = 'PROCEDURE'
  6  /

  COUNT(*)
----------
         1

SQL> exec scott.p1;

PL/SQL procedure successfully completed.

SQL> drop procedure scott.p1
  2  /
drop procedure scott.p1
*
ERROR at line 1:
ORA-01031: insufficient privileges


SQL> 

04043, 00000, "object %s does not exist"
// *Cause:  An object name was specified that was not recognized by the system.
//          There are several possible causes:
//          - An invalid name for a table, view, sequence, procedure, function,
//          package, or package body was entered. Since the system could not
//          recognize the invalid name, it responded with the message that the
//          named object does not exist.
//          - An attempt was made to rename an index or a cluster, or some
//          other object that cannot be renamed.
// *Action: Check the spelling of the named object and rerun the code. (Valid
//          names of tables, views, functions, etc. can be listed by querying
//          the data dictionary.)

SELECT  owner
        object_name,
        object_type
  FROM  all_objects
  WHERE upper(object_name) = upper('AIM_SP_Login_Check')
/

drop procedure "AIM_SP_Login_Check";

SQL> create table test (a number);

Table created.

SQL> create table "test" (a number);

Table created.

SQL> create table "Test" (a number);

Table created.

SQL> select table_name from user_tables where upper(table_name) = 'TEST';

TABLE_NAME
--------------------------------------------------------------------------------
TEST
Test
test

SQL> --the one in upper case is the original, oracle automatically stores object names in upper case
SQL> --unless you wrap the object name in double quotes
SQL>
SQL> drop table test;

Table dropped.

SQL>  select table_name from user_tables where upper(table_name) = 'TEST';

TABLE_NAME
--------------------------------------------------------------------------------
Test
test

SQL> drop table Test;
drop table Test
           *
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> --doesn't work because oracle uppers the table name which then doesn't match the existing tables.
SQL> --need to wrap in in double quotes
SQL> drop table "Test";

Table dropped.

SQL>  select table_name from user_tables where upper(table_name) = 'TEST';

TABLE_NAME
--------------------------------------------------------------------------------
test

SQL> drop table "test";

Table dropped.

SQL>

select * from user_procedures where procedure_name = :proc_name