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 605: delete from QPR_DIMENSION_VALUES

601:
602: -- when looping thro use 'indices of' since this can be a sparse collection
603: -- after deleting duplicate values
604: forall I in indices of c_dim_data_rec.level1_value
605: delete from QPR_DIMENSION_VALUES
606: where dim_code = p_dim_code
607: and hierarchy_code = p_hier_code
608: and instance_id = p_instance_id
609: and level1_value = c_dim_data_rec.level1_value(I);

Line 617: INSERT INTO QPR_DIMENSION_VALUES

613:
614: fnd_file.put_line(fnd_file.log,'Inserting dimension data for: '||p_dim_code||'_'||p_hier_code);
615:
616: forall i in indices of c_dim_data_rec.level1_value
617: INSERT INTO QPR_DIMENSION_VALUES
618: (dim_value_id,
619: instance_id,
620: dim_code,
621: hierarchy_code,

Line 689: (QPR_DIMENSION_VALUES_S.nextval,

685: program_id,
686: program_login_id,
687: request_id)
688: values
689: (QPR_DIMENSION_VALUES_S.nextval,
690: p_instance_id,
691: p_dim_code,
692: p_hier_code,
693: c_dim_data_rec.level1_value(I),