DBA Data[Home] [Help]

APPS.FII_CURRENCY dependencies on BIS_COMMON_PARAMETERS

Line 5: g_prim_currency_code constant varchar2(15) := bis_common_parameters.get_currency_code;

1: Package Body FII_CURRENCY AS
2: /* $Header: FIICACUB.pls 120.14 2005/10/30 05:07:46 appldev noship $ */
3:
4:
5: g_prim_currency_code constant varchar2(15) := bis_common_parameters.get_currency_code;
6: g_prim_rate_type constant varchar2(30) := bis_common_parameters.get_rate_type;
7: g_sec_currency_code constant varchar2(15) := bis_common_parameters.get_secondary_currency_code;
8: g_sec_rate_type constant varchar2(30) := bis_common_parameters.get_secondary_rate_type;
9: g_treasury_rate_type constant Varchar2(30) := bis_common_parameters.get_treasury_rate_type;

Line 6: g_prim_rate_type constant varchar2(30) := bis_common_parameters.get_rate_type;

2: /* $Header: FIICACUB.pls 120.14 2005/10/30 05:07:46 appldev noship $ */
3:
4:
5: g_prim_currency_code constant varchar2(15) := bis_common_parameters.get_currency_code;
6: g_prim_rate_type constant varchar2(30) := bis_common_parameters.get_rate_type;
7: g_sec_currency_code constant varchar2(15) := bis_common_parameters.get_secondary_currency_code;
8: g_sec_rate_type constant varchar2(30) := bis_common_parameters.get_secondary_rate_type;
9: g_treasury_rate_type constant Varchar2(30) := bis_common_parameters.get_treasury_rate_type;
10:

Line 7: g_sec_currency_code constant varchar2(15) := bis_common_parameters.get_secondary_currency_code;

3:
4:
5: g_prim_currency_code constant varchar2(15) := bis_common_parameters.get_currency_code;
6: g_prim_rate_type constant varchar2(30) := bis_common_parameters.get_rate_type;
7: g_sec_currency_code constant varchar2(15) := bis_common_parameters.get_secondary_currency_code;
8: g_sec_rate_type constant varchar2(30) := bis_common_parameters.get_secondary_rate_type;
9: g_treasury_rate_type constant Varchar2(30) := bis_common_parameters.get_treasury_rate_type;
10:
11: /* Below mentioned three variable are for Oracle Internal only */

Line 8: g_sec_rate_type constant varchar2(30) := bis_common_parameters.get_secondary_rate_type;

4:
5: g_prim_currency_code constant varchar2(15) := bis_common_parameters.get_currency_code;
6: g_prim_rate_type constant varchar2(30) := bis_common_parameters.get_rate_type;
7: g_sec_currency_code constant varchar2(15) := bis_common_parameters.get_secondary_currency_code;
8: g_sec_rate_type constant varchar2(30) := bis_common_parameters.get_secondary_rate_type;
9: g_treasury_rate_type constant Varchar2(30) := bis_common_parameters.get_treasury_rate_type;
10:
11: /* Below mentioned three variable are for Oracle Internal only */
12: g_fii_fixed_curr_it constant varchar2(40) := fnd_profile.value('FII_FIXED_CURRENCY_IT');

Line 9: g_treasury_rate_type constant Varchar2(30) := bis_common_parameters.get_treasury_rate_type;

5: g_prim_currency_code constant varchar2(15) := bis_common_parameters.get_currency_code;
6: g_prim_rate_type constant varchar2(30) := bis_common_parameters.get_rate_type;
7: g_sec_currency_code constant varchar2(15) := bis_common_parameters.get_secondary_currency_code;
8: g_sec_rate_type constant varchar2(30) := bis_common_parameters.get_secondary_rate_type;
9: g_treasury_rate_type constant Varchar2(30) := bis_common_parameters.get_treasury_rate_type;
10:
11: /* Below mentioned three variable are for Oracle Internal only */
12: g_fii_fixed_curr_it constant varchar2(40) := fnd_profile.value('FII_FIXED_CURRENCY_IT');
13: g_fii_left_curr constant varchar2(15) := substrb(g_fii_fixed_curr_it,1,INSTR(g_fii_fixed_curr_it,'=')-1);

Line 419: l_warehouse_currency_code := bis_common_parameters.get_currency_code;

415: rate NUMBER;
416:
417: BEGIN
418:
419: l_warehouse_currency_code := bis_common_parameters.get_currency_code;
420:
421: select nvl( curr.minimum_accountable_unit, power( 10, (-1 * curr.precision)))
422: into l_mau
423: from gl_currencies curr

Line 446: l_warehouse_currency_code := bis_common_parameters.get_secondary_currency_code;

442: l_mau NUMBER;
443: l_warehouse_currency_code VARCHAR2(15);
444: BEGIN
445:
446: l_warehouse_currency_code := bis_common_parameters.get_secondary_currency_code;
447:
448: select nvl( curr.minimum_accountable_unit, power( 10, (-1 * curr.precision)))
449: into l_mau
450: from gl_currencies curr