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

Line 57: dbms_lob.trim(p_clob, 0);

53: l_notes_detail := null;
54:
55:
56: -- Clear out the output CLOB buffer
57: dbms_lob.trim(p_clob, 0);
58:
59: Open GET_SR_CONTENT(p_rowid);
60: Fetch GET_SR_CONTENT Into l_incident_id,
61: l_lang,

Line 84: dbms_lob.writeappend(p_clob, l_amt, l_data);

80: ||'';
81:
82: l_amt := length(l_data);
83:
84: dbms_lob.writeappend(p_clob, l_amt, l_data);
85:
86: -- 4. Append all SR notes to the NOTES section
87: l_data := l_newline||'';
88: For srnote in GET_SR_NOTS(l_incident_id, l_lang) Loop

Line 94: dbms_lob.writeappend(p_clob, l_amt, l_data);

90: l_data := l_data ||' '||Remove_Tags(srnote.notes)||l_newline;
91: l_amt := length(l_data);
92: /*
93: If l_amt > 29990 Then
94: dbms_lob.writeappend(p_clob, l_amt, l_data);
95: l_data := '';
96: End If;
97: */
98: dbms_lob.writeappend(p_clob, l_amt, l_data);

Line 98: dbms_lob.writeappend(p_clob, l_amt, l_data);

94: dbms_lob.writeappend(p_clob, l_amt, l_data);
95: l_data := '';
96: End If;
97: */
98: dbms_lob.writeappend(p_clob, l_amt, l_data);
99: l_data := '';
100:
101: If (srnote.notes_detail is not null
102: and dbms_lob.getlength(srnote.notes_detail) > 0)

Line 102: and dbms_lob.getlength(srnote.notes_detail) > 0)

98: dbms_lob.writeappend(p_clob, l_amt, l_data);
99: l_data := '';
100:
101: If (srnote.notes_detail is not null
102: and dbms_lob.getlength(srnote.notes_detail) > 0)
103: Then
104: dbms_lob.createtemporary(l_temp_clob, TRUE, dbms_lob.call);
105:
106: l_notes_detail := Remove_Tags_Clob(srnote.notes_detail, l_temp_clob);

Line 104: dbms_lob.createtemporary(l_temp_clob, TRUE, dbms_lob.call);

100:
101: If (srnote.notes_detail is not null
102: and dbms_lob.getlength(srnote.notes_detail) > 0)
103: Then
104: dbms_lob.createtemporary(l_temp_clob, TRUE, dbms_lob.call);
105:
106: l_notes_detail := Remove_Tags_Clob(srnote.notes_detail, l_temp_clob);
107: l_clob_len := dbms_lob.getlength(l_notes_detail);
108: p_clob_len := dbms_lob.getlength(p_clob);

Line 107: l_clob_len := dbms_lob.getlength(l_notes_detail);

103: Then
104: dbms_lob.createtemporary(l_temp_clob, TRUE, dbms_lob.call);
105:
106: l_notes_detail := Remove_Tags_Clob(srnote.notes_detail, l_temp_clob);
107: l_clob_len := dbms_lob.getlength(l_notes_detail);
108: p_clob_len := dbms_lob.getlength(p_clob);
109: dbms_lob.copy(p_clob,
110: l_notes_detail,
111: l_clob_len,

Line 108: p_clob_len := dbms_lob.getlength(p_clob);

104: dbms_lob.createtemporary(l_temp_clob, TRUE, dbms_lob.call);
105:
106: l_notes_detail := Remove_Tags_Clob(srnote.notes_detail, l_temp_clob);
107: l_clob_len := dbms_lob.getlength(l_notes_detail);
108: p_clob_len := dbms_lob.getlength(p_clob);
109: dbms_lob.copy(p_clob,
110: l_notes_detail,
111: l_clob_len,
112: p_clob_len+1, 1);

Line 109: dbms_lob.copy(p_clob,

105:
106: l_notes_detail := Remove_Tags_Clob(srnote.notes_detail, l_temp_clob);
107: l_clob_len := dbms_lob.getlength(l_notes_detail);
108: p_clob_len := dbms_lob.getlength(p_clob);
109: dbms_lob.copy(p_clob,
110: l_notes_detail,
111: l_clob_len,
112: p_clob_len+1, 1);
113:

Line 114: dbms_lob.freetemporary(l_temp_clob);

110: l_notes_detail,
111: l_clob_len,
112: p_clob_len+1, 1);
113:
114: dbms_lob.freetemporary(l_temp_clob);
115: End if;
116: End Loop;
117:
118: l_data := l_data||'';

Line 121: dbms_lob.writeappend(p_clob, l_amt, l_data);

117:
118: l_data := l_data||'';
119:
120: l_amt := length(l_data);
121: dbms_lob.writeappend(p_clob, l_amt, l_data);
122: End Build_SR_Text;
123:
124: /*
125: Remove_Tags:

Line 156: l_idx := dbms_lob.instr(p_clob, '<', 1);

152: begin
153: --can't use, 8.1.7 does not support CLOB replace
154: --p_clob := replace(p_clob, '<', '!');
155:
156: l_idx := dbms_lob.instr(p_clob, '<', 1);
157: if(l_idx is not null and l_idx > 0) then
158: -- '<' found, so need to copy original into temp clob
159: -- Clear out the temp clob buffer
160: dbms_lob.trim(p_temp_clob, 0);

Line 160: dbms_lob.trim(p_temp_clob, 0);

156: l_idx := dbms_lob.instr(p_clob, '<', 1);
157: if(l_idx is not null and l_idx > 0) then
158: -- '<' found, so need to copy original into temp clob
159: -- Clear out the temp clob buffer
160: dbms_lob.trim(p_temp_clob, 0);
161: -- Copy original data into temporary clob
162: l_len := dbms_lob.getlength(p_clob);
163: dbms_lob.copy(p_temp_clob, p_clob, l_len, 1, 1);
164: else

Line 162: l_len := dbms_lob.getlength(p_clob);

158: -- '<' found, so need to copy original into temp clob
159: -- Clear out the temp clob buffer
160: dbms_lob.trim(p_temp_clob, 0);
161: -- Copy original data into temporary clob
162: l_len := dbms_lob.getlength(p_clob);
163: dbms_lob.copy(p_temp_clob, p_clob, l_len, 1, 1);
164: else
165: -- no '<' found, so just return the original
166: return p_clob;

Line 163: dbms_lob.copy(p_temp_clob, p_clob, l_len, 1, 1);

159: -- Clear out the temp clob buffer
160: dbms_lob.trim(p_temp_clob, 0);
161: -- Copy original data into temporary clob
162: l_len := dbms_lob.getlength(p_clob);
163: dbms_lob.copy(p_temp_clob, p_clob, l_len, 1, 1);
164: else
165: -- no '<' found, so just return the original
166: return p_clob;
167: end if;

Line 177: dbms_lob.write(p_temp_clob, 1, l_idx, '!');

173: --Now replace all '<' with '!' in p_temp_clob
174: --and return p_temp_clob
175:
176: while(l_idx is not null and l_idx > 0) loop
177: dbms_lob.write(p_temp_clob, 1, l_idx, '!');
178: l_idx := dbms_lob.instr(p_temp_clob, '<', l_idx);
179: end loop;
180:
181: return p_temp_clob;

Line 178: l_idx := dbms_lob.instr(p_temp_clob, '<', l_idx);

174: --and return p_temp_clob
175:
176: while(l_idx is not null and l_idx > 0) loop
177: dbms_lob.write(p_temp_clob, 1, l_idx, '!');
178: l_idx := dbms_lob.instr(p_temp_clob, '<', l_idx);
179: end loop;
180:
181: return p_temp_clob;
182: