APPS.ASG_COMPILE_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 14

     select object_name, object_type from all_objects
     where status = 'INVALID'
     and   object_type = 'PACKAGE'
     and owner=schema_name;

Line: 20

     select object_name, object_type from all_objects
     where status = 'INVALID'
     and   object_type = 'VIEW'
     and owner=schema_name ;

Line: 30

     select decode(o.type#,9,1,2) dummy,
            o.name object_name,
            decode(o.type#, 0, 'NEXT OBJECT', 1, 'INDEX', 2, 'TABLE',
                           3, 'CLUSTER',
                           4, 'VIEW', 5, 'SYNONYM', 6, 'SEQUENCE',
                           7, 'PROCEDURE', 8, 'FUNCTION', 9, 'PACKAGE',
                           11, 'PACKAGE BODY', 12, 'TRIGGER',
                           13, 'TYPE', 14, 'TYPE BODY',
                           19, 'TABLE PARTITION', 20, 'INDEX PARTITION',
                           22, 'LIBRARY', 23, 'DIRECTORY', 24, 'QUEUE',
                           28, 'JAVA SOURCE', 29, 'JAVA CLASS',
                           30, 'JAVA RESOURCE',
                           32, 'INDEXTYPE', 33, 'OPERATOR',
                           34, 'TABLE SUBPARTITION', 35, 'INDEX SUBPARTITION',
                           39, 'LOB PARTITION', 40, 'LOB SUBPARTITION',
                           43, 'DIMENSION',
                           44, 'CONTEXT', 47, 'RESOURCE PLAN',
                           48, 'CONSUMER GROUP',
                           51, 'SUBSCRIPTION', 52, 'LOCATION',
                          'UNDEFINED') object_type
     from sys.obj$ o, sys.user$ u
     where o.owner# = u.user#
       and u.name = schema_name

     and o.status <> 1 /* not valid status */
    -- and o.name like '%%'
     and o.type# not in (28, 29, 30,12) /* exclude Java stuff for now + trigger*/
     -- and not exists ( select 'x' from sys.trigger$ t
        --              where o.obj# = t.obj#
          --            and t.enabled = 0)
     order by 1;

Line: 161

     select object_name, object_type from user_objects
     where status = 'INVALID'
     and   object_type = 'PACKAGE' ;

Line: 166

     select object_name, object_type from user_objects
     where status = 'INVALID'
     and   object_type = 'VIEW' ;

Line: 175

     select decode(o.type#,9,1,2) dummy,
            o.name object_name,
            decode(o.type#, 0, 'NEXT OBJECT', 1, 'INDEX', 2, 'TABLE',
                           3, 'CLUSTER',
                           4, 'VIEW', 5, 'SYNONYM', 6, 'SEQUENCE',
                           7, 'PROCEDURE', 8, 'FUNCTION', 9, 'PACKAGE',
                           11, 'PACKAGE BODY', 12, 'TRIGGER',
                           13, 'TYPE', 14, 'TYPE BODY',
                           19, 'TABLE PARTITION', 20, 'INDEX PARTITION',
                           22, 'LIBRARY', 23, 'DIRECTORY', 24, 'QUEUE',
                           28, 'JAVA SOURCE', 29, 'JAVA CLASS',
                           30, 'JAVA RESOURCE',
                           32, 'INDEXTYPE', 33, 'OPERATOR',
                           34, 'TABLE SUBPARTITION', 35, 'INDEX SUBPARTITION',
                           39, 'LOB PARTITION', 40, 'LOB SUBPARTITION',
                           43, 'DIMENSION',
                           44, 'CONTEXT', 47, 'RESOURCE PLAN',
                           48, 'CONSUMER GROUP',
                           51, 'SUBSCRIPTION', 52, 'LOCATION',
                          'UNDEFINED') object_type
     from sys.obj$ o
     where o.owner# = userenv('SCHEMAID')
     and o.status <> 1 /* not valid status */
    -- and o.name like '%%'
     and o.type# not in (28, 29, 30,12) /* exclude Java stuff for now + trigger*/
     -- and not exists ( select 'x' from sys.trigger$ t
        --              where o.obj# = t.obj#
          --            and t.enabled = 0)
     order by 1;