Killing session of a Package Lock

SELECT * FROM DBA_DDL_LOCKS WHERE name ='XX_AUTOMATE_DELIVER_PKG'

select * from v$access where object='XX_AUTOMATE_DELIVER_PKG'

SID OWNER
---------- ----------------------------------------------------------------
OBJECT
--------------------------------------------------------------------------------
TYPE
------------------------
128 APPS
XX_AUTOMATE_DELIVER_PKG
PACKAGE

select sid,serial# from v$session where sid=128

SID SERIAL#
---------- ----------
128 31404

alter system kill session '128,31404'

System altered.

select * from v$access where object='XX_AUTOMATE_DELIVER_PKG';

no rows selected