DBA Data[Home] [Help]

APPS.QPR_COLLECT_CURRENCY_DATA dependencies on FND_DATE

Line 61: date_from := FND_DATE.canonical_to_date(p_date_from);

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
65: delete QPR_CURRENCY_RATES

Line 62: date_to := FND_DATE.canonical_to_date(p_date_to);

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
65: delete QPR_CURRENCY_RATES
66: where INSTANCE_ID = p_instance_id