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_REGRESSION_ANALYSIS dependencies on QPR_SR_UTIL

Line 173: l_transf_func := qpr_sr_util.read_parameter('QPR_TRANSF_FUNC');

169: l_end_dt := date_to;
170: end if;
171: --
172:
173: l_transf_func := qpr_sr_util.read_parameter('QPR_TRANSF_FUNC');
174: case
175: when l_transf_func = 'ln' then
176: l_atransf_func := 'exp';
177: l_parameter_to_func := '';

Line 180: l_parameter_to_func := qpr_sr_util.read_parameter('QPR_PARAM_FUNC');

176: l_atransf_func := 'exp';
177: l_parameter_to_func := '';
178: when l_transf_func = 'log' then
179: l_atransf_func := 'power';
180: l_parameter_to_func := qpr_sr_util.read_parameter('QPR_PARAM_FUNC');
181: when l_transf_func = 'sqrt' then
182: l_atransf_func := 'power';
183: l_parameter_to_func := '2';
184: when l_transf_func = 'power' then

Line 186: l_parameter_to_func := qpr_sr_util.read_parameter('QPR_PARAM_FUNC');

182: l_atransf_func := 'power';
183: l_parameter_to_func := '2';
184: when l_transf_func = 'power' then
185: l_atransf_func := 'log';
186: l_parameter_to_func := qpr_sr_util.read_parameter('QPR_PARAM_FUNC');
187: when l_transf_func = 'exp' then
188: l_atransf_func := 'ln';
189: l_parameter_to_func := '';
190: else

Line 191: l_atransf_func := qpr_sr_util.read_parameter('QPR_ATRANSF_FUNC');

187: when l_transf_func = 'exp' then
188: l_atransf_func := 'ln';
189: l_parameter_to_func := '';
190: else
191: l_atransf_func := qpr_sr_util.read_parameter('QPR_ATRANSF_FUNC');
192: l_parameter_to_func := qpr_sr_util.read_parameter('QPR_PARAM_FUNC');
193: end case;
194:
195: l_bool_transf := validate_function(l_transf_func, l_parameter_to_func);

Line 192: l_parameter_to_func := qpr_sr_util.read_parameter('QPR_PARAM_FUNC');

188: l_atransf_func := 'ln';
189: l_parameter_to_func := '';
190: else
191: l_atransf_func := qpr_sr_util.read_parameter('QPR_ATRANSF_FUNC');
192: l_parameter_to_func := qpr_sr_util.read_parameter('QPR_PARAM_FUNC');
193: end case;
194:
195: l_bool_transf := validate_function(l_transf_func, l_parameter_to_func);
196: l_bool_atransf := validate_function(l_atransf_func, l_parameter_to_func);

Line 218: l_y := l_y || '* qpr_sr_util.ods_curr_conversion(null,'''|| l_curr||''' , null, time_level_value, instance_id)';

214: log_debug ('Transformation Function for Regression: '||l_display_log);
215:
216: -- Dependant Variable
217: l_y := l_log || 'measure4_number'; -- Unit Selling Price
218: l_y := l_y || '* qpr_sr_util.ods_curr_conversion(null,'''|| l_curr||''' , null, time_level_value, instance_id)';
219: l_y := l_y || '/qpr_sr_util.ods_uom_conv(prd_level_value, measure_uom, '''||l_uom||''', instance_id))';
220: -- Independant Variable
221: l_x := l_log || 'measure1_number'; -- Ordered Quantity
222: l_x := l_x || '* qpr_sr_util.ods_uom_conv(prd_level_value, measure_uom, '''||l_uom||''', instance_id))';

Line 219: l_y := l_y || '/qpr_sr_util.ods_uom_conv(prd_level_value, measure_uom, '''||l_uom||''', instance_id))';

215:
216: -- Dependant Variable
217: l_y := l_log || 'measure4_number'; -- Unit Selling Price
218: l_y := l_y || '* qpr_sr_util.ods_curr_conversion(null,'''|| l_curr||''' , null, time_level_value, instance_id)';
219: l_y := l_y || '/qpr_sr_util.ods_uom_conv(prd_level_value, measure_uom, '''||l_uom||''', instance_id))';
220: -- Independant Variable
221: l_x := l_log || 'measure1_number'; -- Ordered Quantity
222: l_x := l_x || '* qpr_sr_util.ods_uom_conv(prd_level_value, measure_uom, '''||l_uom||''', instance_id))';
223:

Line 222: l_x := l_x || '* qpr_sr_util.ods_uom_conv(prd_level_value, measure_uom, '''||l_uom||''', instance_id))';

218: l_y := l_y || '* qpr_sr_util.ods_curr_conversion(null,'''|| l_curr||''' , null, time_level_value, instance_id)';
219: l_y := l_y || '/qpr_sr_util.ods_uom_conv(prd_level_value, measure_uom, '''||l_uom||''', instance_id))';
220: -- Independant Variable
221: l_x := l_log || 'measure1_number'; -- Ordered Quantity
222: l_x := l_x || '* qpr_sr_util.ods_uom_conv(prd_level_value, measure_uom, '''||l_uom||''', instance_id))';
223:
224: -- log_debug('X: '||l_x);
225: -- log_debug('Y: '||l_y);
226:

Line 251: l_sql := l_sql || ' and qpr_sr_util.ods_curr_conversion(null,''';

247:
248: l_sql := l_sql || ' and nvl(measure1_number,0) > 0 ';
249: l_sql := l_sql || ' and nvl(measure4_number,0) > 0 ';
250:
251: l_sql := l_sql || ' and qpr_sr_util.ods_curr_conversion(null,''';
252: l_sql := l_sql || l_curr||''' , null, time_level_value, instance_id) > 0 ';
253: l_sql := l_sql || ' and qpr_sr_util.ods_uom_conv(prd_level_value, measure_uom, '''||l_uom||''', instance_id) > 0 ';
254:
255:

Line 253: l_sql := l_sql || ' and qpr_sr_util.ods_uom_conv(prd_level_value, measure_uom, '''||l_uom||''', instance_id) > 0 ';

249: l_sql := l_sql || ' and nvl(measure4_number,0) > 0 ';
250:
251: l_sql := l_sql || ' and qpr_sr_util.ods_curr_conversion(null,''';
252: l_sql := l_sql || l_curr||''' , null, time_level_value, instance_id) > 0 ';
253: l_sql := l_sql || ' and qpr_sr_util.ods_uom_conv(prd_level_value, measure_uom, '''||l_uom||''', instance_id) > 0 ';
254:
255:
256: begin
257: select 1 into l_scope_exists