APPS.QPR_COLLECT_CURRENCY_DATA dependencies on QPR_SR_UTIL

Line 60: src_table := CURR_RATE_SRC_TBL || qpr_sr_util.get_dblink(p_instance_id);

56: s_sql varchar2(1000);
57: s_conv_type varchar2(30);
58: c_get_curr_rate SYS_REFCURSOR;
59: begin
60: src_table := CURR_RATE_SRC_TBL || qpr_sr_util.get_dblink(p_instance_id);
61: date_from := FND_DATE.canonical_to_date(p_date_from);
62: date_to := FND_DATE.canonical_to_date(p_date_to);
63:
64: if nvl(qpr_sr_util.read_parameter('QPR_PULL_CURR_CONV_TO_ODS'), 'N')= 'Y' then

Line 64: if nvl(qpr_sr_util.read_parameter('QPR_PULL_CURR_CONV_TO_ODS'), 'N')= 'Y' then

60: src_table := CURR_RATE_SRC_TBL || qpr_sr_util.get_dblink(p_instance_id);
61: date_from := FND_DATE.canonical_to_date(p_date_from);
62: date_to := FND_DATE.canonical_to_date(p_date_to);
63:
64: if nvl(qpr_sr_util.read_parameter('QPR_PULL_CURR_CONV_TO_ODS'), 'N')= 'Y' then
65: delete QPR_CURRENCY_RATES
66: where INSTANCE_ID = p_instance_id
67: and CONVERSION_DATE between date_from and date_to;
68:

Line 74: s_conv_type := nvl(qpr_sr_util.read_parameter('QPR_CONVERSION_TYPE'),

70: s_sql := s_sql || 'CONVERSION_RATE,CONVERSION_CLASS from ' || src_table;
71: s_sql := s_sql || ' where CONVERSION_TYPE IS NULL or CONVERSION_TYPE = :1 ' ;
72: s_sql := s_sql || ' and CONVERSION_DATE between :2 and :3' ;
73:
74: s_conv_type := nvl(qpr_sr_util.read_parameter('QPR_CONVERSION_TYPE'),
75: 'Spot');
76:
77: open c_get_curr_rate for s_sql using s_conv_type, date_from, date_to;
78: loop