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

Line 1851: SELECT XMLELEMENT("P_LEDGER_NAME",l_ledger_name) INTO l_xml_item FROM dual;

1847:
1848: --write the parameter infomation into variable l_xml_parameter and last into l_xml_report
1849: FND_FILE.put_line(FND_FILE.output,'');
1850: l_xml_report := NULL;
1851: SELECT XMLELEMENT("P_LEDGER_NAME",l_ledger_name) INTO l_xml_item FROM dual;
1852: l_xml_parameter := l_xml_item;
1853: SELECT XMLELEMENT("P_LEGAL_NAME",l_le_name ) INTO l_xml_item FROM dual;
1854: SELECT XMLCONCAT(l_xml_parameter,l_xml_item) INTO l_xml_parameter FROM dual;
1855: SELECT XMLELEMENT("PERIOD_START",P_PERIOD_FROM) INTO l_xml_item FROM dual;

Line 1853: SELECT XMLELEMENT("P_LEGAL_NAME",l_le_name ) INTO l_xml_item FROM dual;

1849: FND_FILE.put_line(FND_FILE.output,'');
1850: l_xml_report := NULL;
1851: SELECT XMLELEMENT("P_LEDGER_NAME",l_ledger_name) INTO l_xml_item FROM dual;
1852: l_xml_parameter := l_xml_item;
1853: SELECT XMLELEMENT("P_LEGAL_NAME",l_le_name ) INTO l_xml_item FROM dual;
1854: SELECT XMLCONCAT(l_xml_parameter,l_xml_item) INTO l_xml_parameter FROM dual;
1855: SELECT XMLELEMENT("PERIOD_START",P_PERIOD_FROM) INTO l_xml_item FROM dual;
1856: SELECT XMLCONCAT(l_xml_parameter,l_xml_item) INTO l_xml_parameter FROM dual;
1857: SELECT XMLELEMENT("PERIOD_END",P_PERIOD_TO) INTO l_xml_item FROM dual;

Line 1854: SELECT XMLCONCAT(l_xml_parameter,l_xml_item) INTO l_xml_parameter FROM dual;

1850: l_xml_report := NULL;
1851: SELECT XMLELEMENT("P_LEDGER_NAME",l_ledger_name) INTO l_xml_item FROM dual;
1852: l_xml_parameter := l_xml_item;
1853: SELECT XMLELEMENT("P_LEGAL_NAME",l_le_name ) INTO l_xml_item FROM dual;
1854: SELECT XMLCONCAT(l_xml_parameter,l_xml_item) INTO l_xml_parameter FROM dual;
1855: SELECT XMLELEMENT("PERIOD_START",P_PERIOD_FROM) INTO l_xml_item FROM dual;
1856: SELECT XMLCONCAT(l_xml_parameter,l_xml_item) INTO l_xml_parameter FROM dual;
1857: SELECT XMLELEMENT("PERIOD_END",P_PERIOD_TO) INTO l_xml_item FROM dual;
1858: SELECT XMLCONCAT(l_xml_parameter,l_xml_item) INTO l_xml_parameter FROM dual;

Line 1855: SELECT XMLELEMENT("PERIOD_START",P_PERIOD_FROM) INTO l_xml_item FROM dual;

1851: SELECT XMLELEMENT("P_LEDGER_NAME",l_ledger_name) INTO l_xml_item FROM dual;
1852: l_xml_parameter := l_xml_item;
1853: SELECT XMLELEMENT("P_LEGAL_NAME",l_le_name ) INTO l_xml_item FROM dual;
1854: SELECT XMLCONCAT(l_xml_parameter,l_xml_item) INTO l_xml_parameter FROM dual;
1855: SELECT XMLELEMENT("PERIOD_START",P_PERIOD_FROM) INTO l_xml_item FROM dual;
1856: SELECT XMLCONCAT(l_xml_parameter,l_xml_item) INTO l_xml_parameter FROM dual;
1857: SELECT XMLELEMENT("PERIOD_END",P_PERIOD_TO) INTO l_xml_item FROM dual;
1858: SELECT XMLCONCAT(l_xml_parameter,l_xml_item) INTO l_xml_parameter FROM dual;
1859: SELECT XMLCONCAT(l_xml_report,l_xml_parameter) INTO l_xml_report FROM dual;

Line 1856: SELECT XMLCONCAT(l_xml_parameter,l_xml_item) INTO l_xml_parameter FROM dual;

1852: l_xml_parameter := l_xml_item;
1853: SELECT XMLELEMENT("P_LEGAL_NAME",l_le_name ) INTO l_xml_item FROM dual;
1854: SELECT XMLCONCAT(l_xml_parameter,l_xml_item) INTO l_xml_parameter FROM dual;
1855: SELECT XMLELEMENT("PERIOD_START",P_PERIOD_FROM) INTO l_xml_item FROM dual;
1856: SELECT XMLCONCAT(l_xml_parameter,l_xml_item) INTO l_xml_parameter FROM dual;
1857: SELECT XMLELEMENT("PERIOD_END",P_PERIOD_TO) INTO l_xml_item FROM dual;
1858: SELECT XMLCONCAT(l_xml_parameter,l_xml_item) INTO l_xml_parameter FROM dual;
1859: SELECT XMLCONCAT(l_xml_report,l_xml_parameter) INTO l_xml_report FROM dual;
1860:

Line 1857: SELECT XMLELEMENT("PERIOD_END",P_PERIOD_TO) INTO l_xml_item FROM dual;

1853: SELECT XMLELEMENT("P_LEGAL_NAME",l_le_name ) INTO l_xml_item FROM dual;
1854: SELECT XMLCONCAT(l_xml_parameter,l_xml_item) INTO l_xml_parameter FROM dual;
1855: SELECT XMLELEMENT("PERIOD_START",P_PERIOD_FROM) INTO l_xml_item FROM dual;
1856: SELECT XMLCONCAT(l_xml_parameter,l_xml_item) INTO l_xml_parameter FROM dual;
1857: SELECT XMLELEMENT("PERIOD_END",P_PERIOD_TO) INTO l_xml_item FROM dual;
1858: SELECT XMLCONCAT(l_xml_parameter,l_xml_item) INTO l_xml_parameter FROM dual;
1859: SELECT XMLCONCAT(l_xml_report,l_xml_parameter) INTO l_xml_report FROM dual;
1860:
1861: OPEN C_ERROR_JOURNALS;

Line 1858: SELECT XMLCONCAT(l_xml_parameter,l_xml_item) INTO l_xml_parameter FROM dual;

1854: SELECT XMLCONCAT(l_xml_parameter,l_xml_item) INTO l_xml_parameter FROM dual;
1855: SELECT XMLELEMENT("PERIOD_START",P_PERIOD_FROM) INTO l_xml_item FROM dual;
1856: SELECT XMLCONCAT(l_xml_parameter,l_xml_item) INTO l_xml_parameter FROM dual;
1857: SELECT XMLELEMENT("PERIOD_END",P_PERIOD_TO) INTO l_xml_item FROM dual;
1858: SELECT XMLCONCAT(l_xml_parameter,l_xml_item) INTO l_xml_parameter FROM dual;
1859: SELECT XMLCONCAT(l_xml_report,l_xml_parameter) INTO l_xml_report FROM dual;
1860:
1861: OPEN C_ERROR_JOURNALS;
1862: LOOP

Line 1859: SELECT XMLCONCAT(l_xml_report,l_xml_parameter) INTO l_xml_report FROM dual;

1855: SELECT XMLELEMENT("PERIOD_START",P_PERIOD_FROM) INTO l_xml_item FROM dual;
1856: SELECT XMLCONCAT(l_xml_parameter,l_xml_item) INTO l_xml_parameter FROM dual;
1857: SELECT XMLELEMENT("PERIOD_END",P_PERIOD_TO) INTO l_xml_item FROM dual;
1858: SELECT XMLCONCAT(l_xml_parameter,l_xml_item) INTO l_xml_parameter FROM dual;
1859: SELECT XMLCONCAT(l_xml_report,l_xml_parameter) INTO l_xml_report FROM dual;
1860:
1861: OPEN C_ERROR_JOURNALS;
1862: LOOP
1863: FETCH C_ERROR_JOURNALS INTO L_JOURNAL_GROUP,L_JE_LINE_NUM,L_STATUS_CODE,L_DESCRIPTION;

Line 1866: SELECT XMLELEMENT("JOURNAL_GROUP",L_JOURNAL_GROUP) INTO l_xml_item FROM dual;

1862: LOOP
1863: FETCH C_ERROR_JOURNALS INTO L_JOURNAL_GROUP,L_JE_LINE_NUM,L_STATUS_CODE,L_DESCRIPTION;
1864: EXIT WHEN C_ERROR_JOURNALS%NOTFOUND;
1865: l_xml_line:=NULL;
1866: SELECT XMLELEMENT("JOURNAL_GROUP",L_JOURNAL_GROUP) INTO l_xml_item FROM dual;
1867: l_xml_line:=l_xml_item;
1868: SELECT XMLELEMENT("JE_LINE_NUM",L_JE_LINE_NUM) INTO l_xml_item FROM dual;
1869: SELECT XMLCONCAT(l_xml_line,l_xml_item) INTO l_xml_line FROM dual;
1870: SELECT XMLELEMENT("STATUS_CODE",L_STATUS_CODE) INTO l_xml_item FROM dual;

Line 1868: SELECT XMLELEMENT("JE_LINE_NUM",L_JE_LINE_NUM) INTO l_xml_item FROM dual;

1864: EXIT WHEN C_ERROR_JOURNALS%NOTFOUND;
1865: l_xml_line:=NULL;
1866: SELECT XMLELEMENT("JOURNAL_GROUP",L_JOURNAL_GROUP) INTO l_xml_item FROM dual;
1867: l_xml_line:=l_xml_item;
1868: SELECT XMLELEMENT("JE_LINE_NUM",L_JE_LINE_NUM) INTO l_xml_item FROM dual;
1869: SELECT XMLCONCAT(l_xml_line,l_xml_item) INTO l_xml_line FROM dual;
1870: SELECT XMLELEMENT("STATUS_CODE",L_STATUS_CODE) INTO l_xml_item FROM dual;
1871: SELECT XMLCONCAT(l_xml_line,l_xml_item) INTO l_xml_line FROM dual;
1872: SELECT XMLELEMENT("ERROR_MESSAGE",L_DESCRIPTION) INTO l_xml_item FROM dual;

Line 1869: SELECT XMLCONCAT(l_xml_line,l_xml_item) INTO l_xml_line FROM dual;

1865: l_xml_line:=NULL;
1866: SELECT XMLELEMENT("JOURNAL_GROUP",L_JOURNAL_GROUP) INTO l_xml_item FROM dual;
1867: l_xml_line:=l_xml_item;
1868: SELECT XMLELEMENT("JE_LINE_NUM",L_JE_LINE_NUM) INTO l_xml_item FROM dual;
1869: SELECT XMLCONCAT(l_xml_line,l_xml_item) INTO l_xml_line FROM dual;
1870: SELECT XMLELEMENT("STATUS_CODE",L_STATUS_CODE) INTO l_xml_item FROM dual;
1871: SELECT XMLCONCAT(l_xml_line,l_xml_item) INTO l_xml_line FROM dual;
1872: SELECT XMLELEMENT("ERROR_MESSAGE",L_DESCRIPTION) INTO l_xml_item FROM dual;
1873: SELECT XMLCONCAT(l_xml_line,l_xml_item) INTO l_xml_line FROM dual;

Line 1870: SELECT XMLELEMENT("STATUS_CODE",L_STATUS_CODE) INTO l_xml_item FROM dual;

1866: SELECT XMLELEMENT("JOURNAL_GROUP",L_JOURNAL_GROUP) INTO l_xml_item FROM dual;
1867: l_xml_line:=l_xml_item;
1868: SELECT XMLELEMENT("JE_LINE_NUM",L_JE_LINE_NUM) INTO l_xml_item FROM dual;
1869: SELECT XMLCONCAT(l_xml_line,l_xml_item) INTO l_xml_line FROM dual;
1870: SELECT XMLELEMENT("STATUS_CODE",L_STATUS_CODE) INTO l_xml_item FROM dual;
1871: SELECT XMLCONCAT(l_xml_line,l_xml_item) INTO l_xml_line FROM dual;
1872: SELECT XMLELEMENT("ERROR_MESSAGE",L_DESCRIPTION) INTO l_xml_item FROM dual;
1873: SELECT XMLCONCAT(l_xml_line,l_xml_item) INTO l_xml_line FROM dual;
1874: SELECT XMLELEMENT("ERROR_JOURNAL",l_xml_line) INTO l_xml_line FROM dual;

Line 1871: SELECT XMLCONCAT(l_xml_line,l_xml_item) INTO l_xml_line FROM dual;

1867: l_xml_line:=l_xml_item;
1868: SELECT XMLELEMENT("JE_LINE_NUM",L_JE_LINE_NUM) INTO l_xml_item FROM dual;
1869: SELECT XMLCONCAT(l_xml_line,l_xml_item) INTO l_xml_line FROM dual;
1870: SELECT XMLELEMENT("STATUS_CODE",L_STATUS_CODE) INTO l_xml_item FROM dual;
1871: SELECT XMLCONCAT(l_xml_line,l_xml_item) INTO l_xml_line FROM dual;
1872: SELECT XMLELEMENT("ERROR_MESSAGE",L_DESCRIPTION) INTO l_xml_item FROM dual;
1873: SELECT XMLCONCAT(l_xml_line,l_xml_item) INTO l_xml_line FROM dual;
1874: SELECT XMLELEMENT("ERROR_JOURNAL",l_xml_line) INTO l_xml_line FROM dual;
1875: SELECT XMLCONCAT(l_xml_report,l_xml_line) INTO l_xml_report FROM dual;

Line 1872: SELECT XMLELEMENT("ERROR_MESSAGE",L_DESCRIPTION) INTO l_xml_item FROM dual;

1868: SELECT XMLELEMENT("JE_LINE_NUM",L_JE_LINE_NUM) INTO l_xml_item FROM dual;
1869: SELECT XMLCONCAT(l_xml_line,l_xml_item) INTO l_xml_line FROM dual;
1870: SELECT XMLELEMENT("STATUS_CODE",L_STATUS_CODE) INTO l_xml_item FROM dual;
1871: SELECT XMLCONCAT(l_xml_line,l_xml_item) INTO l_xml_line FROM dual;
1872: SELECT XMLELEMENT("ERROR_MESSAGE",L_DESCRIPTION) INTO l_xml_item FROM dual;
1873: SELECT XMLCONCAT(l_xml_line,l_xml_item) INTO l_xml_line FROM dual;
1874: SELECT XMLELEMENT("ERROR_JOURNAL",l_xml_line) INTO l_xml_line FROM dual;
1875: SELECT XMLCONCAT(l_xml_report,l_xml_line) INTO l_xml_report FROM dual;
1876: END LOOP;

Line 1873: SELECT XMLCONCAT(l_xml_line,l_xml_item) INTO l_xml_line FROM dual;

1869: SELECT XMLCONCAT(l_xml_line,l_xml_item) INTO l_xml_line FROM dual;
1870: SELECT XMLELEMENT("STATUS_CODE",L_STATUS_CODE) INTO l_xml_item FROM dual;
1871: SELECT XMLCONCAT(l_xml_line,l_xml_item) INTO l_xml_line FROM dual;
1872: SELECT XMLELEMENT("ERROR_MESSAGE",L_DESCRIPTION) INTO l_xml_item FROM dual;
1873: SELECT XMLCONCAT(l_xml_line,l_xml_item) INTO l_xml_line FROM dual;
1874: SELECT XMLELEMENT("ERROR_JOURNAL",l_xml_line) INTO l_xml_line FROM dual;
1875: SELECT XMLCONCAT(l_xml_report,l_xml_line) INTO l_xml_report FROM dual;
1876: END LOOP;
1877: CLOSE C_ERROR_JOURNALS;

Line 1874: SELECT XMLELEMENT("ERROR_JOURNAL",l_xml_line) INTO l_xml_line FROM dual;

1870: SELECT XMLELEMENT("STATUS_CODE",L_STATUS_CODE) INTO l_xml_item FROM dual;
1871: SELECT XMLCONCAT(l_xml_line,l_xml_item) INTO l_xml_line FROM dual;
1872: SELECT XMLELEMENT("ERROR_MESSAGE",L_DESCRIPTION) INTO l_xml_item FROM dual;
1873: SELECT XMLCONCAT(l_xml_line,l_xml_item) INTO l_xml_line FROM dual;
1874: SELECT XMLELEMENT("ERROR_JOURNAL",l_xml_line) INTO l_xml_line FROM dual;
1875: SELECT XMLCONCAT(l_xml_report,l_xml_line) INTO l_xml_report FROM dual;
1876: END LOOP;
1877: CLOSE C_ERROR_JOURNALS;
1878:

Line 1875: SELECT XMLCONCAT(l_xml_report,l_xml_line) INTO l_xml_report FROM dual;

1871: SELECT XMLCONCAT(l_xml_line,l_xml_item) INTO l_xml_line FROM dual;
1872: SELECT XMLELEMENT("ERROR_MESSAGE",L_DESCRIPTION) INTO l_xml_item FROM dual;
1873: SELECT XMLCONCAT(l_xml_line,l_xml_item) INTO l_xml_line FROM dual;
1874: SELECT XMLELEMENT("ERROR_JOURNAL",l_xml_line) INTO l_xml_line FROM dual;
1875: SELECT XMLCONCAT(l_xml_report,l_xml_line) INTO l_xml_report FROM dual;
1876: END LOOP;
1877: CLOSE C_ERROR_JOURNALS;
1878:
1879: SELECT XMLELEMENT( "REPORT",l_xml_report) INTO l_xml_root FROM dual;

Line 1879: SELECT XMLELEMENT( "REPORT",l_xml_report) INTO l_xml_root FROM dual;

1875: SELECT XMLCONCAT(l_xml_report,l_xml_line) INTO l_xml_report FROM dual;
1876: END LOOP;
1877: CLOSE C_ERROR_JOURNALS;
1878:
1879: SELECT XMLELEMENT( "REPORT",l_xml_report) INTO l_xml_root FROM dual;
1880: JA_CN_UTILITY.Output_Conc(l_xml_root.getclobval());
1881:
1882:
1883: EXCEPTION

Line 2389: SELECT ja_cn_item_interface_s.NEXTVAL into l_header_id FROM Dual;

2385: open c_journal_group;
2386: loop
2387: fetch c_journal_group into l_journal_group;
2388: exit when c_journal_group%notfound;
2389: SELECT ja_cn_item_interface_s.NEXTVAL into l_header_id FROM Dual;
2390: update ja_cn_journal_lines
2391: set je_header_id = l_header_id
2392: where status = 'U'
2393: and je_header_id = l_journal_group;