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

Line 89: ln_amount := DBMS_LOB.GETLENGTH(p_xml_clob);

85: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.edit_clob.debug','p doc id is valid');
86: END IF;
87:
88: -- Editing LoB
89: ln_amount := DBMS_LOB.GETLENGTH(p_xml_clob);
90: DBMS_LOB.ERASE(p_xml_clob,ln_amount,1);
91: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
92: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.edit_clob.debug','CLOB ln_amount ' || ln_amount);
93: END IF;

Line 90: DBMS_LOB.ERASE(p_xml_clob,ln_amount,1);

86: END IF;
87:
88: -- Editing LoB
89: ln_amount := DBMS_LOB.GETLENGTH(p_xml_clob);
90: DBMS_LOB.ERASE(p_xml_clob,ln_amount,1);
91: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
92: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.edit_clob.debug','CLOB ln_amount ' || ln_amount);
93: END IF;
94:

Line 100: ln_start_pos := DBMS_LOB.INSTR(lc_xmldoc,'

96: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
97: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.edit_clob.debug','Find start and end positions ');
98: END IF;
99:
100: ln_start_pos := DBMS_LOB.INSTR(lc_xmldoc,' 101: ln_end_pos := DBMS_LOB.INSTR(lc_xmldoc,'',1,1);
102:
103: DBMS_LOB.COPY(p_xml_clob, lc_xmldoc, ln_end_pos-ln_start_pos, 1, ln_start_pos);
104: -- DBMS_LOB.COPY(lobd, lobs, amt, dest_offset, src_offset);

Line 101: ln_end_pos := DBMS_LOB.INSTR(lc_xmldoc,'',1,1);

97: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.edit_clob.debug','Find start and end positions ');
98: END IF;
99:
100: ln_start_pos := DBMS_LOB.INSTR(lc_xmldoc,' 101: ln_end_pos := DBMS_LOB.INSTR(lc_xmldoc,'',1,1);
102:
103: DBMS_LOB.COPY(p_xml_clob, lc_xmldoc, ln_end_pos-ln_start_pos, 1, ln_start_pos);
104: -- DBMS_LOB.COPY(lobd, lobs, amt, dest_offset, src_offset);
105: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 103: DBMS_LOB.COPY(p_xml_clob, lc_xmldoc, ln_end_pos-ln_start_pos, 1, ln_start_pos);

99:
100: ln_start_pos := DBMS_LOB.INSTR(lc_xmldoc,' 101: ln_end_pos := DBMS_LOB.INSTR(lc_xmldoc,'',1,1);
102:
103: DBMS_LOB.COPY(p_xml_clob, lc_xmldoc, ln_end_pos-ln_start_pos, 1, ln_start_pos);
104: -- DBMS_LOB.COPY(lobd, lobs, amt, dest_offset, src_offset);
105: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
106: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.edit_clob.debug','End of printing ');
107: END IF;

Line 104: -- DBMS_LOB.COPY(lobd, lobs, amt, dest_offset, src_offset);

100: ln_start_pos := DBMS_LOB.INSTR(lc_xmldoc,' 101: ln_end_pos := DBMS_LOB.INSTR(lc_xmldoc,'',1,1);
102:
103: DBMS_LOB.COPY(p_xml_clob, lc_xmldoc, ln_end_pos-ln_start_pos, 1, ln_start_pos);
104: -- DBMS_LOB.COPY(lobd, lobs, amt, dest_offset, src_offset);
105: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
106: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.edit_clob.debug','End of printing ');
107: END IF;
108:

Line 236: ln_len := dbms_lob.getlength(p_xml_clob);

232: ln_offset NUMBER;
233: ln_amount INTEGER;
234: BEGIN
235:
236: ln_len := dbms_lob.getlength(p_xml_clob);
237: ln_offset := 1;
238: ln_amount := 1023; -- changed from 32767 to 1023 so that it can handle upto Fixed-width-32-byte CLOBs objects (32767/1023 = 32) Bug 4323926
239:
240: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 247: lv_myclob_text := DBMS_LOB.SUBSTR (p_xml_clob, ln_amount, ln_offset);

243: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.print_out_xml.debug','ln_amount ' || ln_amount);
244: END IF;
245:
246: WHILE (ln_len > 0) LOOP
247: lv_myclob_text := DBMS_LOB.SUBSTR (p_xml_clob, ln_amount, ln_offset);
248: fnd_file.put(fnd_file.output,lv_myclob_text);
249: ln_amount := LENGTH(lv_myclob_text); -- this will handle any Character Set. But to be optimistic ln_amount is initialized to 1023 instead of 32767. Bug 4323926
250: IF ln_amount = 0 THEN
251: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 252: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.print_out_xml.debug','ln_amount is Zero after DBMS_LOB.SUBSTR, ln_len = ' || ln_len);

248: fnd_file.put(fnd_file.output,lv_myclob_text);
249: ln_amount := LENGTH(lv_myclob_text); -- this will handle any Character Set. But to be optimistic ln_amount is initialized to 1023 instead of 32767. Bug 4323926
250: IF ln_amount = 0 THEN
251: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
252: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.print_out_xml.debug','ln_amount is Zero after DBMS_LOB.SUBSTR, ln_len = ' || ln_len);
253: END IF;
254: EXIT;
255: END IF;
256: ln_len := ln_len - ln_amount;

Line 2057: IF DBMS_LOB.GETLENGTH(l_clob) = 0 THEN

2053: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.store_xml.debug',' after reading lob ');
2054: END IF;
2055: l_clob := l_event.geteventdata;
2056:
2057: IF DBMS_LOB.GETLENGTH(l_clob) = 0 THEN
2058: resultout := 'EMPTY_CLOB';
2059: ELSE
2060:
2061: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN