The following lines contain the word 'select', 'insert', 'update' or 'delete':
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);
SELECT MAX(creation_date)
FROM ben_dm_migration_requests
WHERE (migration_id = p_migration_id);
UPDATE ben_dm_migration_requests
SET enabled_flag = 'N'
WHERE ((migration_id = p_migration_id)
AND (creation_date <> l_migration_date));
UPDATE ben_dm_migrations
SET migration_count = l_migration_count+1
WHERE migration_id = p_migration_id;
ben_dm_utility.update_migrations(p_new_status => 'E',
p_id => p_migration_id);
ben_dm_utility.update_migrations(p_new_status => 'S',
p_id => p_migration_id);
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);
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);
ben_dm_utility.message('INFO','Inserted into ben_dm_migration_requests', 15);
ben_dm_utility.message('SUMM','Inserted into ben_dm_migration_requests', 20);
ben_dm_utility.message('ROUT','exit:ben_dm_master.insert_request', 25);
ben_dm_utility.error(SQLCODE,'ben_dm_master.insert_request','(none)','R');
END insert_request;
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);
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';
ben_dm_utility.update_phases(p_new_status => 'E',
p_id => ben_dm_utility.get_phase_id(
p_current_phase, p_migration));
ben_dm_utility.update_migrations(p_new_status => 'E', p_id => p_migration);
SELECT NULL
FROM ben_dm_phase_items
WHERE phase_id = l_phase_id
AND status <> 'C';
SELECT phase_item_id, group_order
FROM ben_dm_phase_items
WHERE phase_id = l_phase_id;
ben_dm_utility.update_phases(p_new_status => 'C',
p_id => l_phase_id);
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));
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));
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;
SELECT previous_phase, next_phase
FROM hr_dm_phase_rules
WHERE ((migration_type = 'SP')
AND (phase_name = l_request_data));
SELECT status
FROM ben_dm_migrations
WHERE migration_id = r_migration_data.migration_id;
SELECT ben_dm_migrations_s.nextval
INTO l_migration_id
FROM dual;
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'
);
select fnd_global.conc_request_id
into l_request_id
from dual;
ben_dm_utility.message('INFO','Problem with Inserting into BEN_DM_MIGRATION_REQUESTS', 15);
ben_dm_utility.message('SUMM','Problem with Inserting into BEN_DM_MIGRATION_REQUESTS', 20);
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
);
SELECT ben_dm_migrations_s.nextval
INTO l_migration_id
FROM dual;
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'
);
select fnd_global.conc_request_id
into l_request_id
from dual;
ben_dm_utility.message('INFO','Problem with Inserting into BEN_DM_MIGRATION_REQUESTS', 15);
ben_dm_utility.message('SUMM','Problem with Inserting into BEN_DM_MIGRATION_REQUESTS', 20);
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
);
select fnd_global.conc_request_id
into l_request_id
from dual;
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
);
select migration_id
into l_migration_id
from ben_dm_migration_requests
where request_id = fnd_global.conc_request_id;
ben_dm_utility.update_phases(p_new_status => 'S',
p_id => ben_dm_utility.get_phase_id('CF'
, r_migration_data.migration_id));
ben_dm_utility.update_phases(p_new_status => 'C',
p_id => ben_dm_utility.get_phase_id('CF'
, r_migration_data.migration_id));
ben_dm_utility.update_phases(p_new_status => 'S',
p_id => ben_dm_utility.get_phase_id('RC'
, r_migration_data.migration_id));
ben_dm_utility.update_phases(p_new_status => 'C',
p_id => ben_dm_utility.get_phase_id('RC'
,r_migration_data.migration_id));
ben_dm_utility.update_migrations(p_new_status => 'E',
p_id => l_migration_id);