R12.1.3 : Invallid packages EAM_WOREP_PUB EAM_WORKORDERREP_PVT after patch 15856051:R12.EAM.B :
Hi,
Invallid packages EAM_WOREP_PUB EAM_WORKORDERREP_PVT after patch 15856051:R12.EAM.B :
Errors and versions are :
SQL> select text from user_source where name='EAM_WOREP_PUB' and line=2
2 ;
TEXT
--------------------------------------------------------------------------------
/* $Header: EAMPWORS.pls 120.0.12010000.2 2010/06/17 09:57:31 somitra ship $ */
/* $Header: EAMPWORB.pls 120.4.12010000.3 2009/01/20 05:24:27 smrsharm ship $ */
SQL> alter package EAM_WOREP_PUB compile;
Warning: Package altered with compilation errors.
SQL> select line,text from user_errors where name='EAM_WOREP_PUB';
LINE
----------
TEXT
--------------------------------------------------------------------------------
24
PLS-00323: subprogram or cursor 'WORK_ORDER_CP' is declared in a package specifi
cation and must be defined in the package body
SQL>
SQL>
select a.line,a.text