10163: -- Cursor to check validity of a package.
10164: --
10165: cursor csr_package_exists(p_package_name in varchar2) is
10166: select null 10167: from user_objects uo 10168: where uo.object_name = p_package_name
10169: and uo.object_type = 'PACKAGE BODY'
10170: and uo.status ='VALID'
10171: ;