APPS.FII_CURRENCY_API dependencies on BIS_COMMON_PARAMETERS

Line 32: IF bis_common_parameters.get_primary_curdis_name IS NOT NULL THEN

28: l_secondary_currency_code varchar2(100);
29: l_rate varchar2(100);
30: begin
31:
32: IF bis_common_parameters.get_primary_curdis_name IS NOT NULL THEN
33: l_name := bis_common_parameters.get_primary_curdis_name;
34: ELSE
35: SELECT bis_common_parameters.get_currency_code,
36: bis_common_parameters.get_secondary_currency_code,

Line 33: l_name := bis_common_parameters.get_primary_curdis_name;

29: l_rate varchar2(100);
30: begin
31:
32: IF bis_common_parameters.get_primary_curdis_name IS NOT NULL THEN
33: l_name := bis_common_parameters.get_primary_curdis_name;
34: ELSE
35: SELECT bis_common_parameters.get_currency_code,
36: bis_common_parameters.get_secondary_currency_code,
37: user_conversion_type

Line 35: SELECT bis_common_parameters.get_currency_code,

31:
32: IF bis_common_parameters.get_primary_curdis_name IS NOT NULL THEN
33: l_name := bis_common_parameters.get_primary_curdis_name;
34: ELSE
35: SELECT bis_common_parameters.get_currency_code,
36: bis_common_parameters.get_secondary_currency_code,
37: user_conversion_type
38: into l_currency_code,
39: l_secondary_currency_code,

Line 36: bis_common_parameters.get_secondary_currency_code,

32: IF bis_common_parameters.get_primary_curdis_name IS NOT NULL THEN
33: l_name := bis_common_parameters.get_primary_curdis_name;
34: ELSE
35: SELECT bis_common_parameters.get_currency_code,
36: bis_common_parameters.get_secondary_currency_code,
37: user_conversion_type
38: into l_currency_code,
39: l_secondary_currency_code,
40: l_rate

Line 42: WHERE bis_common_parameters.get_currency_code is not null

38: into l_currency_code,
39: l_secondary_currency_code,
40: l_rate
41: FROM gl_daily_conversion_types
42: WHERE bis_common_parameters.get_currency_code is not null
43: AND bis_common_parameters.get_rate_type = conversion_type;
44:
45: -- bug 3887180: if primary not same as secondary, just display the code
46: if l_secondary_currency_code is NULL OR

Line 43: AND bis_common_parameters.get_rate_type = conversion_type;

39: l_secondary_currency_code,
40: l_rate
41: FROM gl_daily_conversion_types
42: WHERE bis_common_parameters.get_currency_code is not null
43: AND bis_common_parameters.get_rate_type = conversion_type;
44:
45: -- bug 3887180: if primary not same as secondary, just display the code
46: if l_secondary_currency_code is NULL OR
47: l_secondary_currency_code <> l_currency_code then

Line 70: IF bis_common_parameters.get_secondary_curdis_name IS NOT NULL THEN

66: l_secondary_currency_code varchar2(100);
67: l_secondary_rate varchar2(100);
68: begin
69:
70: IF bis_common_parameters.get_secondary_curdis_name IS NOT NULL THEN
71: l_name := bis_common_parameters.get_secondary_curdis_name;
72: ELSE
73: SELECT bis_common_parameters.get_currency_code,
74: bis_common_parameters.get_secondary_currency_code,

Line 71: l_name := bis_common_parameters.get_secondary_curdis_name;

67: l_secondary_rate varchar2(100);
68: begin
69:
70: IF bis_common_parameters.get_secondary_curdis_name IS NOT NULL THEN
71: l_name := bis_common_parameters.get_secondary_curdis_name;
72: ELSE
73: SELECT bis_common_parameters.get_currency_code,
74: bis_common_parameters.get_secondary_currency_code,
75: user_conversion_type

Line 73: SELECT bis_common_parameters.get_currency_code,

69:
70: IF bis_common_parameters.get_secondary_curdis_name IS NOT NULL THEN
71: l_name := bis_common_parameters.get_secondary_curdis_name;
72: ELSE
73: SELECT bis_common_parameters.get_currency_code,
74: bis_common_parameters.get_secondary_currency_code,
75: user_conversion_type
76: into l_currency_code,
77: l_secondary_currency_code,

Line 74: bis_common_parameters.get_secondary_currency_code,

70: IF bis_common_parameters.get_secondary_curdis_name IS NOT NULL THEN
71: l_name := bis_common_parameters.get_secondary_curdis_name;
72: ELSE
73: SELECT bis_common_parameters.get_currency_code,
74: bis_common_parameters.get_secondary_currency_code,
75: user_conversion_type
76: into l_currency_code,
77: l_secondary_currency_code,
78: l_secondary_rate

Line 80: WHERE bis_common_parameters.get_secondary_currency_code is not null

76: into l_currency_code,
77: l_secondary_currency_code,
78: l_secondary_rate
79: FROM gl_daily_conversion_types
80: WHERE bis_common_parameters.get_secondary_currency_code is not null
81: AND bis_common_parameters.get_secondary_rate_type = conversion_type;
82:
83: -- bug 3887180: if secondary not same as primary, just display the code
84: if l_secondary_currency_code <> l_currency_code then

Line 81: AND bis_common_parameters.get_secondary_rate_type = conversion_type;

77: l_secondary_currency_code,
78: l_secondary_rate
79: FROM gl_daily_conversion_types
80: WHERE bis_common_parameters.get_secondary_currency_code is not null
81: AND bis_common_parameters.get_secondary_rate_type = conversion_type;
82:
83: -- bug 3887180: if secondary not same as primary, just display the code
84: if l_secondary_currency_code <> l_currency_code then
85: l_name := l_secondary_currency_code;