APPS.XTR_MARKET_DATA_INTERFACE_P dependencies on XTR_SPOT_RATES

Line 59: FROM xtr_spot_rates

55: --
56: CURSOR c_spot_date_stamp (p_currency VARCHAR2,
57: p_rate_date DATE) IS
58: SELECT 1
59: FROM xtr_spot_rates
60: WHERE currency = p_currency
61: AND rate_date = p_rate_date;
62: --
63: BEGIN

Line 160: INSERT INTO xtr_spot_rates

156: CLOSE c_spot_date_stamp;
157: -- If date stamp already exists in table (v_row_exists = 1),
158: -- do not insert, just update
159: IF Nvl(v_row_exists,0)<>1 THEN
160: INSERT INTO xtr_spot_rates
161: (currency,rate_date,bid_rate_against_usd,
162: spread_against_usd,offer_rate_against_usd,
163: usd_base_curr_bid_rate,usd_base_curr_offer_rate,
164: hce_rate,unique_period_id)

Line 171: UPDATE xtr_spot_rates

167: p_ask_price-p_bid_price,p_ask_price,
168: 1/p_ask_price,1/p_bid_price,
169: v_hce,p_ric_code);
170: ELSE
171: UPDATE xtr_spot_rates
172: SET bid_rate_against_usd = p_bid_price,
173: spread_against_usd = p_ask_price-p_bid_price,
174: offer_rate_against_usd = p_ask_price,
175: usd_base_curr_bid_rate = 1/p_ask_price,

Line 211: INSERT INTO xtr_spot_rates

207: CLOSE c_spot_date_stamp;
208: -- If date stamp already exists in table (v_row_exists = 1),
209: -- do not insert, just update
210: IF Nvl(v_row_exists,0)<>1 THEN
211: INSERT INTO xtr_spot_rates
212: (currency,rate_date,bid_rate_against_usd,
213: spread_against_usd,offer_rate_against_usd,
214: usd_base_curr_bid_rate,usd_base_curr_offer_rate,
215: hce_rate,unique_period_id)

Line 222: UPDATE xtr_spot_rates

218: p_ask_price - p_bid_price,
219: p_ask_price,p_bid_price,p_ask_price,
220: v_hce,p_ric_code);
221: ELSE
222: UPDATE xtr_spot_rates
223: SET bid_rate_against_usd = p_bid_price,
224: spread_against_usd = p_ask_price - p_bid_price,
225: offer_rate_against_usd = p_ask_price,
226: usd_base_curr_bid_rate = p_bid_price,

Line 290: INSERT INTO xtr_spot_rates

286: CLOSE c_spot_date_stamp;
287: -- If date stamp already exists in table (v_row_exists = 1),
288: -- do not insert, just update
289: IF Nvl(v_row_exists,0)<>1 THEN
290: INSERT INTO xtr_spot_rates
291: (currency,rate_date,bid_rate_against_usd,spread_against_usd,
292: offer_rate_against_usd,usd_base_curr_bid_rate,
293: usd_base_curr_offer_rate,hce_rate,unique_period_id)
294: VALUES

Line 298: UPDATE xtr_spot_rates

294: VALUES
295: ('USD',p_last_download_time,1,0,1,1,1,
296: v_usd_hce_rate,'USD REF ROW');
297: ELSE
298: UPDATE xtr_spot_rates
299: SET bid_rate_against_usd = 1,
300: spread_against_usd = 0,
301: offer_rate_against_usd = 1,
302: usd_base_curr_bid_rate = 1,

Line 901: FROM xtr_spot_rates outer,

897: SELECT outer.currency quote_currency,
898: AVG(outer.bid_rate_against_usd) bid_rate_against_usd,
899: AVG(outer.offer_rate_against_usd) offer_rate_against_usd,
900: mc.divide_or_multiply
901: FROM xtr_spot_rates outer,
902: xtr_master_currencies mc
903: WHERE outer.currency <> 'USD'
904: AND outer.rate_date >= p_ref_date
905: AND outer.rate_date <= (p_ref_date+1)

Line 913: FROM xtr_spot_rates outer,

909: SELECT outer.currency quote_currency,
910: outer.bid_rate_against_usd,
911: outer.offer_rate_against_usd,
912: mc.divide_or_multiply
913: FROM xtr_spot_rates outer,
914: xtr_master_currencies mc
915: WHERE outer.currency <> 'USD'
916: AND outer.currency = mc.currency
917: AND NOT EXISTS (SELECT 1

Line 918: FROM xtr_spot_rates inner

914: xtr_master_currencies mc
915: WHERE outer.currency <> 'USD'
916: AND outer.currency = mc.currency
917: AND NOT EXISTS (SELECT 1
918: FROM xtr_spot_rates inner
919: WHERE outer.currency = inner.currency
920: AND rate_date >= p_ref_date
921: AND rate_date <= (p_ref_date+1))
922: AND outer.rate_date = (SELECT max(rate_date)

Line 923: FROM xtr_spot_rates inner

919: WHERE outer.currency = inner.currency
920: AND rate_date >= p_ref_date
921: AND rate_date <= (p_ref_date+1))
922: AND outer.rate_date = (SELECT max(rate_date)
923: FROM xtr_spot_rates inner
924: WHERE outer.currency = inner.currency
925: AND rate_date < p_ref_date)
926: ORDER BY quote_currency;
927:

Line 933: FROM xtr_spot_rates outer,

929: SELECT outer.currency,
930: outer.bid_rate_against_usd,
931: outer.offer_rate_against_usd,
932: mc.divide_or_multiply
933: FROM xtr_spot_rates outer,
934: xtr_master_currencies mc
935: WHERE outer.currency <> 'USD'
936: AND outer.currency = mc.currency
937: AND outer.rate_date = (SELECT max(rate_date)

Line 938: FROM xtr_spot_rates inner

934: xtr_master_currencies mc
935: WHERE outer.currency <> 'USD'
936: AND outer.currency = mc.currency
937: AND outer.rate_date = (SELECT max(rate_date)
938: FROM xtr_spot_rates inner
939: WHERE outer.currency = inner.currency
940: AND rate_date <= (p_ref_date+1))
941: ORDER BY outer.currency;
942: