DBA Data[Home] [Help]

APPS.FII_AP_INV_SUM_INC dependencies on FII_CURRENCY

Line 302: g_primary_mau := nvl(fii_currency.get_mau_primary, 0.01 );

298: if g_debug_flag = 'Y' then
299: FII_UTIL.put_line('Initializing the Global Currency Precision');
300: end if;
301:
302: g_primary_mau := nvl(fii_currency.get_mau_primary, 0.01 );
303: g_secondary_mau:= nvl(fii_currency.get_mau_secondary, 0.01);
304:
305: if g_debug_flag = 'Y' then
306: FII_UTIL.put_line('Initializing the Global Currencies');

Line 303: g_secondary_mau:= nvl(fii_currency.get_mau_secondary, 0.01);

299: FII_UTIL.put_line('Initializing the Global Currency Precision');
300: end if;
301:
302: g_primary_mau := nvl(fii_currency.get_mau_primary, 0.01 );
303: g_secondary_mau:= nvl(fii_currency.get_mau_secondary, 0.01);
304:
305: if g_debug_flag = 'Y' then
306: FII_UTIL.put_line('Initializing the Global Currencies');
307: end if;

Line 557: FII_CURRENCY.GET_GLOBAL_RATE_PRIMARY(Functional_Currency,

553: Sec_Conversion_Rate)
554: SELECT Functional_Currency,
555: Trx_Date,
556: DECODE(Functional_Currency, g_prim_currency, 1,
557: FII_CURRENCY.GET_GLOBAL_RATE_PRIMARY(Functional_Currency,
558: least(Trx_Date,sysdate))) PRIM_CONVERSION_RATE,
559: DECODE(Functional_Currency, g_sec_currency, 1,
560: FII_CURRENCY.GET_GLOBAL_RATE_SECONDARY(Functional_Currency,
561: least(Trx_Date,sysdate))) SEC_CONVERSION_RATE

Line 560: FII_CURRENCY.GET_GLOBAL_RATE_SECONDARY(Functional_Currency,

556: DECODE(Functional_Currency, g_prim_currency, 1,
557: FII_CURRENCY.GET_GLOBAL_RATE_PRIMARY(Functional_Currency,
558: least(Trx_Date,sysdate))) PRIM_CONVERSION_RATE,
559: DECODE(Functional_Currency, g_sec_currency, 1,
560: FII_CURRENCY.GET_GLOBAL_RATE_SECONDARY(Functional_Currency,
561: least(Trx_Date,sysdate))) SEC_CONVERSION_RATE
562: FROM (SELECT /*+ no_merge */ DISTINCT
563: Func_Currency Functional_Currency,
564: Invoice_Date Trx_Date

Line 595: FII_CURRENCY.get_rate(From_Currency, To_Currency,

591: Trx_Date,
592: Exchange_Rate_Type,
593: DECODE(Exchange_Rate_Type, 'User', Exchange_Rate, 'No Rate Type', 1,
594: DECODE(From_Currency, To_Currency, 1,
595: FII_CURRENCY.get_rate(From_Currency, To_Currency,
596: least(Trx_Date,sysdate), Exchange_Rate_Type)))
597: Conversion_Rate,
598: Functional_MAU
599: FROM (SELECT /*+ no_merge */ DISTINCT