APPS.XTR_MARKET_DATA_INTERFACE_P dependencies on XTR_INTEREST_PERIOD_RATES

Line 51: FROM xtr_interest_period_rates

47: CURSOR c_interest_date_stamp (p_currency VARCHAR2,
48: p_ric_code VARCHAR2,
49: p_rate_date DATE) IS
50: SELECT 1
51: FROM xtr_interest_period_rates
52: WHERE currency = p_currency
53: AND unique_period_id = p_ric_code
54: AND rate_date = p_rate_date;
55: --

Line 86: INSERT INTO xtr_interest_period_rates

82: CLOSE c_interest_date_stamp;
83: -- If date stamp already exists in table (v_row_exists = 1),
84: -- do not insert, just update
85: IF Nvl(v_row_exists,0)<>1 THEN
86: INSERT INTO xtr_interest_period_rates
87: (currency,contra_option_ccy,unique_period_id,period_code,rate_date,
88: bid_rate,spread,offer_rate,term_type,day_count_basis)
89: VALUES
90: (p_currency_a,p_currency_b,p_ric_code,p_nos_of_days,

Line 94: UPDATE xtr_interest_period_rates

90: (p_currency_a,p_currency_b,p_ric_code,p_nos_of_days,
91: p_last_download_time,p_bid_price,p_ask_price - p_bid_price,
92: p_ask_price,p_term_type,p_day_count_basis);
93: ELSE
94: UPDATE xtr_interest_period_rates
95: SET contra_option_ccy = p_currency_b,
96: period_code = p_nos_of_days,
97: bid_rate = p_bid_price,
98: spread = p_ask_price - p_bid_price,

Line 602: v_day_count_basis XTR_INTEREST_PERIOD_RATES.DAY_COUNT_BASIS%TYPE;

598: v_term_length NUMBER;
599: v_term_type VARCHAR2(1);
600: v_term_year NUMBER;
601: v_code NUMBER ;
602: v_day_count_basis XTR_INTEREST_PERIOD_RATES.DAY_COUNT_BASIS%TYPE;
603: /* v_code scheme
604: 1 is added to v_code if ask is missing
605: 2 is added to v_code if bid is missing
606: 4 is added to v_code if mid is missing