APPS.FII_AP_INV_SUM_INIT dependencies on FII_CURRENCY

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

129: if g_debug_flag = 'Y' then
130: FII_UTIL.put_line('Initializing the Global Currency Precision');
131: end if;
132:
133: g_primary_mau := nvl(fii_currency.get_mau_primary, 0.01 );
134: g_secondary_mau:= nvl(fii_currency.get_mau_secondary, 0.01);
135:
136: if g_debug_flag = 'Y' then
137: FII_UTIL.put_line('Initializing the Global Currencies');

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

130: FII_UTIL.put_line('Initializing the Global Currency Precision');
131: end if;
132:
133: g_primary_mau := nvl(fii_currency.get_mau_primary, 0.01 );
134: g_secondary_mau:= nvl(fii_currency.get_mau_secondary, 0.01);
135:
136: if g_debug_flag = 'Y' then
137: FII_UTIL.put_line('Initializing the Global Currencies');
138: end if;

Line 990: FII_CURRENCY.GET_GLOBAL_RATE_PRIMARY (Curr_Code, LEAST(Trx_Date,sysdate)))

986: Sec_Conversion_Rate)
987: SELECT Curr_Code,
988: Trx_Date,
989: DECODE(Curr_Code, g_prim_currency, 1,
990: FII_CURRENCY.GET_GLOBAL_RATE_PRIMARY (Curr_Code, LEAST(Trx_Date,sysdate)))
991: PRIM_CONVERSION_RATE,
992: DECODE(Curr_Code, g_sec_currency, 1,
993: FII_CURRENCY.GET_GLOBAL_RATE_SECONDARY(Curr_Code, LEAST(Trx_Date,sysdate)))
994: SEC_CONVERSION_RATE

Line 993: FII_CURRENCY.GET_GLOBAL_RATE_SECONDARY(Curr_Code, LEAST(Trx_Date,sysdate)))

989: DECODE(Curr_Code, g_prim_currency, 1,
990: FII_CURRENCY.GET_GLOBAL_RATE_PRIMARY (Curr_Code, LEAST(Trx_Date,sysdate)))
991: PRIM_CONVERSION_RATE,
992: DECODE(Curr_Code, g_sec_currency, 1,
993: FII_CURRENCY.GET_GLOBAL_RATE_SECONDARY(Curr_Code, LEAST(Trx_Date,sysdate)))
994: SEC_CONVERSION_RATE
995: FROM (
996: SELECT /*+ parallel(ASP) parallel(AI) use_hash(AI) */
997: Distinct ASP.Base_Currency_code Curr_Code,

Line 1037: FII_CURRENCY.get_rate(From_Currency, To_Currency,

1033: Trx_Date,
1034: Exchange_Rate_Type,
1035: DECODE(Exchange_Rate_Type, 'User', Exchange_Rate, 'No Rate Type', 1,
1036: DECODE(From_Currency, To_Currency, 1,
1037: FII_CURRENCY.get_rate(From_Currency, To_Currency,
1038: LEAST(Trx_Date,sysdate), Exchange_Rate_Type)))
1039: Conversion_Rate,
1040: Functional_MAU
1041: FROM (