eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QPR_LOAD_DIM_DATA SQL Statements

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

Line: 14


procedure insert_dimension_data(
	p_instance_id in number,
	p_dim_code in varchar2,
	p_hier_code in varchar2,
	c_dim_data_rec in out nocopy QPR_LOAD_DIM_DATA.DIM_DATA_REC_TYPE);

Line: 20


procedure delete_duplicate_data(
	p_instance_id in number);

Line: 35


select distinct dim_code dim, hier_code hier
from qpr_dim_sources
where instance_id = l_dim_src_instance_id
and instance_type = l_inst_type;

Line: 42


select distinct hier_code hier
from qpr_dim_sources
where instance_id = l_dim_src_instance_id
and dim_code = p_dim_code
and instance_type = l_inst_type;

Line: 63


	select hsecs into l_start_time from v$timer;

Line: 71


	select instance_type into l_inst_type
	from qpr_instances
	where instance_id = p_instance_id;

Line: 75


	select count(*) into l_check_instance
	from qpr_dim_sources
	where instance_id = p_instance_id;

Line: 110


	delete_duplicate_data (p_instance_id);

Line: 113


	select hsecs into l_end_time from v$timer;

Line: 125


procedure delete_duplicate_data (p_instance_id in number)
is
Begin
	delete from qpr_dimension_values a
	where a.instance_id = p_instance_id
	and a.rowid >
	ANY
	(select b.rowid
	from qpr_dimension_values b
	where a.dim_code = b.dim_code
	and a.hierarchy_code = b.hierarchy_code
	and a.instance_id = b.instance_id
	and a.level1_value = b.level1_value);

Line: 174


	l_sql := 'select ';

Line: 180


		select count(nvl(user_value_column, value_column)) into l_level_defined
		from qpr_dim_sources
		where instance_id = l_dim_src_instance_id
		and instance_type = l_inst_type
		and dim_code = p_dim_code
		and hier_code = p_hier_code
		and nvl(user_level_number, level_number) = l_count;

Line: 191


			select count(nvl(user_attr_column, attr_column)) into l_attr_defined
			from qpr_dim_sources
			where instance_id = l_dim_src_instance_id
			and instance_type = l_inst_type
			and dim_code = p_dim_code
			and hier_code = p_hier_code
			and nvl(user_level_number, level_number) = l_count;

Line: 204


					select
					nvl(user_value_column, value_column),
					nvl(user_desc_column, desc_column),
					nvl(user_attr_column, attr_column)
					into
					l_value_column,
					l_desc_column,
					l_attr_column
					from qpr_dim_sources
					where instance_id = l_dim_src_instance_id
					and instance_type = l_inst_type
					and dim_code = p_dim_code
					and hier_code = p_hier_code
					and nvl(user_level_number, level_number) = l_count
					and nvl(user_attr_number, attr_number) = l_attr_num;

Line: 254


				select
				nvl(user_value_column, value_column),
				nvl(user_desc_column, desc_column)
				into
				l_value_column,
				l_desc_column
				from qpr_dim_sources
				where instance_id = l_dim_src_instance_id
				and instance_type = l_inst_type
				and dim_code = p_dim_code
				and hier_code = p_hier_code
				and nvl(user_level_number, level_number) = l_count;

Line: 316


		select
		nvl(user_value_column, value_column)
		into
		l_value_column
		from qpr_dim_sources
		where instance_id = l_dim_src_instance_id
		and instance_type = l_inst_type
		and dim_code = p_dim_code
		and hier_code = p_hier_code
		and nvl(user_level_number, level_number) = 999;

Line: 335


	select distinct nvl(user_view_name, view_name)
	into l_source_view_name
	from qpr_dim_sources
	where instance_id = l_dim_src_instance_id
	and instance_type = l_inst_type
	and dim_code = p_dim_code
	and hier_code = p_hier_code;

Line: 353


		select nvl(user_value_column, value_column)
		into l_date_column
		from qpr_dim_sources
		where instance_id = l_dim_src_instance_id
		and instance_type = l_inst_type
		and dim_code = p_dim_code
		and hier_code = p_hier_code
		and nvl(user_level_number, level_number) = 998
                and rownum < 2;

Line: 373


		fnd_file.put_line( fnd_file.log, 'Delete arrays ');

Line: 374


 		c_dim_data_rec.level1_value.delete;

Line: 375


 		c_dim_data_rec.level1_desc.delete;

Line: 376


 		c_dim_data_rec.level1_attribute1.delete;

Line: 377


 		c_dim_data_rec.level1_attribute2.delete;

Line: 378


 		c_dim_data_rec.level1_attribute3.delete;

Line: 379


 		c_dim_data_rec.level1_attribute4.delete;

Line: 380


 		c_dim_data_rec.level1_attribute5.delete;

Line: 381


 		c_dim_data_rec.level2_value.delete;

Line: 382


 		c_dim_data_rec.level2_desc.delete;

Line: 383


 		c_dim_data_rec.level2_attribute1.delete;

Line: 384


 		c_dim_data_rec.level2_attribute2.delete;

Line: 385


 		c_dim_data_rec.level2_attribute3.delete;

Line: 386


 		c_dim_data_rec.level2_attribute4.delete;

Line: 387


 		c_dim_data_rec.level2_attribute5.delete;

Line: 388


 		c_dim_data_rec.level3_value.delete;

Line: 389


 		c_dim_data_rec.level3_desc.delete;

Line: 390


 		c_dim_data_rec.level3_attribute1.delete;

Line: 391


 		c_dim_data_rec.level3_attribute2.delete;

Line: 392


 		c_dim_data_rec.level3_attribute3.delete;

Line: 393


 		c_dim_data_rec.level3_attribute4.delete;

Line: 394


 		c_dim_data_rec.level3_attribute5.delete;

Line: 395


 		c_dim_data_rec.level4_value.delete;

Line: 396


 		c_dim_data_rec.level4_desc.delete;

Line: 397


 		c_dim_data_rec.level4_attribute1.delete;

Line: 398


 		c_dim_data_rec.level4_attribute2.delete;

Line: 399


 		c_dim_data_rec.level4_attribute3.delete;

Line: 400


 		c_dim_data_rec.level4_attribute4.delete;

Line: 401


 		c_dim_data_rec.level4_attribute5.delete;

Line: 402


 		c_dim_data_rec.level5_value.delete;

Line: 403


 		c_dim_data_rec.level5_desc.delete;

Line: 404


 		c_dim_data_rec.level5_attribute1.delete;

Line: 405


 		c_dim_data_rec.level5_attribute2.delete;

Line: 406


 		c_dim_data_rec.level5_attribute3.delete;

Line: 407


 		c_dim_data_rec.level5_attribute4.delete;

Line: 408


 		c_dim_data_rec.level5_attribute5.delete;

Line: 409


 		c_dim_data_rec.level6_value.delete;

Line: 410


 		c_dim_data_rec.level6_desc.delete;

Line: 411


 		c_dim_data_rec.level6_attribute1.delete;

Line: 412


 		c_dim_data_rec.level6_attribute2.delete;

Line: 413


 		c_dim_data_rec.level6_attribute3.delete;

Line: 414


 		c_dim_data_rec.level6_attribute4.delete;

Line: 415


 		c_dim_data_rec.level6_attribute5.delete;

Line: 416


 		c_dim_data_rec.level7_value.delete;

Line: 417


 		c_dim_data_rec.level7_desc.delete;

Line: 418


 		c_dim_data_rec.level7_attribute1.delete;

Line: 419


 		c_dim_data_rec.level7_attribute2.delete;

Line: 420


 		c_dim_data_rec.level7_attribute3.delete;

Line: 421


 		c_dim_data_rec.level7_attribute4.delete;

Line: 422


 		c_dim_data_rec.level7_attribute5.delete;

Line: 423


 		c_dim_data_rec.level8_value.delete;

Line: 424


 		c_dim_data_rec.level8_desc.delete;

Line: 425


 		c_dim_data_rec.level8_attribute1.delete;

Line: 426


 		c_dim_data_rec.level8_attribute2.delete;

Line: 427


 		c_dim_data_rec.level8_attribute3.delete;

Line: 428


 		c_dim_data_rec.level8_attribute4.delete;

Line: 429


 		c_dim_data_rec.level8_attribute5.delete;

Line: 430


 		c_dim_data_rec.check_date.delete;

Line: 493


	insert_dimension_data(p_instance_id, p_dim_code, p_hier_code, c_dim_data_rec);

Line: 503


procedure insert_dimension_data(
	p_instance_id in number,
	p_dim_code in varchar2,
	p_hier_code in varchar2,
	c_dim_data_rec in out nocopy QPR_LOAD_DIM_DATA.DIM_DATA_REC_TYPE)
is

l_request_id number;

Line: 513


	fnd_file.put_line(fnd_file.log,'Entering insert dimension data ');

Line: 514


	fnd_file.put_line(fnd_file.log,'Inserting dimension data for: '||p_dim_code||'_'||p_hier_code);

Line: 521


		delete from QPR_DIMENSION_VALUES
		where dim_code = p_dim_code
		and hierarchy_code = p_hier_code
		and instance_id = p_instance_id
		and level1_value = c_dim_data_rec.level1_value(I);

Line: 529


		INSERT INTO QPR_DIMENSION_VALUES
		(dim_value_id,
		instance_id,
		dim_code,
		hierarchy_code,
		level1_value,
		level1_desc,
		level1_attribute1,
		level1_attribute2,
		level1_attribute3,
		level1_attribute4,
		level1_attribute5,
		level2_value,
		level2_desc,
		level2_attribute1,
		level2_attribute2,
		level2_attribute3,
		level2_attribute4,
		level2_attribute5,
		level3_value,
		level3_desc,
		level3_attribute1,
		level3_attribute2,
		level3_attribute3,
		level3_attribute4,
		level3_attribute5,
		level4_value,
		level4_desc,
		level4_attribute1,
		level4_attribute2,
		level4_attribute3,
		level4_attribute4,
		level4_attribute5,
		level5_value,
		level5_desc,
		level5_attribute1,
		level5_attribute2,
		level5_attribute3,
		level5_attribute4,
		level5_attribute5,
		level6_value,
		level6_desc,
		level6_attribute1,
		level6_attribute2,
		level6_attribute3,
		level6_attribute4,
		level6_attribute5,
		level7_value,
		level7_desc,
		level7_attribute1,
		level7_attribute2,
		level7_attribute3,
		level7_attribute4,
		level7_attribute5,
		level8_value,
		level8_desc,
		level8_attribute1,
		level8_attribute2,
		level8_attribute3,
		level8_attribute4,
		level8_attribute5,
		check_date,
		creation_date,
		created_by,
		last_update_date,
		last_updated_by,
		last_update_login,
		program_application_id,
		program_id,
		program_login_id,
		request_id)
		values
		(QPR_DIMENSION_VALUES_S.nextval,
		p_instance_id,
		p_dim_code,
		p_hier_code,
		c_dim_data_rec.level1_value(I),
		c_dim_data_rec.level1_desc(I),
		c_dim_data_rec.level1_attribute1(I),
		c_dim_data_rec.level1_attribute2(I),
		c_dim_data_rec.level1_attribute3(I),
		c_dim_data_rec.level1_attribute4(I),
		c_dim_data_rec.level1_attribute5(I),
		c_dim_data_rec.level2_value(I),
		c_dim_data_rec.level2_desc(I),
		c_dim_data_rec.level2_attribute1(I),
		c_dim_data_rec.level2_attribute2(I),
		c_dim_data_rec.level2_attribute3(I),
		c_dim_data_rec.level2_attribute4(I),
		c_dim_data_rec.level2_attribute5(I),
		c_dim_data_rec.level3_value(I),
		c_dim_data_rec.level3_desc(I),
		c_dim_data_rec.level3_attribute1(I),
		c_dim_data_rec.level3_attribute2(I),
		c_dim_data_rec.level3_attribute3(I),
		c_dim_data_rec.level3_attribute4(I),
		c_dim_data_rec.level3_attribute5(I),
		c_dim_data_rec.level4_value(I),
		c_dim_data_rec.level4_desc(I),
		c_dim_data_rec.level4_attribute1(I),
		c_dim_data_rec.level4_attribute2(I),
		c_dim_data_rec.level4_attribute3(I),
		c_dim_data_rec.level4_attribute4(I),
		c_dim_data_rec.level4_attribute5(I),
		c_dim_data_rec.level5_value(I),
		c_dim_data_rec.level5_desc(I),
		c_dim_data_rec.level5_attribute1(I),
		c_dim_data_rec.level5_attribute2(I),
		c_dim_data_rec.level5_attribute3(I),
		c_dim_data_rec.level5_attribute4(I),
		c_dim_data_rec.level5_attribute5(I),
		c_dim_data_rec.level6_value(I),
		c_dim_data_rec.level6_desc(I),
		c_dim_data_rec.level6_attribute1(I),
		c_dim_data_rec.level6_attribute2(I),
		c_dim_data_rec.level6_attribute3(I),
		c_dim_data_rec.level6_attribute4(I),
		c_dim_data_rec.level6_attribute5(I),
		c_dim_data_rec.level7_value(I),
		c_dim_data_rec.level7_desc(I),
		c_dim_data_rec.level7_attribute1(I),
		c_dim_data_rec.level7_attribute2(I),
		c_dim_data_rec.level7_attribute3(I),
		c_dim_data_rec.level7_attribute4(I),
		c_dim_data_rec.level7_attribute5(I),
		c_dim_data_rec.level8_value(I),
		c_dim_data_rec.level8_desc(I),
		c_dim_data_rec.level8_attribute1(I),
		c_dim_data_rec.level8_attribute2(I),
		c_dim_data_rec.level8_attribute3(I),
		c_dim_data_rec.level8_attribute4(I),
		c_dim_data_rec.level8_attribute5(I),
		c_dim_data_rec.check_date(I),
		sysdate,
		fnd_global.user_id,
		sysdate,
		fnd_global.user_id,
		fnd_global.conc_login_id,
		fnd_global.prog_appl_id,
		fnd_global.conc_program_id,
		null,
		l_request_id);

Line: 677


       fnd_file.put_line(fnd_file.log, 'UNEXCPECTED ERROR IN INSERT_DIMENSION_DATA:'||sqlerrm);

Line: 680


       fnd_file.put_line(fnd_file.log, 'UNEXCPECTED ERROR IN INSERT_DIMENSION_DATA:'||sqlerrm);