APPS.QPR_COLLECT_CURRENCY_DATA dependencies on QPR_CURRENCY_RATES

Line 25: insert into QPR_CURRENCY_RATES(CURR_CONV_ID, FROM_CURRENCY, TO_CURRENCY,

21: prg_id number:= fnd_global.conc_program_id;
22: begin
23: fnd_profile.get('CONC_REQUEST_ID', request_id);
24: forall i in r_curr_data.FROM_CURRENCY.first..r_curr_data.FROM_CURRENCY.last
25: insert into QPR_CURRENCY_RATES(CURR_CONV_ID, FROM_CURRENCY, TO_CURRENCY,
26: CONVERSION_DATE, CONVERSION_RATE,
27: CONVERSION_CLASS, INSTANCE_ID,
28: CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE,
29: LAST_UPDATED_BY, LAST_UPDATE_LOGIN,

Line 32: values(QPR_CURRENCY_RATES_S.nextval,

28: CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE,
29: LAST_UPDATED_BY, LAST_UPDATE_LOGIN,
30: PROGRAM_APPLICATION_ID, PROGRAM_ID,
31: REQUEST_ID)
32: values(QPR_CURRENCY_RATES_S.nextval,
33: r_curr_data.FROM_CURRENCY(i), r_curr_data.TO_CURRENCY(i),
34: r_curr_data.CONVERSION_DATE(i),
35: r_curr_data.CONVERSION_RATE(i),
36: r_curr_data.CONVERSION_CLASS(i),

Line 65: delete QPR_CURRENCY_RATES

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:
69: s_sql := 'select FROM_CURRENCY, TO_CURRENCY,CONVERSION_DATE, ';