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

Line 201: IF (DBMS_LOB.getlength(trans_clob) > 0) then

197: open get_clob(l_orig_chr_id, l_purpose_code);
198: fetch get_clob into trans_clob;
199: close get_clob;
200:
201: IF (DBMS_LOB.getlength(trans_clob) > 0) then
202: pos1:= dbms_lob.instr(l_outbound_xml,'') - 1;
203: pos2 := pos1 + 26; /* length of the tag + 1 */
204:
205: /* copy data from the tag till the end of the clob */

Line 202: pos1:= dbms_lob.instr(l_outbound_xml,'') - 1;

198: fetch get_clob into trans_clob;
199: close get_clob;
200:
201: IF (DBMS_LOB.getlength(trans_clob) > 0) then
202: pos1:= dbms_lob.instr(l_outbound_xml,'') - 1;
203: pos2 := pos1 + 26; /* length of the tag + 1 */
204:
205: /* copy data from the tag till the end of the clob */
206: DBMS_LOB.createtemporary (l_tag_end_xml, TRUE);

Line 206: DBMS_LOB.createtemporary (l_tag_end_xml, TRUE);

202: pos1:= dbms_lob.instr(l_outbound_xml,'') - 1;
203: pos2 := pos1 + 26; /* length of the tag + 1 */
204:
205: /* copy data from the tag till the end of the clob */
206: DBMS_LOB.createtemporary (l_tag_end_xml, TRUE);
207: length_from_tag_end := DBMS_LOB.getlength(l_outbound_xml) - pos2 + 1;
208: dbms_lob.copy (l_tag_end_xml, l_outbound_xml, length_from_tag_end, 1, pos2);
209:
210: /* trim the clob from the tag till the end */

Line 207: length_from_tag_end := DBMS_LOB.getlength(l_outbound_xml) - pos2 + 1;

203: pos2 := pos1 + 26; /* length of the tag + 1 */
204:
205: /* copy data from the tag till the end of the clob */
206: DBMS_LOB.createtemporary (l_tag_end_xml, TRUE);
207: length_from_tag_end := DBMS_LOB.getlength(l_outbound_xml) - pos2 + 1;
208: dbms_lob.copy (l_tag_end_xml, l_outbound_xml, length_from_tag_end, 1, pos2);
209:
210: /* trim the clob from the tag till the end */
211: DBMS_LOB.TRIM(l_outbound_xml, pos1);

Line 208: dbms_lob.copy (l_tag_end_xml, l_outbound_xml, length_from_tag_end, 1, pos2);

204:
205: /* copy data from the tag till the end of the clob */
206: DBMS_LOB.createtemporary (l_tag_end_xml, TRUE);
207: length_from_tag_end := DBMS_LOB.getlength(l_outbound_xml) - pos2 + 1;
208: dbms_lob.copy (l_tag_end_xml, l_outbound_xml, length_from_tag_end, 1, pos2);
209:
210: /* trim the clob from the tag till the end */
211: DBMS_LOB.TRIM(l_outbound_xml, pos1);
212:

Line 211: DBMS_LOB.TRIM(l_outbound_xml, pos1);

207: length_from_tag_end := DBMS_LOB.getlength(l_outbound_xml) - pos2 + 1;
208: dbms_lob.copy (l_tag_end_xml, l_outbound_xml, length_from_tag_end, 1, pos2);
209:
210: /* trim the clob from the tag till the end */
211: DBMS_LOB.TRIM(l_outbound_xml, pos1);
212:
213: /* append the transaction state to the trimmed clob, and append the tail end from the tag to the end */
214: update okl_stream_trx_data
215: set out_xml = l_outbound_xml || ''||trans_clob||''|| l_tag_end_xml