137: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
138: l_text:=l_text||'';
139: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
140: l_text:='
141: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_id);
142: l_text:=l_text||'
143: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
144: l_text:='
145: l_text:=l_text||fnd_number.number_to_canonical(p_org_payment_method_id);
141: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_id);
142: l_text:=l_text||'';
143: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
144: l_text:='
145: l_text:=l_text||fnd_number.number_to_canonical(p_org_payment_method_id);
146: l_text:=l_text||'
147: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
148: l_text:='
149: l_text:=l_text||fnd_number.number_to_canonical(p_amount);
145: l_text:=l_text||fnd_number.number_to_canonical(p_org_payment_method_id);
146: l_text:=l_text||'';
147: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
148: l_text:='
149: l_text:=l_text||fnd_number.number_to_canonical(p_amount);
150: l_text:=l_text||'
151: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
152: l_text:='
153: l_text:=l_text||fnd_number.number_to_canonical(p_percentage);
149: l_text:=l_text||fnd_number.number_to_canonical(p_amount);
150: l_text:=l_text||'';
151: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
152: l_text:='
153: l_text:=l_text||fnd_number.number_to_canonical(p_percentage);
154: l_text:=l_text||'
155: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
156: l_text:='
157: l_text:=l_text||fnd_number.number_to_canonical(p_priority);
153: l_text:=l_text||fnd_number.number_to_canonical(p_percentage);
154: l_text:=l_text||'';
155: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
156: l_text:='
157: l_text:=l_text||fnd_number.number_to_canonical(p_priority);
158: l_text:=l_text||'
159: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
160: l_text:='
161: l_text:=l_text||irc_utilities_pkg.removeTags(p_comments);
373: l_text:=l_text||irc_utilities_pkg.removeTags(p_payee_type);
374: l_text:=l_text||'';
375: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
376: l_text:='
377: l_text:=l_text||fnd_number.number_to_canonical(p_payee_id);
378: l_text:=l_text||'
379: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
380: l_text:='
381: l_text:=l_text||fnd_number.number_to_canonical(p_personal_payment_method_id);
377: l_text:=l_text||fnd_number.number_to_canonical(p_payee_id);
378: l_text:=l_text||'';
379: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
380: l_text:='
381: l_text:=l_text||fnd_number.number_to_canonical(p_personal_payment_method_id);
382: l_text:=l_text||'
383: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
384: l_text:='
385: l_text:=l_text||fnd_number.number_to_canonical(p_external_account_id);
381: l_text:=l_text||fnd_number.number_to_canonical(p_personal_payment_method_id);
382: l_text:=l_text||'';
383: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
384: l_text:='
385: l_text:=l_text||fnd_number.number_to_canonical(p_external_account_id);
386: l_text:=l_text||'
387: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
388: l_text:='
389: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
385: l_text:=l_text||fnd_number.number_to_canonical(p_external_account_id);
386: l_text:=l_text||'';
387: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
388: l_text:='
389: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
390: l_text:=l_text||'
391: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
392: l_text:='
393: l_text:=l_text||fnd_date.date_to_canonical(p_effective_start_date);
397: l_text:=l_text||fnd_date.date_to_canonical(p_effective_end_date);
398: l_text:=l_text||'';
399: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
400: l_text:='
401: l_text:=l_text||fnd_number.number_to_canonical(p_comment_id);
402: l_text:=l_text||'
403: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
404: l_text:='
405: l_text:=l_text||irc_utilities_pkg.removeTags(p_ppm_information1);