APPS.IRC_NOTES_BE1 dependencies on DBMS_LOB

Line 36: dbms_lob.createTemporary(l_event_data,false,dbms_lob.call);

32: close get_seq;
33: --
34: -- build the xml data for the event
35: --
36: dbms_lob.createTemporary(l_event_data,false,dbms_lob.call);
37: l_text:='';
38: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
39: l_text:='';
40: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 38: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

34: -- build the xml data for the event
35: --
36: dbms_lob.createTemporary(l_event_data,false,dbms_lob.call);
37: l_text:='';
38: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
39: l_text:='';
40: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
41: --
42: l_text:='';

Line 40: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

36: dbms_lob.createTemporary(l_event_data,false,dbms_lob.call);
37: l_text:='';
38: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
39: l_text:='';
40: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
41: --
42: l_text:='';
43: l_text:=l_text||fnd_number.number_to_canonical(p_note_id);
44: l_text:=l_text||'';

Line 45: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

41: --
42: l_text:='';
43: l_text:=l_text||fnd_number.number_to_canonical(p_note_id);
44: l_text:=l_text||'';
45: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
46: l_text:='';
47: l_text:=l_text||fnd_number.number_to_canonical(p_offer_status_history_id);
48: l_text:=l_text||'';
49: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 49: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

45: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
46: l_text:='';
47: l_text:=l_text||fnd_number.number_to_canonical(p_offer_status_history_id);
48: l_text:=l_text||'';
49: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
50: l_text:='';
51: l_text:=l_text||irc_utilities_pkg.removeTags(p_note_text);
52: l_text:=l_text||'';
53: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 53: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

49: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
50: l_text:='';
51: l_text:=l_text||irc_utilities_pkg.removeTags(p_note_text);
52: l_text:=l_text||'';
53: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
54: l_text:='';
55: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
56: l_text:=l_text||'';
57: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 57: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

53: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
54: l_text:='';
55: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
56: l_text:=l_text||'';
57: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
58: l_text:='';
59: --
60: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
61: --

Line 60: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

56: l_text:=l_text||'';
57: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
58: l_text:='';
59: --
60: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
61: --
62: -- raise the event with the event data
63: wf_event.raise(p_event_name=>l_event_name
64: ,p_event_key=>l_event_key