106: l_text:='
107: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
108: --
109: l_text:='
110: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
111: l_text:=l_text||'
112: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
113: l_text:='
114: l_text:=l_text||fnd_number.number_to_canonical(p_period_of_service_id);
118: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
119: l_text:=l_text||'';
120: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
121: l_text:='
122: l_text:=l_text||fnd_date.date_to_canonical(p_actual_termination_date);
123: l_text:=l_text||'
124: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
125: l_text:='
126: l_text:=l_text||fnd_date.date_to_canonical(p_last_standard_process_date);
122: l_text:=l_text||fnd_date.date_to_canonical(p_actual_termination_date);
123: l_text:=l_text||'';
124: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
125: l_text:='
126: l_text:=l_text||fnd_date.date_to_canonical(p_last_standard_process_date);
127: l_text:=l_text||'
128: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
129: l_text:='
130: l_text:=l_text||fnd_number.number_to_canonical(p_person_type_id);
342: l_text:=l_text||irc_utilities_pkg.removeTags(p_pds_information30);
343: l_text:=l_text||'';
344: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
345: l_text:='
346: l_text:=l_text||fnd_date.date_to_canonical(p_last_std_process_date_out);
347: l_text:=l_text||'
348: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
349: l_text:='
350: if(P_SUPERVISOR_WARNING) then