APPS.QPR_REGRESSION_ANALYSIS SQL Statements

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

Line: 21

	l_sql := 'select ' || l_function || '(';

Line: 44

	select replace(log_transf,'',i_value)
	into l_transf
	from qpr_regression_result
	where price_plan_id = i_pp_id
	and product_id = i_item_id
	and pr_segment_id = i_psg_id;

Line: 51

	l_sql := 'select '||l_transf||' from dual';

Line: 68

	select replace(antilog_transf,'',i_value)
	into l_antitransf
	from qpr_regression_result
	where price_plan_id = i_pp_id
	and product_id = i_item_id
	and pr_segment_id = i_psg_id;

Line: 75

	l_sql := 'select '||l_antitransf||' from dual';

Line: 97

select
sc.dim_code dim_code, hier.hierarchy_ppa_code hier_code,
hl.level_seq_num lvl_num, sc.scope_value lvl_value,
sc.operator op_sign
from
qpr_scopes sc, qpr_dimensions dim,
qpr_hierarchies hier, qpr_hier_levels hl
where dim.price_plan_id = 1
and hier.price_plan_id = 1
and hl.price_plan_id = 1
and sc.dim_code = dim.dim_ppa_code
and sc.hierarchy_id = hier.hierarchy_id
and sc.level_id = hl.hierarchy_level_id
and sc.parent_entity_type='DATAMART'
and sc.parent_id = p_price_plan_id;

Line: 148

	select BASE_UOM_CODE, CURRENCY_CODE,
	START_DATE, END_DATE, INSTANCE_ID, name
	into l_uom, l_curr, l_start_dt, l_end_dt, l_instance_id, l_pp_name
	from qpr_price_plans_vl
	where price_plan_id = p_price_plan_id;

Line: 227

	l_sql := 'select prd_level_value, psg_level_value, ';

Line: 257

		select 1 into l_scope_exists
		from qpr_scopes
		where parent_entity_type = 'DATAMART'
		and parent_id = p_price_plan_id
		and rownum < 2;

Line: 280

		l_sql := l_sql || ' in (select level1_value from qpr_dimension_values where ';

Line: 308

		c_regr_data_rec.product_id.delete;

Line: 309

		c_regr_data_rec.pr_segment_id.delete;

Line: 310

		c_regr_data_rec.regression_slope.delete;

Line: 311

		c_regr_data_rec.regression_intercept.delete;

Line: 312

		c_regr_data_rec.regression_r2.delete;

Line: 313

		c_regr_data_rec.regression_count.delete;

Line: 330

			delete from QPR_REGRESSION_RESULT
			where product_id = c_regr_data_rec.product_id(I)
			and pr_segment_id = c_regr_data_rec.pr_segment_id(I)
			and price_plan_id = p_price_plan_id;

Line: 336

			INSERT INTO QPR_REGRESSION_RESULT
			(regression_result_id, price_plan_id,
			product_id, pr_segment_id,
			regression_slope, regression_intercept,
			regression_r2, regression_count,
			log_transf, antilog_transf,
			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_REGRESSION_RESULT_S.nextval, p_price_plan_id,
			c_regr_data_rec.product_id(I), c_regr_data_rec.pr_segment_id(I),
			c_regr_data_rec.regression_slope(I), c_regr_data_rec.regression_intercept(I),
			c_regr_data_rec.regression_r2(I), c_regr_data_rec.regression_count(I),
			l_display_log, l_alog,
			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);