Hello friends,

I have a sample test package with one proc as below.

Package Spec
--------------
CREATE OR REPLACE PACKAGE APPS.samir_test
IS
PROCEDURE samir_test_p (p_employee_number IN VARCHAR2);
END samir_test;
/

Package Body
--------------
CREATE OR REPLACE PACKAGE BODY APPS.samir_test
IS
PROCEDURE samir_test_p (p_employee_number IN VARCHAR2)
IS
x_emp_num NUMBER;
BEGIN
SELECT employee_number into x_emp_num FROM per_all_people_f WHERE employee_number = p_employee_number;
END samir_test_p;
END samir_test;
/


Now, I call the proc samir_test_p as below.
DECLARE
p_employee_number number := 2000121;
BEGIN
apps.samir_test.samir_test_p ( p_employee_number);
END;

I get following error.

ORA-06550: line 7, column 3:
PLS-00905: object APPS.APPS is invalid
ORA-06550: line 7, column 3:
PL/SQL: Statement ignored

But, if I remove apps. qualifier and call it using samir_test.samir_test_p ( p_employee_number);

it works.

I would like to know why it does not like the qualifier here. We have a need to use qualifier in our code.

Please help.

Thanks in Advance.