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.XTR_EXP_SUMM_P dependencies on FND_GLOBAL

Line 145: trunc(sysdate),fnd_global.user_id,

141: discounted_value,yield_curve,forward_fx_rate,selected_ccy,selected_indic,selected_options,
142: hedge_trade_whatif,selected_portfolio,month_or_week,period_date)
143: values
144: (ref_number,sel_ccy,l_date,round(l_amount,2),l_avg_days,l_weight_avg,l_combination,round(l_rate,5),
145: trunc(sysdate),fnd_global.user_id,
146: incl_options,incl_indic_exp,l_company,l_base_ccy,l_num_items,'N',l_portfolio,perspective,disc_rate,
147: trunc(sysdate),disc_value,l_yield_curve,l_fwd_fx_rate,sel_ccy,incl_indic_exp,incl_options,'H',l_portfolio,
148: nvl(l_wk_mth,'M'),decode(l_wk_mth,'W',to_date(l_date,'DD-MM-YYYY'),
149: -- to_date(l_date,'MON-YYYY')));

Line 181: to_char(trunc(sysdate),'MON-YYYY')),round(l_amount,2),1,0,null,null,trunc(sysdate),fnd_global.user_id,

177: discounted_value,yield_curve,selected_ccy,selected_indic,selected_options,
178: hedge_trade_whatif,selected_portfolio,month_or_week,period_date)
179: values
180: (ref_number,sel_ccy,decode(l_wk_mth,'W',to_char(next_day(trunc(sysdate),to_char(to_date('09/03/1997','DD/MM/YYYY'),'DY')),'DD-MM-YYYY'),
181: to_char(trunc(sysdate),'MON-YYYY')),round(l_amount,2),1,0,null,null,trunc(sysdate),fnd_global.user_id,
182: incl_options,incl_indic_exp,l_company,l_base_ccy,l_num_items,'Y',l_portfolio,perspective,
183: 0,trunc(sysdate),l_amount,l_yield_curve,sel_ccy,incl_indic_exp,incl_options,'H',l_portfolio,
184: nvl(l_wk_mth,'M'),trunc(sysdate));
185: exception

Line 292: trunc(sysdate),fnd_global.user_id,

288: number_of_items,acct_balance,portfolio_code,hedge_or_trade_view,discounted_back_to,forward_fx_rate,
289: selected_ccy,selected_ccy2,selected_indic,selected_options,hedge_trade_whatif,selected_portfolio,period_date)
290: values
291: (ref_number,l_ccy,l_date,round(l_amount,2),l_avg_days,l_weight_avg,l_combination,round(l_rate,5),
292: trunc(sysdate),fnd_global.user_id,
293: incl_options,l_company,l_base,l_pl,l_num_items,'N',l_portfolio,perspective,trunc(sysdate),l_fwd_fx_rate,
294: l_ccy_a,l_ccy_b,'N',incl_options,'T',l_portfolio,
295: --to_date(l_date,'MON-YYYY'));
296: l_ins_date);

Line 687: trunc(sysdate),fnd_global.user_id,

683: discounted_value,yield_curve,forward_fx_rate,selected_ccy,selected_indic,selected_options,
684: hedge_trade_whatif,selected_portfolio,period_date)
685: values
686: (ref_number,l_ccy,l_date,round(l_amount,2),l_avg_days,l_weight_avg,l_combination,round(l_rate,5),
687: trunc(sysdate),fnd_global.user_id,
688: incl_options,incl_indic_exp,l_company,l_base_ccy,l_num_items,'N',l_portfolio,decode(perspective,'^','W',perspective),disc_rate,
689: trunc(sysdate),disc_value,l_yield_curve,l_fwd_fx_rate,nvl(p_sel_ccy,'%'),incl_indic_exp,incl_options,'W',l_portfolio,
690: to_date(l_date,'DD-MM-YYYY'));
691: end if;

Line 725: fnd_global.user_id,incl_options,incl_indic_exp,l_company,l_base_ccy,l_num_items,'Y',l_portfolio,perspective,

721: discounted_value,yield_curve,selected_ccy,selected_indic,selected_options,
722: hedge_trade_whatif,selected_portfolio,period_date)
723: values
724: (ref_number,l_row_ccy,to_char(trunc(sysdate),'DD-MM-YYYY'),round(l_amount,2),1,0,null,null,trunc(sysdate),
725: fnd_global.user_id,incl_options,incl_indic_exp,l_company,l_base_ccy,l_num_items,'Y',l_portfolio,perspective,
726: 0,trunc(sysdate),l_amount,l_yield_curve,nvl(p_sel_ccy,'%'),incl_indic_exp,incl_options,'W',l_portfolio,trunc(sysdate));
727: end if;
728: exception
729: when others then

Line 801: trunc(sysdate),fnd_global.user_id,

797: discounted_value,yield_curve,forward_fx_rate,selected_ccy,selected_indic,selected_options,
798: hedge_trade_whatif,selected_portfolio,period_date)
799: values
800: (ref_number,l_row_ccy,l_date,round(l_amount,2),l_avg_days,l_weight_avg,l_combination,round(l_rate,5),
801: trunc(sysdate),fnd_global.user_id,
802: incl_options,incl_indic_exp,l_company,l_base_ccy,l_num_items,'N',l_portfolio,decode(perspective,'^','W',perspective),disc_rate,
803: trunc(sysdate),disc_value,l_yield_curve,l_fwd_fx_rate,nvl(p_sel_ccy,'%'),incl_indic_exp,incl_options,'W',l_portfolio,
804: to_date(l_date,'DD-MM-YYYY'));
805: end if;

Line 840: trunc(sysdate),fnd_global.user_id,incl_options,incl_indic_exp,l_company,l_base_ccy,l_base_ccy,nvl(p_sel_ccy,'%'),

836: company,base_currency,selected_base_currency,selected_ccy,selected_portfolio,yield_curve,
837: period_from,period_to,net_exposure,cover_to_forecast,max_amount,min_amount)
838: values
839: (ref_number,l_fx_ccy,l_period_name,l_period_desc,l_max,l_min,round(l_exp_amt,2),round(l_fx_amt,2),
840: trunc(sysdate),fnd_global.user_id,incl_options,incl_indic_exp,l_company,l_base_ccy,l_base_ccy,nvl(p_sel_ccy,'%'),
841: l_portfolio,l_yield_curve,l_p_from,l_p_to,nvl(round(l_exp_amt,2),0)+nvl(round(l_fx_amt,2),0),
842: decode(nvl(round(l_exp_amt,2),0),0,null,round(nvl(-100*round(l_fx_amt,2),0)/round(l_exp_amt,2),2)),
843: (nvl(l_max,0)*nvl(round(-l_exp_amt,2),0))/100-nvl(round(l_fx_amt,2),0),
844: (nvl(l_min,0)*nvl(round(-l_exp_amt,2),0))/100-nvl(round(l_fx_amt,2),0));