[Home] [Help]
1527:
1528: begin
1529: select rounding_factor
1530: into l_round
1531: from xtr_master_currencies_v
1532: where currency = rec.reval_ccy;
1533:
1534: l_market_set := rec.MARKET_DATA_SET;
1535: xtr_revl_get_mds(l_market_set, rec);
2021:
2022: begin
2023: select rounding_factor
2024: into l_round
2025: from xtr_master_currencies_v
2026: where currency = rec.reval_ccy;
2027:
2028: xtr_get_fv_from_batch(rec, l_ex_fv, l_dummy, cum_pl_value, l_dummy2);
2029:
2454: PARAMETER_CODE = C_BEGIN_FV;
2455:
2456: select rounding_factor
2457: into l_round
2458: from xtr_master_currencies_v
2459: where currency = rec.sob_ccy;
2460:
2461: if l_begin_fv = 'BEGIN' then -- currency G/L = last batch's fair value * (rate1 - rate0)
2462: xtr_get_fv_from_batch(rec, l_fair_value, l_dummy, l_dummy1, l_dummy2);
2597:
2598: Begin
2599: select rounding_factor
2600: into l_round
2601: from xtr_master_currencies_v
2602: where currency = rec.sob_ccy;
2603:
2604: if rec.reval_ccy = rec.sob_ccy then -- No curency G/L calculation needed
2605: rel_currency_gl := 0;
2947: Begin
2948: retcode := 1;
2949: select rounding_factor
2950: into l_round
2951: from xtr_master_currencies_v
2952: where currency = rec.sob_ccy;
2953:
2954: ----------------------------------------------------------------------
2955: -- Obtain GL exchange rate on the batch end date
3447: Begin
3448: retcode := 1;
3449: select rounding_factor
3450: into l_round
3451: from xtr_master_currencies_v
3452: where currency = rec.sob_ccy;
3453:
3454: -------------------------------------------------
3455: -- Obtain GL exchange rate on the batch end date
3859: Begin
3860: retcode := 1;
3861: select rounding_factor
3862: into l_round
3863: from xtr_master_currencies_v
3864: where currency = rec.sob_ccy;
3865:
3866: GL_CURRENCY_API.get_triangulation_rate
3867: (rec.reval_ccy, rec.sob_ccy, rec.revldate, rec.ex_rate_type,
4584:
4585: begin
4586: select rounding_factor
4587: into l_round
4588: from xtr_master_currencies_v
4589: where currency = rec.reval_ccy;
4590:
4591: /*********** TMM ending FV **********************/
4592: if rec.deal_type = 'TMM' then
5211: and param_name = 'FX_REALIZED_RATE';
5212:
5213: select rounding_factor
5214: into l_round
5215: from xtr_master_currencies_v
5216: where currency = rec.reval_ccy;
5217:
5218: if g_call_by_form = TRUE then
5219: -- called from form for FX rollover/predelive
5546: rec.reval_ex_rate_two :=NULL;
5547:
5548: select rounding_factor
5549: into l_round
5550: from xtr_master_currencies_v
5551: where currency = rec.reval_ccy;
5552:
5553: l_base_ccy := rec.currencya;
5554: l_contra_ccy := rec.currencyb;
6391:
6392: BEGIN
6393: select rounding_factor
6394: into l_round
6395: from xtr_master_currencies_v
6396: where currency = rec.reval_ccy;
6397:
6398: /* Derive the correct current hedge amount for the broken down piece */
6399: open C_CUR_HEDGE_AMT;
6567: LOG_MSG('Entering xtr_hedge_fwd_rate');
6568:
6569: select rounding_factor
6570: into l_round
6571: from xtr_master_currencies_v
6572: where currency = rec.reval_ccy;
6573:
6574: /* Derive the correct current hedge amount for the broken down piece */
6575: open C_CUR_HEDGE_AMT;
7634:
7635: Begin
7636: select ROUNDING_FACTOR
7637: into l_rounding
7638: from XTR_MASTER_CURRENCIES_V
7639: where currency = rec.currencya;
7640:
7641: bo_rec.batch_id := rec.batch_id;
7642: xtr_first_reval(rec, l_first);
7817:
7818: Begin
7819: select rounding_factor
7820: into l_round
7821: from xtr_master_currencies_v
7822: where currency = rec.reval_ccy;
7823:
7824: r_rd.amount_type := 'REAL'; -- 'REALMTM'
7825: rec.reval_ccy := rec.currencya;
7967: end if;
7968:
7969: select rounding_factor
7970: into l_round
7971: from xtr_master_currencies_v
7972: where currency = rec.reval_ccy;
7973:
7974: If p_resale = TRUE then
7975: -- record is a result of resale. Create last unrealized G/L record for resold amount.
8223: where deal_no = rec.deal_no;
8224:
8225: select rounding_factor
8226: into l_round
8227: from xtr_master_currencies_v
8228: where currency = rec.reval_ccy;
8229:
8230: l_market_set := rec.MARKET_DATA_SET;
8231: xtr_revl_get_mds(l_market_set, rec);
8688: l_buf Varchar2(500);
8689: BEGIN
8690: select ROUNDING_FACTOR
8691: into l_rounding
8692: from XTR_MASTER_CURRENCIES_V
8693: where currency = rec.currencya;
8694: xtr_first_reval(rec, l_first);
8695: if l_first = TRUE then -- first time reval
8696: l_pre_batch := NULL;
8879: end if;
8880:
8881: select rounding_factor
8882: into l_round
8883: from xtr_master_currencies_v
8884: where currency = rec.reval_ccy;
8885:
8886: If p_resale = TRUE then
8887: -- record is a result of resale. Create last unrealized G/L record for resold amount.
9363:
9364: Begin
9365: select rounding_factor
9366: into l_round
9367: from xtr_master_currencies_v
9368: where currency = rec.reval_ccy;
9369:
9370: select fixed_or_floating_rate, day_count_type, rounding_type, start_date, margin
9371: into l_fix_float, l_day_count_type, l_round_type, l_deal_begin_date,
9669:
9670: Begin
9671: select rounding_factor
9672: into l_round
9673: from xtr_master_currencies_v
9674: where currency = rec.reval_ccy;
9675:
9676: select all_in_rate, rounding_type
9677: into l_all_in_rate, l_rounding_type -- 5130446