DBA Data[Home] [Help]

APPS.FA_FAS423_XMLP_PKG dependencies on FND_NUMBER

Line 166: retval := fnd_number.canonical_to_number(temp_retval);

162: IF life IS NOT NULL
163: THEN
164: temp_retval := (LPAD(TO_CHAR(TRUNC(life/12, 0), '90'),3,' ') || '.' ||
165: SUBSTR(TO_CHAR(MOD(life, 12), '00'), 2, 2)) || ' ';
166: retval := fnd_number.canonical_to_number(temp_retval);
167: ELSIF adj_rate IS NOT NULL
168: THEN
169: retval := TO_CHAR(ROUND((adj_rate + NVL(bonus_rate, 0))*100, 2), '90D99') || '%';
170: ELSIF prod IS NOT NULL

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

259: BEGIN
260: IF life IS NOT NULL
261: THEN
262: -- Fix for bug 601202 -- added substrb after lpad. changed '90' to '999'
263: temp_retval := fnd_number.canonical_to_number((LPAD(SUBSTR(TO_CHAR(TRUNC(life/12, 0), '999'), 2, 3),3,' ') || '.' ||
264: SUBSTR(TO_CHAR(MOD(life, 12), '00'), 2, 2)) );
265: retval := to_char(temp_retval,'999D99');
266: ELSIF adj_rate IS NOT NULL
267: THEN