DBA Data[Home] [Help]

APPS.JL_ZZ_AUTO_INVOICE dependencies on FND_NUMBER

Line 234: SELECT FND_NUMBER.canonical_to_number (p_line_attribute11)

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

Line 253: SELECT FND_NUMBER.canonical_to_number (p_line_attribute12)

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

Line 591: SELECT FND_NUMBER.canonical_to_number(nvl (p_header_attribute9, 999))

587: IF p_line_type = 'LINE' THEN
588:
589: BEGIN
590: -- Bug 9085547 Start
591: SELECT FND_NUMBER.canonical_to_number(nvl (p_header_attribute9, 999))
592: -- Bug 9085547 End
593: INTO dummy_code
594: FROM sys.dual;
595:

Line 619: SELECT FND_NUMBER.canonical_to_number(nvl (p_header_attribute10, 999))

615: IF p_line_type = 'LINE' THEN
616:
617: BEGIN
618: -- Bug 9085547 Start
619: SELECT FND_NUMBER.canonical_to_number(nvl (p_header_attribute10, 999))
620: -- Bug 9085547 End
621: INTO dummy_code
622: FROM sys.dual;
623:

Line 648: SELECT FND_NUMBER.canonical_to_number(nvl (p_header_attribute11, 999))

644: IF p_line_type = 'LINE' THEN
645:
646: BEGIN
647: -- Bug 9085547 Start
648: SELECT FND_NUMBER.canonical_to_number(nvl (p_header_attribute11, 999))
649: -- Bug 9085547 End
650: INTO dummy_code
651: FROM sys.dual;
652:

Line 677: SELECT FND_NUMBER.canonical_to_number(nvl (p_header_attribute13, 999))

673: IF p_line_type = 'LINE' THEN
674:
675: BEGIN
676: -- Bug 9085547 Start
677: SELECT FND_NUMBER.canonical_to_number(nvl (p_header_attribute13, 999))
678: -- Bug 9085547 End
679: INTO dummy_code
680: FROM sys.dual;
681:

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

699: ------------------------------------------------------------
700: IF p_line_type = 'LINE' THEN
701:
702: BEGIN
703: SELECT FND_NUMBER.canonical_to_number(nvl(p_header_attribute16, 999))
704: INTO dummy_code
705: FROM sys.dual;
706:
707: EXCEPTION

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

726: ------------------------------------------------------------
727: IF p_line_type = 'LINE' THEN
728:
729: BEGIN
730: SELECT FND_NUMBER.canonical_to_number(nvl(p_header_attribute17, 999))
731: INTO dummy_code
732: FROM sys.dual;
733:
734: EXCEPTION