APPS.HR_DM_GEN_MAIN SQL Statements

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

Line: 37

  select ORACLE_USERNAME
  from fnd_oracle_userid
  where ORACLE_ID = 900;

Line: 46

  select 1
  from all_tab_columns
  where table_name = p_table_name
  and   data_type = 'LONG'
  and owner in
  (l_apps_name,
   l_fnd_owner,
   l_ff_owner,
   l_ben_owner,
   l_pay_owner,
   l_per_owner);

Line: 110

  select 1
  from hr_dm_hierarchies hir
  where hir.table_id = p_table_id
  and   hir.hierarchy_type = p_hierarchy_type;

Line: 117

  select 1
  from hr_dm_hierarchies hir,
       hr_dm_tables t
  where hir.table_id = t.table_id
    and t.table_name = (
	select nvl(upload_table_name, table_name)
	from hr_dm_tables
	where table_id = p_table_id)
    and   hir.hierarchy_type = p_hierarchy_type;

Line: 163

                         'in hr_dm_dt_deletes table ',15);

Line: 192

  select 1
  from hr_dm_hierarchies hir
  where hir.hierarchy_type = 'L'
    and hir.parent_table_id =  (select table_id
          from hr_dm_tables
          where table_name = (
              select nvl(upload_table_name, table_name)
                from hr_dm_tables
                where table_id = p_table_id));

Line: 259

  select tbl.table_id
      ,upper(tbl.short_name)  short_name
      ,upper(tbl.table_name)  table_name
      ,itm.phase_item_id
      ,phs.phase_id
  from hr_dm_tables tbl,
       hr_dm_phase_items itm,
       hr_dm_phases  phs
  where phs.migration_id = p_migration_id
  and   phs.phase_name   = 'R'
  and   phs.phase_id     = itm.phase_id
  and   itm.table_name   = tbl.table_name;

Line: 275

  select '1'
  from hr_dm_phase_items itm,
       hr_dm_phases  phs
  where phs.migration_id = p_migration_id
  and   phs.phase_name   = 'G'
  and   phs.phase_id     = itm.phase_id
  and   itm.table_name   = p_table_name
  and   itm.status       = 'C';

Line: 286

  select '1'
  from user_objects tups,
       user_objects tds
  where tups.object_name = l_tups_package
  and tups.object_type = 'PACKAGE BODY'
  and tups.status = 'VALID'
  and tds.object_name = l_tds_package
  and tds.object_type = 'PACKAGE BODY'
  and tds.status = 'VALID';

Line: 297

  select ORACLE_USERNAME
  from fnd_oracle_userid
  where ORACLE_ID = 900;

Line: 302

  select av.view_name,
         av.text,
         itm.phase_item_id
  from all_views av,
       hr_dm_phase_items itm,
       hr_dm_phases  phs
  where phs.migration_id = p_migration_id
  and   phs.phase_name   = 'G'
  and   phs.phase_id     = itm.phase_id
  and   itm.table_name = av.view_name
  and   av.view_name like 'HR_DMV%'
  and av.view_name not like 'HR_DMVP%'
  and av.view_name not like 'HR_DMVS%'
  and av.owner = l_apps_name;

Line: 387

      hr_dm_utility.update_phase_items(p_new_status => 'E',
                                  p_id => l_phase_item_id);

Line: 416

    hr_dm_utility.update_phase_items(p_new_status => 'E',
                                    p_id => l_phase_item_id);

Line: 466

select tbl.table_id
      ,lower(tbl.table_name)  table_name
      ,tbl.datetrack
      ,decode (tbl.surrogate_pk_column_name,NULL,'N','Y') surrogate_primary_key
      ,lower(tbl.surrogate_pk_column_name) surrogate_pk_column_name
      ,lower(tbl.table_alias) table_alias
      ,lower(tbl.short_name) short_name
      ,itm.phase_item_id
      ,lower(tbl.who_link_alias) who_link_alias
      ,tbl.derive_sql_download_full
      ,tbl.derive_sql_download_add
      ,tbl.derive_sql_calc_ranges
      ,tbl.derive_sql_delete_source
      ,tbl.derive_sql_source_tables
      ,tbl.derive_sql_chk_row_exists
      ,tbl.derive_sql_chk_source_tables
      ,tbl.use_distinct_download
      ,tbl.always_check_row
      ,upper(nvl(tbl.global_data,'N')) global_data
      ,phs.migration_id
      ,lower(nvl(tbl.upload_table_name, tbl.table_name)) upload_table_name
      ,sequence_name
from hr_dm_tables tbl,
    hr_dm_phases phs,
     hr_dm_phase_items itm
where itm.phase_item_id  =  p_phase_item_id
and   itm.phase_id       = phs.phase_id
and   itm.table_name     =  tbl.table_name;

Line: 496

  select distinct parent_table_id
    from  (select table_id,parent_table_id
             from hr_dm_hierarchies
              where hierarchy_type = 'PC')
              start with table_id = l_table_info.table_id
              connect by prior parent_table_id = table_id;

Line: 544

  hr_dm_utility.update_phase_items(p_new_status => 'S',
                                  p_id => l_phase_item_id);

Line: 565

  l_table_info.derive_sql_delete_source :=
                              l_csr_get_table_rec.derive_sql_delete_source;

Line: 683

        select datetrack
          into l_datetrack
          from hr_dm_tables
        where table_id = l_parent_table_id;

Line: 803

   update hr_dm_tables
   set last_generated_date = sysdate,
       generator_version   = l_generator_version
   where table_id = l_csr_get_table_rec.table_id;

Line: 809

  hr_dm_utility.update_phase_items(p_new_status => 'C',
                                   p_id => l_phase_item_id);

Line: 832

  hr_dm_utility.update_phase_items(p_new_status => 'E',
                                   p_id => l_phase_item_id);

Line: 841

  hr_dm_utility.update_phase_items(p_new_status => 'E',
                                   p_id => l_phase_item_id);

Line: 921

select business_group_id
       from hr_dm_migrations
       where migration_id = p_migration_id;

Line: 929

select tbl.table_id
      ,lower(tbl.table_name)  table_name
      ,tbl.datetrack
      ,decode (tbl.surrogate_pk_column_name,NULL,'N','Y') surrogate_primary_key
      ,lower(tbl.surrogate_pk_column_name) surrogate_pk_column_name
      ,lower(tbl.table_alias) table_alias
      ,lower(tbl.short_name) short_name
      ,itm.phase_item_id
      ,phs.phase_id
      ,lower(tbl.who_link_alias) who_link_alias
      ,tbl.derive_sql_download_full
      ,tbl.derive_sql_download_add
      ,tbl.derive_sql_calc_ranges
      ,tbl.derive_sql_delete_source
      ,tbl.derive_sql_source_tables
      ,tbl.derive_sql_chk_row_exists
      ,tbl.derive_sql_chk_source_tables
      ,tbl.use_distinct_download
      ,tbl.always_check_row
      ,upper(nvl(tbl.global_data,'N')) global_data
      ,lower(nvl(tbl.upload_table_name, tbl.table_name)) upload_table_name
      ,sequence_name
from hr_dm_tables tbl,
     hr_dm_phase_items itm,
     hr_dm_phases  phs
where phs.migration_id = p_migration_id
and   phs.phase_name   = 'G'
and   phs.phase_id     = itm.phase_id
and   mod(itm.phase_item_id,l_no_of_threads) + 1 = p_process_number
and   itm.status       = 'NS'
--and   itm.status       in ('NS','E')
and   itm.table_name   = tbl.table_name
and   rownum < 2;

Line: 964

for update of itm.status,
              phs.phase_name,
              tbl.table_name;

Line: 973

  select distinct parent_table_id
    from  (select table_id,parent_table_id
             from hr_dm_hierarchies
              where hierarchy_type = 'PC')
              start with table_id = l_table_info.table_id
              connect by prior parent_table_id = table_id;

Line: 982

   select count(*)
     from hr_dm_hierarchies h
    where h.table_id = p_table_id
      and h.hierarchy_type ='A'
      and h.column_name not in ('CREATED_BY','LAST_UPDATED_BY');

Line: 1055

   hr_dm_utility.update_phase_items(p_new_status => 'S',
                                   p_id => l_csr_get_table_rec.phase_item_id);

Line: 1091

   l_table_info.derive_sql_delete_source :=
                               l_csr_get_table_rec.derive_sql_delete_source;

Line: 1209

        select datetrack
          into l_datetrack
          from hr_dm_tables
        where table_id = l_parent_table_id;

Line: 1250

           l_fatal_error_message := 'AOL column names must be created_by or last_updated_by for a table with H hierarchy.'||
                                    'Other names are not currently handled. Please contact Oracle Support.';

Line: 1389

   update hr_dm_tables
   set last_generated_date = sysdate,
       generator_version   = l_generator_version
   where table_id = l_csr_get_table_rec.table_id;

Line: 1395

   hr_dm_utility.update_phase_items(p_new_status => 'C',
                                    p_id => l_phase_item_id);

Line: 1430

     hr_dm_utility.update_phase_items(p_new_status => 'E',
                                   p_id => l_phase_item_id);

Line: 1433

     hr_dm_utility.update_phases(p_new_status => 'E',
                                 p_id => l_phase_id);

Line: 1452

     hr_dm_utility.update_phase_items(p_new_status => 'E',
                                   p_id => l_phase_item_id);

Line: 1455

     hr_dm_utility.update_phases(p_new_status => 'E',
                                 p_id => l_phase_id);

Line: 1467

  hr_dm_utility.update_phase_items(p_new_status => 'E',
                                   p_id => l_phase_item_id);