eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QRM_PA_AGGREGATION_P dependencies on XTR_MARKET_DATA_P

Line 4468: this will call xtr_market_data_p.get_md_from_set otherwise

4464:
4465:
4466: /***************************************************************
4467: This function find the FX Spot Rate. If there is MD_SET_CODE defined
4468: this will call xtr_market_data_p.get_md_from_set otherwise
4469: this will call qrm_calculators_p.get_rates_from_base
4470: ***************************************************************/
4471: FUNCTION get_fx_rate(p_md_set_code VARCHAR2,
4472: p_spot_date DATE,

Line 4478: v_md_in xtr_market_data_p.md_from_set_in_rec_type;

4474: p_contra_ccy VARCHAR2,
4475: p_side VARCHAR2)
4476: RETURN NUMBER IS
4477:
4478: v_md_in xtr_market_data_p.md_from_set_in_rec_type;
4479: v_md_out xtr_market_data_p.md_from_set_out_rec_type;
4480: v_ccy_multiplier NUMBER;
4481: v_bid_rate_comm NUMBER;
4482: v_ask_rate_comm NUMBER;

Line 4479: v_md_out xtr_market_data_p.md_from_set_out_rec_type;

4475: p_side VARCHAR2)
4476: RETURN NUMBER IS
4477:
4478: v_md_in xtr_market_data_p.md_from_set_in_rec_type;
4479: v_md_out xtr_market_data_p.md_from_set_out_rec_type;
4480: v_ccy_multiplier NUMBER;
4481: v_bid_rate_comm NUMBER;
4482: v_ask_rate_comm NUMBER;
4483: v_bid_rate_base NUMBER;

Line 4487: --use the same cursor as in XTR_MARKET_DATA_P.GET_MD_FROM_SET

4483: v_bid_rate_base NUMBER;
4484: v_ask_rate_base NUMBER;
4485: v_ccy VARCHAR2(15);
4486:
4487: --use the same cursor as in XTR_MARKET_DATA_P.GET_MD_FROM_SET
4488: CURSOR get_fx_spot_rates IS
4489: SELECT usd_base_curr_bid_rate bid_rate,
4490: usd_base_curr_offer_rate ask_rate,
4491: 1/usd_base_curr_offer_rate bid_rate_base,

Line 4518: xtr_market_data_p.get_md_from_set(v_md_in,v_md_out);

4514: v_md_in.p_spot_date := p_spot_date;
4515: v_md_in.p_ccy := p_base_ccy;
4516: v_md_in.p_contra_ccy := p_contra_ccy;
4517: v_md_in.p_side := p_side;
4518: xtr_market_data_p.get_md_from_set(v_md_in,v_md_out);
4519: --Round the FX Spot
4520: v_ccy_multiplier := v_md_out.p_md_out;
4521: ELSE
4522: OPEN get_fx_spot_rates;

Line 4561: WHEN xtr_market_data_p.e_mdcs_no_data_found THEN

4557: END IF;
4558: RETURN v_ccy_multiplier;
4559:
4560: EXCEPTION
4561: WHEN xtr_market_data_p.e_mdcs_no_data_found THEN
4562:
4563: IF (G_ERROR_level>=g_debug_level) THEN
4564: xtr_risk_debug_pkg.dlog('EXCEPTION','xtr_market_data.e_mdcs_no_data_found',
4565: 'QRM_PA_AGGREGATION_P.GET_FX_RATE',g_eRROR_level);--bug 3236479