APPS.QPR_COLLECT_UOM_DATA dependencies on QPR_SR_UTIL

Line 60: if nvl(qpr_sr_util.read_parameter('QPR_PULL_UOM_CONV_TO_ODS'), 'N')= 'Y' then

56: src_table varchar2(200);
57: s_sql varchar2(1000);
58: c_get_uom_data SYS_REFCURSOR;
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:

Line 61: src_table := UOM_CONV_SRC_TBL || qpr_sr_util.get_dblink(p_instance_id);

57: s_sql varchar2(1000);
58: c_get_uom_data SYS_REFCURSOR;
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, ';