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

Line 101: l_ini_pos := dbms_lob.instr(l_xmlDoc, '!DOCTYPE ');

97:
98: SELECT payload into l_xmlDoc FROM ecx_doclogs WHERE msgid = HEXTORAW(p_msgId);
99:
100: l_ini_pos := -1;
101: l_ini_pos := dbms_lob.instr(l_xmlDoc, '!DOCTYPE ');
102: IF (l_Debug_Level <= 2) THEN
103: ecx_cln_debug_pub.Add('Init Position:' || l_ini_pos, 1);
104: END IF;
105:

Line 107: l_fin_pos := dbms_lob.instr(l_xmlDoc, '>', l_ini_pos);

103: ecx_cln_debug_pub.Add('Init Position:' || l_ini_pos, 1);
104: END IF;
105:
106: IF (l_ini_pos > 0) THEN
107: l_fin_pos := dbms_lob.instr(l_xmlDoc, '>', l_ini_pos);
108: l_fin_pos := l_fin_pos + 1;
109: l_amount := dbms_lob.getlength(l_xmlDoc);
110:
111: IF (l_Debug_Level <= 2) THEN

Line 109: l_amount := dbms_lob.getlength(l_xmlDoc);

105:
106: IF (l_ini_pos > 0) THEN
107: l_fin_pos := dbms_lob.instr(l_xmlDoc, '>', l_ini_pos);
108: l_fin_pos := l_fin_pos + 1;
109: l_amount := dbms_lob.getlength(l_xmlDoc);
110:
111: IF (l_Debug_Level <= 2) THEN
112: ecx_cln_debug_pub.Add('Final Position:' || l_fin_pos, 1);
113: ecx_cln_debug_pub.Add('Length:' || l_amount, 1);

Line 116: DBMS_LOB.CREATETEMPORARY(l_payload, TRUE, DBMS_LOB.SESSION);

112: ecx_cln_debug_pub.Add('Final Position:' || l_fin_pos, 1);
113: ecx_cln_debug_pub.Add('Length:' || l_amount, 1);
114: END IF;
115:
116: DBMS_LOB.CREATETEMPORARY(l_payload, TRUE, DBMS_LOB.SESSION);
117:
118: dbms_lob.copy(l_payload, l_xmlDoc, l_amount - l_fin_pos + 1, 1, l_fin_pos);
119:
120: END IF;

Line 118: dbms_lob.copy(l_payload, l_xmlDoc, l_amount - l_fin_pos + 1, 1, l_fin_pos);

114: END IF;
115:
116: DBMS_LOB.CREATETEMPORARY(l_payload, TRUE, DBMS_LOB.SESSION);
117:
118: dbms_lob.copy(l_payload, l_xmlDoc, l_amount - l_fin_pos + 1, 1, l_fin_pos);
119:
120: END IF;
121:
122: l_parser := xmlparser.newparser;

Line 198: DBMS_LOB.FREETEMPORARY(l_payload);

194: x_doc_creation_date := NULL;
195: END;
196:
197: IF (l_ini_pos > 0) THEN
198: DBMS_LOB.FREETEMPORARY(l_payload);
199: END IF;
200: xmlparser.freeparser(l_parser);
201:
202: IF (l_Debug_Level <= 5) THEN

Line 280: l_ini_pos := dbms_lob.instr(l_xmlDoc, '!DOCTYPE ');

276:
277: SELECT payload into l_xmlDoc FROM ecx_doclogs WHERE msgid = HEXTORAW(p_msgId);
278:
279: l_ini_pos := -1;
280: l_ini_pos := dbms_lob.instr(l_xmlDoc, '!DOCTYPE ');
281: IF (l_Debug_Level <= 2) THEN
282: ecx_cln_debug_pub.Add('Init Position:' || l_ini_pos, 1);
283: END IF;
284:

Line 286: l_fin_pos := dbms_lob.instr(l_xmlDoc, '>', l_ini_pos);

282: ecx_cln_debug_pub.Add('Init Position:' || l_ini_pos, 1);
283: END IF;
284:
285: IF (l_ini_pos > 0) THEN
286: l_fin_pos := dbms_lob.instr(l_xmlDoc, '>', l_ini_pos);
287: l_fin_pos := l_fin_pos + 1;
288: l_amount := dbms_lob.getlength(l_xmlDoc);
289:
290: IF (l_Debug_Level <= 2) THEN

Line 288: l_amount := dbms_lob.getlength(l_xmlDoc);

284:
285: IF (l_ini_pos > 0) THEN
286: l_fin_pos := dbms_lob.instr(l_xmlDoc, '>', l_ini_pos);
287: l_fin_pos := l_fin_pos + 1;
288: l_amount := dbms_lob.getlength(l_xmlDoc);
289:
290: IF (l_Debug_Level <= 2) THEN
291: ecx_cln_debug_pub.Add('Final Position:' || l_fin_pos, 1);
292: ecx_cln_debug_pub.Add('Length:' || l_amount, 1);

Line 295: DBMS_LOB.CREATETEMPORARY(l_payload, TRUE, DBMS_LOB.SESSION);

291: ecx_cln_debug_pub.Add('Final Position:' || l_fin_pos, 1);
292: ecx_cln_debug_pub.Add('Length:' || l_amount, 1);
293: END IF;
294:
295: DBMS_LOB.CREATETEMPORARY(l_payload, TRUE, DBMS_LOB.SESSION);
296:
297: dbms_lob.copy(l_payload, l_xmlDoc, l_amount - l_fin_pos + 1, 1, l_fin_pos);
298:
299: END IF;

Line 297: dbms_lob.copy(l_payload, l_xmlDoc, l_amount - l_fin_pos + 1, 1, l_fin_pos);

293: END IF;
294:
295: DBMS_LOB.CREATETEMPORARY(l_payload, TRUE, DBMS_LOB.SESSION);
296:
297: dbms_lob.copy(l_payload, l_xmlDoc, l_amount - l_fin_pos + 1, 1, l_fin_pos);
298:
299: END IF;
300:
301: l_parser := xmlparser.newparser;

Line 351: DBMS_LOB.FREETEMPORARY(l_payload);

347: x_app_ref_id := NULL;
348: END;
349:
350: IF (l_ini_pos > 0) THEN
351: DBMS_LOB.FREETEMPORARY(l_payload);
352: END IF;
353: xmlparser.freeparser(l_parser);
354:
355: IF (l_Debug_Level <= 5) THEN

Line 436: l_ini_pos := dbms_lob.instr(l_xmlDoc, '!DOCTYPE ');

432: ecx_cln_debug_pub.Add('payload obtained', 1);
433: END IF;
434:
435: l_ini_pos := -1;
436: l_ini_pos := dbms_lob.instr(l_xmlDoc, '!DOCTYPE ');
437: IF (l_Debug_Level <= 1) THEN
438: ecx_cln_debug_pub.Add('Init Position:' || l_ini_pos, 1);
439: END IF;
440:

Line 442: l_fin_pos := dbms_lob.instr(l_xmlDoc, '>', l_ini_pos);

438: ecx_cln_debug_pub.Add('Init Position:' || l_ini_pos, 1);
439: END IF;
440:
441: IF (l_ini_pos > 0) THEN
442: l_fin_pos := dbms_lob.instr(l_xmlDoc, '>', l_ini_pos);
443: l_fin_pos := l_fin_pos + 1;
444: l_amount := dbms_lob.getlength(l_xmlDoc);
445:
446: IF (l_Debug_Level <= 1) THEN

Line 444: l_amount := dbms_lob.getlength(l_xmlDoc);

440:
441: IF (l_ini_pos > 0) THEN
442: l_fin_pos := dbms_lob.instr(l_xmlDoc, '>', l_ini_pos);
443: l_fin_pos := l_fin_pos + 1;
444: l_amount := dbms_lob.getlength(l_xmlDoc);
445:
446: IF (l_Debug_Level <= 1) THEN
447: ecx_cln_debug_pub.Add('Final Position:' || l_fin_pos, 1);
448: ecx_cln_debug_pub.Add('Length:' || l_amount, 1);

Line 451: DBMS_LOB.CREATETEMPORARY(l_payload, TRUE, DBMS_LOB.SESSION);

447: ecx_cln_debug_pub.Add('Final Position:' || l_fin_pos, 1);
448: ecx_cln_debug_pub.Add('Length:' || l_amount, 1);
449: END IF;
450:
451: DBMS_LOB.CREATETEMPORARY(l_payload, TRUE, DBMS_LOB.SESSION);
452:
453: dbms_lob.copy(l_payload, l_xmlDoc, l_amount - l_fin_pos + 1, 1, l_fin_pos);
454:
455: END IF;

Line 453: dbms_lob.copy(l_payload, l_xmlDoc, l_amount - l_fin_pos + 1, 1, l_fin_pos);

449: END IF;
450:
451: DBMS_LOB.CREATETEMPORARY(l_payload, TRUE, DBMS_LOB.SESSION);
452:
453: dbms_lob.copy(l_payload, l_xmlDoc, l_amount - l_fin_pos + 1, 1, l_fin_pos);
454:
455: END IF;
456: IF (l_Debug_Level <= 1) THEN
457: ecx_cln_debug_pub.Add('about to initialize parser', 1);

Line 535: DBMS_LOB.FREETEMPORARY(l_payload);

531: x_app_ref_id := NULL;
532: END;
533:
534: IF (l_ini_pos > 0) THEN
535: DBMS_LOB.FREETEMPORARY(l_payload);
536: END IF;
537: xmlparser.freeparser(l_parser);
538:
539: IF (l_Debug_Level <= 1) THEN