APPS.QPR_COLLECT_UOM_DATA dependencies on QPR_UOM_CONVERSIONS

Line 28: insert into QPR_UOM_CONVERSIONS(UOM_CONV_ID, FROM_UOM_CLASS, TO_UOM_CLASS,

24: prg_id number:= fnd_global.conc_program_id;
25: begin
26: fnd_profile.get('CONC_REQUEST_ID', request_id);
27: forall i in r_uom_data.FROM_UOM_CLASS.first..r_uom_data.FROM_UOM_CLASS.last
28: insert into QPR_UOM_CONVERSIONS(UOM_CONV_ID, FROM_UOM_CLASS, TO_UOM_CLASS,
29: FROM_UOM_CODE, TO_UOM_CODE, BASE_UOM_FLAG,
30: CONVERSION_RATE, ITEM_KEY, FROM_UOM_DESC,
31: INSTANCE_ID,
32: CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE,

Line 36: values(QPR_UOM_CONVERSIONS_S.nextval,

32: CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE,
33: LAST_UPDATED_BY, LAST_UPDATE_LOGIN,
34: PROGRAM_APPLICATION_ID, PROGRAM_ID,
35: REQUEST_ID)
36: values(QPR_UOM_CONVERSIONS_S.nextval,
37: r_uom_data.FROM_UOM_CLASS(i), r_uom_data.TO_UOM_CLASS(i),
38: r_uom_data.FROM_UOM_CODE(i), r_uom_data.TO_UOM_CODE(i),
39: r_uom_data.BASE_UOM_FLAG(i), r_uom_data.CONVERSION_RATE(i),
40: r_uom_data.SR_ITEM_PK(i), r_uom_data.FROM_UOM_DESC(i),

Line 63: delete QPR_UOM_CONVERSIONS where INSTANCE_ID = p_instance_id;

59: begin
60: if nvl(qpr_sr_util.read_parameter('QPR_PULL_UOM_CONV_TO_ODS'), 'N')= 'Y' then
61: src_table := UOM_CONV_SRC_TBL || qpr_sr_util.get_dblink(p_instance_id);
62:
63: delete QPR_UOM_CONVERSIONS where INSTANCE_ID = p_instance_id;
64:
65: s_sql := 'select FROM_UOM_CLASS, TO_UOM_CLASS,FROM_UOM_CODE, TO_UOM_CODE, ';
66: s_sql := s_sql || 'CONVERSION_RATE,BASE_UOM_FLAG, SR_ITEM_PK,FROM_UOM_DESC';
67: s_sql := s_sql || ' FROM ' || src_table;