68: l_text:='
69: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
70: --
71: l_text:='
72: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
73: l_text:=l_text||'
74: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
75: l_text:='
76: l_text:=l_text||fnd_number.number_to_canonical(p_delivery_method_id);
76: l_text:=l_text||fnd_number.number_to_canonical(p_delivery_method_id);
77: l_text:=l_text||'';
78: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
79: l_text:='
80: l_text:=l_text||fnd_date.date_to_canonical(p_date_start);
81: l_text:=l_text||'
82: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
83: l_text:='
84: l_text:=l_text||fnd_date.date_to_canonical(p_date_end);
80: l_text:=l_text||fnd_date.date_to_canonical(p_date_start);
81: l_text:=l_text||'';
82: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
83: l_text:='
84: l_text:=l_text||fnd_date.date_to_canonical(p_date_end);
85: l_text:=l_text||'
86: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
87: l_text:='
88: l_text:=l_text||fnd_number.number_to_canonical(p_person_id);
104: l_text:=l_text||fnd_number.number_to_canonical(p_request_id);
105: l_text:=l_text||'';
106: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
107: l_text:='
108: l_text:=l_text||fnd_date.date_to_canonical(p_program_update_date);
109: l_text:=l_text||'
110: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
111: l_text:='
112: l_text:=l_text||fnd_number.number_to_canonical(p_program_application_id);