APPS.HRI_UTL_STAGE_TABLE SQL Statements

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

Line: 34

  SELECT
   tablespace_name
  ,initial_extent
  ,next_extent
  ,ini_trans
  ,max_trans
  ,min_extent
  ,max_extent
  ,pct_increase
  ,'1' || partition_name  order_by
  FROM all_tab_partitions
  WHERE table_owner = p_owner
  AND table_name = p_master_table_name
  UNION ALL
  SELECT
   tablespace_name
  ,initial_extent
  ,next_extent
  ,ini_trans
  ,max_trans
  ,min_extents
  ,max_extents
  ,pct_increase
  ,'2'
  FROM all_tables
  WHERE owner = p_owner
  AND table_name = p_master_table_name
  ORDER BY 9;

Line: 153

  SELECT
   column_name
  ,DECODE(data_type,
            'VARCHAR2', data_type || '(' || data_length || ')',
          data_type)            data_type
  FROM all_tab_cols a
  WHERE table_name = p_master_table_name
  AND owner = p_owner
  AND NOT EXISTS
   (SELECT
      null
    FROM all_tab_cols b
    WHERE b.table_name = v_table_name
    AND b.owner = p_owner
    AND b.column_name = a.column_name);

Line: 170

  SELECT
   column_name
  ,DECODE(data_type,
            'VARCHAR2', data_type || '(' || data_length || ')',
          data_type)            data_type
  FROM all_tab_cols a
  WHERE table_name = p_master_table_name
  AND owner = p_owner
  AND data_type = 'VARCHAR2'
  AND EXISTS
   (SELECT
      null
    FROM all_tab_cols b
    WHERE b.table_name = v_table_name
    AND b.owner = p_owner
    AND b.column_name = a.column_name
    AND b.data_length < a.data_length);

Line: 259

  SELECT count(*)
  FROM all_tables
  WHERE owner = p_owner
  AND table_name = v_table_name;

Line: 311

  SELECT column_name
  FROM all_tab_cols
  WHERE table_name = p_master_table_name
  AND owner = p_owner;

Line: 334

  l_sql_stmt := 'INSERT /*+ APPEND */ INTO ' || p_master_table_name || g_rtn ||
                ' (' || l_col_list || ' ) ' || g_rtn ||
                'SELECT' || g_rtn ||
                  l_col_list || g_rtn ||
                'FROM ' || get_staging_table_name
                            (p_master_table_name);