APPS.CNDISL_SLICE_ATTRIBUTES_PKG SQL Statements

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

Line: 15

  SELECT cn_column_maps_s.nextval, cn_objects_s.nextval
	INTO X_column_map_id, X_destination_column_id
	FROM dual;

Line: 19

  SELECT cn_column_maps_s.nextval, cn_objects_s.nextval
	INTO X_tmp_column_map_id, X_tmp_dest_column_id
	FROM dual;

Line: 23

  SELECT cn_column_maps_s.nextval, cn_objects_s.nextval
	INTO X_rup_column_map_id, X_rup_dest_column_id
	FROM dual;

Line: 37

  SELECT col.name
	INTO X_column_name
	FROM cn_obj_columns_v col
	WHERE col.column_id = X_source_column_id;

Line: 42

  SELECT name
	INTO X_dest_column_name
	FROM cn_obj_columns_v
	WHERE column_id = X_dest_column_id;

Line: 51

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_aggregate_function	varchar,
			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

  -- Slice table definition --

  INSERT INTO cn_column_maps (	table_map_id,
			      	column_map_id,
				source_column_id,
				group_by_flag,
				destination_column_id,
				aggregate_function)
	VALUES (X_table_map_id, X_column_map_id,
				X_source_column_id,
				X_group_by_flag,
				X_destination_column_id,
				X_aggregate_function);

Line: 85

  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,
		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,
		data_scale, column_type, 'COL'
	FROM cn_obj_columns_v WHERE column_id = X_source_column_id);

Line: 97

  INSERT INTO cn_column_maps (	table_map_id,
			      	column_map_id,
				source_column_id,
				group_by_flag,
				destination_column_id,
				aggregate_function)
	VALUES (X_tmp_table_map_id, X_tmp_column_map_id,
				X_source_column_id,
				X_group_by_flag,
				X_tmp_dest_column_id,
				X_aggregate_function);

Line: 109

  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,
		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,
		data_scale, column_type, 'COL'
	FROM cn_obj_columns_v WHERE column_id = X_source_column_id);

Line: 121

  INSERT INTO cn_column_maps (	table_map_id,
			      	column_map_id,
				source_column_id,
				group_by_flag,
				destination_column_id,
				aggregate_function)
	VALUES (X_rup_table_map_id, X_rup_column_map_id,
				X_source_column_id,
				X_group_by_flag,
				X_rup_dest_column_id,
				X_aggregate_function);

Line: 133

  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,
		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,
		data_scale, column_type, 'COL'
	FROM cn_obj_columns_v WHERE column_id = X_source_column_id);

Line: 143

END Insert_Row;

Line: 147

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;

Line: 157

  DELETE cn_obj_columns_v WHERE column_id = X_destination_column_id;

Line: 159

  DELETE cn_column_maps WHERE column_map_id = X_tmp_column_map_id;

Line: 160

  DELETE cn_obj_columns_v WHERE column_id = X_tmp_dest_column_id;

Line: 162

  DELETE cn_column_maps WHERE column_map_id = X_rup_column_map_id;

Line: 163

  DELETE cn_obj_columns_v WHERE column_id = X_rup_dest_column_id;

Line: 165

END Delete_Row;