APPS.FII_AP_INV_B_C dependencies on FII_CURRENCY

Line 498: fii_currency.get_global_rate_primary( gsob.currency_code,

494: aid.quantity_invoiced,
495: aid.project_id,
496: aid.task_id,
497: decode(gsob.currency_code, g_prim_currency, 1,
498: fii_currency.get_global_rate_primary( gsob.currency_code,
499: trunc(least(aid.accounting_date,sysdate)))) PRIM_CONVERSION_RATE,
500: decode(gsob.currency_code, g_sec_currency, 1,
501: fii_currency.get_global_rate_secondary( gsob.currency_code,
502: trunc(least(aid.accounting_date,sysdate)))) SEC_CONVERSION_RATE,

Line 501: fii_currency.get_global_rate_secondary( gsob.currency_code,

497: decode(gsob.currency_code, g_prim_currency, 1,
498: fii_currency.get_global_rate_primary( gsob.currency_code,
499: trunc(least(aid.accounting_date,sysdate)))) PRIM_CONVERSION_RATE,
500: decode(gsob.currency_code, g_sec_currency, 1,
501: fii_currency.get_global_rate_secondary( gsob.currency_code,
502: trunc(least(aid.accounting_date,sysdate)))) SEC_CONVERSION_RATE,
503: NVL(aid.match_status_flag, 'N') APPROVED_FLAG,
504: NVL(ai.org_id, -1) ORG_ID,
505: nvl(po.employee_id, ai.paid_on_behalf_employee_id),

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

1183: -- get minimum accountable unit of the warehouse currency
1184: -- --------------------------------------------------------
1185: g_phase := 'Find currency information';
1186:
1187: g_primary_mau := nvl(fii_currency.get_mau_primary, 0.01 );
1188: g_secondary_mau:= nvl(fii_currency.get_mau_secondary, 0.01);
1189:
1190: g_prim_currency := bis_common_parameters.get_currency_code;
1191: g_sec_currency := bis_common_parameters.get_secondary_currency_code;

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

1184: -- --------------------------------------------------------
1185: g_phase := 'Find currency information';
1186:
1187: g_primary_mau := nvl(fii_currency.get_mau_primary, 0.01 );
1188: g_secondary_mau:= nvl(fii_currency.get_mau_secondary, 0.01);
1189:
1190: g_prim_currency := bis_common_parameters.get_currency_code;
1191: g_sec_currency := bis_common_parameters.get_secondary_currency_code;
1192:

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

1593: PRIM_CONVERSION_RATE,
1594: SEC_CONVERSION_RATE)
1595: select cc functional_currency,
1596: dt trx_date,
1597: decode(cc, g_prim_currency, 1, FII_CURRENCY.GET_GLOBAL_RATE_PRIMARY (cc,least(dt,sysdate))) PRIM_CONVERSION_RATE,
1598: decode(cc, g_sec_currency, 1, FII_CURRENCY.GET_GLOBAL_RATE_SECONDARY(cc,least(dt,sysdate))) SEC_CONVERSION_RATE
1599: from (
1600: select /*+ no_merge */ distinct
1601: inv_currency_code cc,

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

1594: SEC_CONVERSION_RATE)
1595: select cc functional_currency,
1596: dt trx_date,
1597: decode(cc, g_prim_currency, 1, FII_CURRENCY.GET_GLOBAL_RATE_PRIMARY (cc,least(dt,sysdate))) PRIM_CONVERSION_RATE,
1598: decode(cc, g_sec_currency, 1, FII_CURRENCY.GET_GLOBAL_RATE_SECONDARY(cc,least(dt,sysdate))) SEC_CONVERSION_RATE
1599: from (
1600: select /*+ no_merge */ distinct
1601: inv_currency_code cc,
1602: account_date dt

Line 2280: fii_currency.get_global_rate_primary(stg.inv_currency_code,

2276:
2277: --modified by ilavenil to handle future dated transaction. The change is usage of least(...,sysdate)
2278: UPDATE FII_AP_INV_STG stg
2279: SET stg.PRIM_CONVERSION_RATE = DECODE(stg.inv_currency_code, g_prim_currency, 1,
2280: fii_currency.get_global_rate_primary(stg.inv_currency_code,
2281: least(stg.account_date,sysdate)))
2282: WHERE stg.PRIM_CONVERSION_RATE < 0;
2283:
2284: l_rowcount := SQL%ROWCOUNT;

Line 2301: fii_currency.get_global_rate_secondary(stg.inv_currency_code,

2297:
2298: --modified by ilavenil to handle future dated transaction. The change is usage of least(...,sysdate)
2299: UPDATE FII_AP_INV_STG stg
2300: SET stg.SEC_CONVERSION_RATE = decode(stg.inv_currency_code, g_sec_currency, 1,
2301: fii_currency.get_global_rate_secondary(stg.inv_currency_code,
2302: least( stg.account_date,sysdate)))
2303: WHERE stg.SEC_CONVERSION_RATE < 0;
2304:
2305: l_rowcount := SQL%ROWCOUNT;