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 900: FROM xtr_spot_rates outer,

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

Line 912: FROM xtr_spot_rates outer,

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

Line 917: FROM xtr_spot_rates inner

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

Line 922: FROM xtr_spot_rates inner

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

Line 932: FROM xtr_spot_rates outer,

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

Line 937: FROM xtr_spot_rates inner

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