DBA Data[Home] [Help]

APPS.FA_FAS490_XMLP_PKG dependencies on FND_NUMBER

Line 177: temp_retval := fnd_number.canonical_to_number((LPAD(SUBSTR(TO_CHAR(TRUNC(life/12, 0), '999'), 2, 3),3,' ') || '.' ||

173: BEGIN
174: IF life IS NOT NULL
175: THEN
176: -- Fix for bug 601202 -- added substrb after lpad. changed '90' to '999'
177: temp_retval := fnd_number.canonical_to_number((LPAD(SUBSTR(TO_CHAR(TRUNC(life/12, 0), '999'), 2, 3),3,' ') || '.' ||
178: SUBSTR(TO_CHAR(MOD(life, 12), '00'), 2, 2)) );
179: retval := to_char(temp_retval,'999D99');
180: ELSIF adj_rate IS NOT NULL
181: THEN