APPS.QPR_LOAD_DIM_DATA dependencies on QPR_DIMENSION_VALUES

Line 128: delete from qpr_dimension_values a

124:
125: procedure delete_duplicate_data (p_instance_id in number)
126: is
127: Begin
128: delete from qpr_dimension_values a
129: where a.instance_id = p_instance_id
130: and a.rowid >
131: ANY
132: (select b.rowid

Line 133: from qpr_dimension_values b

129: where a.instance_id = p_instance_id
130: and a.rowid >
131: ANY
132: (select b.rowid
133: from qpr_dimension_values b
134: where a.dim_code = b.dim_code
135: and a.hierarchy_code = b.hierarchy_code
136: and a.instance_id = b.instance_id
137: and a.level1_value = b.level1_value);

Line 521: delete from QPR_DIMENSION_VALUES

517: fnd_profile.get('CONC_REQUEST_ID', l_request_id);
518:
519: forall I in
520: 1..c_dim_data_rec.level1_value.count
521: delete from QPR_DIMENSION_VALUES
522: where dim_code = p_dim_code
523: and hierarchy_code = p_hier_code
524: and instance_id = p_instance_id
525: and level1_value = c_dim_data_rec.level1_value(I);

Line 529: INSERT INTO QPR_DIMENSION_VALUES

525: and level1_value = c_dim_data_rec.level1_value(I);
526:
527: FORALL I IN
528: 1..c_dim_data_rec.level1_value.count
529: INSERT INTO QPR_DIMENSION_VALUES
530: (dim_value_id,
531: instance_id,
532: dim_code,
533: hierarchy_code,

Line 601: (QPR_DIMENSION_VALUES_S.nextval,

597: program_id,
598: program_login_id,
599: request_id)
600: values
601: (QPR_DIMENSION_VALUES_S.nextval,
602: p_instance_id,
603: p_dim_code,
604: p_hier_code,
605: c_dim_data_rec.level1_value(I),