R12.1.3 : Invalids Database Objects after apply patch 9661290
Hi,
Invalids Database Objects after apply patch 9661290
package AP_INVOICE_DISTRIBUTIONS_PKG
====================AP_INVOICE_DISTRIBUTIONS_PKG ====================
SQL> select text from user_source where name='AP_INVOICE_DISTRIBUTIONS_PKG' and line=2;
TEXT
--------------------------------------------------------------------------------
/* $Header: apiindis.pls 120.15.12010000.3 2010/06/04 08:37:33 ppodhiya ship $ *
/
/* $Header: apiindib.pls 120.68.12010000.40 2010/11/02 18:17:58 mayyalas ship $
*/
SQL> alter package AP_INVOICE_DISTRIBUTIONS_PKG compile;
Warning: Package altered with compilation errors.
SQL> select line,text from user_errors where name='AP_INVOICE_DISTRIBUTIONS_PKG';
LINE
----------
TEXT
--------------------------------------------------------------------------------
1015
PLS-00302: component 'REFERENCE_1' must be declared
1015
PLS-00382: expression is of wrong type
1016
PLS-00302: component 'REFERENCE_2' must be declared
LINE
----------
TEXT
--------------------------------------------------------------------------------
1016
PLS-00382: expression is of wrong type