DBA Data[Home] [Help]

APPS.XTR_EXP_SUMM_P dependencies on XTR_FPS2_P

Line 105: XTR_fps2_P.EXTRAPOLATE_FROM_YIELD_CURVE(sel_ccy,l_avg_days,l_yield_curve,disc_rate);

101: if l_avg_days = 0 then
102: l_avg_days := 1;
103: end if;
104: if l_yield_curve is NOT NULL then
105: XTR_fps2_P.EXTRAPOLATE_FROM_YIELD_CURVE(sel_ccy,l_avg_days,l_yield_curve,disc_rate);
106: else
107: XTR_fps2_P.EXTRAPOLATE_FROM_MARKET_PRICES(sel_ccy,l_avg_days,disc_rate);
108: end if;
109: if nvl(disc_rate,0) = 0 then

Line 107: XTR_fps2_P.EXTRAPOLATE_FROM_MARKET_PRICES(sel_ccy,l_avg_days,disc_rate);

103: end if;
104: if l_yield_curve is NOT NULL then
105: XTR_fps2_P.EXTRAPOLATE_FROM_YIELD_CURVE(sel_ccy,l_avg_days,l_yield_curve,disc_rate);
106: else
107: XTR_fps2_P.EXTRAPOLATE_FROM_MARKET_PRICES(sel_ccy,l_avg_days,disc_rate);
108: end if;
109: if nvl(disc_rate,0) = 0 then
110: -- Use Default Discount Rate
111: if nvl(l_dflt_disc_rate,0) = 0 then

Line 115: XTR_fps2_P.DISCOUNT_INTEREST_CALC(nvl(l_year_basis,360),l_amount,disc_rate,l_avg_days,

111: if nvl(l_dflt_disc_rate,0) = 0 then
112: disc_value := l_amount;
113: else
114: disc_rate := l_dflt_disc_rate;
115: XTR_fps2_P.DISCOUNT_INTEREST_CALC(nvl(l_year_basis,360),l_amount,disc_rate,l_avg_days,
116: nvl(l_rounding,2),disc_value);
117: disc_value := l_amount - disc_value;
118: end if;
119: else

Line 120: XTR_fps2_P.DISCOUNT_INTEREST_CALC(nvl(l_year_basis,360),l_amount,disc_rate,l_avg_days,

116: nvl(l_rounding,2),disc_value);
117: disc_value := l_amount - disc_value;
118: end if;
119: else
120: XTR_fps2_P.DISCOUNT_INTEREST_CALC(nvl(l_year_basis,360),l_amount,disc_rate,l_avg_days,
121: nvl(l_rounding,2),disc_value);
122: disc_value := l_amount - disc_value;
123: end if;
124: --

Line 373: XTR_fps2_P.EXTRAPOLATE_FROM_MARKET_PRICES(l_ccy,l_days,l_base_int_rate);

369: goto ERROR_OCCURRED;
370: end if;
371: close FX_SPOT_RATE;
372: end if;
373: XTR_fps2_P.EXTRAPOLATE_FROM_MARKET_PRICES(l_ccy,l_days,l_base_int_rate);
374: --
375: l_ccy := l_ccyb;
376: if l_ccy = 'USD' then
377: l_ccyb_spot := 1;

Line 388: XTR_fps2_P.EXTRAPOLATE_FROM_MARKET_PRICES(l_ccy,l_days,l_contra_int_rate);

384: goto ERROR_OCCURRED;
385: end if;
386: close FX_SPOT_RATE;
387: end if;
388: XTR_fps2_P.EXTRAPOLATE_FROM_MARKET_PRICES(l_ccy,l_days,l_contra_int_rate);
389: --
390: l_ccy := 'USD';
391: XTR_fps2_P.EXTRAPOLATE_FROM_MARKET_PRICES(l_ccy,l_days,l_usd_int_rate);
392: --

Line 391: XTR_fps2_P.EXTRAPOLATE_FROM_MARKET_PRICES(l_ccy,l_days,l_usd_int_rate);

387: end if;
388: XTR_fps2_P.EXTRAPOLATE_FROM_MARKET_PRICES(l_ccy,l_days,l_contra_int_rate);
389: --
390: l_ccy := 'USD';
391: XTR_fps2_P.EXTRAPOLATE_FROM_MARKET_PRICES(l_ccy,l_days,l_usd_int_rate);
392: --
393: open C1;
394: fetch C1 INTO base_curr_year_basis,l_round1,contra_curr_year_basis,l_round2,
395: usd_curr_year_basis,l_round3,tmp_calc_h,l_base_contra_ccya,tmp_calc_k,l_base_contra_ccyb;

Line 646: XTR_fps2_P.EXTRAPOLATE_FROM_YIELD_CURVE(sel_ccy,l_avg_days,l_yield_curve,disc_rate);

642: if l_avg_days = 0 then
643: l_avg_days := 1;
644: end if;
645: if l_yield_curve is NOT NULL then
646: XTR_fps2_P.EXTRAPOLATE_FROM_YIELD_CURVE(sel_ccy,l_avg_days,l_yield_curve,disc_rate);
647: else
648: XTR_fps2_P.EXTRAPOLATE_FROM_MARKET_PRICES(sel_ccy,l_avg_days,disc_rate);
649: end if;
650: if nvl(disc_rate,0) = 0 then

Line 648: XTR_fps2_P.EXTRAPOLATE_FROM_MARKET_PRICES(sel_ccy,l_avg_days,disc_rate);

644: end if;
645: if l_yield_curve is NOT NULL then
646: XTR_fps2_P.EXTRAPOLATE_FROM_YIELD_CURVE(sel_ccy,l_avg_days,l_yield_curve,disc_rate);
647: else
648: XTR_fps2_P.EXTRAPOLATE_FROM_MARKET_PRICES(sel_ccy,l_avg_days,disc_rate);
649: end if;
650: if nvl(disc_rate,0) = 0 then
651: -- Use Default Discount Rate
652: if nvl(l_dflt_disc_rate,0) = 0 then

Line 656: XTR_fps2_P.DISCOUNT_INTEREST_CALC(nvl(l_year_basis,360),l_amount,disc_rate,l_avg_days,

652: if nvl(l_dflt_disc_rate,0) = 0 then
653: disc_value := l_amount;
654: else
655: disc_rate := l_dflt_disc_rate;
656: XTR_fps2_P.DISCOUNT_INTEREST_CALC(nvl(l_year_basis,360),l_amount,disc_rate,l_avg_days,
657: nvl(l_rounding,2),disc_value);
658: disc_value := l_amount - disc_value;
659: end if;
660: else

Line 661: XTR_fps2_P.DISCOUNT_INTEREST_CALC(nvl(l_year_basis,360),l_amount,disc_rate,l_avg_days,

657: nvl(l_rounding,2),disc_value);
658: disc_value := l_amount - disc_value;
659: end if;
660: else
661: XTR_fps2_P.DISCOUNT_INTEREST_CALC(nvl(l_year_basis,360),l_amount,disc_rate,l_avg_days,
662: nvl(l_rounding,2),disc_value);
663: disc_value := l_amount - disc_value;
664: end if;
665: --

Line 760: XTR_fps2_P.EXTRAPOLATE_FROM_YIELD_CURVE(l_row_ccy,l_avg_days,l_yield_curve,disc_rate);

756: if l_avg_days = 0 then
757: l_avg_days := 1;
758: end if;
759: if l_yield_curve is NOT NULL then
760: XTR_fps2_P.EXTRAPOLATE_FROM_YIELD_CURVE(l_row_ccy,l_avg_days,l_yield_curve,disc_rate);
761: else
762: XTR_fps2_P.EXTRAPOLATE_FROM_MARKET_PRICES(l_row_ccy,l_avg_days,disc_rate);
763: end if;
764: if nvl(disc_rate,0) = 0 then

Line 762: XTR_fps2_P.EXTRAPOLATE_FROM_MARKET_PRICES(l_row_ccy,l_avg_days,disc_rate);

758: end if;
759: if l_yield_curve is NOT NULL then
760: XTR_fps2_P.EXTRAPOLATE_FROM_YIELD_CURVE(l_row_ccy,l_avg_days,l_yield_curve,disc_rate);
761: else
762: XTR_fps2_P.EXTRAPOLATE_FROM_MARKET_PRICES(l_row_ccy,l_avg_days,disc_rate);
763: end if;
764: if nvl(disc_rate,0) = 0 then
765: -- Use Default Discount Rate
766: if nvl(l_dflt_disc_rate,0) = 0 then

Line 770: XTR_fps2_P.DISCOUNT_INTEREST_CALC(nvl(l_year_basis,360),l_amount,disc_rate,l_avg_days,

766: if nvl(l_dflt_disc_rate,0) = 0 then
767: disc_value := l_amount;
768: else
769: disc_rate := l_dflt_disc_rate;
770: XTR_fps2_P.DISCOUNT_INTEREST_CALC(nvl(l_year_basis,360),l_amount,disc_rate,l_avg_days,
771: nvl(l_rounding,2),disc_value);
772: disc_value := l_amount - disc_value;
773: end if;
774: else

Line 775: XTR_fps2_P.DISCOUNT_INTEREST_CALC(nvl(l_year_basis,360),l_amount,disc_rate,l_avg_days,

771: nvl(l_rounding,2),disc_value);
772: disc_value := l_amount - disc_value;
773: end if;
774: else
775: XTR_fps2_P.DISCOUNT_INTEREST_CALC(nvl(l_year_basis,360),l_amount,disc_rate,l_avg_days,
776: nvl(l_rounding,2),disc_value);
777: disc_value := l_amount - disc_value;
778: end if;
779: --