82: l_text:='
83: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
84: --
85: l_text:='
86: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
87: l_text:=l_text||'
88: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
89: l_text:='
90: l_text:=l_text||fnd_number.number_to_canonical(p_business_group_id);
94: l_text:=l_text||irc_utilities_pkg.removeTags(p_name);
95: l_text:=l_text||'';
96: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
97: l_text:='
98: l_text:=l_text||fnd_date.date_to_canonical(p_date_from);
99: l_text:=l_text||'
100: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
101: l_text:='
102: l_text:=l_text||irc_utilities_pkg.removeTags(p_language_code);
106: l_text:=l_text||fnd_number.number_to_canonical(p_location_id);
107: l_text:=l_text||'';
108: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
109: l_text:='
110: l_text:=l_text||fnd_date.date_to_canonical(p_date_to);
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||irc_utilities_pkg.removeTags(p_internal_external_flag);