APPS.HR_DM_MASTER SQL Statements

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

Line: 60

  SELECT MIGRATION_ID, UPPER(SOURCE_DATABASE_INSTANCE),
         UPPER(DESTINATION_DATABASE_INSTANCE),
         MIGRATION_TYPE, APPLICATION_ID, MIGRATION_COUNT, BUSINESS_GROUP_ID,
         STATUS
    FROM hr_dm_migrations
    WHERE (migration_id = p_migration_id);

Line: 68

  SELECT MAX(creation_date)
    FROM hr_dm_migration_requests
    WHERE (migration_id = p_migration_id);

Line: 74

  SELECT UPPER(name)
    FROM v$database;

Line: 114

  UPDATE hr_dm_migration_requests
    SET enabled_flag = 'N'
      WHERE ((migration_id = p_migration_id)
        AND (creation_date <> l_migration_date));

Line: 153

  UPDATE hr_dm_migrations
    SET migration_count = l_migration_count+1
    WHERE migration_id = p_migration_id;

Line: 166

    hr_dm_utility.update_migrations(p_new_status => 'E',
                                    p_id => p_migration_id);

Line: 174

  hr_dm_utility.update_migrations(p_new_status => 'S',
                                  p_id => p_migration_id);

Line: 232

PROCEDURE insert_request(p_phase IN VARCHAR2,
                         p_request_id IN NUMBER,
                         p_master_slave IN VARCHAR2 DEFAULT 'S',
                         p_migration_id IN NUMBER,
                         p_phase_id IN NUMBER DEFAULT NULL,
                         p_phase_item_id IN NUMBER DEFAULT NULL) IS
--

--
BEGIN
--

hr_dm_utility.message('ROUT','entry:hr_dm_master.insert_request', 5);

Line: 253

INSERT INTO hr_dm_migration_requests (migration_request_id,
                                      migration_id,
                                      phase_id,
                                      phase_item_id,
                                      request_id,
                                      enabled_flag,
                                      master_slave,
                                      last_updated_by,
                                      last_update_date,
                                      last_update_login,
                                      creation_date,
                                      created_by)
  SELECT hr_dm_migration_requests_s.nextval,
         p_migration_id,
         p_phase_id,
         p_phase_item_id,
         p_request_id,
         'Y',
         p_master_slave,
         1,
         sysdate,
         1,
         sysdate,
         1
    FROM sys.dual
    WHERE NOT EXISTS
      (SELECT NULL FROM hr_dm_migration_requests
         WHERE request_id = p_request_id);

Line: 284

hr_dm_utility.message('INFO','Inserted into hr_dm_migration_requests', 15);

Line: 285

hr_dm_utility.message('SUMM','Inserted into hr_dm_migration_requests', 20);

Line: 286

hr_dm_utility.message('ROUT','exit:hr_dm_master.insert_request', 25);

Line: 292

  hr_dm_utility.error(SQLCODE,'hr_dm_master.insert_request','(none)','R');

Line: 297

END insert_request;

Line: 388

  insert_request(p_phase => p_current_phase,
                 p_request_id => l_request_id,
                 p_master_slave => 'S',
                 p_migration_id => r_migration_data.migration_id,
                 p_phase_id => l_phase_id);

Line: 466

  SELECT request_id
    FROM hr_dm_migration_requests
    WHERE ((phase_id = l_phase_id)
      AND (master_slave = 'S')
      AND (enabled_flag = 'Y'));

Line: 568

  hr_dm_utility.update_phases(p_new_status => 'E',
                              p_id => hr_dm_utility.get_phase_id(
                                             p_current_phase, p_migration));

Line: 574

  hr_dm_utility.update_migrations(p_new_status => 'E', p_id => p_migration);

Line: 623

  SELECT NULL
    FROM hr_dm_phase_items
    WHERE phase_id = l_phase_id
      AND status <> 'C';

Line: 629

  SELECT phase_item_id, group_id
    FROM hr_dm_phase_items
    WHERE phase_id = l_phase_id;

Line: 634

  SELECT rpi.phase_item_id
    FROM hr_dm_phase_items rpi,
         hr_dm_migration_ranges mr
    WHERE rpi.group_id = l_group_id
      AND rpi.phase_id = l_range_phase_id
      AND rpi.phase_item_id = mr.phase_item_id
      AND mr.status <> 'C';

Line: 665

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

Line: 698

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

Line: 700

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

Line: 714

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

Line: 862

    hr_dm_utility.update_phases(p_new_status => 'S',
                              p_id => hr_dm_utility.get_phase_id(
                                            p_current_phase,
                                            r_migration_data.migration_id));

Line: 888

    hr_dm_delete.set_active(r_migration_data.migration_id);

Line: 889

    hr_dm_delete.pre_delete_process(r_migration_data);

Line: 1062

  SELECT phase_name, next_phase, database_location
    FROM hr_dm_phase_rules
    WHERE ((migration_type = r_migration_data.migration_type)
      AND (previous_phase = l_search_phase));

Line: 1068

  SELECT previous_phase, next_phase
    FROM hr_dm_phase_rules
    WHERE ((migration_type = r_migration_data.migration_type)
      AND (phase_name = l_request_data));

Line: 1074

  SELECT status
    FROM hr_dm_migrations
    WHERE migration_id = r_migration_data.migration_id;

Line: 1163

          hr_dm_utility.update_phases(p_new_status => 'S',
                                      p_id => hr_dm_utility.get_phase_id('CP'
                                        , r_migration_data.migration_id));

Line: 1173

            hr_dm_utility.update_phases(p_new_status => 'C',
                                     p_id => hr_dm_utility.get_phase_id('CP'
                                          , r_migration_data.migration_id));

Line: 1191

        hr_dm_utility.update_migrations(p_new_status => 'E',
                                        p_id => p_migration_id);

Line: 1236

  UPDATE hr_dm_migrations
  SET status = 'F'
    WHERE migration_id = r_migration_data.migration_id;