APPS.QPR_SPECIAL_ETL dependencies on QPR_DIMENSION_VALUES

Line 430: from qpr_dimension_values

426: FOR I IN 1..c_cost_data.ord_level_value.count LOOP
427: if first_time = 1 then
428: begin
429: select 1 into l_dummy
430: from qpr_dimension_values
431: where dim_code = 'COS'
432: and hierarchy_code = 'COSTING'
433: and level1_value = c_cost_data.cos_level_value(I)
434: and instance_id = p_instance_id;

Line 442: qpr_dimension_values(instance_id,

438: begin
439: fnd_file.put_line(fnd_file.log,
440: 'Inserting Cost dim :' || c_cost_data.cos_level_value(I));
441: INSERT INTO
442: qpr_dimension_values(instance_id,
443: dim_value_id,
444: dim_code,
445: hierarchy_code,
446: level1_value,

Line 459: qpr_dimension_values_s.nextval,

455: LAST_UPDATED_BY,
456: LAST_UPDATE_LOGIN,
457: REQUEST_ID) values
458: (p_instance_id,
459: qpr_dimension_values_s.nextval,
460: 'COS',
461: 'COSTING',
462: c_cost_data.cos_level_value(I),
463: c_cost_data.cos_level_value(I),

Line 596: from qpr_dimension_values

592: FOR I IN 1..c_cost_data.ord_level_value.count LOOP
593: if first_time = 1 then
594: begin
595: select 1 into l_dummy
596: from qpr_dimension_values
597: where dim_code = 'COS'
598: and hierarchy_code = 'COSTING'
599: and level1_value = c_cost_data.cos_level_value(I)
600: and instance_id = p_instance_id;

Line 608: qpr_dimension_values(instance_id,

604: begin
605: fnd_file.put_line(fnd_file.log,
606: 'Inserting Cost dim :' || c_cost_data.cos_level_value(I));
607: INSERT INTO
608: qpr_dimension_values(instance_id,
609: dim_value_id,
610: dim_code,
611: hierarchy_code,
612: level1_value,

Line 625: qpr_dimension_values_s.nextval,

621: LAST_UPDATED_BY,
622: LAST_UPDATE_LOGIN,
623: REQUEST_ID) values
624: (p_instance_id,
625: qpr_dimension_values_s.nextval,
626: 'COS',
627: 'COSTING',
628: c_cost_data.cos_level_value(I),
629: c_cost_data.cos_level_value(I),

Line 828: delete qpr_dimension_values

824: ----- Insert Dimension ----
825: fnd_file.put_line(fnd_file.log,
826: 'Deleting overlapping dimension values...');
827: FORALL I IN 1..c_offadj_data.level1_value.count
828: delete qpr_dimension_values
829: where dim_code = 'OAD'
830: and hierarchy_code = 'OFFINVADJ'
831: and level1_value = c_offadj_data.level1_value(I)
832: and instance_id = p_instance_id;

Line 837: INSERT INTO qpr_dimension_values(instance_id,

833:
834: fnd_file.put_line(fnd_file.log,
835: 'Inserting Offinvoice Adjustment dimension values...');
836: FORALL I IN 1..c_offadj_data.level1_value.count
837: INSERT INTO qpr_dimension_values(instance_id,
838: dim_value_id,
839: dim_code,
840: hierarchy_code,
841: level1_value,

Line 863: qpr_dimension_values_s.nextval,

859: LAST_UPDATED_BY,
860: LAST_UPDATE_LOGIN,
861: REQUEST_ID) values
862: (p_instance_id,
863: qpr_dimension_values_s.nextval,
864: 'OAD',
865: 'OFFINVADJ',
866: c_offadj_data.level1_value(I), --level1 val
867: c_offadj_data.level2_value(I)||'-'||c_offadj_data.level8_value(I), --level1 desc

Line 1346: from qpr_dimension_values

1342: /*
1343: if l_pr_segment_id is not null then
1344: begin
1345: select 1 into l_dummy
1346: from qpr_dimension_values
1347: where dim_code = 'PSG'
1348: and hierarchy_code = 'PR_SEGMENT'
1349: and level1_value = l_pr_segment_id
1350: and instance_id = p_instance_id

Line 1366: insert into qpr_dimension_values(DIM_VALUE_ID,

1362: l_pr_segment_id := null;
1363: l_pr_segment_desc:= null;
1364: end;
1365: --TODO: All level to be added
1366: insert into qpr_dimension_values(DIM_VALUE_ID,
1367: INSTANCE_ID,
1368: DIM_CODE,
1369: HIERARCHY_CODE,
1370: LEVEL1_VALUE,

Line 1377: values(qpr_dimension_values_s.nextval,

1373: CREATED_BY,
1374: LAST_UPDATE_DATE,
1375: LAST_UPDATED_BY,
1376: LAST_UPDATE_LOGIN)
1377: values(qpr_dimension_values_s.nextval,
1378: p_instance_id,
1379: 'PSG',
1380: 'PR_SEGMENT',
1381: l_pr_segment_id,