APPS.CNDISL_SLICE_DEF_DIM_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: 38

  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 (+);

Line: 45

  SELECT name
	INTO X_dest_column_name
	FROM cn_obj_columns_v
	WHERE column_id = X_dest_column_id;

Line: 54

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

Line: 80

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

Line: 93

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

Line: 100

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

Line: 112

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

Line: 119

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

Line: 129

END Insert_Row;

Line: 133

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

  DELETE cn_obj_columns_v WHERE column_id = X_destination_column_id;

Line: 144

  DELETE cn_column_maps WHERE column_map_id = X_tmp_column_map_id;

Line: 145

  DELETE cn_obj_columns_v WHERE column_id = X_tmp_dest_column_id;

Line: 147

  DELETE cn_column_maps WHERE column_map_id = X_rup_column_map_id;

Line: 148

  DELETE cn_obj_columns_v WHERE column_id = X_rup_dest_column_id;

Line: 150

END Delete_Row;