eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FII_GL_JE_B_C dependencies on FII_CURRENCY

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

366: -- Find all currency related information
367: --------------------------------------------------------------
368: g_phase := 'Find currency information';
369:
370: g_primary_mau := nvl(fii_currency.get_mau_primary, 0.01 );
371: g_secondary_mau:= nvl(fii_currency.get_mau_secondary, 0.01);
372: g_prim_currency := bis_common_parameters.get_currency_code;
373: g_sec_currency := bis_common_parameters.get_secondary_currency_code;
374: g_prim_rate_type := bis_common_parameters.get_rate_type;

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

367: --------------------------------------------------------------
368: g_phase := 'Find currency information';
369:
370: g_primary_mau := nvl(fii_currency.get_mau_primary, 0.01 );
371: g_secondary_mau:= nvl(fii_currency.get_mau_secondary, 0.01);
372: g_prim_currency := bis_common_parameters.get_currency_code;
373: g_sec_currency := bis_common_parameters.get_secondary_currency_code;
374: g_prim_rate_type := bis_common_parameters.get_rate_type;
375: g_sec_rate_type := bis_common_parameters.get_secondary_rate_type;

Line 1566: fii_currency.get_global_rate_primary(sob.currency_code, least(sysdate, line.effective_date)),

1562: ''E'', decode(njhi.encumbrance_type,
1563: ''OTHERS'', sum(NVL(line.accounted_cr, 0) - NVL(line.accounted_dr, 0)),
1564: 0),
1565: 0), -- For encumbrances: others (other_amount)
1566: fii_currency.get_global_rate_primary(sob.currency_code, least(sysdate, line.effective_date)),
1567: fii_currency.get_global_rate_secondary(sob.currency_code, least(sysdate, line.effective_date)),
1568: decode('''||g_industry||''',
1569: ''G'', decode(njhi.actual_flag, --for Government
1570: ''A'', null, -- for actuals

Line 1567: fii_currency.get_global_rate_secondary(sob.currency_code, least(sysdate, line.effective_date)),

1563: ''OTHERS'', sum(NVL(line.accounted_cr, 0) - NVL(line.accounted_dr, 0)),
1564: 0),
1565: 0), -- For encumbrances: others (other_amount)
1566: fii_currency.get_global_rate_primary(sob.currency_code, least(sysdate, line.effective_date)),
1567: fii_currency.get_global_rate_secondary(sob.currency_code, least(sysdate, line.effective_date)),
1568: decode('''||g_industry||''',
1569: ''G'', decode(njhi.actual_flag, --for Government
1570: ''A'', null, -- for actuals
1571: njhi.posted_date), -- for encumbrances

Line 1934: -- fii_currency.get_global_rate_primary(sob.currency_code, line.effective_date),

1930: fset2.currency_code,
1931: decode(v1.actual_flag,
1932: 'A', sum(NVL(line.accounted_cr, 0) - NVL(line.accounted_dr, 0)),
1933: 0),
1934: -- fii_currency.get_global_rate_primary(sob.currency_code, line.effective_date),
1935: -- fii_currency.get_global_rate_secondary(sob.currency_code, line.effective_date),
1936: -1,
1937: -1,
1938: decode(v1.actual_flag,

Line 1935: -- fii_currency.get_global_rate_secondary(sob.currency_code, line.effective_date),

1931: decode(v1.actual_flag,
1932: 'A', sum(NVL(line.accounted_cr, 0) - NVL(line.accounted_dr, 0)),
1933: 0),
1934: -- fii_currency.get_global_rate_primary(sob.currency_code, line.effective_date),
1935: -- fii_currency.get_global_rate_secondary(sob.currency_code, line.effective_date),
1936: -1,
1937: -1,
1938: decode(v1.actual_flag,
1939: 'E', decode(v1.encumbrance_type,

Line 2451: decode(cc, l_global_prim_curr_code, 1, FII_CURRENCY.GET_GLOBAL_RATE_PRIMARY (cc,least(sysdate, dt))) PRIM_CONVERSION_RATE,

2447: PRIM_CONVERSION_RATE,
2448: SEC_CONVERSION_RATE)
2449: select cc functional_currency,
2450: dt trx_date,
2451: decode(cc, l_global_prim_curr_code, 1, FII_CURRENCY.GET_GLOBAL_RATE_PRIMARY (cc,least(sysdate, dt))) PRIM_CONVERSION_RATE,
2452: decode(cc, l_global_sec_curr_code, 1, FII_CURRENCY.GET_GLOBAL_RATE_SECONDARY(cc,least(sysdate, dt))) SEC_CONVERSION_RATE
2453: from (
2454: select /*+ no_merge parallel(FII_gl_je_summary_STG)*/ distinct
2455: FUNCTIONAL_CURRENCY cc,

Line 2452: decode(cc, l_global_sec_curr_code, 1, FII_CURRENCY.GET_GLOBAL_RATE_SECONDARY(cc,least(sysdate, dt))) SEC_CONVERSION_RATE

2448: SEC_CONVERSION_RATE)
2449: select cc functional_currency,
2450: dt trx_date,
2451: decode(cc, l_global_prim_curr_code, 1, FII_CURRENCY.GET_GLOBAL_RATE_PRIMARY (cc,least(sysdate, dt))) PRIM_CONVERSION_RATE,
2452: decode(cc, l_global_sec_curr_code, 1, FII_CURRENCY.GET_GLOBAL_RATE_SECONDARY(cc,least(sysdate, dt))) SEC_CONVERSION_RATE
2453: from (
2454: select /*+ no_merge parallel(FII_gl_je_summary_STG)*/ distinct
2455: FUNCTIONAL_CURRENCY cc,
2456: effective_date dt

Line 3776: fii_currency.get_global_rate_primary(stg.functional_currency,least(sysdate, stg.effective_date))

3772: end if;
3773:
3774: Update FII_GL_JE_SUMMARY_STG stg
3775: SET prim_conversion_rate =
3776: fii_currency.get_global_rate_primary(stg.functional_currency,least(sysdate, stg.effective_date))
3777: WHERE stg.prim_conversion_rate < 0;
3778:
3779: if g_debug_flag = 'Y' then
3780: FII_UTIL.put_line('Updated ' || SQL%ROWCOUNT || ' records for primary currency rates in staging table');

Line 3791: fii_currency.get_global_rate_secondary(stg.functional_currency,least(sysdate, stg.effective_date))

3787: commit; --use commit after print out correct SQL%ROWCOUNT
3788:
3789: Update FII_GL_JE_SUMMARY_STG stg
3790: SET sec_conversion_rate =
3791: fii_currency.get_global_rate_secondary(stg.functional_currency,least(sysdate, stg.effective_date))
3792: WHERE stg.sec_conversion_rate < 0;
3793:
3794: if g_debug_flag = 'Y' then
3795: FII_UTIL.put_line('Updated ' || SQL%ROWCOUNT || ' records for secondary currency rates in staging table');