DBA Data[Home] [Help]

APPS.JL_ZZ_AUTO_INVOICE dependencies on FND_NUMBER

Line 231: SELECT FND_NUMBER.canonical_to_number (p_line_attribute11)

227: ELSIF p_line_type ='TAX' THEN
228: IF p_line_attribute11 IS NOT NULL THEN
229: l_dummy_code := NULL;
230: BEGIN
231: SELECT FND_NUMBER.canonical_to_number (p_line_attribute11)
232: INTO l_dummy_code
233: FROM sys.dual;
234: EXCEPTION
235: WHEN INVALID_NUMBER OR VALUE_ERROR THEN

Line 250: SELECT FND_NUMBER.canonical_to_number (p_line_attribute12)

246:
247: IF p_line_attribute12 IS NOT NULL THEN
248: l_dummy_code := NULL;
249: BEGIN
250: SELECT FND_NUMBER.canonical_to_number (p_line_attribute12)
251: INTO l_dummy_code
252: FROM sys.dual;
253: EXCEPTION
254: WHEN INVALID_NUMBER OR VALUE_ERROR THEN

Line 692: SELECT FND_NUMBER.canonical_to_number(nvl(p_header_attribute16, 999))

688: ------------------------------------------------------------
689: IF p_line_type = 'LINE' THEN
690:
691: BEGIN
692: SELECT FND_NUMBER.canonical_to_number(nvl(p_header_attribute16, 999))
693: INTO dummy_code
694: FROM sys.dual;
695:
696: EXCEPTION

Line 719: SELECT FND_NUMBER.canonical_to_number(nvl(p_header_attribute17, 999))

715: ------------------------------------------------------------
716: IF p_line_type = 'LINE' THEN
717:
718: BEGIN
719: SELECT FND_NUMBER.canonical_to_number(nvl(p_header_attribute17, 999))
720: INTO dummy_code
721: FROM sys.dual;
722:
723: EXCEPTION