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);
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);
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);
89: l_text:=l_text||'
90: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
91: l_text:='
92: l_text:=l_text||irc_utilities_pkg.removeTags(p_comm_dlvry_method);
96: l_text:=l_text||irc_utilities_pkg.removeTags(p_preferred_flag);
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_object_version_number);
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_object_version_number);
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_date.date_to_canonical(p_program_update_date);
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);
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_number.number_to_canonical(p_program_id);
112: l_text:=l_text||fnd_number.number_to_canonical(p_program_application_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_number.number_to_canonical(p_program_id);
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||irc_utilities_pkg.removeTags(p_attribute_category);