APPS.BEN_DM_MASTER SQL Statements

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

Line: 65

  SELECT MIGRATION_ID, MIGRATION_NAME,
         INPUT_PARAMATER_FILE_NAME,
         INPUT_PARAMETER_FILE_PATH,
         DATA_FILE_NAME,
         DATA_FILE_PATH,
         MIGRATION_COUNT,
         DATABASE_LOCATION,
         STATUS
    FROM ben_dm_migrations
    WHERE (migration_id = p_migration_id);

Line: 77

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

Line: 122

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

Line: 145

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

Line: 158

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

Line: 166

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

Line: 257

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
--

ben_dm_utility.message('ROUT','entry:ben_dm_master.insert_request', 5);

Line: 278

INSERT INTO ben_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 ben_dm_migration_requests_s.nextval,
         p_migration_id,
         nvl(p_phase_id,-1),
         nvl(p_phase_item_id,-1),
         p_request_id,
         'Y',
         p_master_slave,
         1,
         sysdate,
         1,
         sysdate,
         1
    FROM sys.dual
    WHERE NOT EXISTS
      (SELECT NULL FROM ben_dm_migration_requests
         WHERE request_id = p_request_id);

Line: 309

ben_dm_utility.message('INFO','Inserted into ben_dm_migration_requests', 15);

Line: 310

ben_dm_utility.message('SUMM','Inserted into ben_dm_migration_requests', 20);

Line: 311

ben_dm_utility.message('ROUT','exit:ben_dm_master.insert_request', 25);

Line: 317

  ben_dm_utility.error(SQLCODE,'ben_dm_master.insert_request','(none)','R');

Line: 322

END insert_request;

Line: 499

  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: 576

  SELECT request_id
    FROM ben_dm_migration_requests
   WHERE migration_id = p_migration_id
     AND phase_id = p_phase_id
     AND master_slave = 'S'
     AND enabled_flag = 'Y';

Line: 682

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

Line: 688

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

Line: 737

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

Line: 743

  SELECT phase_item_id, group_order
    FROM ben_dm_phase_items
    WHERE phase_id = l_phase_id;

Line: 773

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

Line: 921

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

Line: 960

     ben_dm_utility.update_phases(p_new_status => l_current_phase_status,
                                   p_id => ben_dm_utility.get_phase_id(p_current_phase, r_migration_data.migration_id));

Line: 1104

  SELECT phase_name, next_phase, database_location
    FROM hr_dm_phase_rules
    WHERE ((migration_type = 'SP')
      AND (previous_phase = l_search_phase))
        AND database_location like l_db_loc;

Line: 1111

  SELECT previous_phase, next_phase
    FROM hr_dm_phase_rules
    WHERE ((migration_type = 'SP')
      AND (phase_name = l_request_data));

Line: 1117

  SELECT status
    FROM ben_dm_migrations
    WHERE migration_id = r_migration_data.migration_id;

Line: 1165

   SELECT ben_dm_migrations_s.nextval
     INTO l_migration_id
     FROM dual;

Line: 1169

   INSERT INTO ben_dm_migrations
      (migration_id
      ,migration_name
      ,source_migration_id
      ,input_parameter_file_path
      ,input_paramater_file_name
      ,Data_file_path
      ,Data_file_name
      ,migration_start_date
      ,migration_end_date
      ,status
      ,migration_type
      ,effective_date
      ,migration_count
      ,last_updated_by
      ,last_update_date
      ,last_update_login
      ,creation_date
      ,created_by
      ,database_location
      )
   VALUES
      (l_migration_id
      ,p_migration_name
      ,NULL
      ,p_input_file_path
      ,nvl(p_input_file_name,'null')
      ,p_output_file_path
      ,p_output_file_name
      ,SYSDATE
      ,NULL
      ,'NS'
      ,NULL
      ,SYSDATE
      ,0
      ,fnd_global.user_id
      ,SYSDATE
      ,fnd_global.user_id
      ,SYSDATE
      ,fnd_global.user_id
      ,'S'
      );

Line: 1214

  select fnd_global.conc_request_id
    into l_request_id
  from dual;

Line: 1219

    ben_dm_utility.message('INFO','Problem with Inserting into BEN_DM_MIGRATION_REQUESTS', 15);

Line: 1220

    ben_dm_utility.message('SUMM','Problem with Inserting into BEN_DM_MIGRATION_REQUESTS', 20);

Line: 1227

    INSERT INTO ben_dm_migration_requests
           (migration_request_id
           ,phase_id
           ,phase_item_id
           ,migration_id
           ,request_id
           ,master_slave
           ,enabled_flag
           ,last_update_date
           ,last_updated_by
           ,last_update_login
           ,created_by
           ,creation_date
           )
        VALUES
           (ben_dm_migration_requests_s.nextval
           ,-1
           ,-1
           ,l_migration_id
           ,l_request_id
           ,'M'
           ,'Y'
           ,SYSDATE
           ,fnd_global.user_id
           ,fnd_global.login_id
           ,fnd_global.user_id
           ,SYSDATE
           );

Line: 1304

   SELECT ben_dm_migrations_s.nextval
     INTO l_migration_id
     FROM dual;

Line: 1308

   INSERT INTO ben_dm_migrations
      (migration_id
      ,migration_name
      ,source_migration_id
      ,input_parameter_file_path
      ,input_paramater_file_name
      ,Data_file_path
      ,Data_file_name
      ,migration_start_date
      ,migration_end_date
      ,status
      ,migration_type
      ,effective_date
      ,migration_count
      ,last_updated_by
      ,last_update_date
      ,last_update_login
      ,creation_date
      ,created_by
      ,database_location
      )
   VALUES
      (l_migration_id
      ,p_migration_name
      ,NULL
      ,p_input_file_path
      ,nvl(p_input_file_name,'null')
      ,p_output_file_path
      ,p_output_file_name
      ,SYSDATE
      ,NULL
      ,'NS'
      ,NULL
      ,SYSDATE
      ,0
      ,fnd_global.user_id
      ,SYSDATE
      ,fnd_global.user_id
      ,SYSDATE
      ,fnd_global.user_id
      ,'D'
      );

Line: 1353

  select fnd_global.conc_request_id
    into l_request_id
  from dual;

Line: 1358

    ben_dm_utility.message('INFO','Problem with Inserting into BEN_DM_MIGRATION_REQUESTS', 15);

Line: 1359

    ben_dm_utility.message('SUMM','Problem with Inserting into BEN_DM_MIGRATION_REQUESTS', 20);

Line: 1366

    INSERT INTO ben_dm_migration_requests
           (migration_request_id
           ,phase_id
           ,phase_item_id
           ,migration_id
           ,request_id
           ,master_slave
           ,enabled_flag
           ,last_update_date
           ,last_updated_by
           ,last_update_login
           ,created_by
           ,creation_date
           )
        VALUES
           (ben_dm_migration_requests_s.nextval
           ,-1
           ,-1
           ,l_migration_id
           ,l_request_id
           ,'M'
           ,'Y'
           ,SYSDATE
           ,fnd_global.user_id
           ,fnd_global.login_id
           ,fnd_global.user_id
           ,SYSDATE
           );

Line: 1424

  select fnd_global.conc_request_id
    into l_request_id
  from dual;

Line: 1433

    INSERT INTO ben_dm_migration_requests
           (migration_request_id
           ,phase_id
           ,phase_item_id
           ,migration_id
           ,request_id
           ,master_slave
           ,enabled_flag
           ,last_update_date
           ,last_updated_by
           ,last_update_login
           ,created_by
           ,creation_date
           )
        VALUES
           (ben_dm_migration_requests_s.nextval
           ,-1
           ,-1
           ,l_migration_id
           ,l_request_id
           ,'M'
           ,'Y'
           ,SYSDATE
           ,fnd_global.user_id
           ,fnd_global.login_id
           ,fnd_global.user_id
           ,SYSDATE
           );

Line: 1469

  select migration_id
    into l_migration_id
    from ben_dm_migration_requests
   where request_id = fnd_global.conc_request_id;

Line: 1559

          ben_dm_utility.update_phases(p_new_status => 'S',
                                      p_id => ben_dm_utility.get_phase_id('CF'
                                        , r_migration_data.migration_id));

Line: 1567

          ben_dm_utility.update_phases(p_new_status => 'C',
                                      p_id => ben_dm_utility.get_phase_id('CF'
                                        , r_migration_data.migration_id));

Line: 1572

          ben_dm_utility.update_phases(p_new_status => 'S',
                                      p_id => ben_dm_utility.get_phase_id('RC'
                                        , r_migration_data.migration_id));

Line: 1580

          ben_dm_utility.update_phases(p_new_status => 'C',
                                      p_id => ben_dm_utility.get_phase_id('RC'
                                     ,r_migration_data.migration_id));

Line: 1603

        ben_dm_utility.update_migrations(p_new_status => 'E',
                                        p_id => l_migration_id);