10086: -- Cursor to check validity of a package.
10087: --
10088: cursor csr_package_exists(p_package_name in varchar2) is
10089: select null 10090: from user_objects uo 10091: where uo.object_name = p_package_name
10092: and uo.object_type = 'PACKAGE BODY'
10093: and uo.status ='VALID'
10094: ;