451: raise;
452: return(null);
453: end getConfigVar;
454: function getCurrencyName(currencyCodeIn in varchar2) return varchar2 as
455: returnValue fnd_currencies_active_v.name%type;
456: begin
457: select name
458: into returnValue
459: from fnd_currencies_active_v
455: returnValue fnd_currencies_active_v.name%type;
456: begin
457: select name
458: into returnValue
459: from fnd_currencies_active_v
460: where currency_code = currencyCodeIn;
461: return(currencyCodeIn || ' (' || returnValue || ')');
462: exception
463: when others then
1163: tempCount integer;
1164: begin
1165: select count(*)
1166: into tempCount
1167: from fnd_currencies_active_v
1168: where currency_code = currencyCodeIn;
1169: if(tempCount > 0) then
1170: return(true);
1171: end if;
3093: end getConversionTypes;
3094: procedure getCurrencyCodes(currencyCodesOut out nocopy ame_util.stringList) as
3095: cursor codeCursor is
3096: select currency_code
3097: from fnd_currencies_active_v;
3098: tempIndex integer;
3099: begin
3100: tempIndex := 1;
3101: for tempCurrencyCode in codeCursor loop
3117: select
3118: name,
3119: currency_code
3120: from
3121: fnd_currencies_active_v
3122: order by currency_code;
3123: tempIndex integer;
3124: begin
3125: tempIndex := 1;