eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.JL_ZZ_AUTO_INVOICE dependencies on DUAL

Line 233: FROM sys.dual;

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
236: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'
237: ,'JL_ZZ_AR_TX_RAXTRX_BS_AMT_INV'

Line 252: FROM sys.dual;

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
255: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'
256: ,'JL_ZZ_AR_TX_RAXTRX_BS_RATE_INV'

Line 373: FROM dual

369:
370: BEGIN
371: SELECT 'Success'
372: INTO dummy_code
373: FROM dual
374: WHERE to_number (p_header_attribute3) >= 0;
375:
376: EXCEPTION
377: WHEN NO_DATA_FOUND OR INVALID_NUMBER OR VALUE_ERROR THEN

Line 447: FROM dual

443:
444: BEGIN
445: SELECT 'Success'
446: INTO dummy_code
447: FROM dual
448: WHERE to_number (p_header_attribute5) >= 0;
449:
450: EXCEPTION
451: WHEN NO_DATA_FOUND OR INVALID_NUMBER OR VALUE_ERROR THEN

Line 589: FROM sys.dual;

585:
586: BEGIN
587: SELECT to_number (nvl (p_header_attribute9, 999))
588: INTO dummy_code
589: FROM sys.dual;
590:
591: EXCEPTION
592: WHEN INVALID_NUMBER OR VALUE_ERROR THEN
593: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'

Line 615: FROM sys.dual;

611:
612: BEGIN
613: SELECT to_number (nvl (p_header_attribute10, 999))
614: INTO dummy_code
615: FROM sys.dual;
616:
617: EXCEPTION
618: WHEN INVALID_NUMBER OR VALUE_ERROR THEN
619: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'

Line 642: FROM sys.dual;

638:
639: BEGIN
640: SELECT to_number (nvl (p_header_attribute11, 999))
641: INTO dummy_code
642: FROM sys.dual;
643:
644: EXCEPTION
645: WHEN INVALID_NUMBER OR VALUE_ERROR THEN
646: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'

Line 669: FROM sys.dual;

665:
666: BEGIN
667: SELECT to_number (nvl (p_header_attribute13, 999))
668: INTO dummy_code
669: FROM sys.dual;
670:
671: EXCEPTION
672: WHEN INVALID_NUMBER OR VALUE_ERROR THEN
673: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'

Line 694: FROM sys.dual;

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
697: WHEN INVALID_NUMBER OR VALUE_ERROR THEN
698: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'

Line 721: FROM sys.dual;

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
724: WHEN INVALID_NUMBER OR VALUE_ERROR THEN
725: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'