APPS.QPR_REGRESSION_ANALYSIS dependencies on QPR_REGRESSION_RESULT

Line 46: from qpr_regression_result

42: l_sql varchar2(1000);
43: begin
44: select replace(log_transf,'',i_value)
45: into l_transf
46: from qpr_regression_result
47: where price_plan_id = i_pp_id
48: and product_id = i_item_id
49: and pr_segment_id = i_psg_id;
50:

Line 70: from qpr_regression_result

66: l_sql varchar2(1000);
67: begin
68: select replace(antilog_transf,'',i_value)
69: into l_antitransf
70: from qpr_regression_result
71: where price_plan_id = i_pp_id
72: and product_id = i_item_id
73: and pr_segment_id = i_psg_id;
74:

Line 330: delete from QPR_REGRESSION_RESULT

326:
327: log_debug ('Count: '||c_regr_data_rec.product_id.count);
328:
329: forall I in 1..c_regr_data_rec.product_id.count
330: delete from QPR_REGRESSION_RESULT
331: where product_id = c_regr_data_rec.product_id(I)
332: and pr_segment_id = c_regr_data_rec.pr_segment_id(I)
333: and price_plan_id = p_price_plan_id;
334:

Line 336: INSERT INTO QPR_REGRESSION_RESULT

332: and pr_segment_id = c_regr_data_rec.pr_segment_id(I)
333: and price_plan_id = p_price_plan_id;
334:
335: forall I in 1..c_regr_data_rec.product_id.count
336: INSERT INTO QPR_REGRESSION_RESULT
337: (regression_result_id, price_plan_id,
338: product_id, pr_segment_id,
339: regression_slope, regression_intercept,
340: regression_r2, regression_count,

Line 348: (QPR_REGRESSION_RESULT_S.nextval, p_price_plan_id,

344: last_update_login, program_application_id,
345: program_id, program_login_id,
346: request_id)
347: values
348: (QPR_REGRESSION_RESULT_S.nextval, p_price_plan_id,
349: c_regr_data_rec.product_id(I), c_regr_data_rec.pr_segment_id(I),
350: c_regr_data_rec.regression_slope(I), c_regr_data_rec.regression_intercept(I),
351: c_regr_data_rec.regression_r2(I), c_regr_data_rec.regression_count(I),
352: l_display_log, l_alog,