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
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