APPS.HR_DM_AOL_UP SQL Statements

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

Line: 69

  SELECT lp.loader_name,
         lp.loader_conc_program,
         lp.loader_config_file,
         lp.loader_application,
         lp.parameter_1, lp.parameter_2,
         lp.parameter_3, lp.parameter_4,
         lp.parameter_5, lp.parameter_6,
         lp.parameter_7, lp.parameter_8,
         lp.parameter_9, lp.parameter_10,
         lp.application_id,
         lp.filename
  FROM hr_dm_loader_phase_items lp,
       hr_dm_phase_items pi
  WHERE pi.phase_item_id = p_phase_item_id
    AND pi.phase_item_id = lp.ua_phase_item_id;

Line: 86

  SELECT sg.security_group_key
  FROM hr_dm_migrations dm,
       fnd_security_groups sg,
       per_business_groups pbg
  WHERE dm.migration_id = p_migration_id
    AND dm.business_group_id = pbg.business_group_id
    AND pbg.security_group_id = sg.security_group_id;

Line: 225

IF (l_parameter1 = ':selective') THEN l_parameter1 := null;

Line: 226

ELSIF (l_parameter2 = ':selective') THEN l_parameter2 := null;

Line: 227

ELSIF (l_parameter3 = ':selective') THEN l_parameter3 := null;

Line: 228

ELSIF (l_parameter4 = ':selective') THEN l_parameter4 := null;

Line: 229

ELSIF (l_parameter5 = ':selective') THEN l_parameter5 := null;

Line: 230

ELSIF (l_parameter6 = ':selective') THEN l_parameter6 := null;

Line: 231

ELSIF (l_parameter7 = ':selective') THEN l_parameter7 := null;

Line: 232

ELSIF (l_parameter8 = ':selective') THEN l_parameter8 := null;

Line: 233

ELSIF (l_parameter9 = ':selective') THEN l_parameter9 := null;

Line: 234

ELSIF (l_parameter10 = ':selective') THEN l_parameter10 := null;

Line: 266

SELECT DESTINATION_DATABASE_INSTANCE
  INTO l_destination_database
  FROM HR_DM_MIGRATIONS
  WHERE migration_id = p_migration_id;

Line: 362

SELECT business_group_id
  INTO l_business_group_id
  FROM hr_dm_migrations
  WHERE migration_id = p_migration_id;

Line: 368

SELECT ORG_INFORMATION4,
       ORG_INFORMATION5,
       ORG_INFORMATION6,
       ORG_INFORMATION7,
       ORG_INFORMATION8,
       ORG_INFORMATION14
  INTO l_org_information4,
       l_org_information5,
       l_org_information6,
       l_org_information7,
       l_org_information8,
       l_org_information14
  FROM hr_dm_exp_hr_org_inf_flx_v;

Line: 382

SELECT ID_FLEX_NUM
  INTO l_org_information4_id
  FROM fnd_id_flex_structures_vl
  WHERE ID_FLEX_STRUCTURE_NAME = l_org_information4
    AND ID_FLEX_CODE = 'GRD';

Line: 387

SELECT ID_FLEX_NUM
  INTO l_org_information5_id
  FROM fnd_id_flex_structures_vl
  WHERE ID_FLEX_STRUCTURE_NAME = l_org_information5
    AND ID_FLEX_CODE = 'GRP';

Line: 392

SELECT ID_FLEX_NUM
  INTO l_org_information6_id
  FROM fnd_id_flex_structures_vl
  WHERE ID_FLEX_STRUCTURE_NAME = l_org_information6
    AND ID_FLEX_CODE = 'JOB';

Line: 397

SELECT ID_FLEX_NUM
  INTO l_org_information7_id
  FROM fnd_id_flex_structures_vl
  WHERE ID_FLEX_STRUCTURE_NAME = l_org_information7
    AND ID_FLEX_CODE = 'COST';

Line: 402

SELECT ID_FLEX_NUM
  INTO l_org_information8_id
  FROM fnd_id_flex_structures_vl
  WHERE ID_FLEX_STRUCTURE_NAME = l_org_information8
    AND ID_FLEX_CODE = 'POS';

Line: 407

SELECT security_group_id
  INTO l_org_information14_id
  FROM fnd_security_groups_vl
  WHERE security_group_key = l_org_information14;

Line: 412

UPDATE hr_organization_information
  SET ORG_INFORMATION4 = l_org_information4_id,
      ORG_INFORMATION5 = l_org_information5_id,
      ORG_INFORMATION6 = l_org_information6_id,
      ORG_INFORMATION7 = l_org_information7_id,
      ORG_INFORMATION8 = l_org_information8_id,
      ORG_INFORMATION14 = l_org_information14_id
  WHERE ORG_INFORMATION_CONTEXT = 'Business Group Information'
    AND ORGANIZATION_ID = l_business_group_id;

Line: 513

l_selective_mc                     VARCHAR2(2000);

Line: 517

  SELECT pi.phase_item_id,
         pi.status
    FROM hr_dm_phase_items pi
    WHERE (pi.status = 'NS')
      AND (pi.phase_id = l_phase_id)
      AND (pi.loader_name = l_loader_group)
    ORDER BY pi.phase_item_id;

Line: 526

  SELECT tbl.loader_name
    FROM hr_dm_groups grp,
         hr_dm_application_groups apg,
         hr_dm_table_groupings tbg,
         hr_dm_tables tbl,
         hr_dm_migrations mig
    WHERE tbl.table_id = tbg.table_id
      AND tbg.group_id = grp.group_id
      AND grp.group_type = 'A'
      AND grp.group_id = apg.group_id
      AND apg.application_id = mig.application_id
      AND apg.migration_type = mig.migration_type
      AND mig.migration_id = p_migration_id;

Line: 541

  SELECT source_database_instance,
         destination_database_instance,
         migration_type,
         hr_general.decode_lookup('HR_DM_MIGRATION_TYPE',
                                  migration_type),
         business_group_id,
         business_group_name,
         selective_migration_criteria
  FROM hr_dm_migrations
  WHERE migration_id = p_migration_id;

Line: 612

  l_selective_mc;

Line: 623

SELECT to_char(sysdate,'HH:MI  DD-MON-YYYY')
  INTO l_sysdate
  FROM dual;

Line: 634

utl_file.put_line(l_filehandle, '#  Selective Migration Criteria');

Line: 636

                                    NVL(SUBSTR(l_selective_mc,1,240),'(Not Applicable)'));

Line: 670

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

Line: 680

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

Line: 704

SELECT DESTINATION_DATABASE_INSTANCE
  INTO l_destination_database
  FROM HR_DM_MIGRATIONS
  WHERE migration_id = p_migration_id;

Line: 746

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

Line: 755

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

Line: 763

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