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.

APPS.JL_ZZ_AUTO_INVOICE dependencies on DUAL

Line 236: FROM sys.dual;

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

Line 255: FROM sys.dual;

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

Line 376: FROM dual

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

Line 450: FROM dual

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

Line 594: FROM sys.dual;

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:
596: EXCEPTION
597: WHEN INVALID_NUMBER OR VALUE_ERROR THEN
598: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'

Line 622: FROM sys.dual;

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:
624: EXCEPTION
625: WHEN INVALID_NUMBER OR VALUE_ERROR THEN
626: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'

Line 651: FROM sys.dual;

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:
653: EXCEPTION
654: WHEN INVALID_NUMBER OR VALUE_ERROR THEN
655: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'

Line 680: FROM sys.dual;

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:
682: EXCEPTION
683: WHEN INVALID_NUMBER OR VALUE_ERROR THEN
684: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL'

Line 705: FROM sys.dual;

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

Line 732: FROM sys.dual;

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