Patches 6402032 and 6281689 - Causes Package AR_PREPAYMENTS_PUB to be Invalid
VPC Team member opened this thread for the customer.
After applying patches 6402032 and 6281689 the following package body became invalid.
OBJECT_NAME OWNER OBJECT_TYPE
--------------------------------------------- ------------------------------ -------------------
AR_PREPAYMENTS_PUB APPS PACKAGE BODY
SQL>
SQL> alter package AR_PREPAYMENTS_PUB compile body;
Warning: Package Body altered with compilation errors.
SQL> show error
Errors for PACKAGE BODY AR_PREPAYMENTS_PUB:
LINE/COL ERROR
-------- -----------------------------------------------------------------
70/11 PLS-00323: subprogram or cursor 'CREATE_PREPAYMENT' is declared in a package specification and must be defined in the package body
168/12 PLS-00323: subprogram or cursor 'GET_INSTALLMENT' is declared in a package specification and must be defined in the package body
After applying patches 6402032 and 6281689 the following package body became invalid.
OBJECT_NAME OWNER OBJECT_TYPE
--------------------------------------------- ------------------------------ -------------------
AR_PREPAYMENTS_PUB APPS PACKAGE BODY
SQL>
SQL> alter package AR_PREPAYMENTS_PUB compile body;
Warning: Package Body altered with compilation errors.
SQL> show error
Errors for PACKAGE BODY AR_PREPAYMENTS_PUB:
LINE/COL ERROR
-------- -----------------------------------------------------------------
70/11 PLS-00323: subprogram or cursor 'CREATE_PREPAYMENT' is declared in a package specification and must be defined in the package body
168/12 PLS-00323: subprogram or cursor 'GET_INSTALLMENT' is declared in a package specification and must be defined in the package body
Tagged:
0