In AP Module there is a builtin Function (ap_amount_utilities_pkg.ap_convert_number )to convert number value into Figures.
Example :-
SELECT Upper(ap_amount_utilities_pkg.ap_convert_number (123456789)) AS Value_in_words FROM DUAL -- For Upper Case Letters
SELECT InitCap(ap_amount_utilities_pkg.ap_convert_number (123456789)) AS Value_in_words FROM DUAL -- For Mixed Case Letters
SELECT Lower(ap_amount_utilities_pkg.ap_convert_number (123456789)) AS Value_in_words FROM DUAL -- For Lower Case Letters
Example :-
SELECT Upper(ap_amount_utilities_pkg.ap_convert_number (123456789)) AS Value_in_words FROM DUAL -- For Upper Case Letters
SELECT InitCap(ap_amount_utilities_pkg.ap_convert_number (123456789)) AS Value_in_words FROM DUAL -- For Mixed Case Letters
SELECT Lower(ap_amount_utilities_pkg.ap_convert_number (123456789)) AS Value_in_words FROM DUAL -- For Lower Case Letters
No comments:
Post a Comment