Monday, January 19, 2015

Functions in Oracle Apps that can be reused in general programming

1. From Oracle AP

a. Function for converting numbers to words
       apps.AP_AMOUNT_UTILITIES_PKG.ap_convert_number(number)

Example:
select apps.AP_AMOUNT_UTILITIES_PKG.ap_convert_number(1006555) from dual;
One million six thousand five hundred fifty-five

File: $AP_TOP/patch/115/sql/apamtutb.pls