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 752: l_resultOffset := DBMS_LOB.INSTR(l_result,'>');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1954: EXECUTE IMMEDIATE l_alter_str;
1955: END IF;
1956:
1957: IF l_rows_processed <> 0 THEN
1958: l_resultOffset := DBMS_LOB.INSTR(l_result,'>');
1959: tempResult := l_result;
1960: ELSE
1961: l_resultOffset := 0;
1962: END IF;

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

2009:
2010: l_close_tag := l_new_line||''||l_new_line;
2011: l_xml_header_length := length(l_xml_header);
2012: IF l_rows_processed <> 0 THEN
2013: dbms_lob.write(tempResult,l_xml_header_length,1,l_xml_header);
2014: dbms_lob.copy(tempResult,l_result,dbms_lob.getlength(l_result)-l_resultOffset,
2015: l_xml_header_length,l_resultOffset);
2016: ELSE
2017: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);

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

2010: l_close_tag := l_new_line||''||l_new_line;
2011: l_xml_header_length := length(l_xml_header);
2012: IF l_rows_processed <> 0 THEN
2013: dbms_lob.write(tempResult,l_xml_header_length,1,l_xml_header);
2014: dbms_lob.copy(tempResult,l_result,dbms_lob.getlength(l_result)-l_resultOffset,
2015: l_xml_header_length,l_resultOffset);
2016: ELSE
2017: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
2018: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);

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

2013: dbms_lob.write(tempResult,l_xml_header_length,1,l_xml_header);
2014: dbms_lob.copy(tempResult,l_result,dbms_lob.getlength(l_result)-l_resultOffset,
2015: l_xml_header_length,l_resultOffset);
2016: ELSE
2017: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
2018: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
2019: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
2020: END IF;
2021:

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

2014: dbms_lob.copy(tempResult,l_result,dbms_lob.getlength(l_result)-l_resultOffset,
2015: l_xml_header_length,l_resultOffset);
2016: ELSE
2017: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
2018: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
2019: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
2020: END IF;
2021:
2022: dbms_lob.writeAppend(tempResult, length(l_close_tag), l_close_tag);

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

2015: l_xml_header_length,l_resultOffset);
2016: ELSE
2017: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
2018: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
2019: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
2020: END IF;
2021:
2022: dbms_lob.writeAppend(tempResult, length(l_close_tag), l_close_tag);
2023:

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

2018: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
2019: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
2020: END IF;
2021:
2022: dbms_lob.writeAppend(tempResult, length(l_close_tag), l_close_tag);
2023:
2024: ar_cumulative_balance_report.process_clob(tempResult);
2025: p_result := tempResult;
2026:

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

3061: EXECUTE IMMEDIATE l_alter_str;
3062: END IF;
3063:
3064: IF l_rows_processed <> 0 THEN
3065: l_resultOffset := DBMS_LOB.INSTR(l_result,'>');
3066: tempResult := l_result;
3067: ELSE
3068: l_resultOffset := 0;
3069: END IF;

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

3116:
3117: l_close_tag := l_new_line||''||l_new_line;
3118: l_xml_header_length := length(l_xml_header);
3119: IF l_rows_processed <> 0 THEN
3120: dbms_lob.write(tempResult,l_xml_header_length,1,l_xml_header);
3121: dbms_lob.copy(tempResult,l_result,dbms_lob.getlength(l_result)-l_resultOffset,
3122: l_xml_header_length,l_resultOffset);
3123: ELSE
3124: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);

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

3117: l_close_tag := l_new_line||''||l_new_line;
3118: l_xml_header_length := length(l_xml_header);
3119: IF l_rows_processed <> 0 THEN
3120: dbms_lob.write(tempResult,l_xml_header_length,1,l_xml_header);
3121: dbms_lob.copy(tempResult,l_result,dbms_lob.getlength(l_result)-l_resultOffset,
3122: l_xml_header_length,l_resultOffset);
3123: ELSE
3124: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
3125: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);

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

3120: dbms_lob.write(tempResult,l_xml_header_length,1,l_xml_header);
3121: dbms_lob.copy(tempResult,l_result,dbms_lob.getlength(l_result)-l_resultOffset,
3122: l_xml_header_length,l_resultOffset);
3123: ELSE
3124: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
3125: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
3126: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
3127: END IF;
3128:

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

3121: dbms_lob.copy(tempResult,l_result,dbms_lob.getlength(l_result)-l_resultOffset,
3122: l_xml_header_length,l_resultOffset);
3123: ELSE
3124: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
3125: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
3126: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
3127: END IF;
3128:
3129: dbms_lob.writeAppend(tempResult, length(l_close_tag), l_close_tag);

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

3122: l_xml_header_length,l_resultOffset);
3123: ELSE
3124: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
3125: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
3126: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
3127: END IF;
3128:
3129: dbms_lob.writeAppend(tempResult, length(l_close_tag), l_close_tag);
3130:

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

3125: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
3126: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
3127: END IF;
3128:
3129: dbms_lob.writeAppend(tempResult, length(l_close_tag), l_close_tag);
3130:
3131: ar_cumulative_balance_report.process_clob(tempResult);
3132: p_result := tempResult;
3133:

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

3544: l_rows_processed := DBMS_XMLGEN.getNumRowsProcessed(qryCtx);
3545: DBMS_XMLGEN.closeContext(qryCtx);
3546: END IF;
3547: IF l_rows_processed <> 0 THEN
3548: l_resultOffset := DBMS_LOB.INSTR(l_result,'>');
3549: tempResult := l_result;
3550: ELSE
3551: l_resultOffset := 0;
3552: END IF;

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

3599:
3600: l_close_tag := l_new_line||''||l_new_line;
3601: l_xml_header_length := length(l_xml_header);
3602: IF l_rows_processed <> 0 THEN
3603: dbms_lob.write(tempResult,l_xml_header_length,1,l_xml_header);
3604: dbms_lob.copy(tempResult,l_result,dbms_lob.getlength(l_result)-l_resultOffset,
3605: l_xml_header_length,l_resultOffset);
3606: ELSE
3607: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);

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

3600: l_close_tag := l_new_line||''||l_new_line;
3601: l_xml_header_length := length(l_xml_header);
3602: IF l_rows_processed <> 0 THEN
3603: dbms_lob.write(tempResult,l_xml_header_length,1,l_xml_header);
3604: dbms_lob.copy(tempResult,l_result,dbms_lob.getlength(l_result)-l_resultOffset,
3605: l_xml_header_length,l_resultOffset);
3606: ELSE
3607: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
3608: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);

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

3603: dbms_lob.write(tempResult,l_xml_header_length,1,l_xml_header);
3604: dbms_lob.copy(tempResult,l_result,dbms_lob.getlength(l_result)-l_resultOffset,
3605: l_xml_header_length,l_resultOffset);
3606: ELSE
3607: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
3608: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
3609: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
3610: END IF;
3611:

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

3604: dbms_lob.copy(tempResult,l_result,dbms_lob.getlength(l_result)-l_resultOffset,
3605: l_xml_header_length,l_resultOffset);
3606: ELSE
3607: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
3608: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
3609: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
3610: END IF;
3611:
3612: dbms_lob.writeAppend(tempResult, length(l_close_tag), l_close_tag);

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

3605: l_xml_header_length,l_resultOffset);
3606: ELSE
3607: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
3608: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
3609: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
3610: END IF;
3611:
3612: dbms_lob.writeAppend(tempResult, length(l_close_tag), l_close_tag);
3613:

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

3608: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
3609: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
3610: END IF;
3611:
3612: dbms_lob.writeAppend(tempResult, length(l_close_tag), l_close_tag);
3613:
3614: ar_cumulative_balance_report.process_clob(tempResult);
3615: p_result := tempResult;
3616:

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

4861: EXECUTE IMMEDIATE l_alter_str;
4862: END IF;
4863:
4864: IF l_rows_processed <> 0 THEN
4865: l_resultOffset := DBMS_LOB.INSTR(l_result,'>');
4866: tempResult := l_result;
4867: ELSE
4868: l_resultOffset := 0;
4869: END IF;

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

4908: l_close_tag := l_new_line||''||l_new_line;
4909:
4910: l_xml_header_length := length(l_xml_header);
4911: IF l_rows_processed <> 0 THEN
4912: dbms_lob.write(tempResult,l_xml_header_length,1,l_xml_header);
4913: dbms_lob.copy(tempResult,l_result,dbms_lob.getlength(l_result)-l_resultOffset,
4914: l_xml_header_length,l_resultOffset);
4915: ELSE
4916: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);

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

4909:
4910: l_xml_header_length := length(l_xml_header);
4911: IF l_rows_processed <> 0 THEN
4912: dbms_lob.write(tempResult,l_xml_header_length,1,l_xml_header);
4913: dbms_lob.copy(tempResult,l_result,dbms_lob.getlength(l_result)-l_resultOffset,
4914: l_xml_header_length,l_resultOffset);
4915: ELSE
4916: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
4917: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);

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

4912: dbms_lob.write(tempResult,l_xml_header_length,1,l_xml_header);
4913: dbms_lob.copy(tempResult,l_result,dbms_lob.getlength(l_result)-l_resultOffset,
4914: l_xml_header_length,l_resultOffset);
4915: ELSE
4916: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
4917: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
4918: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
4919: END IF;
4920:

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

4913: dbms_lob.copy(tempResult,l_result,dbms_lob.getlength(l_result)-l_resultOffset,
4914: l_xml_header_length,l_resultOffset);
4915: ELSE
4916: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
4917: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
4918: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
4919: END IF;
4920:
4921: dbms_lob.writeAppend(tempResult, length(l_close_tag), l_close_tag);

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

4914: l_xml_header_length,l_resultOffset);
4915: ELSE
4916: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
4917: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
4918: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
4919: END IF;
4920:
4921: dbms_lob.writeAppend(tempResult, length(l_close_tag), l_close_tag);
4922:

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

4917: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
4918: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
4919: END IF;
4920:
4921: dbms_lob.writeAppend(tempResult, length(l_close_tag), l_close_tag);
4922:
4923: ar_cumulative_balance_report.process_clob(tempResult);
4924: p_result := tempResult;
4925: