DBA Data[Home] [Help]

APPS.IRC_PENDING_DATA_BE3 dependencies on DBMS_LOB

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

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

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

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

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

33: dbms_lob.createTemporary(l_event_data,false,dbms_lob.call);
34: l_text:='';
35: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
36: l_text:='';
37: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
38: --
39: l_text:='';
40: l_text:=l_text||fnd_number.number_to_canonical(p_pending_data_id);
41: l_text:=l_text||'
';

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

38: --
39: l_text:='';
40: l_text:=l_text||fnd_number.number_to_canonical(p_pending_data_id);
41: l_text:=l_text||'
';
42: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
43: l_text:='';
44: --
45: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
46: --

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

41: l_text:=l_text||'';
42: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
43: l_text:='';
44: --
45: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
46: --
47: -- raise the event with the event data
48: wf_event.raise(p_event_name=>l_event_name
49: ,p_event_key=>l_event_key