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.CLN_NTFYINVC_PKG dependencies on DUAL

Line 39: FROM DUAL

35: -- check for failed rows..
36: BEGIN
37: SELECT 'x'
38: INTO l_count_failed_rows
39: FROM DUAL
40: WHERE EXISTS (
41: SELECT 'x'
42: FROM ap_interface_rejections air
43: WHERE parent_table = 'AP_INVOICES_INTERFACE'

Line 175: FROM dual;

171:
172: -- Assigns the next value of 'CLN.CLN_3C4_DOCUMENT_NUM_S' sequence
173: SELECT M4R_3C4_DOCUMENT_NUM_S.NEXTVAL
174: INTO l_doc_id
175: FROM dual;
176:
177: l_doc_id := 'CLN3C4OT-' || l_doc_id;
178:
179: IF (l_debug_level <= 1) THEN

Line 790: FROM DUAL

786:
787: BEGIN
788: SELECT 'x'
789: INTO l_status
790: FROM DUAL
791: WHERE EXISTS (
792: SELECT 'x'
793: FROM ecx_doclogs
794: WHERE document_number = l_doc_id

Line 885: FROM dual;

881: SAVEPOINT CHECK_COLLABORATION_PUB;
882:
883: SELECT sysdate
884: INTO l_date
885: FROM dual;
886:
887: l_canonical_date := FND_DATE.DATE_TO_CANONICAL(l_date);
888:
889: IF (l_Debug_Level <= 1) THEN

Line 982: FROM dual;

978:
979: -- generate doc creation date
980: SELECT sysdate
981: INTO l_date
982: FROM dual;
983:
984: l_canonical_date := FND_DATE.DATE_TO_CANONICAL(l_date);
985:
986: -- here we do not initialize x_msg_data so as to account for the actual message coming from