Applied patch 11i.HZ.N (3618299) caused invalid HZ_IMP_LOAD_WRAPPER
Hi All,
After applying patch 11i.HZ.N (3618299) it caused invalid object HZ_IMP_LOAD_WRAPPER.
Research led us to this note :- HZ_IMP_LOAD_WRAPPER Invalid After Application Of Financial Family Pack G [ID 367530.1].
This advised us to apply Patch 4709096 which we have done. However, the HZ_IMP_LOAD_WRAPPER object is still invalid, but this time with the following error,
PLS-00323: subprogram or cursor 'GET_CONTENT_SRC_TYPE' is declared in a package
Unable to find any hits on metalink with regard to this. However, reviewing the package and package body versions we are now on :-
CREATE OR REPLACE PACKAGE APPS.HZ_IMP_LOAD_WRAPPER AUTHID CURRENT_USER AS