13: Function get_display_name(currency_code varchar2, rate varchar2) return varchar2 is
14: l_name varchar2(100);
15: begin
16:
17: fnd_message.set_name('FII','FII_CURRENCY_DISPLAY_NAME');
18: fnd_message.set_token('CURRENCY_CODE',currency_code,FALSE);
19: fnd_message.set_token('RATE',rate,FALSE);
20: l_name := fnd_message.get;
21:
14: l_name varchar2(100);
15: begin
16:
17: fnd_message.set_name('FII','FII_CURRENCY_DISPLAY_NAME');
18: fnd_message.set_token('CURRENCY_CODE',currency_code,FALSE);
19: fnd_message.set_token('RATE',rate,FALSE);
20: l_name := fnd_message.get;
21:
22: return l_name;
15: begin
16:
17: fnd_message.set_name('FII','FII_CURRENCY_DISPLAY_NAME');
18: fnd_message.set_token('CURRENCY_CODE',currency_code,FALSE);
19: fnd_message.set_token('RATE',rate,FALSE);
20: l_name := fnd_message.get;
21:
22: return l_name;
23: end get_display_name;
16:
17: fnd_message.set_name('FII','FII_CURRENCY_DISPLAY_NAME');
18: fnd_message.set_token('CURRENCY_CODE',currency_code,FALSE);
19: fnd_message.set_token('RATE',rate,FALSE);
20: l_name := fnd_message.get;
21:
22: return l_name;
23: end get_display_name;
24:
116: l_rate
117: FROM gl_daily_conversion_types
118: WHERE conversion_type=fnd_profile.value('BIS_ANNUALIZED_RATE_TYPE');
119:
120: fnd_message.set_name('FII','FII_ANNUALIZED_CURR_DISP_NAME');
121: fnd_message.set_token('CURRENCY_CODE',l_currency_code,FALSE);
122: fnd_message.set_token('RATE',l_rate,FALSE);
123: l_name := fnd_message.get;
124:
117: FROM gl_daily_conversion_types
118: WHERE conversion_type=fnd_profile.value('BIS_ANNUALIZED_RATE_TYPE');
119:
120: fnd_message.set_name('FII','FII_ANNUALIZED_CURR_DISP_NAME');
121: fnd_message.set_token('CURRENCY_CODE',l_currency_code,FALSE);
122: fnd_message.set_token('RATE',l_rate,FALSE);
123: l_name := fnd_message.get;
124:
125: end if;
118: WHERE conversion_type=fnd_profile.value('BIS_ANNUALIZED_RATE_TYPE');
119:
120: fnd_message.set_name('FII','FII_ANNUALIZED_CURR_DISP_NAME');
121: fnd_message.set_token('CURRENCY_CODE',l_currency_code,FALSE);
122: fnd_message.set_token('RATE',l_rate,FALSE);
123: l_name := fnd_message.get;
124:
125: end if;
126:
119:
120: fnd_message.set_name('FII','FII_ANNUALIZED_CURR_DISP_NAME');
121: fnd_message.set_token('CURRENCY_CODE',l_currency_code,FALSE);
122: fnd_message.set_token('RATE',l_rate,FALSE);
123: l_name := fnd_message.get;
124:
125: end if;
126:
127: END IF;