SYSTEM.AD_DDL SQL Statements

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

Line: 145

      select ORACLE_USERNAME
      into
      oracle_schema
      from fnd_oracle_userid where read_only_flag='U';

Line: 206

        c_statement:='select install_group_num from '||
               p_apps_schema||'.fnd_oracle_userid '||
           'where oracle_username = upper(:oracle_schema) '||
           'and install_group_num is not null';

Line: 489

              c_statement:='select install_group_num from '||
                     davcsap_apps_schema||'.fnd_oracle_userid '||
                     'where read_only_flag = ''U'' '||
                 'order by install_group_num';

Line: 656

              c_statement:='select distinct install_group_num from '||
                     dctcs_apps_schema||'.fnd_oracle_userid '||
                     'where read_only_flag = ''U'' '||
                 'order by install_group_num';

Line: 806

              c_statement:='select distinct install_group_num from '||
                     dcv_apps_schema||'.fnd_oracle_userid '||
                     'where read_only_flag = ''U'' '||
                 'order by install_group_num';

Line: 926

            insert_newlines        in  varchar2,
            comp_error             out nocopy varchar2)
is
  success_with_comp_error exception;

Line: 1022

  c_statement := 'select oracle_username from '||upper(apps_schema)||
    '.fnd_oracle_userid where oracle_username = USER';

Line: 1070

       select ORACLE_USERNAME
       into
       oracle_schema
       from
       fnd_oracle_userid where
       read_only_flag='U';

Line: 1090

    c_statement := 'select oracle_username from '||
      apps_schema||'.fnd_oracle_userid '||
      'where install_group_num = 1 and read_only_flag = ''U''';

Line: 1116

      c_statement:='select install_group_num from '||
             apps_schema||'.fnd_oracle_userid '||
             'where oracle_username = upper(:oracle_schema) '||
             'and install_group_num is not null';

Line: 1156

        c_statement := 'select oracle_username from '||
          apps_schema||'.fnd_oracle_userid '||
          'where install_group_num = '||install_group_num||
          ' and read_only_flag = ''U''';

Line: 1530

          insert_newlines);

Line: 1619

            insert_newlines);

Line: 1660

            insert_newlines);

Line: 1744

          insert_newlines);

Line: 1774

            insert_newlines);

Line: 1800

                insert_newlines);

Line: 1825

                insert_newlines);

Line: 1874

        c_statement := 'select status from dba_objects '||
          'where owner='''||upper(first_apps_schema)||
          ''' and object_name='''||upper_obj_name||
          ''' and object_type='''||upper(object_type)||'''';

Line: 1901

            c_statement := 'select count(*) from dba_objects '||
              'where owner= '''||upper(current_apps_schema)||
              ''' and object_name='''||upper_obj_name||
              ''' and object_type='''||upper(object_type)||
              ''' and status=''INVALID''';

Line: 1926

            c_statement := 'select count(*) from dba_objects '||
              'where object_name='''||upper_obj_name||
              ''' and object_type='''||upper(object_type)||
              ''' and owner in (select oracle_username '||
              'from '||upper(first_apps_schema)||'.fnd_oracle_userid '||
              'where read_only_flag in (''U'',''K'')) '||
              'and status=''INVALID''';

Line: 1965

                        lb||', '||ub||', '||insert_newlines||'): '||
                        ad_ddl.error_buf||': '||ad_apps_private.error_buf||
                        ': substr($statement$,1,255)='''||
                        substr(gbl_statement,1,255)||'''';

Line: 2064

      select ORACLE_USERNAME
      into
      oracle_schema
      from
      fnd_oracle_userid where
      read_only_flag='U';

Line: 2120

      c_statement:='select install_group_num from '||
             p_apps_schema||'.fnd_oracle_userid '||
         'where oracle_username = upper(:oracle_schema) '||
         'and install_group_num is not null';

Line: 2225

              c_statement:='select distinct install_group_num from '||
                     dcv_apps_schema||'.fnd_oracle_userid '||
                     'where read_only_flag = ''U'' '||
                 'order by install_group_num';