APPS.QPR_TRANSFORMATION dependencies on QPR_DIMENSION_VALUES

Line 218: from qpr_dimension_values

214: l_insert_measure:=0;
215: begin
216: if measure_rec.limit_dim_level = 'PRODUCT_CATEGORY' then
217: select 1 into l_insert_measure
218: from qpr_dimension_values
219: where dim_code='PRD'
220: and hierarchy_code='PRODUCTCATEGORY'
221: and instance_id = p_instance_id and
222: level2_value = measure_rec.limit_dim_level_value;

Line 225: from qpr_dimension_values

221: and instance_id = p_instance_id and
222: level2_value = measure_rec.limit_dim_level_value;
223: elsif measure_rec.limit_dim_level = 'PRODUCT_FAMILY' then
224: select 1 into l_insert_measure
225: from qpr_dimension_values
226: where dim_code='PRD'
227: and hierarchy_code='PRODUCTFAMILY'
228: and instance_id = p_instance_id and
229: level2_value = measure_rec.limit_dim_level_value;

Line 232: from qpr_dimension_values

228: and instance_id = p_instance_id and
229: level2_value = measure_rec.limit_dim_level_value;
230: elsif measure_rec.limit_dim_level = 'ITEM' then
231: select 1 into l_insert_measure
232: from qpr_dimension_values
233: where dim_code='PRD'
234: and hierarchy_code='PRODUCTCATEGORY'
235: and instance_id = p_instance_id and
236: level1_value = measure_rec.limit_dim_level_value;

Line 249: from qpr_dimension_values

245: end if;
246: if l_insert_measure = 1 then
247: begin
248: select 1 into l_dummy
249: from qpr_dimension_values
250: where dim_code = transf_header_rec.to_dim_code
251: and hierarchy_code = nvl(decode(transf_header_rec.to_dim_code,
252: 'DSB', 'DISC_BAND',
253: 'VLB', 'VOL_BAND',

Line 265: select qpr_dimension_values_s.nextval

261: end if;
262: exception
263: WHEN NO_DATA_FOUND THEN
264: begin
265: select qpr_dimension_values_s.nextval
266: into l_next_seq from dual ;
267: if transf_header_rec.to_dim_code = 'DSB' then
268: l_all_desc := qpr_sr_util.get_all_dsb_desc;
269: l_all_value := qpr_sr_util.get_all_dsb_pk;

Line 279: INSERT INTO qpr_dimension_values(instance_id,

275: l_all_value := qpr_sr_util.get_all_mgb_pk;
276: end if;
277: fnd_file.put_line(fnd_file.log,
278: 'Inserting band dim with id :'||l_next_seq);
279: INSERT INTO qpr_dimension_values(instance_id,
280: dim_value_id,
281: dim_code,
282: hierarchy_code,
283: level1_value,

Line 450: ' from qpr_dimension_values a, qpr_transf_rules_b b ';

446: transf_header_rec.TRANSF_HEADER_ID);
447:
448: l_first:=0;
449: sql1_text := ' select a.dim_value_id as dim_value_id ' ||
450: ' from qpr_dimension_values a, qpr_transf_rules_b b ';
451: sql1_text := sql1_text|| ' where a.dim_code = '|| '''' ||
452: replace(transf_header_rec.from_dim_meas_code, '''', '''''') || '''';
453: sql1_text := sql1_text|| ' and a.hierarchy_code = '|| '''' ||
454: replace(transf_header_rec.from_dim_hier_code, '''', '''''') || '''';

Line 525: update qpr_dimension_values

521: loop
522: fnd_file.put_line(fnd_file.log, 'Dim_value_id: '||
523: c_dim_rec.dim_value_id(I));
524: begin
525: update qpr_dimension_values
526: set
527: level2_value = nvl(decode(transf_header_rec.to_level_id, 2,
528: transf_header_rec.to_value, null), level2_value),
529: level2_desc = nvl(decode(transf_header_rec.to_level_id, 2,

Line 570: update qpr_dimension_values

566: end;
567: /*
568: if transf_header_rec.to_level_id = 2 then
569: begin
570: update qpr_dimension_values
571: set level2_value = transf_header_rec.to_value,
572: level2_desc = transf_header_rec.to_value_desc,
573: last_update_date = sysdate,
574: last_updated_by = fnd_global.user_id,

Line 587: update qpr_dimension_values

583: end;
584: end if;
585: if transf_header_rec.to_level_id = 3 then
586: begin
587: update qpr_dimension_values
588: set level3_value = transf_header_rec.to_value,
589: level3_desc = transf_header_rec.to_value_desc,
590: last_update_date = sysdate,
591: last_updated_by = fnd_global.user_id,