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.ARP_RECON_REP dependencies on DBMS_LOB

Line 751: l_resultOffset := DBMS_LOB.INSTR(l_result,'>');

747: DBMS_XMLGEN.closeContext(qryCtx);
748: END IF;
749:
750: IF l_rows_processed <> 0 THEN
751: l_resultOffset := DBMS_LOB.INSTR(l_result,'>');
752: tempResult := l_result;
753: ELSE
754: l_resultOffset := 0;
755: END IF;

Line 805: dbms_lob.write(tempResult,l_xml_header_length,1,l_xml_header);

801:
802: l_close_tag := l_new_line||''||l_new_line;
803: l_xml_header_length := length(l_xml_header);
804: IF l_rows_processed <> 0 THEN
805: dbms_lob.write(tempResult,l_xml_header_length,1,l_xml_header);
806: dbms_lob.copy(tempResult,l_result,dbms_lob.getlength(l_result)-l_resultOffset,
807: l_xml_header_length,l_resultOffset);
808: ELSE
809: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);

Line 806: dbms_lob.copy(tempResult,l_result,dbms_lob.getlength(l_result)-l_resultOffset,

802: l_close_tag := l_new_line||''||l_new_line;
803: l_xml_header_length := length(l_xml_header);
804: IF l_rows_processed <> 0 THEN
805: dbms_lob.write(tempResult,l_xml_header_length,1,l_xml_header);
806: dbms_lob.copy(tempResult,l_result,dbms_lob.getlength(l_result)-l_resultOffset,
807: l_xml_header_length,l_resultOffset);
808: ELSE
809: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
810: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);

Line 809: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);

805: dbms_lob.write(tempResult,l_xml_header_length,1,l_xml_header);
806: dbms_lob.copy(tempResult,l_result,dbms_lob.getlength(l_result)-l_resultOffset,
807: l_xml_header_length,l_resultOffset);
808: ELSE
809: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
810: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
811: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
812: END IF;
813:

Line 810: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);

806: dbms_lob.copy(tempResult,l_result,dbms_lob.getlength(l_result)-l_resultOffset,
807: l_xml_header_length,l_resultOffset);
808: ELSE
809: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
810: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
811: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
812: END IF;
813:
814: dbms_lob.writeAppend(tempResult, length(l_close_tag), l_close_tag);

Line 811: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);

807: l_xml_header_length,l_resultOffset);
808: ELSE
809: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
810: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
811: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
812: END IF;
813:
814: dbms_lob.writeAppend(tempResult, length(l_close_tag), l_close_tag);
815:

Line 814: dbms_lob.writeAppend(tempResult, length(l_close_tag), l_close_tag);

810: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
811: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
812: END IF;
813:
814: dbms_lob.writeAppend(tempResult, length(l_close_tag), l_close_tag);
815:
816: ar_cumulative_balance_report.process_clob(tempResult);
817: p_result := tempResult;
818:

Line 1345: l_resultOffset := DBMS_LOB.INSTR(l_result,'>');

1341: DBMS_XMLGEN.closeContext(qryCtx);
1342: END IF;
1343:
1344: IF l_rows_processed <> 0 THEN
1345: l_resultOffset := DBMS_LOB.INSTR(l_result,'>');
1346: tempResult := l_result;
1347: ELSE
1348: l_resultOffset := 0;
1349: END IF;

Line 1400: dbms_lob.write(tempResult,l_xml_header_length,1,l_xml_header);

1396:
1397: l_close_tag := l_new_line||''||l_new_line;
1398: l_xml_header_length := length(l_xml_header);
1399: IF l_rows_processed <> 0 THEN
1400: dbms_lob.write(tempResult,l_xml_header_length,1,l_xml_header);
1401: dbms_lob.copy(tempResult,l_result,dbms_lob.getlength(l_result)-l_resultOffset,
1402: l_xml_header_length,l_resultOffset);
1403: ELSE
1404: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);

Line 1401: dbms_lob.copy(tempResult,l_result,dbms_lob.getlength(l_result)-l_resultOffset,

1397: l_close_tag := l_new_line||''||l_new_line;
1398: l_xml_header_length := length(l_xml_header);
1399: IF l_rows_processed <> 0 THEN
1400: dbms_lob.write(tempResult,l_xml_header_length,1,l_xml_header);
1401: dbms_lob.copy(tempResult,l_result,dbms_lob.getlength(l_result)-l_resultOffset,
1402: l_xml_header_length,l_resultOffset);
1403: ELSE
1404: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
1405: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);

Line 1404: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);

1400: dbms_lob.write(tempResult,l_xml_header_length,1,l_xml_header);
1401: dbms_lob.copy(tempResult,l_result,dbms_lob.getlength(l_result)-l_resultOffset,
1402: l_xml_header_length,l_resultOffset);
1403: ELSE
1404: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
1405: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
1406: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
1407: END IF;
1408:

Line 1405: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);

1401: dbms_lob.copy(tempResult,l_result,dbms_lob.getlength(l_result)-l_resultOffset,
1402: l_xml_header_length,l_resultOffset);
1403: ELSE
1404: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
1405: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
1406: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
1407: END IF;
1408:
1409: dbms_lob.writeAppend(tempResult, length(l_close_tag), l_close_tag);

Line 1406: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);

1402: l_xml_header_length,l_resultOffset);
1403: ELSE
1404: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
1405: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
1406: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
1407: END IF;
1408:
1409: dbms_lob.writeAppend(tempResult, length(l_close_tag), l_close_tag);
1410:

Line 1409: dbms_lob.writeAppend(tempResult, length(l_close_tag), l_close_tag);

1405: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
1406: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
1407: END IF;
1408:
1409: dbms_lob.writeAppend(tempResult, length(l_close_tag), l_close_tag);
1410:
1411: ar_cumulative_balance_report.process_clob(tempResult);
1412: p_result := tempResult;
1413:

Line 1864: l_resultOffset := DBMS_LOB.INSTR(l_result,'>');

1860: DBMS_XMLGEN.closeContext(qryCtx);
1861: END IF;
1862:
1863: IF l_rows_processed <> 0 THEN
1864: l_resultOffset := DBMS_LOB.INSTR(l_result,'>');
1865: tempResult := l_result;
1866: ELSE
1867: l_resultOffset := 0;
1868: END IF;

Line 1919: dbms_lob.write(tempResult,l_xml_header_length,1,l_xml_header);

1915:
1916: l_close_tag := l_new_line||''||l_new_line;
1917: l_xml_header_length := length(l_xml_header);
1918: IF l_rows_processed <> 0 THEN
1919: dbms_lob.write(tempResult,l_xml_header_length,1,l_xml_header);
1920: dbms_lob.copy(tempResult,l_result,dbms_lob.getlength(l_result)-l_resultOffset,
1921: l_xml_header_length,l_resultOffset);
1922: ELSE
1923: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);

Line 1920: dbms_lob.copy(tempResult,l_result,dbms_lob.getlength(l_result)-l_resultOffset,

1916: l_close_tag := l_new_line||''||l_new_line;
1917: l_xml_header_length := length(l_xml_header);
1918: IF l_rows_processed <> 0 THEN
1919: dbms_lob.write(tempResult,l_xml_header_length,1,l_xml_header);
1920: dbms_lob.copy(tempResult,l_result,dbms_lob.getlength(l_result)-l_resultOffset,
1921: l_xml_header_length,l_resultOffset);
1922: ELSE
1923: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
1924: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);

Line 1923: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);

1919: dbms_lob.write(tempResult,l_xml_header_length,1,l_xml_header);
1920: dbms_lob.copy(tempResult,l_result,dbms_lob.getlength(l_result)-l_resultOffset,
1921: l_xml_header_length,l_resultOffset);
1922: ELSE
1923: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
1924: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
1925: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
1926: END IF;
1927:

Line 1924: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);

1920: dbms_lob.copy(tempResult,l_result,dbms_lob.getlength(l_result)-l_resultOffset,
1921: l_xml_header_length,l_resultOffset);
1922: ELSE
1923: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
1924: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
1925: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
1926: END IF;
1927:
1928: dbms_lob.writeAppend(tempResult, length(l_close_tag), l_close_tag);

Line 1925: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);

1921: l_xml_header_length,l_resultOffset);
1922: ELSE
1923: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
1924: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
1925: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
1926: END IF;
1927:
1928: dbms_lob.writeAppend(tempResult, length(l_close_tag), l_close_tag);
1929:

Line 1928: dbms_lob.writeAppend(tempResult, length(l_close_tag), l_close_tag);

1924: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
1925: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
1926: END IF;
1927:
1928: dbms_lob.writeAppend(tempResult, length(l_close_tag), l_close_tag);
1929:
1930: ar_cumulative_balance_report.process_clob(tempResult);
1931: p_result := tempResult;
1932:

Line 2335: l_resultOffset := DBMS_LOB.INSTR(l_result,'>');

2331: l_rows_processed := DBMS_XMLGEN.getNumRowsProcessed(qryCtx);
2332: DBMS_XMLGEN.closeContext(qryCtx);
2333: END IF;
2334: IF l_rows_processed <> 0 THEN
2335: l_resultOffset := DBMS_LOB.INSTR(l_result,'>');
2336: tempResult := l_result;
2337: ELSE
2338: l_resultOffset := 0;
2339: END IF;

Line 2390: dbms_lob.write(tempResult,l_xml_header_length,1,l_xml_header);

2386:
2387: l_close_tag := l_new_line||''||l_new_line;
2388: l_xml_header_length := length(l_xml_header);
2389: IF l_rows_processed <> 0 THEN
2390: dbms_lob.write(tempResult,l_xml_header_length,1,l_xml_header);
2391: dbms_lob.copy(tempResult,l_result,dbms_lob.getlength(l_result)-l_resultOffset,
2392: l_xml_header_length,l_resultOffset);
2393: ELSE
2394: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);

Line 2391: dbms_lob.copy(tempResult,l_result,dbms_lob.getlength(l_result)-l_resultOffset,

2387: l_close_tag := l_new_line||''||l_new_line;
2388: l_xml_header_length := length(l_xml_header);
2389: IF l_rows_processed <> 0 THEN
2390: dbms_lob.write(tempResult,l_xml_header_length,1,l_xml_header);
2391: dbms_lob.copy(tempResult,l_result,dbms_lob.getlength(l_result)-l_resultOffset,
2392: l_xml_header_length,l_resultOffset);
2393: ELSE
2394: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
2395: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);

Line 2394: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);

2390: dbms_lob.write(tempResult,l_xml_header_length,1,l_xml_header);
2391: dbms_lob.copy(tempResult,l_result,dbms_lob.getlength(l_result)-l_resultOffset,
2392: l_xml_header_length,l_resultOffset);
2393: ELSE
2394: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
2395: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
2396: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
2397: END IF;
2398:

Line 2395: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);

2391: dbms_lob.copy(tempResult,l_result,dbms_lob.getlength(l_result)-l_resultOffset,
2392: l_xml_header_length,l_resultOffset);
2393: ELSE
2394: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
2395: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
2396: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
2397: END IF;
2398:
2399: dbms_lob.writeAppend(tempResult, length(l_close_tag), l_close_tag);

Line 2396: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);

2392: l_xml_header_length,l_resultOffset);
2393: ELSE
2394: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
2395: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
2396: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
2397: END IF;
2398:
2399: dbms_lob.writeAppend(tempResult, length(l_close_tag), l_close_tag);
2400:

Line 2399: dbms_lob.writeAppend(tempResult, length(l_close_tag), l_close_tag);

2395: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
2396: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
2397: END IF;
2398:
2399: dbms_lob.writeAppend(tempResult, length(l_close_tag), l_close_tag);
2400:
2401: ar_cumulative_balance_report.process_clob(tempResult);
2402: p_result := tempResult;
2403:

Line 3045: l_resultOffset := DBMS_LOB.INSTR(l_result,'>');

3041: DBMS_XMLGEN.closeContext(qryCtx);
3042: END IF;
3043:
3044: IF l_rows_processed <> 0 THEN
3045: l_resultOffset := DBMS_LOB.INSTR(l_result,'>');
3046: tempResult := l_result;
3047: ELSE
3048: l_resultOffset := 0;
3049: END IF;

Line 3092: dbms_lob.write(tempResult,l_xml_header_length,1,l_xml_header);

3088: l_close_tag := l_new_line||''||l_new_line;
3089:
3090: l_xml_header_length := length(l_xml_header);
3091: IF l_rows_processed <> 0 THEN
3092: dbms_lob.write(tempResult,l_xml_header_length,1,l_xml_header);
3093: dbms_lob.copy(tempResult,l_result,dbms_lob.getlength(l_result)-l_resultOffset,
3094: l_xml_header_length,l_resultOffset);
3095: ELSE
3096: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);

Line 3093: dbms_lob.copy(tempResult,l_result,dbms_lob.getlength(l_result)-l_resultOffset,

3089:
3090: l_xml_header_length := length(l_xml_header);
3091: IF l_rows_processed <> 0 THEN
3092: dbms_lob.write(tempResult,l_xml_header_length,1,l_xml_header);
3093: dbms_lob.copy(tempResult,l_result,dbms_lob.getlength(l_result)-l_resultOffset,
3094: l_xml_header_length,l_resultOffset);
3095: ELSE
3096: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
3097: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);

Line 3096: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);

3092: dbms_lob.write(tempResult,l_xml_header_length,1,l_xml_header);
3093: dbms_lob.copy(tempResult,l_result,dbms_lob.getlength(l_result)-l_resultOffset,
3094: l_xml_header_length,l_resultOffset);
3095: ELSE
3096: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
3097: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
3098: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
3099: END IF;
3100:

Line 3097: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);

3093: dbms_lob.copy(tempResult,l_result,dbms_lob.getlength(l_result)-l_resultOffset,
3094: l_xml_header_length,l_resultOffset);
3095: ELSE
3096: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
3097: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
3098: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
3099: END IF;
3100:
3101: dbms_lob.writeAppend(tempResult, length(l_close_tag), l_close_tag);

Line 3098: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);

3094: l_xml_header_length,l_resultOffset);
3095: ELSE
3096: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
3097: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
3098: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
3099: END IF;
3100:
3101: dbms_lob.writeAppend(tempResult, length(l_close_tag), l_close_tag);
3102:

Line 3101: dbms_lob.writeAppend(tempResult, length(l_close_tag), l_close_tag);

3097: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
3098: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
3099: END IF;
3100:
3101: dbms_lob.writeAppend(tempResult, length(l_close_tag), l_close_tag);
3102:
3103: ar_cumulative_balance_report.process_clob(tempResult);
3104: p_result := tempResult;
3105: