[Home] [Help]
80: and r.transaction_number = d.transaction_number
81: and r.MATURITY_DATE is NULL;
82: --
83: begin
84: delete from XTR_exposure_summary
85: where created_on < (trunc(sysdate) - 7);
86: commit;
87: open GET_EXPOSURES;
88: LOOP
133: end if;
134: */
135: --
136: begin
137: insert into XTR_EXPOSURE_SUMMARY
138: (unique_ref_number,currency,period,amount,average_days,weighted_average,currency_combination,
139: transaction_rate,created_on,created_by,incl_fx_options,incl_indic_exposures,company,base_currency,
140: number_of_items,acct_balance,portfolio_code,hedge_or_trade_view,discount_rate,discounted_back_to,
141: discounted_value,yield_curve,forward_fx_rate,selected_ccy,selected_indic,selected_options,
169: -- add On Call Cash Balances to Account Balances
170: l_amount := nvl(l_amount,0) + nvl(l_onc_amount,0);
171: --
172: begin
173: insert into XTR_EXPOSURE_SUMMARY
174: (unique_ref_number,currency,period,amount,average_days,weighted_average,currency_combination,
175: transaction_rate,created_on,created_by,incl_fx_options,incl_indic_exposures,company,base_currency,
176: number_of_items,acct_balance,portfolio_code,hedge_or_trade_view,discount_rate,discounted_back_to,
177: discounted_value,yield_curve,selected_ccy,selected_indic,selected_options,
243: from XTR_MASTER_CURRENCIES
244: where CURRENCY = l_ccy;
245: --
246: begin
247: delete from XTR_exposure_summary
248: where created_on < (trunc(sysdate) - 7);
249: commit;
250: open GET_CONTRACTS;
251: LOOP
281: l_base := substr(l_combination,5,3);
282: end if;
283: --
284: begin
285: insert into XTR_EXPOSURE_SUMMARY
286: (unique_ref_number,currency,period,amount,average_days,weighted_average,currency_combination,
287: transaction_rate,created_on,created_by,incl_fx_options,company,base_currency,discounted_value,
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)
580: cursor GET_FX_POSTION is
581: SELECT nvl(sum(decode(CURRENCY_COMBINATION,NULL,AMOUNT,0)),0) exp_amt,
582: nvl(sum(decode(CURRENCY_COMBINATION,NULL,0,
583: decode(currency,l_fx_ccy,AMOUNT,-AMOUNT*round(TRANSACTION_RATE,5)))),0) fx_amt
584: from XTR_EXPOSURE_SUMMARY
585: where UNIQUE_REF_NUMBER = ref_number
586: and((currency_combination is null and currency = l_fx_ccy) or
587: (currency_combination is not null and
588: (substr(currency_combination,1,3) = l_fx_ccy or substr(currency_combination,5,3) = l_fx_ccy)))
606: l_year_basis NUMBER;
607: l_rounding NUMBER;
608: --
609: begin
610: delete from XTR_exposure_summary
611: where created_on < (trunc(sysdate) - 7);
612: delete from XTR_tmp_fx_exposure
613: where created_on < (trunc(sysdate) - 7);
614: --
675: */
676: --
677: begin
678: if nvl(l_amount,0) <>0 then
679: insert into XTR_EXPOSURE_SUMMARY
680: (unique_ref_number,currency,period,amount,average_days,weighted_average,currency_combination,
681: transaction_rate,created_on,created_by,incl_fx_options,incl_indic_exposures,company,base_currency,
682: number_of_items,acct_balance,portfolio_code,hedge_or_trade_view,discount_rate,discounted_back_to,
683: discounted_value,yield_curve,forward_fx_rate,selected_ccy,selected_indic,selected_options,
713: l_amount := nvl(l_amount,0) + nvl(l_onc_amount,0);
714: --
715: begin
716: if nvl(l_amount,0) <>0 then
717: insert into XTR_EXPOSURE_SUMMARY
718: (unique_ref_number,currency,period,amount,average_days,weighted_average,currency_combination,
719: transaction_rate,created_on,created_by,incl_fx_options,incl_indic_exposures,company,base_currency,
720: number_of_items,acct_balance,portfolio_code,hedge_or_trade_view,discount_rate,discounted_back_to,
721: discounted_value,yield_curve,selected_ccy,selected_indic,selected_options,
789: */
790: --
791: begin
792: if nvl(l_amount,0) <>0 then
793: insert into XTR_EXPOSURE_SUMMARY
794: (unique_ref_number,currency,period,amount,average_days,weighted_average,currency_combination,
795: transaction_rate,created_on,created_by,incl_fx_options,incl_indic_exposures,company,base_currency,
796: number_of_items,acct_balance,portfolio_code,hedge_or_trade_view,discount_rate,discounted_back_to,
797: discounted_value,yield_curve,forward_fx_rate,selected_ccy,selected_indic,selected_options,