The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT cn_column_maps_s.nextval, cn_objects_s.nextval
INTO X_column_map_id, X_destination_column_id
FROM dual;
SELECT cn_column_maps_s.nextval, cn_objects_s.nextval
INTO X_tmp_column_map_id, X_tmp_dest_column_id
FROM dual;
SELECT cn_column_maps_s.nextval, cn_objects_s.nextval
INTO X_rup_column_map_id, X_rup_dest_column_id
FROM dual;
SELECT col.name, dim.name
INTO X_column_name, X_dimension_name
FROM cn_obj_columns_v col,
cn_dimensions dim
WHERE col.column_id = X_source_column_id
AND col.dimension_id = dim.dimension_id (+);
SELECT name
INTO X_dest_column_name
FROM cn_obj_columns_v
WHERE column_id = X_dest_column_id;
PROCEDURE Insert_Row ( X_table_map_id number,
X_column_map_id number,
X_source_column_id number,
X_group_by_flag varchar,
X_destination_column_id number,
X_column_name varchar,
X_repository_id number,
X_table_id number,
X_tmp_table_map_id number,
X_tmp_table_id number,
X_tmp_column_map_id number,
X_tmp_dest_column_id number,
X_rup_table_map_id number,
X_rup_table_id number,
X_rup_column_map_id number,
X_rup_dest_column_id number) IS
BEGIN
INSERT INTO cn_column_maps (table_map_id, column_map_id,
source_column_id, group_by_flag,
destination_column_id)
VALUES (X_table_map_id, X_column_map_id,
X_source_column_id, X_group_by_flag,
X_destination_column_id);
INSERT INTO cn_obj_columns_v (column_id, name, dependency_map_complete,
status, repository_id, table_id, data_length,
data_type, nullable, primary_key, position,
dimension_id, data_scale, column_type, object_type)
(SELECT X_destination_column_id, X_column_name, 'N',
'V', X_repository_id, X_table_id, data_length,
data_type, nullable, 'N', position,
dimension_id, data_scale, column_type, 'COL'
FROM cn_obj_columns_v WHERE column_id = X_source_column_id);
INSERT INTO cn_column_maps (table_map_id, column_map_id,
source_column_id, group_by_flag,
destination_column_id)
VALUES (X_tmp_table_map_id, X_tmp_column_map_id,
X_source_column_id, X_group_by_flag,
X_tmp_dest_column_id);
INSERT INTO cn_obj_columns_v (column_id, name, dependency_map_complete,
status, repository_id, table_id, data_length,
data_type, nullable, primary_key, position,
dimension_id, data_scale, column_type, object_type)
(SELECT X_tmp_dest_column_id, X_column_name, 'N',
'V', X_repository_id, X_tmp_table_id, data_length,
data_type, nullable, 'N', position,
dimension_id, data_scale, column_type, 'COL'
FROM cn_obj_columns_v WHERE column_id = X_source_column_id);
INSERT INTO cn_column_maps (table_map_id, column_map_id,
source_column_id, group_by_flag,
destination_column_id)
VALUES (X_rup_table_map_id, X_rup_column_map_id,
X_source_column_id, X_group_by_flag,
X_rup_dest_column_id);
INSERT INTO cn_obj_columns_v (column_id, name, dependency_map_complete,
status, repository_id, table_id, data_length,
data_type, nullable, primary_key, position,
dimension_id, data_scale, column_type, object_type)
(SELECT X_rup_dest_column_id, X_column_name, 'N',
'V', X_repository_id, X_rup_table_id, data_length,
data_type, nullable, 'N', position,
dimension_id, data_scale, column_type, 'COL'
FROM cn_obj_columns_v WHERE column_id = X_source_column_id);
END Insert_Row;
PROCEDURE Delete_Row ( X_column_map_id number,
X_destination_column_id number,
X_tmp_column_map_id number,
X_tmp_dest_column_id number,
X_rup_column_map_id number,
X_rup_dest_column_id number) IS
BEGIN
DELETE cn_column_maps WHERE column_map_id = X_column_map_id;
DELETE cn_obj_columns_v WHERE column_id = X_destination_column_id;
DELETE cn_column_maps WHERE column_map_id = X_tmp_column_map_id;
DELETE cn_obj_columns_v WHERE column_id = X_tmp_dest_column_id;
DELETE cn_column_maps WHERE column_map_id = X_rup_column_map_id;
DELETE cn_obj_columns_v WHERE column_id = X_rup_dest_column_id;
END Delete_Row;