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