declare
	l_count number;
	l_count2 number;
	l_count3 number;
      l_count4 number;
begin
	select count(*) into l_count from user_objects 
		where object_name like 'WMP_%' and object_type in ('PACKAGE', 'PACKAGE BODY') and status <> 'VALID';
	if l_count <> 0
	then
		raise_application_error(-20000, 'One or more packages is invalid');
	end if;

	select count(*) into l_count2 from user_objects 
		where object_name in ('%_NoRootExce%',
					    '%_ExtractDBA%', 
					    '%_HTMLTagMan%',
					    '%_HtmlTable%',
					    '%_DataExtrac%',
					    '%_TableCell%',
					    '%_ExtractDB%',
					    '%_HtmlDiagra%',
					    '%_Generator%',
					    '%_HTMLPrint%',
					    '%_ExtractDB%',
					    '%_Connector%',
					    '%_ImageCell%',
					    '%_ExtractEx%',
					    '%_TextCell%',
					    '%oracle/wh/wmp/lia/%')
		and object_type in ('JAVA CLASS') 
		and status <> 'VALID';
	if l_count2 <> 0
	then
		raise_application_error(-20000, 'One or more java class is invalid');
	end if;

	select count(*) into l_count3 from user_objects 
		where object_name in ('WWCTX_API',
					    'WWERR_API_ERROR', 
					    'WWERR_API_ERROR_UI',
					    'WWLOG_API',
					    'WWNLS_API',
					    'WWNLS_STRINGS$',
					    'WWPOB_API_PAGE',
					    'WWPOB_API_STYLE',
					    'WWPOB_STYLES$',
					    'WWPRE_API_NAME',
					    'WWPRE_API_VALUE',
					    'WWPRO_API_PARAMETERS',
					    'WWPRO_API_PROVIDER',
					    'WWPRO_API_PROVIDER_REGISTRY',
					    'WWSEC_API',
					    'WWSEC_APP_PRIV',
					    'WWSEC_PERSON',
					    'WWSTO_API',
					    'WWUI_API_PORTLET',
					    'WWUTL_HTF',
					    'WWUTL_HTP',
					    'WWV_STANDARD_UTIL',
					    'WWV_UTLGLOBL')
		and object_type in ('SYNONYM') 
		and status <> 'VALID';
	if l_count3 <> 0
	then
		raise_application_error(-20000, 'One or more synonym is invalid');
	end if;

	select count(*) into l_count4 from user_objects 
		where object_name in ('DEFAULT_OWB_LINK%')
		and object_type in ('DATABASE LINK') 
		and status <> 'VALID';
	if l_count4 <> 0
	then
		raise_application_error(-20000, 'One or more database link is invalid');
	end if;

end;