APPS.HR_DM_COPY SQL Statements

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

Line: 60

procedure delete_datapump_tables is

l_schema varchar2(30);

Line: 66

hr_dm_utility.message('ROUT','entry:hr_dm_copy.delete_datapump_tables', 5);

Line: 187

hr_dm_utility.message('ROUT','exit:hr_dm_copy.delete_datapump_tables', 35);

Line: 193

  hr_dm_utility.error(SQLCODE,'hr_dm_copy.delete_datapump_tables',
                       '(none)','R');

Line: 196

end delete_datapump_tables;

Line: 234

  select business_group_id,
         migration_type
  from hr_dm_migrations
  where migration_id = p_migration_id;

Line: 240

  SELECT pr.phase_name
    FROM hr_dm_phase_rules pr,
         hr_dm_migrations m
    WHERE m.migration_type = pr.migration_type
      AND pr.phase_name = 'UP'
      AND m.migration_id = p_migration_id;

Line: 264

    hr_dm_utility.message('INFO','Inserting row into hr_dm_exp_api_modules_v',15);

Line: 265

    insert into hr_dm_exp_api_modules_v  (exp_imp_id
                                         ,table_name
                                         ,api_module_id
                                         ,api_module_type
                                         ,module_name
                                         ,data_within_business_group
                                         ,legislation_code
                                         ,module_package
                                         ,last_update_date
                                         ,last_updated_by
                                         ,last_update_login
                                         ,created_by
                                         ,creation_date )
                                 select   hr_dm_exp_imps_s.nextval
                                         ,'HR_API_MODULES'
                                         ,api_module_id
                                         ,api_module_type
                                         ,module_name
                                         ,data_within_business_group
                                         ,legislation_code
                                         ,module_package
                                         ,to_char(last_update_date,'YYYYMMDD HH24:MI:SS')
                                         ,last_updated_by
                                         ,last_update_login
                                         ,created_by
                                         ,to_char(creation_date,'YYYYMMDD HH24:MI:SS')
                                 from hr_api_modules ai
                                 where api_module_type = 'DM'
                                   and not exists (select null
                                       from hr_dm_exp_api_modules_v v
                                       where v.api_module_id = ai.api_module_id);

Line: 302

  hr_dm_utility.message('INFO','Inserting row into hr_dm_exp_migrations_v',20);

Line: 303

  insert into hr_dm_exp_migrations_v  ( exp_imp_id
                                       ,table_name
                                       ,migration_id
                                       ,source_database_instance
                                       ,destination_database_instance
                                       ,migration_type
                                       ,application_id
                                       ,business_group_id
                                       ,business_group_name
                                       ,migration_start_date
                                       ,migration_end_date
                                       ,status
                                       ,effective_date
                                       ,migration_count
                                       ,selective_migration_criteria
                                       ,active_group
                                       ,last_update_date
                                       ,last_updated_by
                                       ,last_update_login
                                       ,created_by
                                       ,creation_date )
                               select   hr_dm_exp_imps_s.nextval
                                       ,'HR_DM_MIGRATIONS'
                                       ,migration_id
                                       ,source_database_instance
                                       ,destination_database_instance
                                       ,migration_type
                                       ,application_id
                                       ,business_group_id
                                       ,business_group_name
                                       ,migration_start_date
                                       ,migration_end_date
                                       ,'NS'
                                       ,effective_date
                                       ,migration_count
                                       ,selective_migration_criteria
                                       ,active_group
                                       ,to_char(last_update_date,'YYYYMMDD HH24:MI:SS')
                                       ,last_updated_by
                                       ,last_update_login
                                       ,created_by
                                       ,to_char(creation_date,'YYYYMMDD HH24:MI:SS')
                               from hr_dm_migrations dm
                               where migration_id = p_migration_id
                                   and not exists (select null
                                       from hr_dm_exp_migrations_v v
                                       where v.migration_id = dm.migration_id);

Line: 361

    hr_dm_utility.message('INFO','Inserting row(s) into HR_DM_EXP_HR_LOC_ALL_V',15);

Line: 362

    insert into HR_DM_EXP_HR_LOC_ALL_V (
      EXP_IMP_ID,
      TABLE_NAME,
      LOCATION_ID,
      LOCATION_CODE,
      BUSINESS_GROUP_ID,
      DESCRIPTION,
      SHIP_TO_LOCATION_ID,
      SHIP_TO_SITE_FLAG,
      RECEIVING_SITE_FLAG,
      BILL_TO_SITE_FLAG,
      IN_ORGANIZATION_FLAG,
      OFFICE_SITE_FLAG,
      DESIGNATED_RECEIVER_ID,
      INVENTORY_ORGANIZATION_ID,
      TAX_NAME,
      INACTIVE_DATE,
      STYLE,
      ADDRESS_LINE_1,
      ADDRESS_LINE_2,
      ADDRESS_LINE_3,
      TOWN_OR_CITY,
      COUNTRY,
      POSTAL_CODE,
      REGION_1,
      REGION_2,
      REGION_3,
      TELEPHONE_NUMBER_1,
      TELEPHONE_NUMBER_2,
      TELEPHONE_NUMBER_3,
      LOC_INFORMATION13,
      LOC_INFORMATION14,
      LOC_INFORMATION15,
      LOC_INFORMATION16,
      LOC_INFORMATION17,
      ATTRIBUTE_CATEGORY,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE15,
      ATTRIBUTE16,
      ATTRIBUTE17,
      ATTRIBUTE18,
      ATTRIBUTE19,
      ATTRIBUTE20,
      GLOBAL_ATTRIBUTE_CATEGORY,
      GLOBAL_ATTRIBUTE1,
      GLOBAL_ATTRIBUTE2,
      GLOBAL_ATTRIBUTE3,
      GLOBAL_ATTRIBUTE4,
      GLOBAL_ATTRIBUTE5,
      GLOBAL_ATTRIBUTE6,
      GLOBAL_ATTRIBUTE7,
      GLOBAL_ATTRIBUTE8,
      GLOBAL_ATTRIBUTE9,
      GLOBAL_ATTRIBUTE10,
      GLOBAL_ATTRIBUTE11,
      GLOBAL_ATTRIBUTE12,
      GLOBAL_ATTRIBUTE13,
      GLOBAL_ATTRIBUTE14,
      GLOBAL_ATTRIBUTE15,
      GLOBAL_ATTRIBUTE16,
      GLOBAL_ATTRIBUTE17,
      GLOBAL_ATTRIBUTE18,
      GLOBAL_ATTRIBUTE19,
      GLOBAL_ATTRIBUTE20,
      LAST_UPDATE_DATE,
      LAST_UPDATED_BY,
      LAST_UPDATE_LOGIN,
      CREATED_BY,
      CREATION_DATE,
      ENTERED_BY,
      TP_HEADER_ID,
      ECE_TP_LOCATION_CODE,
      OBJECT_VERSION_NUMBER)
      select
      hr_dm_exp_imps_s.nextval,
      'HR_LOCATIONS_ALL',
      LOCATION_ID,
      LOCATION_CODE,
      BUSINESS_GROUP_ID,
      DESCRIPTION,
      SHIP_TO_LOCATION_ID,
      SHIP_TO_SITE_FLAG,
      RECEIVING_SITE_FLAG,
      BILL_TO_SITE_FLAG,
      IN_ORGANIZATION_FLAG,
      OFFICE_SITE_FLAG,
      DESIGNATED_RECEIVER_ID,
      INVENTORY_ORGANIZATION_ID,
      TAX_NAME,
      to_char(INACTIVE_DATE,'YYYYMMDD HH24:MI:SS'),
      STYLE,
      ADDRESS_LINE_1,
      ADDRESS_LINE_2,
      ADDRESS_LINE_3,
      TOWN_OR_CITY,
      COUNTRY,
      POSTAL_CODE,
      REGION_1,
      REGION_2,
      REGION_3,
      TELEPHONE_NUMBER_1,
      TELEPHONE_NUMBER_2,
      TELEPHONE_NUMBER_3,
      LOC_INFORMATION13,
      LOC_INFORMATION14,
      LOC_INFORMATION15,
      LOC_INFORMATION16,
      LOC_INFORMATION17,
      ATTRIBUTE_CATEGORY,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE15,
      ATTRIBUTE16,
      ATTRIBUTE17,
      ATTRIBUTE18,
      ATTRIBUTE19,
      ATTRIBUTE20,
      GLOBAL_ATTRIBUTE_CATEGORY,
      GLOBAL_ATTRIBUTE1,
      GLOBAL_ATTRIBUTE2,
      GLOBAL_ATTRIBUTE3,
      GLOBAL_ATTRIBUTE4,
      GLOBAL_ATTRIBUTE5,
      GLOBAL_ATTRIBUTE6,
      GLOBAL_ATTRIBUTE7,
      GLOBAL_ATTRIBUTE8,
      GLOBAL_ATTRIBUTE9,
      GLOBAL_ATTRIBUTE10,
      GLOBAL_ATTRIBUTE11,
      GLOBAL_ATTRIBUTE12,
      GLOBAL_ATTRIBUTE13,
      GLOBAL_ATTRIBUTE14,
      GLOBAL_ATTRIBUTE15,
      GLOBAL_ATTRIBUTE16,
      GLOBAL_ATTRIBUTE17,
      GLOBAL_ATTRIBUTE18,
      GLOBAL_ATTRIBUTE19,
      GLOBAL_ATTRIBUTE20,
      to_char(last_update_date,'YYYYMMDD HH24:MI:SS'),
      LAST_UPDATED_BY,
      LAST_UPDATE_LOGIN,
      CREATED_BY,
      to_char(creation_date,'YYYYMMDD HH24:MI:SS'),
      ENTERED_BY,
      TP_HEADER_ID,
      ECE_TP_LOCATION_CODE,
      OBJECT_VERSION_NUMBER
    from HR_LOCATIONS_ALL
    where BUSINESS_GROUP_ID = l_business_group_id
      or BUSINESS_GROUP_ID is null;

Line: 544

  execute immediate 'delete HRDPV_UHR_LOCATIONS_ALL';

Line: 546

    hr_dm_utility.message('INFO','Inserting row(s) into HR_DM_EXP_HR_LOC_ALL_TL_V',15);

Line: 547

    insert into HR_DM_EXP_HR_LOC_ALL_TL_V (
      EXP_IMP_ID,
      TABLE_NAME,
      LOCATION_ID,
      LANGUAGE,
      SOURCE_LANG,
      LOCATION_CODE,
      DESCRIPTION,
      LAST_UPDATE_DATE,
      LAST_UPDATED_BY,
      LAST_UPDATE_LOGIN,
      CREATED_BY,
      CREATION_DATE)
      select
      hr_dm_exp_imps_s.nextval,
      'HR_LOCATIONS_ALL_TL',
      LOCATION_ID,
      LANGUAGE,
      SOURCE_LANG,
      LOCATION_CODE,
      DESCRIPTION,
      to_char(last_update_date,'YYYYMMDD HH24:MI:SS'),
      LAST_UPDATED_BY,
      LAST_UPDATE_LOGIN,
      CREATED_BY,
      to_char(creation_date,'YYYYMMDD HH24:MI:SS')
    from HR_LOCATIONS_ALL_TL
    where LOCATION_ID in (
      select LOCATION_ID
        from HR_LOCATIONS_ALL
        where BUSINESS_GROUP_ID = l_business_group_id)
      or LOCATION_ID in (
      select LOCATION_ID
        from HR_LOCATIONS_ALL
        where BUSINESS_GROUP_ID is null);

Line: 588

  execute immediate 'delete HRDPV_UHR_LOCATIONS_ALL_TL ' ||
                    'where p_LOCATION_ID in ( ' ||
                    '  select to_char(LOCATION_ID) ' ||
                    '    from HR_LOCATIONS_ALL ' ||
                    '    where BUSINESS_GROUP_ID = ' ||
                    l_business_group_id || ')';

Line: 594

  execute immediate 'delete HRDPV_UHR_LOCATIONS_ALL_TL ' ||
                    'where p_LOCATION_ID in ( ' ||
                    '  select to_char(LOCATION_ID) ' ||
                    '    from HR_LOCATIONS_ALL ' ||
                    '    where BUSINESS_GROUP_ID is null' || ')';

Line: 601

    hr_dm_utility.message('INFO','Inserting row(s) into HR_DM_EXP_ALL_ORG_UNITS_V',15);

Line: 603

    insert into HR_DM_EXP_ALL_ORG_UNITS_V (
      EXP_IMP_ID,
      TABLE_NAME,
      ORGANIZATION_ID,
      BUSINESS_GROUP_ID,
      COST_ALLOCATION_KEYFLEX_ID,
      LOCATION_ID,
      SOFT_CODING_KEYFLEX_ID,
      DATE_FROM,
      NAME,
      DATE_TO,
      INTERNAL_EXTERNAL_FLAG,
      INTERNAL_ADDRESS_LINE,
      TYPE,
      REQUEST_ID,
      PROGRAM_APPLICATION_ID,
      PROGRAM_ID,
      PROGRAM_UPDATE_DATE,
      ATTRIBUTE_CATEGORY,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE15,
      ATTRIBUTE16,
      ATTRIBUTE17,
      ATTRIBUTE18,
      ATTRIBUTE19,
      ATTRIBUTE20,
      LAST_UPDATE_DATE,
      LAST_UPDATED_BY,
      LAST_UPDATE_LOGIN,
      CREATED_BY,
      CREATION_DATE)
      select
      hr_dm_exp_imps_s.nextval,
      'HR_ALL_ORGANIZATION_UNITS',
      ORGANIZATION_ID,
      BUSINESS_GROUP_ID,
      COST_ALLOCATION_KEYFLEX_ID,
      LOCATION_ID,
      SOFT_CODING_KEYFLEX_ID,
      to_char(DATE_FROM,'YYYYMMDD HH24:MI:SS'),
      NAME,
      to_char(DATE_TO,'YYYYMMDD HH24:MI:SS'),
      INTERNAL_EXTERNAL_FLAG,
      INTERNAL_ADDRESS_LINE,
      TYPE,
      REQUEST_ID,
      PROGRAM_APPLICATION_ID,
      PROGRAM_ID,
      to_char(PROGRAM_UPDATE_DATE,'YYYYMMDD HH24:MI:SS'),
      ATTRIBUTE_CATEGORY,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE15,
      ATTRIBUTE16,
      ATTRIBUTE17,
      ATTRIBUTE18,
      ATTRIBUTE19,
      ATTRIBUTE20,
      to_char(last_update_date,'YYYYMMDD HH24:MI:SS'),
      last_updated_by,
      last_update_login,
      created_by,
      to_char(creation_date,'YYYYMMDD HH24:MI:SS')
    from HR_ALL_ORGANIZATION_UNITS
    where BUSINESS_GROUP_ID = l_business_group_id;

Line: 700

    execute immediate 'delete HRDPV_UHR_ALL_ORGANIZATONUNITS';

Line: 702

    hr_dm_utility.message('INFO','Inserting row(s) into HR_DM_EXP_ORG_INFO_V',15);

Line: 703

    insert into HR_DM_EXP_ORG_INFO_V (
      EXP_IMP_ID,
      TABLE_NAME,
      ORG_INFORMATION_ID,
      ORG_INFORMATION_CONTEXT,
      ORGANIZATION_ID,
      ORG_INFORMATION1,
      ORG_INFORMATION10,
      ORG_INFORMATION11,
      ORG_INFORMATION12,
      ORG_INFORMATION13,
      ORG_INFORMATION14,
      ORG_INFORMATION15,
      ORG_INFORMATION16,
      ORG_INFORMATION17,
      ORG_INFORMATION18,
      ORG_INFORMATION19,
      ORG_INFORMATION2,
      ORG_INFORMATION20,
      ORG_INFORMATION3,
      ORG_INFORMATION4,
      ORG_INFORMATION5,
      ORG_INFORMATION6,
      ORG_INFORMATION7,
      ORG_INFORMATION8,
      ORG_INFORMATION9,
      REQUEST_ID,
      PROGRAM_APPLICATION_ID,
      PROGRAM_ID,
      PROGRAM_UPDATE_DATE,
      ATTRIBUTE_CATEGORY,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE15,
      ATTRIBUTE16,
      ATTRIBUTE17,
      ATTRIBUTE18,
      ATTRIBUTE19,
      ATTRIBUTE20,
      LAST_UPDATE_DATE,
      LAST_UPDATED_BY,
      LAST_UPDATE_LOGIN,
      CREATED_BY,
      CREATION_DATE)
    select
      hr_dm_exp_imps_s.nextval,
      'HR_ORGANIZATION_INFORMATION',
      ORG_INFORMATION_ID,
      ORG_INFORMATION_CONTEXT,
      ORGANIZATION_ID,
      ORG_INFORMATION1,
      ORG_INFORMATION10,
      ORG_INFORMATION11,
      ORG_INFORMATION12,
      ORG_INFORMATION13,
      ORG_INFORMATION14,
      ORG_INFORMATION15,
      ORG_INFORMATION16,
      ORG_INFORMATION17,
      ORG_INFORMATION18,
      ORG_INFORMATION19,
      ORG_INFORMATION2,
      ORG_INFORMATION20,
      ORG_INFORMATION3,
      ORG_INFORMATION4,
      ORG_INFORMATION5,
      ORG_INFORMATION6,
      ORG_INFORMATION7,
      ORG_INFORMATION8,
      ORG_INFORMATION9,
      REQUEST_ID,
      PROGRAM_APPLICATION_ID,
      PROGRAM_ID,
      to_char(PROGRAM_UPDATE_DATE,'YYYYMMDD HH24:MI:SS'),
      ATTRIBUTE_CATEGORY,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE15,
      ATTRIBUTE16,
      ATTRIBUTE17,
      ATTRIBUTE18,
      ATTRIBUTE19,
      ATTRIBUTE20,
      to_char(last_update_date,'YYYYMMDD HH24:MI:SS'),
      last_updated_by,
      last_update_login,
      created_by,
      to_char(creation_date,'YYYYMMDD HH24:MI:SS')
    from HR_ORGANIZATION_INFORMATION
    where ORGANIZATION_ID in (
      select ORGANIZATION_ID
        from HR_ALL_ORGANIZATION_UNITS
        where BUSINESS_GROUP_ID = l_business_group_id);

Line: 826

  execute immediate 'delete HRDPV_UHR_ORGANIZATNINFORMATON ' ||
                    '  where p_ORGANIZATION_ID in ( ' ||
                    '    select to_char(ORGANIZATION_ID) ' ||
                    '      from HR_ALL_ORGANIZATION_UNITS ' ||
                    '      where BUSINESS_GROUP_ID = ' ||
                    l_business_group_id || ')';

Line: 833

    hr_dm_utility.message('INFO','Inserting row(s) into HR_DM_EXP_ALL_ORG_UNITS_TL_V',15);

Line: 834

    insert into HR_DM_EXP_ALL_ORG_UNITS_TL_V (
      EXP_IMP_ID,
      TABLE_NAME,
      ORGANIZATION_ID,
      LANGUAGE,
      SOURCE_LANG,
      NAME,
      LAST_UPDATE_DATE,
      LAST_UPDATED_BY,
      LAST_UPDATE_LOGIN,
      CREATED_BY,
      CREATION_DATE)
    select
      hr_dm_exp_imps_s.nextval,
      'HR_ALL_ORGANIZATION_UNITS_TL',
      ORGANIZATION_ID,
      LANGUAGE,
      SOURCE_LANG,
      NAME,
      to_char(last_update_date,'YYYYMMDD HH24:MI:SS'),
      last_updated_by,
      last_update_login,
      created_by,
      to_char(creation_date,'YYYYMMDD HH24:MI:SS')
    from HR_ALL_ORGANIZATION_UNITS_TL
    where ORGANIZATION_ID in (
      select ORGANIZATION_ID
        from HR_ALL_ORGANIZATION_UNITS
        where BUSINESS_GROUP_ID = l_business_group_id);

Line: 869

  execute immediate 'delete HRDPV_UHR_ALL_ORGANZTNUNITS_TL ' ||
                    '  where p_ORGANIZATION_ID in ( ' ||
                    '    select to_char(ORGANIZATION_ID) ' ||
                    '      from HR_ALL_ORGANIZATION_UNITS ' ||
                    '      where BUSINESS_GROUP_ID = ' ||
                    l_business_group_id || ')';

Line: 886

    select ID_FLEX_STRUCTURE_NAME
      into l_org_information4
      from fnd_id_flex_structures_vl
      where id_flex_num = (select org_information4
                             from hr_organization_information
                             where org_information_context =
                                                  'Business Group Information'
                               and organization_id = l_business_group_id)
        and ID_FLEX_CODE = 'GRD';

Line: 895

    select ID_FLEX_STRUCTURE_NAME
      into l_org_information5
      from fnd_id_flex_structures_vl
      where id_flex_num = (select org_information5
                             from hr_organization_information
                             where org_information_context =
                                                  'Business Group Information'
                               and organization_id = l_business_group_id)
        and ID_FLEX_CODE = 'GRP';

Line: 904

    select ID_FLEX_STRUCTURE_NAME
      into l_org_information6
      from fnd_id_flex_structures_vl
      where id_flex_num = (select org_information6
                             from hr_organization_information
                             where org_information_context =
                                                  'Business Group Information'
                               and organization_id = l_business_group_id)
        and ID_FLEX_CODE = 'JOB';

Line: 913

    select ID_FLEX_STRUCTURE_NAME
      into l_org_information7
      from fnd_id_flex_structures_vl
      where id_flex_num = (select org_information7
                             from hr_organization_information
                             where org_information_context =
                                                  'Business Group Information'
                               and organization_id = l_business_group_id)
        and ID_FLEX_CODE = 'COST';

Line: 922

    select ID_FLEX_STRUCTURE_NAME
      into l_org_information8
      from fnd_id_flex_structures_vl
      where id_flex_num = (select org_information8
                             from hr_organization_information
                             where org_information_context =
                                                  'Business Group Information'
                               and organization_id = l_business_group_id)
        and ID_FLEX_CODE = 'POS';

Line: 931

    select SECURITY_GROUP_KEY
      into l_org_information14
      from fnd_security_groups_vl
      where security_group_id = (select org_information14
                                   from hr_organization_information
                                   where org_information_context =
                                                  'Business Group Information'
                                     and organization_id = l_business_group_id);

Line: 940

    insert into hr_dm_exp_hr_org_inf_flx_v (
      EXP_IMP_ID,
      TABLE_NAME,
      ORG_INFORMATION4,
      ORG_INFORMATION5,
      ORG_INFORMATION6,
      ORG_INFORMATION7,
      ORG_INFORMATION8,
      ORG_INFORMATION14)
    select
      hr_dm_exp_imps_s.nextval,
      'HR_ORG_INF_FLX',
      l_org_information4,
      l_org_information5,
      l_org_information6,
      l_org_information7,
      l_org_information8,
      l_org_information14
    from dual;

Line: 968

    hr_dm_utility.message('INFO','Inserting row(s) into HR_DM_EXP_BEN_BATCH_PARAS_V',15);

Line: 969

    insert into HR_DM_EXP_BEN_BATCH_PARAS_V (
      EXP_IMP_ID,
      TABLE_NAME,
      BATCH_PARAMETER_ID,
      BATCH_EXE_CD,
      THREAD_CNT_NUM,
      MAX_ERR_NUM,
      CHUNK_SIZE,
      BUSINESS_GROUP_ID,
      LAST_UPDATE_DATE,
      LAST_UPDATED_BY,
      LAST_UPDATE_LOGIN,
      CREATED_BY,
      CREATION_DATE,
      OBJECT_VERSION_NUMBER)
    select
      hr_dm_exp_imps_s.nextval,
      'BEN_BATCH_PARAMETER',
      batch_parameter_id,
      batch_exe_cd,
      thread_cnt_num,
      max_err_num,
      chunk_size,
      business_group_id,
      to_char(last_update_date,'YYYYMMDD HH24:MI:SS'),
      last_updated_by,
      last_update_login,
      created_by,
      to_char(creation_date,'YYYYMMDD HH24:MI:SS'),
      object_version_number
    from BEN_BATCH_PARAMETER
    where business_group_id = l_business_group_id
      and batch_exe_cd = 'HRDM'
      and last_update_date >= nvl(p_last_migration_date,
                                  last_update_date);

Line: 1006

  execute immediate 'delete HRDPV_UBEN_BATCH_PARAMETER ' ||
                    '  where p_batch_exe_cd = ''HRDM''';

Line: 1063

  select migration_type,
         business_group_id,
         source_database_instance,
         destination_database_instance,
         hr_general.decode_lookup('HR_DM_MIGRATION_TYPE',migration_type),
         business_group_name,
         migration_start_date
    from hr_dm_exp_migrations_v;

Line: 1073

  select business_group_id
    from per_business_groups
  where business_group_id = l_business_group_id;

Line: 1078

  select upper(name)
    from v$database;

Line: 1082

  select phase_name
    from hr_dm_phase_rules
    where migration_type = l_migration_type
      and phase_name = 'UP';

Line: 1088

  select
    batch_exe_cd,
    thread_cnt_num,
    max_err_num,
    chunk_size,
    object_version_number
  from HR_DM_EXP_BEN_BATCH_PARAS_V
  where (business_group_id = to_char(l_business_group_id))
    and (batch_exe_cd = 'HRDM');

Line: 1099

  select
    batch_parameter_id
  from ben_batch_parameter
  where (business_group_id = l_business_group_id)
    and (batch_exe_cd = 'HRDM');

Line: 1202

  hr_utility.trace('  Truncating hr_dm_dt_deletes');

Line: 1204

                        '.hr_dm_dt_deletes');

Line: 1236

    hr_utility.trace('  Call delete hr_api_modules');

Line: 1238

    delete hr_api_modules
      where api_module_type = 'DM';

Line: 1246

    insert into hr_api_modules ( api_module_id
                                ,api_module_type
                                ,module_name
                                ,data_within_business_group
                                ,legislation_code
                                ,module_package
                                ,last_update_date
                                ,last_updated_by
                                ,last_update_login
                                ,created_by
                                ,creation_date )
                        select  api_module_id
                                ,api_module_type
                                ,module_name
                                ,data_within_business_group
                                ,legislation_code
                                ,module_package
                                ,to_date(last_update_date,'YYYYMMDD HH24:MI:SS')
                                ,last_updated_by
                                ,last_update_login
                                ,created_by
                                ,to_date(creation_date,'YYYYMMDD HH24:MI:SS')
                        from hr_dm_exp_api_modules_v;

Line: 1286

     hr_utility.trace('call insert into hr_dm_migrations');

Line: 1290

  select hr_dm_migrations_s.nextval
    into l_migration_id
    from dual;

Line: 1294

  insert into hr_dm_migrations ( migration_id
                                ,source_database_instance
                                ,destination_database_instance
                                ,migration_type
                                ,application_id
                                ,business_group_id
                                ,business_group_name
                                ,migration_start_date
                                ,migration_end_date
                                ,status
                                ,effective_date
                                ,migration_count
                                ,selective_migration_criteria
                                ,active_group
                                ,last_update_date
                                ,last_updated_by
                                ,last_update_login
                                ,created_by
                                ,creation_date )
                        select   l_migration_id
                                ,source_database_instance
                                ,destination_database_instance
                                ,migration_type
                                ,application_id
                                ,business_group_id
                                ,business_group_name
                                ,migration_start_date
                                ,migration_end_date
                                ,status
                                ,effective_date
                                ,migration_count
                                ,selective_migration_criteria
                                ,active_group
                                ,to_date(last_update_date,'YYYYMMDD HH24:MI:SS')
                                ,last_updated_by
                                ,last_update_login
                                ,created_by
                                ,to_date(creation_date,'YYYYMMDD HH24:MI:SS')
                        from hr_dm_exp_migrations_v;

Line: 1343

    insert into HR_LOCATIONS_ALL (
      LOCATION_ID,
      LOCATION_CODE,
      BUSINESS_GROUP_ID,
      DESCRIPTION,
      SHIP_TO_LOCATION_ID,
      SHIP_TO_SITE_FLAG,
      RECEIVING_SITE_FLAG,
      BILL_TO_SITE_FLAG,
      IN_ORGANIZATION_FLAG,
      OFFICE_SITE_FLAG,
      DESIGNATED_RECEIVER_ID,
      INVENTORY_ORGANIZATION_ID,
      TAX_NAME,
      INACTIVE_DATE,
      STYLE,
      ADDRESS_LINE_1,
      ADDRESS_LINE_2,
      ADDRESS_LINE_3,
      TOWN_OR_CITY,
      COUNTRY,
      POSTAL_CODE,
      REGION_1,
      REGION_2,
      REGION_3,
      TELEPHONE_NUMBER_1,
      TELEPHONE_NUMBER_2,
      TELEPHONE_NUMBER_3,
      LOC_INFORMATION13,
      LOC_INFORMATION14,
      LOC_INFORMATION15,
      LOC_INFORMATION16,
      LOC_INFORMATION17,
      ATTRIBUTE_CATEGORY,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE15,
      ATTRIBUTE16,
      ATTRIBUTE17,
      ATTRIBUTE18,
      ATTRIBUTE19,
      ATTRIBUTE20,
      GLOBAL_ATTRIBUTE_CATEGORY,
      GLOBAL_ATTRIBUTE1,
      GLOBAL_ATTRIBUTE2,
      GLOBAL_ATTRIBUTE3,
      GLOBAL_ATTRIBUTE4,
      GLOBAL_ATTRIBUTE5,
      GLOBAL_ATTRIBUTE6,
      GLOBAL_ATTRIBUTE7,
      GLOBAL_ATTRIBUTE8,
      GLOBAL_ATTRIBUTE9,
      GLOBAL_ATTRIBUTE10,
      GLOBAL_ATTRIBUTE11,
      GLOBAL_ATTRIBUTE12,
      GLOBAL_ATTRIBUTE13,
      GLOBAL_ATTRIBUTE14,
      GLOBAL_ATTRIBUTE15,
      GLOBAL_ATTRIBUTE16,
      GLOBAL_ATTRIBUTE17,
      GLOBAL_ATTRIBUTE18,
      GLOBAL_ATTRIBUTE19,
      GLOBAL_ATTRIBUTE20,
      last_update_date,
      LAST_UPDATED_BY,
      LAST_UPDATE_LOGIN,
      CREATED_BY,
      creation_date,
      ENTERED_BY,
      TP_HEADER_ID,
      ECE_TP_LOCATION_CODE,
      OBJECT_VERSION_NUMBER)
      select
      LOCATION_ID,
      LOCATION_CODE,
      BUSINESS_GROUP_ID,
      DESCRIPTION,
      SHIP_TO_LOCATION_ID,
      SHIP_TO_SITE_FLAG,
      RECEIVING_SITE_FLAG,
      BILL_TO_SITE_FLAG,
      IN_ORGANIZATION_FLAG,
      OFFICE_SITE_FLAG,
      DESIGNATED_RECEIVER_ID,
      INVENTORY_ORGANIZATION_ID,
      TAX_NAME,
      to_date(INACTIVE_DATE,'YYYYMMDD HH24:MI:SS'),
      STYLE,
      ADDRESS_LINE_1,
      ADDRESS_LINE_2,
      ADDRESS_LINE_3,
      TOWN_OR_CITY,
      COUNTRY,
      POSTAL_CODE,
      REGION_1,
      REGION_2,
      REGION_3,
      TELEPHONE_NUMBER_1,
      TELEPHONE_NUMBER_2,
      TELEPHONE_NUMBER_3,
      LOC_INFORMATION13,
      LOC_INFORMATION14,
      LOC_INFORMATION15,
      LOC_INFORMATION16,
      LOC_INFORMATION17,
      ATTRIBUTE_CATEGORY,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE15,
      ATTRIBUTE16,
      ATTRIBUTE17,
      ATTRIBUTE18,
      ATTRIBUTE19,
      ATTRIBUTE20,
      GLOBAL_ATTRIBUTE_CATEGORY,
      GLOBAL_ATTRIBUTE1,
      GLOBAL_ATTRIBUTE2,
      GLOBAL_ATTRIBUTE3,
      GLOBAL_ATTRIBUTE4,
      GLOBAL_ATTRIBUTE5,
      GLOBAL_ATTRIBUTE6,
      GLOBAL_ATTRIBUTE7,
      GLOBAL_ATTRIBUTE8,
      GLOBAL_ATTRIBUTE9,
      GLOBAL_ATTRIBUTE10,
      GLOBAL_ATTRIBUTE11,
      GLOBAL_ATTRIBUTE12,
      GLOBAL_ATTRIBUTE13,
      GLOBAL_ATTRIBUTE14,
      GLOBAL_ATTRIBUTE15,
      GLOBAL_ATTRIBUTE16,
      GLOBAL_ATTRIBUTE17,
      GLOBAL_ATTRIBUTE18,
      GLOBAL_ATTRIBUTE19,
      GLOBAL_ATTRIBUTE20,
      to_date(last_update_date,'YYYYMMDD HH24:MI:SS'),
      LAST_UPDATED_BY,
      LAST_UPDATE_LOGIN,
      CREATED_BY,
      to_date(creation_date,'YYYYMMDD HH24:MI:SS'),
      ENTERED_BY,
      TP_HEADER_ID,
      ECE_TP_LOCATION_CODE,
      OBJECT_VERSION_NUMBER
      from HR_DM_EXP_HR_LOC_ALL_V dmv
      where not exists (select null
                        from HR_LOCATIONS_ALL tb
                        where dmv.location_id = tb.LOCATION_ID);

Line: 1516

    insert into HR_LOCATIONS_ALL_TL (
      LOCATION_ID,
      LANGUAGE,
      SOURCE_LANG,
      LOCATION_CODE,
      DESCRIPTION,
      LAST_UPDATE_DATE,
      LAST_UPDATED_BY,
      LAST_UPDATE_LOGIN,
      CREATED_BY,
      CREATION_DATE)
      select
      LOCATION_ID,
      LANGUAGE,
      SOURCE_LANG,
      LOCATION_CODE,
      DESCRIPTION,
      to_date(last_update_date,'YYYYMMDD HH24:MI:SS'),
      LAST_UPDATED_BY,
      LAST_UPDATE_LOGIN,
      CREATED_BY,
      to_date(creation_date,'YYYYMMDD HH24:MI:SS')
      from HR_DM_EXP_HR_LOC_ALL_TL_V dmv
      where not exists (select null
                        from HR_LOCATIONS_ALL_TL tb
                        where dmv.location_id = tb.LOCATION_ID);

Line: 1547

    insert into HR_ALL_ORGANIZATION_UNITS (
      ORGANIZATION_ID,
      BUSINESS_GROUP_ID,
      COST_ALLOCATION_KEYFLEX_ID,
      LOCATION_ID,
      SOFT_CODING_KEYFLEX_ID,
      DATE_FROM,
      NAME,
      DATE_TO,
      INTERNAL_EXTERNAL_FLAG,
      INTERNAL_ADDRESS_LINE,
      TYPE,
      REQUEST_ID,
      PROGRAM_APPLICATION_ID,
      PROGRAM_ID,
      PROGRAM_UPDATE_DATE,
      ATTRIBUTE_CATEGORY,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE15,
      ATTRIBUTE16,
      ATTRIBUTE17,
      ATTRIBUTE18,
      ATTRIBUTE19,
      ATTRIBUTE20,
      LAST_UPDATE_DATE,
      LAST_UPDATED_BY,
      LAST_UPDATE_LOGIN,
      CREATED_BY,
      CREATION_DATE)
      select
      ORGANIZATION_ID,
      BUSINESS_GROUP_ID,
      COST_ALLOCATION_KEYFLEX_ID,
      LOCATION_ID,
      SOFT_CODING_KEYFLEX_ID,
      to_date(DATE_FROM,'YYYYMMDD HH24:MI:SS'),
      NAME,
      to_date(DATE_TO,'YYYYMMDD HH24:MI:SS'),
      INTERNAL_EXTERNAL_FLAG,
      INTERNAL_ADDRESS_LINE,
      TYPE,
      REQUEST_ID,
      PROGRAM_APPLICATION_ID,
      PROGRAM_ID,
      to_date(PROGRAM_UPDATE_DATE,'YYYYMMDD HH24:MI:SS'),
      ATTRIBUTE_CATEGORY,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE15,
      ATTRIBUTE16,
      ATTRIBUTE17,
      ATTRIBUTE18,
      ATTRIBUTE19,
      ATTRIBUTE20,
      to_date(last_update_date,'YYYYMMDD HH24:MI:SS'),
      last_updated_by,
      last_update_login,
      created_by,
      to_date(creation_date,'YYYYMMDD HH24:MI:SS')
    from HR_DM_EXP_ALL_ORG_UNITS_V;

Line: 1633

    insert into HR_ORGANIZATION_INFORMATION (
      ORG_INFORMATION_ID,
      ORG_INFORMATION_CONTEXT,
      ORGANIZATION_ID,
      ORG_INFORMATION1,
      ORG_INFORMATION10,
      ORG_INFORMATION11,
      ORG_INFORMATION12,
      ORG_INFORMATION13,
      ORG_INFORMATION14,
      ORG_INFORMATION15,
      ORG_INFORMATION16,
      ORG_INFORMATION17,
      ORG_INFORMATION18,
      ORG_INFORMATION19,
      ORG_INFORMATION2,
      ORG_INFORMATION20,
      ORG_INFORMATION3,
      ORG_INFORMATION4,
      ORG_INFORMATION5,
      ORG_INFORMATION6,
      ORG_INFORMATION7,
      ORG_INFORMATION8,
      ORG_INFORMATION9,
      REQUEST_ID,
      PROGRAM_APPLICATION_ID,
      PROGRAM_ID,
      PROGRAM_UPDATE_DATE,
      ATTRIBUTE_CATEGORY,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE15,
      ATTRIBUTE16,
      ATTRIBUTE17,
      ATTRIBUTE18,
      ATTRIBUTE19,
      ATTRIBUTE20,
      LAST_UPDATE_DATE,
      LAST_UPDATED_BY,
      LAST_UPDATE_LOGIN,
      CREATED_BY,
      CREATION_DATE)
    select
      ORG_INFORMATION_ID,
      ORG_INFORMATION_CONTEXT,
      ORGANIZATION_ID,
      ORG_INFORMATION1,
      ORG_INFORMATION10,
      ORG_INFORMATION11,
      ORG_INFORMATION12,
      ORG_INFORMATION13,
      ORG_INFORMATION14,
      ORG_INFORMATION15,
      ORG_INFORMATION16,
      ORG_INFORMATION17,
      ORG_INFORMATION18,
      ORG_INFORMATION19,
      ORG_INFORMATION2,
      ORG_INFORMATION20,
      ORG_INFORMATION3,
      ORG_INFORMATION4,
      ORG_INFORMATION5,
      ORG_INFORMATION6,
      ORG_INFORMATION7,
      ORG_INFORMATION8,
      ORG_INFORMATION9,
      REQUEST_ID,
      PROGRAM_APPLICATION_ID,
      PROGRAM_ID,
      to_date(PROGRAM_UPDATE_DATE,'YYYYMMDD HH24:MI:SS'),
      ATTRIBUTE_CATEGORY,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE15,
      ATTRIBUTE16,
      ATTRIBUTE17,
      ATTRIBUTE18,
      ATTRIBUTE19,
      ATTRIBUTE20,
      to_date(last_update_date,'YYYYMMDD HH24:MI:SS'),
      last_updated_by,
      last_update_login,
      created_by,
      to_date(creation_date,'YYYYMMDD HH24:MI:SS')
    from HR_DM_EXP_ORG_INFO_V;

Line: 1743

    insert into HR_ALL_ORGANIZATION_UNITS_TL (
      ORGANIZATION_ID,
      LANGUAGE,
      SOURCE_LANG,
      NAME,
      LAST_UPDATE_DATE,
      LAST_UPDATED_BY,
      LAST_UPDATE_LOGIN,
      CREATED_BY,
      CREATION_DATE)
    select
      ORGANIZATION_ID,
      LANGUAGE,
      SOURCE_LANG,
      NAME,
      to_date(last_update_date,'YYYYMMDD HH24:MI:SS'),
      last_updated_by,
      last_update_login,
      created_by,
      to_date(creation_date,'YYYYMMDD HH24:MI:SS')
    from HR_DM_EXP_ALL_ORG_UNITS_TL_V;

Line: 1765

    update hr_dm_migrations
      set business_group_created = 'Y'
      where migration_id = l_migration_id;

Line: 1795

        update BEN_BATCH_PARAMETER
          set batch_exe_cd = l_batch_exe_cd,
              thread_cnt_num =  l_thread_cnt_num,
              max_err_num = l_max_err_num,
              chunk_size = l_chunk_size,
              object_version_number = l_object_version_number
          where (business_group_id = l_business_group_id)
            and (batch_exe_cd = 'HRDM');

Line: 1805

        insert into BEN_BATCH_PARAMETER (
          BATCH_PARAMETER_ID,
          BATCH_EXE_CD,
          THREAD_CNT_NUM,
          MAX_ERR_NUM,
          CHUNK_SIZE,
          BUSINESS_GROUP_ID,
          LAST_UPDATE_DATE,
          LAST_UPDATED_BY,
          LAST_UPDATE_LOGIN,
          CREATED_BY,
          CREATION_DATE,
          OBJECT_VERSION_NUMBER)
        select
          batch_parameter_id,
          batch_exe_cd,
          thread_cnt_num,
          max_err_num,
          chunk_size,
          business_group_id,
          to_date(last_update_date,'YYYYMMDD HH24:MI:SS'),
          last_updated_by,
          last_update_login,
          created_by,
          to_date(creation_date,'YYYYMMDD HH24:MI:SS'),
          object_version_number
        from HR_DM_EXP_BEN_BATCH_PARAS_V;