SYSTEM.AD_DDL SQL Statements

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

Line: 167

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

Line: 229

        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: 601

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

Line: 725

               SELECT count(1)
               INTO   l_exist
               FROM   dba_editioning_views
               where  owner=dctcs_oracle_schema
               and    view_name=l_evname
               and    table_name=dctcs_object_name;

Line: 797

              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: 971

              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: 1107

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

Line: 1203

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

Line: 1251

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

Line: 1271

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

Line: 1297

      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: 1337

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

Line: 1711

          insert_newlines,object_name,'PACKAGE');                                         ---- vpalakur

Line: 1800

            insert_newlines,object_name,'PACKAGE');                                         ---- vpalakur

Line: 1841

            insert_newlines,object_name,'PACKAGE');                                         ---- vpalakur

Line: 1925

          insert_newlines,object_name,'PACKAGE BODY');                                         ---- vpalakur

Line: 1955

            insert_newlines,object_name,'PACKAGE BODY');                                         ---- vpalakur

Line: 1981

                insert_newlines,object_name,'PACKAGE BODY');                                         ---- vpalakur

Line: 2006

                insert_newlines,object_name,'PACKAGE BODY');                                         ---- vpalakur

Line: 2055

        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: 2082

            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: 2107

            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: 2146

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

Line: 2245

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

Line: 2301

      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: 2406

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