R12.1.3 : Invalid package CSE_PROJ_TRANSFER_PKG
Hi,
Invalid package CSE_PROJ_TRANSFER_PKG after migration to R12
SQL> conn
Enter user-name: apps/xxxxxxx
Connected.
SQL> select text from user_source where name='CSE_PROJ_TRANSFER_PKG' and line=2;
TEXT
----------------------------------------------------------------------------------------------------
/* $Header: CSEPROTS.pls 115.0.11510.3 2006/01/18 02:17:26 sguthiva noship $ */
/* $Header: CSEPROTB.pls 115.0.11510.6 2006/01/21 19:20:00 sguthiva noship $ */
2 rows selected.
SQL> alter package CSE_PROJ_TRANSFER_PKG compile;
Warning: Package altered with compilation errors.
SQL> show error
No errors.
SQL> select line,text from user_errors where name='CSE_PROJ_TRANSFER_PKG';
LINE
----------
TEXT
----------------------------------------------------------------------------------------------------
211
PLS-00302: component 'TO_PROJECT_ID' must be declared
211
PL/SQL: Statement ignored
212
PLS-00302: component 'TO_TASK_ID' must be declared
Invalid package CSE_PROJ_TRANSFER_PKG after migration to R12
SQL> conn
Enter user-name: apps/xxxxxxx
Connected.
SQL> select text from user_source where name='CSE_PROJ_TRANSFER_PKG' and line=2;
TEXT
----------------------------------------------------------------------------------------------------
/* $Header: CSEPROTS.pls 115.0.11510.3 2006/01/18 02:17:26 sguthiva noship $ */
/* $Header: CSEPROTB.pls 115.0.11510.6 2006/01/21 19:20:00 sguthiva noship $ */
2 rows selected.
SQL> alter package CSE_PROJ_TRANSFER_PKG compile;
Warning: Package altered with compilation errors.
SQL> show error
No errors.
SQL> select line,text from user_errors where name='CSE_PROJ_TRANSFER_PKG';
LINE
----------
TEXT
----------------------------------------------------------------------------------------------------
211
PLS-00302: component 'TO_PROJECT_ID' must be declared
211
PL/SQL: Statement ignored
212
PLS-00302: component 'TO_TASK_ID' must be declared
Tagged:
0