Invalid objects after applying merged patch 10117518 R12.AD.C and CUP8
The following objects are invalid after applying merge patches 10117518, 24690501 and 26321002:
AD_PA_INSERT_PACKAGE
AD_PA_SUBMIT_REQUEST
When I try to recompile:
SQL> alter package ad_pa_insert_package compile body;
Warning: Package Body altered with compilation errors.
SQL> show error
Errors for PACKAGE BODY AD_PA_INSERT_PACKAGE:
LINE/COL ERROR
-------- -----------------------------------------------------------------
149/3 PL/SQL: SQL Statement ignored
186/24 PL/SQL: ORA-02289: sequence does not exist
SQL> alter package ad_pa_submit_request compile body;
Warning: Package Body altered with compilation errors.
SQL> show error
Errors for PACKAGE BODY AD_PA_SUBMIT_REQUEST:
LINE/COL ERROR
-------- -----------------------------------------------------------------
674/4 PL/SQL: Statement ignored