After applying Patch 9654468 R12.POS.B the object POS_SUPP_CONTACT_PKG has become invalid
Hi,
Issue: After applying Patch 9654468 R12.POS.B the object POS_SUPP_CONTACT_PKG has become invalid
SQL> alter package POS_SUPP_CONTACT_PKG compile body;
Warning: Package Body altered with compilation errors.
SQL> show error;
Errors for PACKAGE BODY POS_SUPP_CONTACT_PKG:
LINE/COL ERROR
-------- -----------------------------------------------------------------
321/4 PL/SQL: Statement ignored
321/29 PLS-00302: component 'UPDATE_PARTY_ALT_PHONE' must be declared
348/4 PL/SQL: Statement ignored
348/29 PLS-00302: component 'UPDATE_PARTY_URL' must be declared
776/5 PL/SQL: Statement ignored
776/30 PLS-00302: component 'UPDATE_PARTY_ALT_PHONE' must be declared
795/5 PL/SQL: Statement ignored
795/30 PLS-00302: component 'UPDATE_PARTY_URL' must be declared
Warning: Package Body altered with compilation errors.
SQL> show error;
Errors for PACKAGE BODY POS_SUPP_CONTACT_PKG:
LINE/COL ERROR
-------- -----------------------------------------------------------------
321/4 PL/SQL: Statement ignored
321/29 PLS-00302: component 'UPDATE_PARTY_ALT_PHONE' must be declared
348/4 PL/SQL: Statement ignored
348/29 PLS-00302: component 'UPDATE_PARTY_URL' must be declared
776/5 PL/SQL: Statement ignored
776/30 PLS-00302: component 'UPDATE_PARTY_ALT_PHONE' must be declared
795/5 PL/SQL: Statement ignored
795/30 PLS-00302: component 'UPDATE_PARTY_URL' must be declared
Cause:
Tagged:
0