APPS.FII_AP_INV_DISTRIBUTIONS_B_C dependencies on FII_CURRENCY

Line 349: fii_currency.get_global_rate_primary( gsob.currency_code,

345: glcc.company_id,
346: glcc.cost_center_id,
347: aid.po_distribution_id,
348: decode(gsob.currency_code, g_prim_currency, 1,
349: fii_currency.get_global_rate_primary( gsob.currency_code,
350: trunc(least(aid.accounting_date,sysdate)))) PRIM_CONVERSION_RATE,
351: decode(gsob.currency_code, g_sec_currency, 1,
352: fii_currency.get_global_rate_secondary( gsob.currency_code,
353: trunc(least(aid.accounting_date,sysdate)))) SEC_CONVERSION_RATE,

Line 352: fii_currency.get_global_rate_secondary( gsob.currency_code,

348: decode(gsob.currency_code, g_prim_currency, 1,
349: fii_currency.get_global_rate_primary( gsob.currency_code,
350: trunc(least(aid.accounting_date,sysdate)))) PRIM_CONVERSION_RATE,
351: decode(gsob.currency_code, g_sec_currency, 1,
352: fii_currency.get_global_rate_secondary( gsob.currency_code,
353: trunc(least(aid.accounting_date,sysdate)))) SEC_CONVERSION_RATE,
354: NVL(aid.posted_flag, 'N') POSTED_FLAG,
355: NVL(aid.match_status_flag, 'N') APPROVED_FLAG,
356: NVL(ai.org_id, -1) ORG_ID,

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

963: -- get minimum accountable unit of the warehouse currency
964: -- --------------------------------------------------------
965: g_phase := 'Find currency information';
966:
967: g_primary_mau := nvl(fii_currency.get_mau_primary, 0.01 );
968: g_secondary_mau:= nvl(fii_currency.get_mau_secondary, 0.01);
969:
970: g_prim_currency := bis_common_parameters.get_currency_code;
971: g_sec_currency := bis_common_parameters.get_secondary_currency_code;

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

964: -- --------------------------------------------------------
965: g_phase := 'Find currency information';
966:
967: g_primary_mau := nvl(fii_currency.get_mau_primary, 0.01 );
968: g_secondary_mau:= nvl(fii_currency.get_mau_secondary, 0.01);
969:
970: g_prim_currency := bis_common_parameters.get_currency_code;
971: g_sec_currency := bis_common_parameters.get_secondary_currency_code;
972:

Line 1269: decode(cc, g_prim_currency, 1, FII_CURRENCY.GET_GLOBAL_RATE_PRIMARY (cc,least(dt,sysdate))) PRIM_CONVERSION_RATE,

1265: PRIM_CONVERSION_RATE,
1266: SEC_CONVERSION_RATE)
1267: select cc functional_currency,
1268: dt trx_date,
1269: decode(cc, g_prim_currency, 1, FII_CURRENCY.GET_GLOBAL_RATE_PRIMARY (cc,least(dt,sysdate))) PRIM_CONVERSION_RATE,
1270: decode(cc, g_sec_currency, 1, FII_CURRENCY.GET_GLOBAL_RATE_SECONDARY(cc,least(dt,sysdate))) SEC_CONVERSION_RATE
1271: from (
1272: select /*+ no_merge */ distinct
1273: inv_currency_code cc,

Line 1270: decode(cc, g_sec_currency, 1, FII_CURRENCY.GET_GLOBAL_RATE_SECONDARY(cc,least(dt,sysdate))) SEC_CONVERSION_RATE

1266: SEC_CONVERSION_RATE)
1267: select cc functional_currency,
1268: dt trx_date,
1269: decode(cc, g_prim_currency, 1, FII_CURRENCY.GET_GLOBAL_RATE_PRIMARY (cc,least(dt,sysdate))) PRIM_CONVERSION_RATE,
1270: decode(cc, g_sec_currency, 1, FII_CURRENCY.GET_GLOBAL_RATE_SECONDARY(cc,least(dt,sysdate))) SEC_CONVERSION_RATE
1271: from (
1272: select /*+ no_merge */ distinct
1273: inv_currency_code cc,
1274: account_date dt

Line 2005: fii_currency.get_global_rate_primary(stg.inv_currency_code,

2001:
2002: --modified by ilavenil to handle future dated transaction. The change is usage of least(...,sysdate)
2003: UPDATE FII_AP_INV_DIST_T stg
2004: SET stg.PRIM_CONVERSION_RATE = DECODE(stg.inv_currency_code, g_prim_currency, 1,
2005: fii_currency.get_global_rate_primary(stg.inv_currency_code,
2006: least(stg.account_date,sysdate)))
2007: WHERE stg.PRIM_CONVERSION_RATE < 0;
2008:
2009: l_rowcount := SQL%ROWCOUNT;

Line 2026: fii_currency.get_global_rate_secondary(stg.inv_currency_code,

2022:
2023: --modified by ilavenil to handle future dated transaction. The change is usage of least(...,sysdate)
2024: UPDATE FII_AP_INV_DIST_T stg
2025: SET stg.SEC_CONVERSION_RATE = decode(stg.inv_currency_code, g_sec_currency, 1,
2026: fii_currency.get_global_rate_secondary(stg.inv_currency_code,
2027: least( stg.account_date,sysdate)))
2028: WHERE stg.SEC_CONVERSION_RATE < 0;
2029:
2030: l_rowcount := SQL%ROWCOUNT;