APPS.EDW_SIZE_WRAPPER SQL Statements

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

Line: 34

   select table_name, table_owner, table_type
   from  EDW_SIZE_INPUT where
   table_logical_name like p_log_name || '%';

Line: 39

   select num_rows_proc_name, row_len_proc_name
   from  EDW_SIZE_INPUT where table_owner = g_schema
   and table_name = g_table_name;

Line: 44

   select num_rows_proc_name, row_len_proc_name, table_name, table_owner,
                   table_type, table_logical_name
   from  EDW_SIZE_INPUT order by table_owner;

Line: 53

   select count(*)
   from  user_objects where object_type = 'PACKAGE BODY'
   and object_name = l_pack_name;

Line: 290

   select count(*)
   from EDW_SIZE_OUTPUT where
   table_name = g_table_name
   and owner = g_schema;

Line: 296

   select avg_row_len1, avg_row_len2, avg_row_len3, max_row_len_ss, max_row_len_m
   from  EDW_SIZE_INPUT where table_name = g_table_name
   and table_owner = g_schema;

Line: 301

   select num_of_levels, avg_row_len1, avg_row_len2, avg_row_len3,
   avg_row_len4, avg_row_len5, avg_row_len6, max_row_len_l
   from  EDW_SIZE_INPUT where table_name = g_table_name
   and table_owner = g_schema;

Line: 352

         insert into edw_size_output(
         TABLE_NAME,
         OWNER,
         TABLE_TYPE,
         TABLE_LOGICAL_NAME,
         AVG_ROW_LEN_STAGE,
         AVG_ROW_LEN,
         AVG_ROW_LEN_IND_S,
         AVG_ROW_LEN_IND,
         NUM_ROWS,
         TABLE_SIZE_STAGE,
         INDEX_SIZE_STAGE,
         TABLE_SIZE,
         INDEX_SIZE,
         TEMP_TABLE_SIZE,
         TEMP_SIZE,
         TEMP_SIZE_SOURCE,
         RB_SIZE,
         TOTAL_PEM_SPACE,
         TOTAL_TMP_SPACE,
         PCT_FREE_S,
         PCT_FREE_L,
         PCT_FREE,
         FROM_DATE,
         TO_DATE,
         LAST_UPDATE_DATE	,
         LAST_UPDATED_BY,
         LAST_UPDATE_LOGIN,
         CREATED_BY,
         CREATION_DATE) values
      (  g_table_name,
         g_schema,
         g_table_type,
         g_log_name,
         l_TBL_s,
         l_TBL_t,
         l_IND_s,
         l_IND_t,
         p_num_rows,
         l_tbl_size_s,
         l_ind_size_s,
         l_tbl_size_t,
         l_ind_size_t,
         l_temp_tbl_size,
         l_temp_size,
         l_temp_size_source,
         l_rb_size,
         l_total_pem_space,
         l_total_tmp_space,
         l_pct_s,
         l_pct_l,
         l_pct_t,
         g_from_date,
         g_to_date,
         sysdate, 0, 0, 0, sysdate);

Line: 408

                      ', one record is inserted';

Line: 411

         update edw_size_output set  TABLE_LOGICAL_NAME = g_log_name,
         OWNER = g_schema,
         AVG_ROW_LEN_STAGE = l_TBL_s,
         AVG_ROW_LEN = l_TBL_t,
         AVG_ROW_LEN_IND_S = l_IND_s,
         AVG_ROW_LEN_IND = l_IND_t,
         NUM_ROWS = p_num_rows,
         TABLE_SIZE_STAGE = l_tbl_size_s,
         INDEX_SIZE_STAGE = l_ind_size_s,
         TABLE_SIZE = l_tbl_size_t,
         INDEX_SIZE = l_ind_size_t,
         TEMP_TABLE_SIZE = l_temp_tbl_size,
         TEMP_SIZE = l_temp_size,
         TEMP_SIZE_SOURCE = l_temp_size_source,
         RB_SIZE = l_rb_size,
         TOTAL_PEM_SPACE = l_total_pem_space,
         TOTAL_TMP_SPACE = l_total_tmp_space,
         PCT_FREE_S = l_pct_s,
         PCT_FREE_L = l_pct_l,
         PCT_FREE = l_pct_t,
         FROM_DATE = g_from_date,
         TO_DATE = g_to_date,
         LAST_UPDATE_DATE = sysdate,
         LAST_UPDATED_BY = 0,
         LAST_UPDATE_LOGIN = 0,
         CREATED_BY = 0,
         CREATION_DATE = sysdate
         where table_name = g_table_name
         and owner = g_schema;

Line: 441

                      ', record is updated';

Line: 506

         insert into edw_size_output(
         TABLE_NAME,
         OWNER,
         TABLE_TYPE,
         TABLE_LOGICAL_NAME,
         AVG_ROW_LEN_STAGE,
         AVG_ROW_LEN,
         AVG_ROW_LEN_LEVEL,
         AVG_ROW_LEN_IND_S,
         AVG_ROW_LEN_IND,
         AVG_ROW_LEN_IND_L,
         NUM_ROWS,
         TABLE_SIZE_STAGE,
         INDEX_SIZE_STAGE,
         TABLE_SIZE_LEVEL,
         INDEX_SIZE_LEVEL,
         TABLE_SIZE,
         INDEX_SIZE,
         TEMP_TABLE_SIZE,
         TEMP_SIZE,
         RB_SIZE,
         TOTAL_PEM_SPACE,
         TOTAL_TMP_SPACE,
         PCT_FREE_S,
         PCT_FREE_L,
         PCT_FREE,
         FROM_DATE,
         TO_DATE,
         LAST_UPDATE_DATE	,
         LAST_UPDATED_BY,
         LAST_UPDATE_LOGIN,
         CREATED_BY,
         CREATION_DATE) values
      (  g_table_name,
         g_schema,
         g_table_type,
         g_log_name,
         l_TBL_s,
         l_TBL_t,
         l_TBL_l,
         l_IND_s,
         l_IND_t,
         l_IND_l,
         p_num_rows,
         l_tbl_size_s,
         l_ind_size_s,
         l_tbl_size_l,
         l_ind_size_l,
         l_tbl_size_t,
         l_ind_size_t,
         l_temp_tbl_size,
         l_temp_size,
         l_rb_size,
         l_total_pem_space,
         l_total_tmp_space,
         l_pct_s,
         l_pct_l,
         l_pct_t,
         g_from_date,
         g_to_date,
         sysdate, 0, 0, 0, sysdate);

Line: 568

                      ', one record is inserted';

Line: 571

         update edw_size_output set  TABLE_LOGICAL_NAME = g_log_name,
         OWNER = g_schema,
         AVG_ROW_LEN_STAGE = l_TBL_s,
         AVG_ROW_LEN = l_TBL_t,
         AVG_ROW_LEN_LEVEL = l_TBL_l,
         AVG_ROW_LEN_IND_S = l_IND_s,
         AVG_ROW_LEN_IND = l_IND_t,
         AVG_ROW_LEN_IND_L = l_IND_l,
         NUM_ROWS = p_num_rows,
         TABLE_SIZE_STAGE = l_tbl_size_s,
         INDEX_SIZE_STAGE = l_ind_size_s,
         TABLE_SIZE_LEVEL = l_tbl_size_l,
         INDEX_SIZE_LEVEL = l_ind_size_l,
         TABLE_SIZE = l_tbl_size_t,
         INDEX_SIZE = l_ind_size_t,
         TEMP_TABLE_SIZE = l_temp_tbl_size,
         TEMP_SIZE = l_temp_size,
         RB_SIZE = l_rb_size,
         TOTAL_PEM_SPACE = l_total_pem_space,
         TOTAL_TMP_SPACE = l_total_tmp_space,
         PCT_FREE_S = l_pct_s,
         PCT_FREE_L = l_pct_l,
         PCT_FREE = l_pct_t,
         FROM_DATE = g_from_date,
         TO_DATE = g_to_date,
         LAST_UPDATE_DATE = sysdate,
         LAST_UPDATED_BY = 0,
         LAST_UPDATE_LOGIN = 0,
         CREATED_BY = 0,
         CREATION_DATE = sysdate
         where table_name = g_table_name
         and owner = g_schema;

Line: 604

                      ', record is updated' ;

Line: 673

   select  table_name, table_type
   from  EDW_SIZE_OUTPUT where table_logical_name = p_log_name;

Line: 677

   select  TABLE_LOGICAL_NAME,
           OWNER,
           FROM_DATE,
           TO_DATE,
           TEMP_SIZE_SOURCE ,
           AVG_ROW_LEN_STAGE,
           AVG_ROW_LEN      ,
           AVG_ROW_LEN_IND_S,
           AVG_ROW_LEN_IND  ,
           NUM_ROWS         ,
           TABLE_SIZE_STAGE ,
           INDEX_SIZE_STAGE ,
           TABLE_SIZE       ,
           INDEX_SIZE       ,
           TEMP_SIZE        ,
           RB_SIZE          ,
           TEMP_TABLE_SIZE  ,
           TOTAL_PEM_SPACE  ,
           TOTAL_TMP_SPACE
   from  EDW_SIZE_OUTPUT where table_logical_name = p_log_name;

Line: 699

   select  TABLE_LOGICAL_NAME,
           OWNER,
           FROM_DATE,
           TO_DATE,
           AVG_ROW_LEN_STAGE,
           AVG_ROW_LEN_LEVEL,
           AVG_ROW_LEN      ,
           AVG_ROW_LEN_IND_S,
           AVG_ROW_LEN_IND_L,
           AVG_ROW_LEN_IND  ,
           NUM_ROWS         ,
           TABLE_SIZE_STAGE ,
           INDEX_SIZE_STAGE ,
           TABLE_SIZE_LEVEL ,
           INDEX_SIZE_LEVEL ,
           TABLE_SIZE       ,
           INDEX_SIZE       ,
           TEMP_SIZE        ,
           RB_SIZE          ,
           TEMP_TABLE_SIZE  ,
           TEMP_SIZE_SOURCE ,
           TOTAL_PEM_SPACE  ,
           TOTAL_TMP_SPACE
   from  EDW_SIZE_OUTPUT where table_logical_name = p_log_name;

Line: 725

   select  TABLE_LOGICAL_NAME,
           TABLE_TYPE,
           OWNER,
           FROM_DATE,
           TO_DATE,
           AVG_ROW_LEN_STAGE,
           AVG_ROW_LEN_LEVEL,
           AVG_ROW_LEN      ,
           AVG_ROW_LEN_IND_S,
           AVG_ROW_LEN_IND_L,
           AVG_ROW_LEN_IND  ,
           NUM_ROWS         ,
           TABLE_SIZE_STAGE ,
           INDEX_SIZE_STAGE ,
           TABLE_SIZE_LEVEL ,
           INDEX_SIZE_LEVEL ,
           TABLE_SIZE       ,
           INDEX_SIZE       ,
           TEMP_SIZE        ,
           RB_SIZE          ,
           TEMP_TABLE_SIZE  ,
           TEMP_SIZE_SOURCE ,
           TOTAL_PEM_SPACE  ,
           TOTAL_TMP_SPACE
   from  EDW_SIZE_OUTPUT order by owner;