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

Line 157: EXIT WHEN l_offset > dbms_lob.getlength(p_clob);

153: l_offset NUMBER DEFAULT 1;
154: BEGIN
155: BEGIN
156: LOOP
157: EXIT WHEN l_offset > dbms_lob.getlength(p_clob);
158: arp_standard.debug( dbms_lob.substr( p_clob, 255, l_offset ) );
159: l_offset := l_offset + 255;
160: END LOOP;
161:

Line 158: arp_standard.debug( dbms_lob.substr( p_clob, 255, l_offset ) );

154: BEGIN
155: BEGIN
156: LOOP
157: EXIT WHEN l_offset > dbms_lob.getlength(p_clob);
158: arp_standard.debug( dbms_lob.substr( p_clob, 255, l_offset ) );
159: l_offset := l_offset + 255;
160: END LOOP;
161:
162: EXCEPTION

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

3066: arp_standard.debug( 'l_rows_processed '||l_rows_processed);
3067: END IF;
3068:
3069: IF l_rows_processed <> 0 THEN
3070: l_resultOffset := DBMS_LOB.INSTR(l_result,'>');
3071: tempResult := l_result;
3072: ELSE
3073: l_resultOffset := 0;
3074: END IF;

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

3076: l_xml_header := get_report_header_xml;
3077: l_xml_header_length := length(l_xml_header);
3078:
3079: IF l_rows_processed <> 0 THEN
3080: dbms_lob.write(tempResult,l_xml_header_length,1,l_xml_header);
3081: dbms_lob.copy(tempResult,l_result,dbms_lob.getlength(l_result)-l_resultOffset,
3082: l_xml_header_length,l_resultOffset);
3083: dbms_lob.writeAppend(tempResult, length(''), '');
3084: ELSE

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

3077: l_xml_header_length := length(l_xml_header);
3078:
3079: IF l_rows_processed <> 0 THEN
3080: dbms_lob.write(tempResult,l_xml_header_length,1,l_xml_header);
3081: dbms_lob.copy(tempResult,l_result,dbms_lob.getlength(l_result)-l_resultOffset,
3082: l_xml_header_length,l_resultOffset);
3083: dbms_lob.writeAppend(tempResult, length(''), '');
3084: ELSE
3085: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);

Line 3083: dbms_lob.writeAppend(tempResult, length(''), '');

3079: IF l_rows_processed <> 0 THEN
3080: dbms_lob.write(tempResult,l_xml_header_length,1,l_xml_header);
3081: dbms_lob.copy(tempResult,l_result,dbms_lob.getlength(l_result)-l_resultOffset,
3082: l_xml_header_length,l_resultOffset);
3083: dbms_lob.writeAppend(tempResult, length(''), '');
3084: ELSE
3085: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
3086: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
3087: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);

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

3081: dbms_lob.copy(tempResult,l_result,dbms_lob.getlength(l_result)-l_resultOffset,
3082: l_xml_header_length,l_resultOffset);
3083: dbms_lob.writeAppend(tempResult, length(''), '');
3084: ELSE
3085: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
3086: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
3087: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
3088: dbms_lob.writeAppend(tempResult, length(''), '');
3089: END IF;

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

3082: l_xml_header_length,l_resultOffset);
3083: dbms_lob.writeAppend(tempResult, length(''), '');
3084: ELSE
3085: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
3086: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
3087: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
3088: dbms_lob.writeAppend(tempResult, length(''), '');
3089: END IF;
3090:

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

3083: dbms_lob.writeAppend(tempResult, length(''), '');
3084: ELSE
3085: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
3086: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
3087: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
3088: dbms_lob.writeAppend(tempResult, length(''), '');
3089: END IF;
3090:
3091:

Line 3088: dbms_lob.writeAppend(tempResult, length(''), '');

3084: ELSE
3085: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
3086: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
3087: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
3088: dbms_lob.writeAppend(tempResult, length(''), '');
3089: END IF;
3090:
3091:
3092: ar_cumulative_balance_report.process_clob(tempResult);