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);
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:='
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||'
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: --
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