DBA Data[Home] [Help]

APPS.WF_RENDER dependencies on DBMS_LOB

Line 24: amt := DBMS_LOB.GetLength(l_data);

20: chunksize number := 16000;
21: offset number := 1;
22:
23: begin
24: amt := DBMS_LOB.GetLength(l_data);
25: DBMS_LOB.CreateTemporary(tmp, TRUE, DBMS_LOB.session);
26: -- display XML content in a pre formatted way if the
27: dbms_lob.writeappend(tmp, 5, '

');

28:   loop




Line 25: DBMS_LOB.CreateTemporary(tmp, TRUE, DBMS_LOB.session);



21: offset number := 1;

22: 

23: begin

24: amt := DBMS_LOB.GetLength(l_data);

25: DBMS_LOB.CreateTemporary(tmp, TRUE, DBMS_LOB.session);

26: -- display XML content in a pre formatted way if the

27: dbms_lob.writeappend(tmp, 5, '
');

28:   loop

29:     if amt > chunksize then




Line 27: dbms_lob.writeappend(tmp, 5, '
');



23: begin

24: amt := DBMS_LOB.GetLength(l_data);

25: DBMS_LOB.CreateTemporary(tmp, TRUE, DBMS_LOB.session);

26: -- display XML content in a pre formatted way if the

27: dbms_lob.writeappend(tmp, 5, '
');

28: loop

29: if amt > chunksize then

30: dbms_lob.read(l_data, chunksize, offset, buf);

31: buf := replace(buf, l_amp, l_amp||'amp;');




Line 30: dbms_lob.read(l_data, chunksize, offset, buf);



26: -- display XML content in a pre formatted way if the

27: dbms_lob.writeappend(tmp, 5, '
');

28:   loop

29:     if amt > chunksize then

30:       dbms_lob.read(l_data, chunksize, offset, buf);

31:       buf := replace(buf, l_amp, l_amp||'amp;');

32:       buf := replace(buf, l_gt, l_amp||'gt;');

33:       buf := replace(buf, l_lt, l_amp||'lt;');

34:       dbms_lob.WriteAppend(tmp, length(buf), buf);




Line 34: dbms_lob.WriteAppend(tmp, length(buf), buf);



30: dbms_lob.read(l_data, chunksize, offset, buf);

31: buf := replace(buf, l_amp, l_amp||'amp;');

32: buf := replace(buf, l_gt, l_amp||'gt;');

33: buf := replace(buf, l_lt, l_amp||'lt;');

34: dbms_lob.WriteAppend(tmp, length(buf), buf);

35: amt := amt - chunksize;

36: offset := offset + chunksize;

37: else

38: dbms_lob.read(l_data, amt, offset, buf);




Line 38: dbms_lob.read(l_data, amt, offset, buf);



34: dbms_lob.WriteAppend(tmp, length(buf), buf);

35: amt := amt - chunksize;

36: offset := offset + chunksize;

37: else

38: dbms_lob.read(l_data, amt, offset, buf);

39: buf := replace(buf, l_amp, l_amp||'amp;');

40: buf := replace(buf, l_gt, l_amp||'gt;');

41: buf := replace(buf, l_lt, l_amp||'lt;');

42: dbms_lob.WriteAppend(tmp, length(buf), buf);




Line 42: dbms_lob.WriteAppend(tmp, length(buf), buf);



38: dbms_lob.read(l_data, amt, offset, buf);

39: buf := replace(buf, l_amp, l_amp||'amp;');

40: buf := replace(buf, l_gt, l_amp||'gt;');

41: buf := replace(buf, l_lt, l_amp||'lt;');

42: dbms_lob.WriteAppend(tmp, length(buf), buf);

43: exit;

44: end if;

45: end loop;

46: dbms_lob.writeappend(tmp, 6, '
');




Line 46: dbms_lob.writeappend(tmp, 6, '
');



42: dbms_lob.WriteAppend(tmp, length(buf), buf);

43: exit;

44: end if;

45: end loop;

46: dbms_lob.writeappend(tmp, 6, '
');

47: 

48: amt := dbms_lob.GetLength(tmp);

49: dbms_lob.copy(l_data, tmp, amt, 1, 1);

50: 




Line 48: amt := dbms_lob.GetLength(tmp);



44: end if;

45: end loop;

46: dbms_lob.writeappend(tmp, 6, '
');
47:
48: amt := dbms_lob.GetLength(tmp);
49: dbms_lob.copy(l_data, tmp, amt, 1, 1);
50:
51: exception
52: when others then

Line 49: dbms_lob.copy(l_data, tmp, amt, 1, 1);

45: end loop;
46: dbms_lob.writeappend(tmp, 6, '');
47:
48: amt := dbms_lob.GetLength(tmp);
49: dbms_lob.copy(l_data, tmp, amt, 1, 1);
50:
51: exception
52: when others then
53: -- don't do anything, give back what you have processed

Line 118: dbms_lob.createtemporary(l_data, TRUE, DBMS_LOB.Session);

114: -- get profile value for WF_SIG_TEXT_ONLY
115: l_sig_text := fnd_profile.value('WF_SIG_TEXT_ONLY');
116:
117: -- get the event from wf_notification_attributes
118: dbms_lob.createtemporary(l_data, TRUE, DBMS_LOB.Session);
119: l_event := Wf_Notification_Util.GetAttrEvent(l_nid, l_evt_attr);
120: l_temp := l_event.GetEventData();
121: l_amount := dbms_lob.getLength(l_temp);
122: dbms_lob.copy(l_data, l_temp, l_amount, 1, 1);

Line 121: l_amount := dbms_lob.getLength(l_temp);

117: -- get the event from wf_notification_attributes
118: dbms_lob.createtemporary(l_data, TRUE, DBMS_LOB.Session);
119: l_event := Wf_Notification_Util.GetAttrEvent(l_nid, l_evt_attr);
120: l_temp := l_event.GetEventData();
121: l_amount := dbms_lob.getLength(l_temp);
122: dbms_lob.copy(l_data, l_temp, l_amount, 1, 1);
123:
124: -- if no XML document do nothing
125: if (l_data is NULL) then

Line 122: dbms_lob.copy(l_data, l_temp, l_amount, 1, 1);

118: dbms_lob.createtemporary(l_data, TRUE, DBMS_LOB.Session);
119: l_event := Wf_Notification_Util.GetAttrEvent(l_nid, l_evt_attr);
120: l_temp := l_event.GetEventData();
121: l_amount := dbms_lob.getLength(l_temp);
122: dbms_lob.copy(l_data, l_temp, l_amount, 1, 1);
123:
124: -- if no XML document do nothing
125: if (l_data is NULL) then
126: return;

Line 146: dbms_lob.append(document, l_data);

142: if (l_retcode > 0) then
143: -- render XML content without transformation
144: wf_core.raise('WFE_DEFAULT_RENDER');
145: end if;
146: dbms_lob.append(document, l_data);
147: return;
148: end if;
149: if (display_type = WF_NOTIFICATION.doc_text) then
150: if (l_txslt_name is NULL) then

Line 173: dbms_lob.append(document, l_data);

169: if (l_retcode > 0) then
170: -- render XML content without transformation
171: wf_core.raise('WFE_DEFAULT_RENDER');
172: end if;
173: dbms_lob.append(document, l_data);
174: return;
175: end if;
176:
177: if (display_type = WF_NOTIFICATION.doc_html) then

Line 201: dbms_lob.append(document, l_data);

197: if (l_retcode > 0) then
198: -- render XML content without transformation
199: wf_core.raise('WFE_DEFAULT_RENDER');
200: end if;
201: dbms_lob.append(document, l_data);
202: return;
203: end if;
204: exception
205: when others then

Line 213: dbms_lob.append(document, l_data);

209: xmlparser.parseClob(l_parser, l_data);
210: if (display_type = Wf_Notification.doc_html) then
211: DefaultRender(l_data);
212: end if;
213: dbms_lob.append(document, l_data);
214: end if;
215: end XML_Style_Sheet;
216: ---------------------------------------------------------------------------
217: end WF_RENDER;