116: l_error NUMBER;
117: l_dummy NUMBER;
118: CURSOR c_package_status IS
119: SELECT 1 120: FROM dual 121: WHERE exists(
122: SELECT status
123: FROM all_objects
124: WHERE object_name = p_package_name
Line 131: FROM dual
127: AND owner = g_owner);
128:
129: CURSOR c_package_body_status IS
130: SELECT 1 131: FROM dual 132: WHERE exists(
133: SELECT status
134: FROM all_objects
135: WHERE object_name = p_package_name