APPS.HR_DM_AOL_DOWN SQL Statements

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

Line: 43

l_selective VARCHAR2(2000);

Line: 63

l_selective_migration_criteria VARCHAR2(2000);

Line: 70

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

Line: 87

  SELECT dm.migration_type,
         dm.selective_migration_criteria,
         dm.business_group_id,
         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: 192

                              l_selective_migration_criteria,
                              l_business_group_id,
                              l_security_group;

Line: 197

l_selective := null;

Line: 199

  l_selective := 'DESCRIPTIVE_FLEXFIELD_NAME=' ||
                 l_selective_migration_criteria;

Line: 203

  l_selective := 'LOOKUP_TYPE=' ||
                 l_selective_migration_criteria;

Line: 208

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

Line: 209

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

Line: 210

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

Line: 211

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

Line: 212

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

Line: 213

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

Line: 214

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

Line: 215

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

Line: 216

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

Line: 217

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

Line: 284

SELECT source_database_instance
  INTO l_source_database
  FROM HR_DM_MIGRATIONS
  WHERE migration_id = p_migration_id;

Line: 303

INSERT INTO HR_DM_AOL_DOWN_V
  (
   exp_imp_id
  ,table_name
  ,migration_id
  ,phase_item_id
  ,code
  )
  SELECT
   hr_dm_exp_imps_s.nextval
  ,'HR_DM_AOL_DOWN_V'
  ,p_migration_id
  ,p_phase_item_id
  ,l_aol_command
  FROM dual;

Line: 325

hr_dm_master.insert_request(p_phase => 'DA',
                            p_request_id => l_request_id,
                            p_master_slave => 'S',
                            p_migration_id => p_migration_id,
                            p_phase_id => p_phase_id,
                            p_phase_item_id => p_phase_item_id);

Line: 452

  SELECT pi.phase_item_id, pi.loader_name, pi.status
    FROM hr_dm_phase_items pi,
         hr_dm_tables tbl
    WHERE (pi.status = 'NS')
      AND (pi.phase_id = l_phase_id)
      AND (pi.loader_name = tbl.loader_name)
      AND ((MOD(pi.phase_item_id, l_no_of_threads) + 1) = p_process_number);

Line: 462

  SELECT request_id
    FROM hr_dm_migration_requests
    WHERE phase_item_id = l_phase_item_id
      AND enabled_flag = 'Y';

Line: 469

  SELECT business_group_id
    FROM hr_dm_migrations
    WHERE migration_id = p_migration_id;

Line: 529

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

Line: 535

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

Line: 566

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

Line: 617

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

Line: 626

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

Line: 634

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