8:
9: procedure compile_apps_ddl is
10: cursor c1 is
11: select owner, object_type, object_name 12: from dba_objects 13: where object_type in ('PACKAGE', 'PACKAGE BODY')
14: and object_name in ('APPS_DDL', 'APPS_ARRAY_DDL')
15: and status = 'INVALID'
16: order by object_type, object_name desc;