52: l_text:='
53: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
54: --
55: l_text:='
56: l_text:=l_text||fnd_number.number_to_canonical(p_document_type_id);
57: l_text:=l_text||'
58: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
59: l_text:='
60: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
96: l_text:=l_text||irc_utilities_pkg.removeTags(p_legislation_code);
97: l_text:=l_text||'';
98: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
99: l_text:='
100: l_text:=l_text||fnd_number.number_to_canonical(p_warning_period);
101: l_text:=l_text||'
102: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
103: l_text:='
104: l_text:=l_text||fnd_number.number_to_canonical(p_request_id);
100: l_text:=l_text||fnd_number.number_to_canonical(p_warning_period);
101: l_text:=l_text||'';
102: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
103: l_text:='
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_number.number_to_canonical(p_program_application_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_number.number_to_canonical(p_program_application_id);
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_id);
108: l_text:=l_text||fnd_number.number_to_canonical(p_program_application_id);
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_id);
113: l_text:=l_text||'
114: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
115: l_text:='
116: l_text:=l_text||fnd_date.date_to_canonical(p_program_update_date);
116: l_text:=l_text||fnd_date.date_to_canonical(p_program_update_date);
117: l_text:=l_text||'';
118: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
119: l_text:='
120: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
121: l_text:=l_text||'
122: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
123: l_text:='';
124: --