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.

[Home] [Help]

APPS.FII_AR_REVENUE_B_C dependencies on FII_CURRENCY

Line 305: g_mau_prim := NVL(FII_CURRENCY.GET_MAU_PRIMARY, 0.01 );

301: g_section := 'Section 50';
302: ------------------------------------------------------
303: -- get minimum accountable unit of the global currency
304: ------------------------------------------------------
305: g_mau_prim := NVL(FII_CURRENCY.GET_MAU_PRIMARY, 0.01 );
306: g_mau_sec := NVL(FII_CURRENCY.GET_MAU_SECONDARY, 0.01 );
307:
308: g_section := 'Section 60';
309:

Line 306: g_mau_sec := NVL(FII_CURRENCY.GET_MAU_SECONDARY, 0.01 );

302: ------------------------------------------------------
303: -- get minimum accountable unit of the global currency
304: ------------------------------------------------------
305: g_mau_prim := NVL(FII_CURRENCY.GET_MAU_PRIMARY, 0.01 );
306: g_mau_sec := NVL(FII_CURRENCY.GET_MAU_SECONDARY, 0.01 );
307:
308: g_section := 'Section 60';
309:
310: g_fii_user_id := FND_GLOBAL.User_Id;

Line 565: fii_currency.get_global_rate_primary(sob.currency_code,

561: 'ORDER ENTRY',ctl_parent.interface_line_attribute1,
562: 'INTERCOMPANY',ctl_parent.interface_line_attribute1,
563: ctl_parent.sales_order),1,30) ORDER_NUMBER,
564: 'Y' POSTED_FLAG,
565: fii_currency.get_global_rate_primary(sob.currency_code,
566: trunc(least(trunc(aeh.accounting_date), sysdate))) PRIM_CONVERSION_RATE,
567: fii_currency.get_global_rate_secondary(sob.currency_code,
568: trunc(least(trunc(aeh.accounting_date), sysdate))) SEC_CONVERSION_RATE,
569: ccdim.prod_category_id PROD_CATEGORY_ID,

Line 567: fii_currency.get_global_rate_secondary(sob.currency_code,

563: ctl_parent.sales_order),1,30) ORDER_NUMBER,
564: 'Y' POSTED_FLAG,
565: fii_currency.get_global_rate_primary(sob.currency_code,
566: trunc(least(trunc(aeh.accounting_date), sysdate))) PRIM_CONVERSION_RATE,
567: fii_currency.get_global_rate_secondary(sob.currency_code,
568: trunc(least(trunc(aeh.accounting_date), sysdate))) SEC_CONVERSION_RATE,
569: ccdim.prod_category_id PROD_CATEGORY_ID,
570: sob.chart_of_accounts_id CHART_OF_ACCOUNTS_ID,
571: -- ffcta.fin_cat_type_code FIN_CAT_TYPE_CODE,

Line 843: FII_CURRENCY.GET_GLOBAL_RATE_PRIMARY(sob.currency_code,

839: 'INTERCOMPANY',ctl_parent.interface_line_attribute1,
840: ctl_parent.sales_order),1,30) ORDER_NUMBER, */
841: null ORDER_NUMBER,
842: 'Y' POSTED_FLAG,
843: FII_CURRENCY.GET_GLOBAL_RATE_PRIMARY(sob.currency_code,
844: trunc(least(trunc(aeh.accounting_date), sysdate))) PRIM_CONVERSION_RATE,
845: FII_CURRENCY.GET_GLOBAL_RATE_SECONDARY(sob.currency_code,
846: trunc(least(trunc(aeh.accounting_date), sysdate))) SEC_CONVERSION_RATE,
847: ccdim.prod_category_id PROD_CATEGORY_ID,

Line 845: FII_CURRENCY.GET_GLOBAL_RATE_SECONDARY(sob.currency_code,

841: null ORDER_NUMBER,
842: 'Y' POSTED_FLAG,
843: FII_CURRENCY.GET_GLOBAL_RATE_PRIMARY(sob.currency_code,
844: trunc(least(trunc(aeh.accounting_date), sysdate))) PRIM_CONVERSION_RATE,
845: FII_CURRENCY.GET_GLOBAL_RATE_SECONDARY(sob.currency_code,
846: trunc(least(trunc(aeh.accounting_date), sysdate))) SEC_CONVERSION_RATE,
847: ccdim.prod_category_id PROD_CATEGORY_ID,
848: sob.chart_of_accounts_id CHART_OF_ACCOUNTS_ID,
849: -- ffcta.fin_cat_type_code FIN_CAT_TYPE_CODE,

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

3465: PRIM_CONVERSION_RATE,
3466: SEC_CONVERSION_RATE)
3467: select cc functional_currency,
3468: dt trx_date,
3469: decode(cc, l_global_prim_curr_code, 1, FII_CURRENCY.GET_GLOBAL_RATE_PRIMARY (cc,least(dt, sysdate))) PRIM_CONVERSION_RATE,
3470: decode(cc, l_global_sec_curr_code, 1, FII_CURRENCY.GET_GLOBAL_RATE_SECONDARY(cc,least(dt, sysdate))) SEC_CONVERSION_RATE
3471: from (
3472: select /*+ no_merge parallel(stg) */ distinct
3473: FUNCTIONAL_CURRENCY cc,

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

3466: SEC_CONVERSION_RATE)
3467: select cc functional_currency,
3468: dt trx_date,
3469: decode(cc, l_global_prim_curr_code, 1, FII_CURRENCY.GET_GLOBAL_RATE_PRIMARY (cc,least(dt, sysdate))) PRIM_CONVERSION_RATE,
3470: decode(cc, l_global_sec_curr_code, 1, FII_CURRENCY.GET_GLOBAL_RATE_SECONDARY(cc,least(dt, sysdate))) SEC_CONVERSION_RATE
3471: from (
3472: select /*+ no_merge parallel(stg) */ distinct
3473: FUNCTIONAL_CURRENCY cc,
3474: TRUNC(GL_DATE) dt

Line 4499: fii_currency.get_global_rate_primary(stg.functional_currency, least(stg.exchange_date, sysdate))

4495: end if;
4496:
4497: Update FII_AR_REVENUE_STG stg
4498: SET prim_conversion_rate =
4499: fii_currency.get_global_rate_primary(stg.functional_currency, least(stg.exchange_date, sysdate))
4500: WHERE stg.prim_conversion_rate < 0;
4501: -- commit;
4502: if g_debug_flag = 'Y' then
4503: FII_UTIL.put_line('Updated ' || SQL%ROWCOUNT || ' records for primary currency rates in staging table');

Line 4513: fii_currency.get_global_rate_secondary(stg.functional_currency, least(stg.exchange_date, sysdate))

4509: commit;
4510:
4511: Update FII_AR_REVENUE_STG stg
4512: SET sec_conversion_rate =
4513: fii_currency.get_global_rate_secondary(stg.functional_currency, least(stg.exchange_date, sysdate))
4514: WHERE stg.sec_conversion_rate < 0;
4515: -- commit;
4516: if g_debug_flag = 'Y' then
4517: FII_UTIL.put_line('Updated ' || SQL%ROWCOUNT || ' records for secondary currency rates in staging table');