APPS.WF_INSTALL SQL Statements

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

Line: 31

       SELECT TABLESPACE_NAME, INITIAL_EXTENT, NEXT_EXTENT,
              PCT_INCREASE,PARTITIONED
       INTO   v_tablespace_name, v_initial, v_next,
              v_pctinc, v_partitioned
       FROM   USER_TABLES
       WHERE  TABLE_NAME = tblname;

Line: 48

      SELECT  NVL(UT.TABLESPACE_NAME,UPT.DEF_TABLESPACE_NAME),
              TO_CHAR(GREATEST(NVL(UT.INITIAL_EXTENT,
              TO_NUMBER(UPT.DEF_INITIAL_EXTENT)),65536)),
              TO_CHAR(GREATEST(NVL(UT.NEXT_EXTENT,
              TO_NUMBER(UPT.DEF_NEXT_EXTENT)),65536)),
              NVL(to_char(UT.PCT_INCREASE),UPT.DEF_PCT_INCREASE),
              UT.PARTITIONED
      INTO    v_tablespace_name, v_initial, v_next, v_pctinc, v_partitioned
      FROM    USER_PART_TABLES    UPT,
              USER_TABLES         UT
      WHERE   UT.TABLE_NAME       = tblname
      AND     UPT.TABLE_NAME(+) = UT.TABLE_NAME;

Line: 105

      SELECT  null
      INTO    v_dummy from sys.dual
      WHERE   exists (
        SELECT  1
        FROM    USER_OBJECTS
        WHERE   OBJECT_NAME = v_new_table
                      );

Line: 220

            ' as select * from %s ; \n';

Line: 293

      SELECT to_char(least(to_number(VALUE),8)),
             to_char(least(to_number(VALUE),4))
      INTO   v_freelist_groups, v_initrans
      FROM   V$PARAMETER
      WHERE  NAME = 'cpu_count';

Line: 310

      SELECT to_char(min(to_number(VALUE)))
      INTO   v_degree
      FROM   V$PARAMETER
      WHERE  NAME IN ('parallel_max_servers','cpu_count');

Line: 334

      SELECT  null
      INTO    v_dummy
      FROM    sys.dual
      WHERE   exists (SELECT 1
                      FROM   USER_OBJECTS
                      WHERE  OBJECT_NAME = v_new_table
                      );

Line: 388

              ' as select * from %s ;'||'\n';

Line: 502

    SELECT  I.TABLESPACE_NAME, I.INITIAL_EXTENT, I.NEXT_EXTENT, I.PCT_INCREASE,
            I.PARTITIONED, T.PARTITIONED
    INTO    v_tablespace_name, v_initial, v_next, v_pctinc,
            v_idxpartitioned, v_tblpartitioned
    FROM    USER_INDEXES I, USER_TABLES T
    WHERE   I.INDEX_NAME = idxname
    AND     I.TABLE_NAME = T.TABLE_NAME;

Line: 520

    SELECT  NVL(I.TABLESPACE_NAME,UPI.DEF_TABLESPACE_NAME),
            TO_CHAR(GREATEST(NVL(I.INITIAL_EXTENT,
            TO_NUMBER(UPI.DEF_INITIAL_EXTENT)),65536)),
            TO_CHAR(GREATEST(NVL(I.NEXT_EXTENT,
            TO_NUMBER(UPI.DEF_NEXT_EXTENT)),65536)),
            NVL(to_char(I.PCT_INCREASE),UPI.DEF_PCT_INCREASE),
            I.PARTITIONED, T.PARTITIONED
    INTO    v_tablespace_name, v_initial, v_next, v_pctinc,
            v_idxpartitioned, v_tblpartitioned
    FROM    USER_INDEXES I, USER_TABLES T, USER_PART_INDEXES UPI
    WHERE   I.INDEX_NAME = idxname
    AND     I.TABLE_NAME = T.TABLE_NAME
    AND     UPI.INDEX_NAME(+) = I.INDEX_NAME;

Line: 569

      SELECT null
      INTO   v_dummy
      FROM   sys.dual
      WHERE  exists (
             SELECT  1
             FROM    USER_OBJECTS
             WHERE   OBJECT_NAME = v_new_index
                    );

Line: 1111

      SELECT to_char(least(to_number(VALUE),8)),
             to_char(least(to_number(VALUE)*2,8))
      INTO   v_freelist_groups, v_initrans
      FROM   V$PARAMETER
      WHERE  NAME = 'cpu_count';

Line: 1129

      SELECT to_char(min(to_number(VALUE)))
      INTO   v_degree
      FROM   V$PARAMETER
      WHERE  NAME IN ('parallel_max_servers','cpu_count');

Line: 1155

      select null
      into   v_dummy
      from   sys.dual
      where  exists (select 1
                     from   USER_OBJECTS
                     where  OBJECT_NAME = v_new_index
                     );

Line: 1334

     select  default_tablespace
     into    l_tablespace
     from user_users;

Line: 1343

  select sum(bytes )/1024/1024
  into   current_space
  from   user_free_space
  where  tablespace_name = p_tablespace;

Line: 1348

  select sum(bytes)/1024/1024
  into   used_space
  from   user_segments
  where  TABLESPACE_NAME = p_tablespace
  and segment_name in (
         'WF_ITEM_ACTIVITY_STATUSES',
         'WF_ITEM_ACTIVITY_STATUSES_N1',
         'WF_ITEM_ACTIVITY_STATUSES_N2',
         'WF_ITEM_ACTIVITY_STATUSES_N3',
         'WF_ITEM_ACTIVITY_STATUSES_N4',
         'WF_ITEM_ACTIVITY_STATUSES_PK',
         'WF_ITEM_ACTIVITY_STATUSES_H',
         'WF_ITEM_ACTIVITY_STATUSES_H_N1',
         'WF_ITEM_ACTIVITY_STATUSES_H_N2',
         'WF_ITEM_ATTRIBUTE_VALUES',
         'WF_ITEM_ATTRIBUTE_VALUES_PK',
         'WF_ITEMS',
         'WF_ITEMS_N1',
         'WF_ITEMS_N2',
         'WF_ITEMS_N3',
         'WF_ITEMS_N4',
         'WF_ITEMS_N5',
         'WF_ITEMS_N6',
         'WF_ITEMS_PK',
         'WF_ITEMS_U1');