Invalid package CSI_WIP_TRXS_PKG after applying patch 13821497
Hi,
Invalid after applying patch 13821497
SQL> select text from user_source where name='CSI_WIP_TRXS_PKG' and line=2;
TEXT
--------------------------------------------------------------------------------
/* $Header: csipiwps.pls 115.18.11510.8 2009/06/10 19:38:05 devijay ship $ */
/* $Header: csipiwpb.pls 115.42.11510.28 2012/03/29 06:11:34 jrkumar ship $ */
SQL> SQL> SQL> alter package CSI_WIP_TRXS_PKG compile;
Warning: Package altered with compilation errors.
SQL> SQL> select line,text from user_errors where name='CSI_WIP_TRXS_PKG';
LINE
----------
TEXT
--------------------------------------------------------------------------------
197
PLS-00302: component 'GET_LOT_CTRL_CODE' must be declared
197
PLS-00302: component 'GET_LOT_CTRL_CODE' must be declared
197
PL/SQL: ORA-00904: "CSI_UTL_PKG"."GET_LOT_CTRL_CODE": invalid identifier
LINE
----------
TEXT
--------------------------------------------------------------------------------
195
PL/SQL: SQL Statement ignored