Convert Number into Amount in words.

There were some thread longtime back, and
they were looking for some xsl function , that can convert the number in to Words..
The great Gareth, gave a suggestion to use package from database & convert into the words :)..
--------------------------------------------------------------------------------
Use ap_amount_utilities_pkg.ap_convert_number
E.g.
SQL> select ap_amount_utilities_pkg.ap_convert_number(trunc(12345678)) from dual;
AP_AMOUNT_UTILITIES_PKG.AP_CONVERT_NUMBER(TRUNC(12345678))
--------------------------------------------------------------------------------
Twelve million three hundred forty-five thousand six hundred seventy-eight

http://sureshvaishya.blogspot.com/2008/03/display-numbers-in-figures.html
--------------------------------------------------------------------------------
Another person with great though Frank Greene,
can the Oracle BI Publisher access a PL/SQL stored package.function at run time and return a value? Something like
xdofx:run_function(base_package.num_to_char(local_var)
He raised a simple question
which raised eyebrow of so many people, why cant we do that..
--------------------------------------------------------------------------------
Our Guru Tim , got a sample extension to do that
http://blogs.oracle.com/xmlpublisher/2007/12/03/
--------------------------------------------------------------------------------
Finally it went into ears of O'..cle BIP team,
they gave a extended function to do this conversion..
here you have,

 

I tried to change the Locale settings, to display value for USD, my effort went in vain,
ater i came to know 
the "Paise" has been hard-coded and the function has been written specifically to Indian rupees,
Lakshman, opened up this today in the forum, 
I replied as follows 
"its a bug, Paise has been hardcoded it seems, they should have coded by looking @ the currency locale settings.
 i guess, Tim will accept this :). " 

 Tim replied as
Hi All

I have to admit not knowing about this function until it arrived and checking the code its hardcoded!
These were some functions that were developed in India for one of Oracle's aquisitions that operates almost exclusively in India.

I'll log an enhancement for this to get other languages! Might take some time as looking at the code it does not use any i18n library its just plain coded for rupees!

Regards

Tim

http://blogs.oracle.com/xmlpublisher